How I Create Custom n8n Dashboards To Automate Anything (Google Sheets)

Jono Catliff β€’ April 9, 2025
Video Thumbnail
Jono Catliff Logo

Jono Catliff

@jonocatliff

About

82% of viewers don't realise they don't subscribe, please double check, thank you!! Hello there! πŸ‘‹ I'm Jono. I'm a business owner that has nearly removed myself from work - through automation, and I'm passionate about sharing my knowledge with others interested in doing the same. My goal here is to share my expertise in a structured way and to offer guidance to those looking to grow or start their own business. Here, you'll discover a variety of resources including sales, marketing, Make.com/Integromat, and Zapier guidesβ€”essentially, anything that catches my interest on any given day. Don't hesitate to drop any questions in the comments. I'm always happy to provide answers. Thank you for stopping by!

Video Description

🌍 COMMUNITY https://www.skool.com/automatable/about πŸ“ BLUEPRINTS https://www.skool.com/automatable-free/about πŸ“š SUMMARY This video is a demo on how to create custom Google Sheet dashboards using n8n. πŸ“£ SOCIAL MEDIA β€’ Instagram β†’ https://instagram.com/jono_catliff β€’ TikTok β†’ https://www.tiktok.com/@jonocatliff β€’ LinkedIn β†’ https://www.linkedin.com/in/jonocatliff/ β€’ X β†’ https://twitter.com/@jonocatliff πŸ“Ί RELATED VIDEOS β€’ Full crash course on Make.com β†’ https://youtu.be/hinLebdX8aM β€’ Full crash course on n8n β†’https://youtu.be/AURnISajubk β€’ 11 Favourite Make.com automations β†’ https://youtu.be/dIH1F1WlE84 β€’ 12 Favourite n8n automations β†’ https://youtu.be/uQGT2K26W84 🎯 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 β€’ Make.com β†’ https://jonocatliff.com/make β€’ Go High Level β†’ https://jonocatliff.com/gohighlevel β€’ Apify β†’ https://jonocatliff.com/apify β€’ Skool β†’ https://jonocatliff.com/skool β€’ Zapier β†’ https://jonocatliff.com/zapier β€’ PandaDoc β†’ https://jonocatliff.com/pandadoc β€’ Apollo β†’ https://jonocatliff.com/apollo β€’ ManyChat β†’ https://jonocatliff.com/manychat β€’ Vapi β†’ https://jonocatliff.com/vapi β€’ PhantomBuster β†’ https://jonocatliff.com/phantombuster β€’ ClickUp β†’ https://jonocatliff.com/clickup β€’ ElevenLabs β†’ https://jonocatliff.com/elevenlabs β€’ Upwork β†’ https://jonocatliff.com/upwork β€’ Instantly.ai β†’ https://jonocatliff.com/instantly β€’ Airtable β†’ https://jonocatliff.com/airtable πŸ‘‹ 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 4:06 Creating the dashboard 5:14 Creating a trigger 7:25 Adding data into the Google Sheet 19:52 Sending data from Google Sheets to n8n 29:00 Send email 31:15 Sending invoice 37:29 Conclusion

Automate Faster with These Essentials

AI-recommended products based on this video

Loading...
Dell UltraSharp 24 Monitor - U2424H

Dell UltraSharp 24 Monitor - U2424H

(43)
$309.44$262.14
FREE delivery Aug 22 - 25Only 8 left in stock.
Loading...
Dell UltraSharp U2723QE 27" 4K UHD WLED LCD Monitor - 16:9 - Black, Silver EPEAT

Dell UltraSharp U2723QE 27" 4K UHD WLED LCD Monitor - 16:9 - Black, Silver EPEAT

(13)
$699.99$650.99
FREE delivery Tue, Oct 7
50+ bought in past month
Loading...
Logitech G203 Wired Gaming Mouse, 8,000 DPI, Rainbow Optical Effect LIGHTSYNC RGB, 6 Programmable Buttons, On-Board Memory, Screen Mapping, PC/Mac Computer and Laptop Compatible - Black
Best Seller

Logitech G203 Wired Gaming Mouse, 8,000 DPI, Rainbow Optical Effect LIGHTSYNC RGB, 6 Programmable Buttons, On-Board Memory, Screen Mapping, PC/Mac Computer and Laptop Compatible - Black

