Overview
Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Learn 11 powerful automation techniques for integrating Google Sheets with n8n, the open-source workflow automation platform, in this comprehensive 59-minute tutorial. Master essential Google Sheets triggers and discover how to create custom dashboards that automatically update with your data. Explore advanced polling requests and wait-for-event functionality to make your workflows more responsive. Develop skills in adding, updating, and searching rows programmatically, while implementing autocomplete functionality to enhance user experience. Understand how to apply styling and formatting to your spreadsheets through automation, and learn to execute inline Google Sheets functions within your n8n workflows. Gain expertise in bulk operations by adding multiple rows simultaneously, and discover strategies for handling rate limiting and 429 errors effectively. Master conditional logic implementation using IF/ELSE statements in n8n to create more sophisticated automation workflows that can handle complex business scenarios and data processing tasks.
Syllabus
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
Taught by
Jono Catliff