🌍 COMMUNITY
www.skool.com/automatable/about

📝 BLUEPRINTS
jonocatliff.gumroad.com/l/jjhnd

📚 SUMMARY
This video goes into 11 powerful n8n Google Sheets automation tips.

📺 RELATED VIDEOS
• Full crash course on Make.com →    • Make.com Basics: How To Automate Anyt...  
• Full crash course on Apify & web scraping →   • Apify Basics: How To Scrape Anything ...  
• How I made 507K last year with Bark.com →    • I Made $507K On Bark.com Using This 5...  
• How I generate 1,000+ blog posts instantly →    • How I Make 1,000+ Blogs In One Click ...  
• How I scraped 10,000+ leads & sent lead magnets →    • How I Scraped 10,000+ Leads & Sent Au...  

🎯 1:1 CONSULTING
Book a time → jonocatliff.com/consultation

🚀 AUTOMATION AGENCY
Get help with your business → www.automatable.co/

💼 CAREERS
Work with me → jonocatliff.com/careers

🔗 LINKS (some of these make me money - thanks in advance!)
• n8n → jonocatliff.com/n8n
• Apify → jonocatliff.com/apify
• Zapier → jonocatliff.com/zapier
• PandaDoc → jonocatliff.com/pandadoc
• Make.com → jonocatliff.com/make
• Go High Level → jonocatliff.com/gohighlevel

👋 ABOUT ME
Hey everyone, my name is Jono. I run a 7-figure service business that offers DJ, photo, video services (#1 largest in Canada), and spent years figuring out how to automate every part of it (and hired the roles that I couldn't). Conservatively, I used to work 80+ hours per week, before sunrise till long after sunset; missing gatherings, family events and everything in between. Through automation though, I was able to replace my job. My goal is to help share what worked for me, in a dream of helping others find true success with their passion.

Please subscribe, like and comment below if you have any questions! Thank you 😊

⌛ TIMESTAMPS
0:00 Intro
3:23 Google Sheets triggers
12:14 Creating custom dashboards in Google Sheets
19:01 Polling requests / wait for events
21:54 Adding & updating a row
26:15 Searching rows
31:28 Autocomplete cells in Google Sheets
38:20 Style Google Sheets with n8n
42:37 Inline Google Sheets functions
45:12 Adding multiple rows into Google Sheets
50:38 Google Sheets rate limiting / 429 errors
52:31 IF/ELSE stateme