(17,871)
$27.98$22.38
FREE delivery Tue, Oct 14 on your first order
500+ bought in past month
Loading...
Logitech G305 Lightspeed Wireless Gaming Mouse, Hero 12K Sensor, 12,000 DPI, Lightweight, 6 Programmable Buttons, 250h Battery Life, On-Board Memory, PC/Mac - Black

Logitech G305 Lightspeed Wireless Gaming Mouse, Hero 12K Sensor, 12,000 DPI, Lightweight, 6 Programmable Buttons, 250h Battery Life, On-Board Memory, PC/Mac - Black

(35,879)
$49.99$44.99
FREE delivery Mon, Jan 26
1K+ bought in past month
Loading...
Anker 332 USB-C Hub (5-in-1) with 4K HDMI Display, 5Gbps - and 2 5Gbps USB-A Data Ports and for MacBook Pro, MacBook Air, Dell XPS, Lenovo Thinkpad, HP Laptops and More

Anker 332 USB-C Hub (5-in-1) with 4K HDMI Display, 5Gbps - and 2 5Gbps USB-A Data Ports and for MacBook Pro, MacBook Air, Dell XPS, Lenovo Thinkpad, HP Laptops and More

(11,639)
$23.99
FREE delivery Sat, Jun 14 on your first order
1K+ bought in past month
Loading...
Anker Nano USB C Wall Charger,45W Fast Charging Smart Display Charger,with 180Β°Foldable Plug,Smart Recognition,Built-in Care Mode,for iPhone17/16/15 (Non-Battery,One USB-C Port,No Cable Included) ClimatePartner certified

Anker Nano USB C Wall Charger,45W Fast Charging Smart Display Charger,with 180Β°Foldable Plug,Smart Recognition,Built-in Care Mode,for iPhone17/16/15 (Non-Battery,One USB-C Port,No Cable Included) ClimatePartner certified

(698)
$39.99
FREE delivery Wed, Mar 4
1K+ bought in past month
Loading...
10.1 Inch Touch Portable Monitor IPS Screen 1366x768P 60Hz 400 Brightness 99% sRGB HDMI USB-C Monitors Switch for Xbox PS3/4/5 Laptop Compatible with Raspberry Pi, Mini Touch Screen

10.1 Inch Touch Portable Monitor IPS Screen 1366x768P 60Hz 400 Brightness 99% sRGB HDMI USB-C Monitors Switch for Xbox PS3/4/5 Laptop Compatible with Raspberry Pi, Mini Touch Screen

(1)
$99.99
FREE delivery Mon, Aug 11
Loading...
DHT11 modules Digital Temperature and Humidity Temperature Sensor for arduino DIY KIT 5pcs

DHT11 modules Digital Temperature and Humidity Temperature Sensor for arduino DIY KIT 5pcs

(1)
$15.99
FREE delivery Sat, Jun 14 on your first order
Loading...
Kasa Smart Outdoor Smart Plug by TP-Link (KP400) - Smart WiFi Outlet with 2 Sockets, IP64 Waterproof, Works with Alexa and Google Home, 2.4GHz WiFi Required, No Hub Required, Sunset & Sunrise Offset

Kasa Smart Outdoor Smart Plug by TP-Link (KP400) - Smart WiFi Outlet with 2 Sockets, IP64 Waterproof, Works with Alexa and Google Home, 2.4GHz WiFi Required, No Hub Required, Sunset & Sunrise Offset

(28,846)
$21.99$17.99
FREE delivery Wed, Aug 20 on your first order
1K+ bought in past month
Loading...
TP-Link AV1000 Powerline Ethernet Adapter(TL-PA7017P KIT) - Gigabit Port, Plug and Play, Extra Power Socket for Additional Devices, Ideal for Smart TV

TP-Link AV1000 Powerline Ethernet Adapter(TL-PA7017P KIT) - Gigabit Port, Plug and Play, Extra Power Socket for Additional Devices, Ideal for Smart TV

(17,610)
$64.99$51.48
PrimeFREE delivery Sat, Jun 14
100+ bought in past month