January 22, 2026

Google Sheets + Gmail: HR outreach logged, no dupes

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

You build a careful outreach list, hit send… then realize you emailed the same HR contact twice, attached the wrong file, or blew past a safe daily volume. It’s messy, and it’s avoidable.

Recruiters feel it when follow-ups get awkward. HR coordinators lose hours chasing what was sent and to whom. And a founder doing hiring on the side gets stuck in inbox busywork. This HR outreach automation keeps outreach consistent, paced, and logged without you babysitting every email.

You’ll set up an n8n workflow that pulls rows from Google Sheets, removes duplicates, validates emails, enforces sending limits, attaches a resume, sends via Gmail, then writes the outcome back to Sheets.

How This Automation Works

Here’s the complete workflow you’ll be setting up:

n8n Workflow Template: Google Sheets + Gmail: HR outreach logged, no dupes

Click to explore

flowchart LR

    subgraph sg0["Schedule Flow"]
        direction LR
        n0@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Email Validation1", pos: "b", h: 48 }
        n1["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Rate Limiter"]
        n2["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Email Creator"]
        n3["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>Download Resume"]
        n4@{ icon: "mdi:message-outline", form: "rounded", label: "Send Gmail", pos: "b", h: 48 }
        n5@{ icon: "mdi:database", form: "rounded", label: "Google Sheets - Read HR Data", pos: "b", h: 48 }
        n6@{ icon: "mdi:cog", form: "rounded", label: "Remove Duplicates", pos: "b", h: 48 }
        n7["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Update Counter1"]
        n8["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Handle Failures1"]
        n9@{ icon: "mdi:database", form: "rounded", label: "Log to Google Sheets1", pos: "b", h: 48 }
        n10@{ icon: "mdi:swap-vertical", form: "rounded", label: "Edit Fields1", pos: "b", h: 48 }
        n11@{ icon: "mdi:play-circle", form: "rounded", label: "Schedule Trigger", pos: "b", h: 48 }
        n12@{ icon: "mdi:swap-horizontal", form: "rounded", label: "If", pos: "b", h: 48 }
        n13@{ icon: "mdi:swap-vertical", form: "rounded", label: "Loop Over Items", pos: "b", h: 48 }
        n14@{ icon: "mdi:cog", form: "rounded", label: "Wait", pos: "b", h: 48 }
        n15@{ icon: "mdi:play-circle", form: "rounded", label: "When clicking ‘Execute workf..", pos: "b", h: 48 }
        n12 --> n7
        n12 --> n8
        n14 --> n3
        n4 --> n12
        n10 --> n9
        n1 --> n2
        n2 --> n13
        n3 --> n4
        n13 --> n14
        n7 --> n10
        n8 --> n10
        n11 --> n5
        n0 --> n1
        n6 --> n0
        n9 --> n13
        n5 --> n6
        n15 --> n5
    end

    %% Styling
    classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
    classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
    classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
    classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
    classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
    classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
    classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
    classDef disabled stroke-dasharray: 5 5,opacity: 0.5
    class n11,n15 trigger
    class n0,n12 decision
    class n5,n9 database
    class n3 api
    class n1,n2,n7,n8 code
    classDef customIcon fill:none,stroke:none
    class n1,n2,n3,n7,n8 customIcon

Why This Matters: HR Outreach Breaks When It’s Manual

Manual HR outreach looks simple until you do it at scale. You copy names from a sheet, paste email addresses into Gmail, attach the right resume, tweak the wording, then try to remember if you already sent to “Jordan at Acme” last week. Small mistakes compound. One duplicate email can sour a relationship. One day of over-sending can nudge deliverability the wrong way, which means the next batch quietly lands in spam. And the worst part is the tracking: hours later, you’re hunting through “Sent” trying to reconstruct what happened.

It adds up fast. Here’s where it usually breaks down in real teams.

Duplicates sneak in when lists come from multiple sources, and you don’t notice until someone replies, “You already sent this.”
Attachment handling is surprisingly fragile, especially if resumes live in different folders or shared drives.
Daily sending volume is hard to manage by memory, so outreach spikes and deliverability gets unpredictable.
Status tracking turns into a second job because Sheets, Gmail, and follow-up notes never stay in sync.

