Cost-free email follow-up sequence with Google Sheets and Gmail
Ready for 3.0What this workflow does
This workflow has 14 nodes and runs on a schedule (every day). Along the way it connects Google Sheets, Google Docs and Gmail.
How it runs
Trigger: On a schedule (every day).
- Settings (Edit Fields (Set)): sets or maps fields
- Get Contacts (Google Sheets): uses Google Sheets
- Limit: keeps the first few items
- Filter: keeps only the items that match a condition
- Has contact completed email sequence? (Filter): keeps only the items that match a condition
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Is Contact Real? (If): checks a condition and branches into true / false
- Determine Email Number (Edit Fields (Set)): sets or maps fields
- email template selector (Google Docs): uses Google Docs
- HTML: parses or builds HTML
…plus 3 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (11)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Wait
n8n-nodes-base.wait - Google Docs
n8n-nodes-base.googleDocs - Gmail
n8n-nodes-base.gmail - Limit
n8n-nodes-base.limit - Filter
n8n-nodes-base.filter - If
n8n-nodes-base.if - HTML
n8n-nodes-base.html
From the author
Simple But Powerful Email Automation for Everyone: No AI, No API Costs! This n8n workflow template, "Email Outreach Automation," is designed to help you set up an automated email outreach system using tools you might already be familiar with: Google Sheets…