? COMMUNITY
https://www.skool.com/automatable/about
? BLUEPRINTS
https://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 → https://youtu.be/hinLebdX8aM
• Full crash course on Apify & web scraping →https://youtu.be/pKgup8tsPv8
• How I made 507K last year with Bark.com → https://youtu.be/oCaGVACutdE
• How I generate 1,000+ blog posts instantly → https://youtu.be/FmXt26JY24I
• How I scraped 10,000+ leads & sent lead magnets → https://youtu.be/qwsB72PhM3E
? 1:1 CONSULTING
Book a time → https://jonocatliff.com/consultation
? AUTOMATION AGENCY
Get help with your business → https://www.automatable.co
? CAREERS
Work with me → https://jonocatliff.com/careers
? LINKS (some of these make me money - thanks in advance!)
• n8n → https://jonocatliff.com/n8n
• Apify → https://jonocatliff.com/apify
• Zapier → https://jonocatliff.com/zapier
• PandaDoc → https://jonocatliff.com/pandadoc
• Make.com → https://jonocatliff.com/make
• Go High Level → https://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 statements in n8n