What You’ll Build: Personalized Outreach That Sends Safely and Logs Everything

This workflow starts with your HR outreach list in Google Sheets, where each row represents a contact you want to email. n8n pulls those rows on a schedule (or when you run it manually), removes duplicate entries, then checks that email addresses look valid before anything gets sent. Next, it applies a daily sending limit so your outreach stays steady instead of spiky. For each approved row, n8n generates a personalized message, downloads the resume attachment from your repository, and sends the email through Gmail. Finally, it writes a clear success or failure result back to a logging sheet, so you always know what happened and why.

The workflow begins in Google Sheets, then moves through validation and rate limiting. Gmail handles the send, while the logging step closes the loop by updating Sheets with send status and details. You get controlled outreach with a real audit trail.

What You’re Building

What Gets Automated

What You’ll Achieve

Pull HR contact rows from Google Sheets on a schedule or manual run.
Remove duplicate records before you ever reach Gmail.
Validate email formatting and skip bad addresses automatically.
Download the right resume file and attach it to each email send.

Cut “copy/paste + attach + log” down to about 10 minutes of setup.
Send at a steady daily pace, which helps keep deliverability stable.
Get a reliable “sent / failed” log in Sheets you can filter and report on.
Reduce awkward duplicate outreach because deduping happens every run.
Stop guessing what happened by checking one tracking sheet instead of Gmail search.

Expected Results

Say you reach out to 30 HR contacts a day from a Sheet. Manually, a “safe” process is usually: open the row (1 minute), draft and personalize (3 minutes), find and attach the resume (2 minutes), send, then log it back to the sheet (1 minute). That’s about 7 minutes per contact, or roughly 3.5 hours daily. With this workflow, you update the sheet and run it; sending and logging happens automatically, and your time drops to quick list maintenance plus spot-checking failures.

Before You Start

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
Google Sheets to store contacts and logging rows.
Gmail to send outreach from your account.
Resume file hosting (Google Drive or a download URL) for attachments.

Skill level: Intermediate. You’ll connect Google credentials and edit a few “message” and “limit” settings confidently.

Want someone to build this for you? Talk to an automation expert (free 15-minute consultation).

Step by Step

A scheduled or manual trigger starts the run. You can let it fire daily with the schedule trigger, or kick it off on demand when you’ve just updated your sheet.

Contacts are pulled from Google Sheets and cleaned up. n8n reads your HR sheet rows, removes duplicates, and checks basic email format so obvious bad inputs don’t waste sends or ruin your logs.

Sending limits are enforced before email content is created. A rate-limiting step applies your daily plan (including ramping up over time if you want that), then the workflow drafts a personalized message for each approved contact.

Attachments are fetched and emails go out through Gmail. n8n downloads the resume file, attaches it, sends the message, then evaluates whether Gmail returned a success response.

Everything is logged back to Sheets. Successes and failures both get mapped into a clean log row, which means you can filter by status and retry only what failed.

You can easily modify the daily limit rules to match your outreach policy based on role, region, or campaign. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Schedule Trigger

Set up the time-based and manual triggers that start the workflow and route into the same data intake path.

Select Scheduled Start and confirm the schedule rule uses triggerAtHour: 9 so it runs daily at 9 AM.
Keep Manual Run Trigger connected to Fetch HR Sheet Rows so you can test the flow on demand.
Verify both Scheduled Start and Manual Run Trigger feed into Fetch HR Sheet Rows as shown in the execution flow.

Step 2: Connect Google Sheets

Configure the HR data source and logging destination in Google Sheets.

Open Fetch HR Sheet Rows and set Document ID to YOUR_RESOURCE_ID_HERE and Sheet Name to YOUR_RESOURCE_ID_HERE.
Credential Required: Connect your Google Sheets credentials in Fetch HR Sheet Rows.
Open Append Log to Sheets and set Operation to append with Document ID YOUR_RESOURCE_ID_HERE and Sheet Name YOUR_RESOURCE_ID_HERE.
Confirm the column mappings in Append Log to Sheets use expressions like {{ $json.Email }}, {{ $json.emailStatus }}, and {{ $now.format('MM-DD HH:mm:ss') }}.
Credential Required: Connect your Google Sheets credentials in Append Log to Sheets.

