Send timezone-aware drip emails with Gmail and Google Sheets using daily limits

How it works

• Three scheduled triggers fire on weekdays at region-appropriate working hours: EU/UK at 10:00 UTC, North America at 18:00 UTC, and Australia at 01:00 UTC
• All three feed one shared pipeline, so there is no duplicated logic across regions
• A code node detects the active region from the current UTC hour and picks a daily send limit (45 / 90 / 15 by default)
• Reads your contact list from Google Sheets, filters by country-to-region mapping, skips rows already marked sent, and caps at the daily limit
• Sends a personalised email via Gmail using expressions like {{ $json['First Name'] }} and {{ $json['Company'] }}
• Writes success or error status back to the same row (email_sent, sent_date, status, group_sent, error_msg)
• No Wait nodes, no long-running executions - timing is driven entirely by Cron schedules

Set up steps

• Setup takes about 10-15 minutes
• Connect a Google Sheets OAuth2 credential with read + write access to your contacts sheet
• Connect a Gmail OAuth2 credential for the sending account
• Create a Google Sheet with these columns: First Name, Company, Email, Country, email_sent, sent_date, status, group_sent, error_msg
• In all three Google Sheets nodes, select your spreadsheet and the contacts tab
• Open the Build Email node and replace the placeholder subject and HTML body with your own copy
• In the Send Gmail node, set senderName to your display name
• Optional: adjust daily send caps inside Determine Group and edit the country-to-region lookup inside Filter and Limit
• Detailed per-step notes live inside the workflow as sticky notes