Get Started & Master Kitchn
- General
  - ➝ Start Here
  - Glossary of Common Terms
- Intro
  - Integrations
  - Automations
- Nodes
  - Adding and Deleting nodes
  - Inputs & Outputs
  - Required Input, validation & schema intro
  - Entering data & input types
  - Editing & clearing data inputs
  - JSON
- Running an automation
  - Using Widgets for User Input
  - Run & Stop
  - Running partial workflows and individual nodes
  - Monitoring automation activity
  - Aborting automations
  - Errors & Exceptions
  - Scheduling and delaying automations runs
  - Using Variables
  - Using Data stores
- Re-using automations
  - Exporting & Importing automations
  - Group Components
  - Navigating the automation
  - Backups
- Advanced Automation Patterns
  - Iteratively append items to a list
  - Run automations on a schedule with CRON
Tutorials
- Pulling data from Facebook (and output to spreadsheet)
  - Fetch insights data
  - Ad object settings / metadata
  - Other data: audiences, activity, text, URLs
  - Pulling data from Google Sheets
  - Calculating metrics
- Sending Slack notifications
  - Disapproved ads
  - High spend
  - Ads don’t have any UTM parameters
  - Ads’ URLs not working & catching all UTM parameter issues
  - Budget (or other settings) set too high/false
- Making changes to ad objects
  - Update Ad status
  - Increase the budget of the selected campaign
  - Convert regular ad into ad with post id
  - Create a set of rules for campaign/adset bids and budgets changes
- Creating ad objects - advanced
  - Duplicate original and modified campaigns
  - Duplicating original and modified adsets
  - Duplicating original and modified ads
  - Duplicating simple image ads, but changing an image
  - Duplicating simple video ads, but changing a video
Recipes
- Ad Creation & Uploading
  - Facebook Bulk Ad Uploading
  - Pinterest Bulk Pin/Ad Uploading
  - TikTok Bulk Ad Uploading
  - Snapchat Bulk Ad Uploading
  - LinkedIn Bulk Ad Upload
  - Upload new assets (Dropbox → Facebook)
  - Export recent Facebook Media Assets
  - Automatically upload new assets (GDrive → Facebook)
- Reporting
  - Facebook Ads Performance Export
  - Facebook Ads Creative Report (Slack)
  - Google Ads Performance Report
- Quality Control
  - [Slack Alert] Facebook Ads URL Check
  - [Slack Alert] Facebook Ads UTM Check
  - [Slack Alert] Facebook Disapproved ads
  - [Slack Alert] Pinterest Ads URL Check
  - [Slack Alert] Pinterest Disapproved ads
  - [Slack Alert] Pinterest High Spend
  - [Slack Alert] Pinterest UTM Check
  - [Slack Alert] Tiktok Ads URL Check
  - [Slack Alert] Tiktok Disapproved ads
  - [Slack Alert] Tiktok UTM Check
  - Facebook Ads Automated Changelog
  - [Slack Alert] Facebook Ads Pixel Check
  - Tiktok Ads Automated Changelog
- Others
  - Using AI Models like OpenAI GPT in Kitchn
Node Documentation
- Core
  - Append
  - Build Filter
  - Calculate Math Operation
  - Calculate Set Operation
  - Cast
  - Clone File
  - Concat
  - Converge
  - Create CRON Timstamp
  - Delay
  - Delay To v2
  - Email Notifier
  - Extract
  - Extract List
  - Fetch Integration Url
  - Fetch Variable
  - Filter
  - For Each
  - Format Timestamp V2
  - GroupBy
  - If
  - Join
  - JoinBy (deprecated)
  - JoinData
  - Map Any to Table Rows
  - Map Table Rows to Any
  - Parse String to Id
  - Patch JSON (TiKiLa)
  - Patch JSON or JSON List
  - Present
  - Process Script
  - Replace String or List String
  - Slice List (v3)
  - Sort
  - Split List
  - Trigger Relay
  - Update Variable
  - Webhook v3
- Facebook
  - Fetch Facebook Insights
  - Create Facebook Ad Video
  - Create Facebook Ad Image V3
  - Fetch Facebook Ad Ids
  - Fetch Facebook Campaign Ids
  - Fetch Facebook Ads
  - Fetch Facebook Campaigns
  - Extract Facebook Ad URLs
- Google Sheets
  - Fetch Google Spreadsheets Rows
  - Fetch Google Spreadsheet Row Mapping
  - Append Google Spreadsheets Rows
  - Clear Google Spreadsheet Rows
- Google Drive
  - Fetch Google Drive Files
- Slack
  - Slack Notifier
- Google Analytics
  - Fetch Google Analytics Reports
- Patch JSON TiKiLa
  - Home: Patch JSON TiKiLa
  - TiKiLa Math Operations
  - TiKiLa Logic Operations
  - TiKiLa Data & String Manipulation
  - TiKiLa Random Generator Functions
  - TiKiLa Date and Time Functions
Integrations
- Ad Platforms
  - Facebook
  - Google Ads
  - TikTok
  - Snapchat
  - Pinterest
- Tools & Software
  - Slack
  - Google Analytics
  - Google Drive
  - Google Sheets
  - Monday.com
- Custom Integrations
  - Asana
  - Tableau (PAT)
  - Voluum
  - Notion
  - Dropbox
  - Google BigQuery
  - Airtable
  - LinkedIn
  - Emarsys
  - Appsflyer
  - Frontify
Webinars
- Webinars
  - Patch JSON TiKiLa
FAQs
- General
  - How do I fix the "This app is blocked" error message?
  - How to create Deep Links into various Ads Managers?
  - Onboarding: How to start?
- Facebook Bulk Ad Creation
  - Why do I get the error “Cloud Function: Validate Input” when creating new ads?
  - Why are my GDrive videos not uploaded to Facebook?
- Spreadsheets
  - Why do some ids show up as scientific numbers, e.g. 1.032E+02?
- Facebook
  - Why don’t Facebook image links work anymore?
- Automation Architecture
  - How can I skip specific items in a For Each loop?
  - How can I use regular expressions to search for specific campaigns/ad set/ads?
  - How can I make a list of objects uniform (ensure same properties)?
  - How can I change the timeout or retry settings on a Node?
  - How can I use secrets (i.e. API keys) in my automations?
Product Updates
- Product Updates
  - January Updates
  - February Updates
  - March Updates
  - April Updates
  - May Updates
  - June Updates
  - July Updates
  - August Updates
Creative Reporting
- Settings
  - Values
  - Metrics
  - Dimensions
How to Set up the Slack Notification Bot
More

Pulling data from Google Sheets

In this tutorial, you will learn how to pull data from GSheets. This is relevant if you are planning to create ads in bulk from a spreadsheet. Combine this tutorial with any of the tutorials from section D to learn how to create ads from scratch.

Video Tutorial

Instructions

Add Select Google Spreadsheet Id node. Choose the tab and the range that you would like to pull in Kitchnware.

Add Fetch Google Spreadsheet Rows node. Connect spreadesheet_id and range nodes. Select ROWS as a dimension. Select FORMATTED_VALUE as value_render_option.

Add Map Table Rows to Any node. Connect rows sockets. Use Any List as schema. Create the mapping you would need in a JSON object.

Did this answer your question?

😞

😐

🤩

Last updated on August 6, 2021

Other data: audiences, activity, text, URLs Calculating metrics