⚠️ Common Pitfall: If the sheet IDs are left as YOUR_RESOURCE_ID_HERE, Fetch HR Sheet Rows and Append Log to Sheets will fail to read or write data.

Step 3: Set Up Validation and Sending Limits

Filter valid email addresses, remove duplicates, and apply daily sending limits before drafting messages.

In Eliminate Duplicate Records, keep default settings to de-duplicate the incoming HR rows.
In Validate Email Format, confirm the regex checks use {{ $json["Email"] }} and the patterns ^[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,}$ and ^(?:info|support|sales|admin|no[-.]?reply|noreply|contact|help|service|marketing|team|hello|hi)@.
In Apply Sending Limits, update the ramp settings if needed: RAMP_START = new Date('2025-09-21') and LIMIT_BY_WEEK = [150].
Ensure the flow continues from Validate Email Format → Apply Sending Limits → Compose Email Draft.

Step 4: Configure Drafting, Batching, and Delays

Create the email content, process recipients in batches, and enforce the delay between sends.

In Compose Email Draft, replace the placeholder YOUR_URL_HERE with your actual draft logic or API call.
Use Batch Iterator to split the list; keep options as-is unless you want to specify a batch size.
In Delay Interval, set Amount to 60 to pause 60 seconds between batches.
Confirm the sequence Compose Email Draft → Batch Iterator → Delay Interval → Retrieve Resume File.

Tip: If you need faster or slower sending, adjust Delay Interval Amount from 60 to your preferred delay.

Step 5: Configure Email Sending and Logging

Attach the resume file, send the email via Gmail, evaluate success, and log results back to Sheets.

In Retrieve Resume File, set URL to YOUR_GOOGLE_DRIVE_URL_HERE and keep Response Format set to file.
Open Dispatch Gmail Message and set Send To to {{ $json.Email }}, Subject to {{ $json.emailSubject }}, and Message to {{ $json.emailBody }}.
Credential Required: Connect your Gmail credentials in Dispatch Gmail Message.
Use Send Result Check to route successes to Increment Send Counter and failures to Process Failure Case.
In Map Log Fields, confirm mappings like {{ $('Retrieve Resume File').item.json.Email }} and {{ $json.emailStatus }} for logging.
Ensure Map Log Fields outputs to Append Log to Sheets so every send attempt is recorded.

⚠️ Common Pitfall: If Dispatch Gmail Message lacks credentials, the workflow will still continue because Continue On Fail is enabled, but all sends will be logged as failures.

Step 6: Test and Activate Your Workflow

Run a manual test to validate the flow, then activate the scheduled run for production use.

Click Manual Run Trigger to execute the workflow and process a small sample of HR rows.
Verify that Dispatch Gmail Message returns a non-empty id and that Send Result Check routes to Increment Send Counter for successes.
Confirm that Append Log to Sheets appends a row with fields like {{ $json.Email }} and {{ $json.emailSubject }}.
Once the test succeeds, toggle the workflow to Active so Scheduled Start runs daily at 9 AM.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Troubleshooting Tips

Google Sheets credentials can expire or need specific permissions. If things break, check the n8n Credentials menu and confirm the connected Google account still has access to the source and log spreadsheets first.
If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
Gmail OAuth permissions matter more than people expect. If “Dispatch Gmail Message” fails, re-check your Gmail credential scope in n8n and confirm the sending account hasn’t hit daily send limits.

Quick Answers

What’s the setup time for this HR outreach automation?

About 30 minutes if your Sheets and Gmail access are ready.

Is coding required for this HR outreach automation?

No. You’ll mainly connect accounts and edit the email template and limits. The workflow already includes the logic for deduping, rate limiting, and logging.

Is n8n free to use for this HR outreach automation workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in typical costs for hosting your resume files (often $0 if you use Google Drive).

Where can I host n8n to run this automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.

Can I modify this HR outreach automation workflow for different use cases?

