n8n HR Email Automation: Google Sheets & Gmail CV Sends

Instant HR outreach: send CV/document content from Google Docs to a Google Sheets recipient list via Gmail

This n8n HR Email Automation workflow removes the repetitive work of collecting emails and attaching or copying documents. With a single run, it pulls recipient addresses from Google Sheets, retrieves a Google Docs document (such as a CV or template), and sends it to each recipient using Gmail.

What this workflow does

• Run the workflow (Manual Trigger): HR can trigger the process whenever they need to send out documents.
• Get HR emails from Google Sheets: Reads the list of recipient email addresses from a designated Google Sheet.
• Get a CV from Google Docs: Retrieves the document content from a specified Google Docs file (e.g., a CV or the content you want to share).
• Send emails for HR use via Gmail: Sends the retrieved document content to each recipient email address using Gmail.

Use cases

• HR Communication across contacts: Send the same CV request or document to HR contacts in one run—useful when you need to reach out across different companies.
• Document sharing automation: Pull content directly from a Google Docs file and deliver it via email without manual copy-pasting or per-recipient handling.
• Recruitment & CV handling: Automatically fetch a candidate-related document stored in Google Docs and forward it to the relevant HR recipients.
• Reducing manual work: Centralize recipients in Google Sheets and centralize content in Google Docs, so HR can focus on outreach instead of formatting.

Technical details

• n8n Manual Trigger to start the process when needed
• Google Sheets for recipient email address lookup
• Google Docs for retrieving CV/template content
• Gmail for sending the emails to each recipient

To get started, connect your Google Sheets, Google Docs, and Gmail accounts to n8n with the correct credentials and permissions, prepare the recipient list in the Google Sheet, and ensure the Google Docs file is accessible.