Automate personalized HR email outreach using Gmail, Google Sheets with rate limiting
Ready for 3.0What this workflow does
This workflow has 16 nodes and runs on a schedule (every day at 09:00) (plus 1 other trigger). Along the way it connects Gmail and Google Sheets.
How it runs
Trigger: On a schedule (every day at 09:00) (plus 1 other trigger).
- Google Sheets: uses Google Sheets
- Remove Duplicates: removes duplicate items
- Email Validation (If): checks a condition and branches into true / false
- Rate Limiter (Code): runs custom JavaScript code
- Email Creator (Code): runs custom JavaScript code
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Wait: waits 60 seconds
- Download Resume (HTTP Request): calls an HTTP API
- Send Gmail (Gmail): uses Gmail
- If: checks a condition and branches into true / false
…plus 4 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)
- If
n8n-nodes-base.if - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Gmail
n8n-nodes-base.gmail - Google Sheets
n8n-nodes-base.googleSheets - Remove Duplicates
n8n-nodes-base.removeDuplicates - Edit Fields (Set)
n8n-nodes-base.set - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Wait
n8n-nodes-base.wait - Manual Trigger
n8n-nodes-base.manualTrigger
From the author
Automate Personalized HR Email Outreach with Rate Limiting This workflow streamlines HR outreach by fetching contact data, validating emails, enforcing daily sending limits, and sending personalized emails with attachments, all while logging activity. How it…