Yes, and you probably should. Most teams customize the “Compose Email Draft” step for tone, role type, and follow-up language, then adjust “Apply Sending Limits” to match their warm-up plan. You can also swap the attachment source by changing “Retrieve Resume File” to pull from Google Drive instead of a public URL. If you want campaign-specific tracking, add more columns in “Map Log Fields” so the log captures things like role name, region, or recruiter owner.

Why is my Gmail connection failing in this workflow?

Usually it’s an OAuth permission issue or an expired Google login. Reconnect your Gmail credential in n8n, then confirm the sending account can send emails normally and hasn’t hit a daily sending cap. If it fails only on some rows, check the email addresses that passed through validation and make sure you’re not sending to blank or malformed values pulled from Sheets.

What volume can this HR outreach automation workflow process?

It depends on your plan and the limits you set. On n8n Cloud Starter, you’re working within your monthly execution allowance, while self-hosting has no execution cap (your server becomes the limiter). In practice, this workflow is built for paced sending, so it’s common to run 20–200 emails per day with waits between batches to keep Gmail happy.

Is this HR outreach automation better than using Zapier or Make?

Often, yes. This workflow relies on branching logic (success vs. failure handling), deduplication, and a configurable rate limiter, which are doable in Zapier/Make but tend to get awkward or expensive as the flow grows. n8n also gives you the self-hosting option, which is a big deal when you’re running outreach every day. That said, if you only need “read one row, send one email,” Zapier can be quicker to get running. Talk to an automation expert if you want help choosing.

Once this is in place, outreach becomes a controlled system instead of a daily scramble. Your sheet stays truthful, your sending pace stays sane, and you get time back for the work that actually moves hiring forward.

Need Help Setting This Up?

Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

