Send predefined personalized emails to leads from Google Sheets using SendGrid
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 10 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets and SendGrid.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- Limit: keeps the first few items
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Parse Email Template from DB (Google Sheets): uses Google Sheets
- Merge: merges the data from its input branches
- Pick a random template (Code): runs custom JavaScript code
- Fix Variables (Edit Fields (Set)): sets 4 fields: body, subject, email…
- Send an email (SendGrid): work with mail
- Wait: waits 1 seconds
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 (9)
- Manual Trigger
n8n-nodes-base.manualTrigger - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Merge
n8n-nodes-base.merge - Wait
n8n-nodes-base.wait - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Limit
n8n-nodes-base.limit - SendGrid
n8n-nodes-base.sendGrid - Edit Fields (Set)
n8n-nodes-base.set
From the author
📧 What It Does This n8n workflow sends personalized marketing or outreach emails using predefined templates stored in Google Sheets, with SendGrid as the email delivery provider. Instead of relying on dynamic AI content, this setup selects a ready-made…