Automate Personalized HR Email Outreach using Gmail, Google Sheets with Rate Limiting

Description

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 works
Read HR contact data from Google Sheets.
Remove duplicates and validate email formats.
Apply dynamic daily email sending limits.
Generate personalized email content.
Download resumes for attachments.
Send emails via Gmail with attachments.
Log sending status (success/failure) to Google Sheets.

Setup
Configure Google Sheets credentials.
Configure Gmail OAuth2 credentials.
Update 'Google Sheets - Read HR Data' with your document and sheet IDs.
Define email content in 'Email Creator' node.
Set 'Download Resume' URL to your resume repository.
Update 'Log to Google Sheets' with your tracking sheet IDs.

Customization
Adjust the 'Rate Limiter' node's RAMP_START and LIMIT_BY_WEEK variables to match your desired sending schedule and volume.