{
"id": null,
"name": "Automated HR Outreach Email Flow",
"tags": [],
"nodes": [
{
"id": "flowpast-topbar-11329",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
20
],
"parameters": {
"color": 7,
"width": 990,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "0c65668e-bad4-4c65-a3e4-b0a8c2a957f5",
"name": "Validate Email Format",
"type": "n8n-nodes-base.if",
"position": [
0,
180
],
"parameters": {
"options": [],
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "88d7ea8a-c3c3-4b6f-ac8a-aac877f13bda",
"operator": {
"type": "string",
"operation": "regex"
},
"leftValue": "={{$json[\"Email\"]}}",
"rightValue": "^[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\\.[A-Za-z]{2,}$"
},
{
"id": "07f8bfdf-368f-46a9-9600-be3556706046",
"operator": {
"type": "string",
"operation": "notRegex"
},
"leftValue": "={{$json[\"Email\"]}}",
"rightValue": "^(?:info|support|sales|admin|no[-.]?reply|noreply|contact|help|service|marketing|team|hello|hi)@"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "ee9cdafc-6566-4e83-9d2e-690aef94b650",
"name": "Apply Sending Limits",
"type": "n8n-nodes-base.code",
"position": [
65,
375
],
"parameters": {
"jsCode": "// Get input items\nconst items = $input.all();\n\n// Config - Updated to start from current date\nconst RAMP_START = new Date('2025-09-21'); // Changed from '2025-09-28'\nconst LIMIT_BY_WEEK = [150];  // weeks 1..4+, capped at last\n\n// Week since start (1-based, clamped)\nconst msPerWeek = 7 * 24 * 60 * 60 * 1000;\nconst weeksSinceStart = Math.floor((Date.now() - RAMP_START.getTime()) / msPerWeek) + 1;\nconst dailyLimit = LIMIT_BY_WEEK[Math.min(weeksSinceStart, LIMIT_BY_WEEK.length) - 1];\n\n// Local \"today\" to avoid UTC boundary surprises (00:00 local)\nconst now = new Date();\nconst today = `${now.getFullYear()}-${String(now.getMonth()+1).padStart(2,'0')}-${String(now.getDate()).padStart(2,'0')}`;\n\n// Get/reset counter\nlet sentToday = $getWorkflowStaticData('node');\nif (!sentToday.date || sentToday.date !== today) {\n  sentToday.date = today;\n  sentToday.count = 0;\n}\n\n// Calculate how many emails we can still send today\nconst remainingToday = Math.max(0, dailyLimit - sentToday.count);\n\nconsole.log('Rate limiting info:', { \n  today, \n  currentCount: sentToday.count, \n  dailyLimit, \n  remainingToday, \n  weeksSinceStart,\n  totalInputEmails: items.length\n});\n\n// If no emails can be sent today, return empty array\nif (remainingToday === 0) {\n  console.log('Daily limit reached - no emails will be sent');\n  return [];\n}\n\n// Take only the emails we can send today\nconst emailsToSend = items.slice(0, remainingToday);\n\n// DON'T UPDATE COUNTER HERE - wait until emails are actually sent\nconsole.log(`Preparing to send ${emailsToSend.length} emails. Current count: ${sentToday.count}/${dailyLimit}`);\n\n// Return ALL emails to send with metadata\nreturn emailsToSend.map((item, index) => ({\n  json: { \n    ...item.json, \n    canSend: true, \n    currentSentToday: sentToday.count,\n    dailyLimit, \n    weeksSinceStart,\n    batchSize: emailsToSend.length,\n    emailIndex: index + 1,\n    totalToSend: emailsToSend.length\n  }\n}));"
},
"typeVersion": 2
},
{
"id": "554bee55-818f-444c-b337-6fdd80ea385d",
"name": "Compose Email Draft",
"type": "n8n-nodes-base.code",
"position": [
220,
395
],
"parameters": {
"jsCode": "YOUR_URL_HERE"
},
"typeVersion": 2
},
{
"id": "26af4f1e-94f2-48b6-a9e1-46cbf45124a3",
"name": "Retrieve Resume File",
"type": "n8n-nodes-base.httpRequest",
"position": [
890,
385
],
"parameters": {
"url": "YOUR_GOOGLE_DRIVE_URL_HERE",
"options": {
"response": {
"response": {
"responseFormat": "file"
}
}
}
},
"executeOnce": true,
"typeVersion": 4.2,
"alwaysOutputData": true
},
{
"id": "ae321150-8ac7-45de-89b7-ae22f7b80d6b",
"name": "Dispatch Gmail Message",
"type": "n8n-nodes-base.gmail",
"position": [
700,
650
],
"webhookId": "",
"parameters": {
"sendTo": "={{$json.Email}}",
"message": "={{ $json.emailBody }}",
"options": {
"attachmentsUi": {
"attachmentsBinary": [
[]
]
}
},
"subject": "={{ $json.emailSubject }}"
},
"typeVersion": 2.1,
"continueOnFail": true,
"alwaysOutputData": true
},
{
"id": "7f75bd28-658e-4bc0-93ff-80977d88fd69",
"name": "Fetch HR Sheet Rows",
"type": "n8n-nodes-base.googleSheets",
"position": [
415,
170
],
"parameters": {
"options": [],
"sheetName": {
"__rl": true,
"mode": "list",
"value": "YOUR_RESOURCE_ID_HERE"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "YOUR_RESOURCE_ID_HERE"
}
},
"typeVersion": 4.7,
"alwaysOutputData": true
},
{
"id": "4cbb8ff6-55b8-4726-b1a8-cf5f236cca53",
"name": "Eliminate Duplicate Records",
"type": "n8n-nodes-base.removeDuplicates",
"position": [
175,
155
],
"parameters": {
"options": []
},
"typeVersion": 2
},
{
"id": "2f2f8673-627e-42f7-88ab-8a64d2fc0e2e",
"name": "Increment Send Counter",
"type": "n8n-nodes-base.code",
"position": [
370,
590
],
"parameters": {
"jsCode": "// Update the counter for successfully sent email\nconst item = $input.first();\n\n// Get today's date\nconst now = new Date();\nconst today = `${now.getFullYear()}-${String(now.getMonth()+1).padStart(2,'0')}-${String(now.getDate()).padStart(2,'0')}`;\n\n// Get/update counter\nlet sentToday = $getWorkflowStaticData('node');\nif (!sentToday.date || sentToday.date !== today) {\n  sentToday.date = today;\n  sentToday.count = 0;\n}\n\n// Increment counter by 1 for this successfully sent email\nsentToday.count += 1;\n\nconsole.log(`Email sent successfully to: ${item.json.Email}`);\nconsole.log(`Total sent today: ${sentToday.count}`);\n\n// Return the item with success status\nreturn [{\n  json: {\n    ...item.json,\n    emailStatus: 'sent',\n    totalSentToday: sentToday.count,\n    sentDate: new Date().toISOString(),\n    success: true\n  }\n}];"
},
"typeVersion": 2,
"alwaysOutputData": true
},
{
"id": "cca22795-e112-450a-a86c-5f34e3d36fe5",
"name": "Process Failure Case",
"type": "n8n-nodes-base.code",
"position": [
405,
720
],
"parameters": {
"jsCode": "// Handle failed email\nconst item = $input.first();\n\n// Extract error message if available\nlet errorMessage = 'Unknown error';\nif (item.json.error) {\n  errorMessage = typeof item.json.error === 'string' ? item.json.error : JSON.stringify(item.json.error);\n} else if (item.json.message) {\n  errorMessage = item.json.message;\n}\n\nconsole.log(`Email failed to send to: ${item.json.Email}`);\nconsole.log(`Error: ${errorMessage}`);\n\n// Return item with failed status\nreturn [{\n  json: {\n    ...item.json,\n    emailStatus: 'failed',\n    failureReason: errorMessage,\n    failedDate: new Date().toISOString(),\n    success: false\n  }\n}];"
},
"typeVersion": 2,
"alwaysOutputData": true
},
{
"id": "779d1514-6b77-4c16-b88f-4e4db7c45d8a",
"name": "Append Log to Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
15,
645
],
"parameters": {
"columns": {
"value": {
"Name ": "={{ $json.Name }}",
"email ": "={{ $json.Email }}",
"status ": "={{ $json.emailStatus }}",
"Company ": "={{ $json.Company }}",
"sentDate ": "={{ $now.format('MM-DD HH:mm:ss') }}",
"emailSubject": "={{ $json.emailSubject }}"
},
"schema": [
{
"id": "email ",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "email ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Name ",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Name ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company ",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Company ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "status ",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "status ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "sentDate ",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "sentDate ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "emailSubject",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "emailSubject",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "YOUR_RESOURCE_ID_HERE"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "YOUR_RESOURCE_ID_HERE"
}
},
"typeVersion": 4.7
},
{
"id": "49081a57-e8e2-4d7c-a74a-ff1ea2f8fbde",
"name": "Map Log Fields",
"type": "n8n-nodes-base.set",
"position": [
165,
655
],
"parameters": {
"options": [],
"assignments": {
"assignments": [
{
"id": "5afe75fb-0362-442c-b2d5-25873059a159",
"name": "emailStatus",
"type": "string",
"value": "={{ $json.emailStatus }}"
},
{
"id": "63ca4777-d636-4bbc-8e90-84b13485b820",
"name": "failureReason",
"type": "string",
"value": "={{ $json.failureReason }}"
},
{
"id": "8d5ea9a4-b935-492a-913c-7e3b644bb1de",
"name": "SNo",
"type": "number",
"value": "={{ $('Retrieve Resume File').item.json.SNo }}"
},
{
"id": "cd380045-b087-441f-9207-916ad351b779",
"name": "Name",
"type": "string",
"value": "={{ $('Retrieve Resume File').item.json.Name }}"
},
{
"id": "f897bb52-37a1-4979-b042-00bdbea25470",
"name": "Email",
"type": "string",
"value": "={{ $('Retrieve Resume File').item.json.Email }}"
},
{
"id": "3ac6efb9-23c2-4810-ad72-28a9bd1fdc01",
"name": "Title",
"type": "string",
"value": "={{ $('Retrieve Resume File').item.json.Title }}"
},
{
"id": "044f8868-2669-461f-ba70-bd067489d37b",
"name": "Company",
"type": "string",
"value": "={{ $('Retrieve Resume File').item.json.Company }}"
},
{
"id": "7cd30591-5fa5-497b-8eac-0732afd712db",
"name": "emailSubject",
"type": "string",
"value": "={{ $('Retrieve Resume File').item.json.emailSubject }}"
},
{
"id": "cf53b800-264f-4813-9da9-8c072f46356a",
"name": "firstName",
"type": "string",
"value": "={{ $('Retrieve Resume File').item.json.firstName }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "668eb556-46e1-4820-8367-4d7bd06130e3",
"name": "Scheduled Start",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
570,
120
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 9
}
]
}
},
"typeVersion": 1.2
},
{
"id": "c3ef6f9f-f42a-4b99-a477-30a424d0d03a",
"name": "Send Result Check",
"type": "n8n-nodes-base.if",
"position": [
535,
635
],
"parameters": {
"options": [],
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "88364e2e-629a-43b0-8c40-30196f20b27c",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.id }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "c9d72b91-1196-4a99-813b-545c23fa6e65",
"name": "Batch Iterator",
"type": "n8n-nodes-base.splitInBatches",
"position": [
450,
365
],
"parameters": {
"options": []
},
"typeVersion": 3
},
{
"id": "6f82fe6f-57e4-457f-ad69-c1fa4aa7c422",
"name": "Delay Interval",
"type": "n8n-nodes-base.wait",
"position": [
600,
410
],
"webhookId": "",
"parameters": {
"amount": 60
},
"typeVersion": 1.1
},
{
"id": "84bab284-deed-4df4-a33d-e567a18311dc",
"name": "Manual Run Trigger",
"type": "n8n-nodes-base.manualTrigger",
"position": [
810,
140
],
"parameters": [],
"typeVersion": 1
}
],
"active": false,
"pinData": [],
"settings": {
"executionOrder": "v1"
},
"connections": {
"Send Result Check": {
"main": [
[
{
"node": "Increment Send Counter",
"type": "main",
"index": 0
}
],
[
{
"node": "Process Failure Case",
"type": "main",
"index": 0
}
]
]
},
"Delay Interval": {
"main": [
[
{
"node": "Retrieve Resume File",
"type": "main",
"index": 0
}
]
]
},
"Dispatch Gmail Message": {
"main": [
[
{
"node": "Send Result Check",
"type": "main",
"index": 0
}
]
]
},
"Map Log Fields": {
"main": [
[
{
"node": "Append Log to Sheets",
"type": "main",
"index": 0
}
]
]
},
"Apply Sending Limits": {
"main": [
[
{
"node": "Compose Email Draft",
"type": "main",
"index": 0
}
]
]
},
"Compose Email Draft": {
"main": [
[
{
"node": "Batch Iterator",
"type": "main",
"index": 0
}
]
]
},
"Retrieve Resume File": {
"main": [
[
{
"node": "Dispatch Gmail Message",
"type": "main",
"index": 0
}
]
]
},
"Batch Iterator": {
"main": [
[],
[
{
"node": "Delay Interval",
"type": "main",
"index": 0
}
]
]
},
"Increment Send Counter": {
"main": [
[
{
"node": "Map Log Fields",
"type": "main",
"index": 0
}
]
]
},
"Process Failure Case": {
"main": [
[
{
"node": "Map Log Fields",
"type": "main",
"index": 0
}
]
]
},
"Scheduled Start": {
"main": [
[
{
"node": "Fetch HR Sheet Rows",
"type": "main",
"index": 0
}
]
]
},
"Validate Email Format": {
"main": [
[
{
"node": "Apply Sending Limits",
"type": "main",
"index": 0
}
]
]
},
"Eliminate Duplicate Records": {
"main": [
[
{
"node": "Validate Email Format",
"type": "main",
"index": 0
}
]
]
},
"Append Log to Sheets": {
"main": [
[
{
"node": "Batch Iterator",
"type": "main",
"index": 0
}
]
]
},
"Fetch HR Sheet Rows": {
"main": [
[
{
"node": "Eliminate Duplicate Records",
"type": "main",
"index": 0
}
]
]
},
"Manual Run Trigger": {
"main": [
[
{
"node": "Fetch HR Sheet Rows",
"type": "main",
"index": 0
}
]
]
}
},
"meta": {
"instanceId": "456773266ccd7016da3639bd0a9809e6fe5d52e2851a00318f93a23f424efda6",
"templateId": null,
"templateCredsSetupCompleted": null
},
"versionId": null
}