Templates / Automate personalized HR email outreach using Gmail, Google Sheets with rate limiting

Automate personalized HR email outreach using Gmail, Google Sheets with rate limiting

Ready for 3.0

by Panth1823 ✓ · 209 views · created 2025-11-28 · HR

Ready 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 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).

  1. Google Sheets: uses Google Sheets
  2. Remove Duplicates: removes duplicate items
  3. Email Validation (If): checks a condition and branches into true / false
  4. Rate Limiter (Code): runs custom JavaScript code
  5. Email Creator (Code): runs custom JavaScript code
  6. Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
  7. Wait: waits 60 seconds
  8. Download Resume (HTTP Request): calls an HTTP API
  9. Send Gmail (Gmail): uses Gmail
  10. If: checks a condition and branches into true / false

…plus 4 more steps. See the full node list below.

Services it uses

GmailGoogle Sheets

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)

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…

Excerpt from Panth1823's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.