January 22, 2026

Google Sheets + Gmail: offer letters sent and filed

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

Your hiring process shouldn’t fall apart because one candidate forgot to upload an ID or someone can’t find “OfferLetter_Final_FINAL(2).pdf”. But that’s exactly how it goes: lots of tabs, Slack pings, and “just following up” emails that eat up your day.

HR managers feel this when they’re juggling five open roles. Recruiters run into it when they’re moving fast and still need an audit trail. Even an ops lead in a small business ends up doing offer letter automation by hand, one candidate at a time.

This workflow turns Google Sheets into a reliable pipeline: it checks document status, sends reminders, generates a polished PDF offer letter, emails it, stores it in Drive, and updates the sheet so everyone stays aligned.

How This Automation Works

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

n8n Workflow Template: Google Sheets + Gmail: offer letters sent and filed

Click to explore

flowchart LR

    subgraph sg0["Google Sheets Flow"]
        direction LR
        n0@{ icon: "mdi:play-circle", form: "rounded", label: "Google Sheets Trigger", pos: "b", h: 48 }
        n1@{ icon: "mdi:cog", form: "rounded", label: "Get PDF", pos: "b", h: 48 }
        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/httprequest.dark.svg' width='40' height='40' /></div><br/>PDF Generate"]
        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 PDF"]
        n4["<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/slack.svg' width='40' height='40' /></div><br/>Send a message to Manager"]
        n5@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Check Document Status(If Doc..", pos: "b", h: 48 }
        n6["<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/>Create Offer Letter"]
        n7@{ icon: "mdi:message-outline", form: "rounded", label: "Send Missing Document Email", pos: "b", h: 48 }
        n8@{ icon: "mdi:database", form: "rounded", label: "Change Status", pos: "b", h: 48 }
        n9@{ icon: "mdi:cog", form: "rounded", label: "Upload Offer Letter", pos: "b", h: 48 }
        n10@{ icon: "mdi:database", form: "rounded", label: "Add Offer Letter in Sheet", pos: "b", h: 48 }
        n11@{ icon: "mdi:message-outline", form: "rounded", label: "Send Offer Letter To Candidate", pos: "b", h: 48 }
        n12@{ icon: "mdi:database", form: "rounded", label: "Change Status in Sheet", pos: "b", h: 48 }
        n1 --> n3
        n3 --> n9
        n3 --> n11
        n3 --> n4
        n2 --> n1
        n6 --> n2
        n9 --> n10
        n0 --> n5
        n4 --> n12
        n7 --> n8
        n5 --> n7
        n5 --> n6
    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 n0 trigger
    class n5 decision
    class n8,n10,n12 database
    class n2,n3 api
    class n6 code
    classDef customIcon fill:none,stroke:none
    class n2,n3,n4,n6 customIcon

Why This Matters: Offer Letters Get Stuck in the Middle

Offer letters are “simple” until they aren’t. One candidate is missing a document, another needs a salary line updated, and the hiring manager wants confirmation the offer actually went out. Meanwhile the source of truth (your spreadsheet) is out of date because updating it is the last step, and the last step never happens when you’re busy. So you re-check the same rows, resend the same emails, and hunt through Drive for the right PDF. It’s not hard work. It’s draining work.

The friction compounds. Here’s where things usually break down.

You spend about 20 minutes per candidate chasing missing documents through email threads.
Offer letters get generated inconsistently, which means more revisions and slower approvals.
Files end up scattered across inboxes and Drive folders, so nobody trusts where the final PDF lives.
Status in Google Sheets lags behind reality, and that creates awkward “did we send this?” moments.

What You’ll Build: A Self-Updating Offer Letter Pipeline

This workflow watches your candidate tracker in Google Sheets and reacts the moment a row is updated. First, it checks the candidate’s document status. If anything is missing, it automatically sends a reminder email through Gmail, updates the sheet to a “Documents_Pending” state, and stops there (no accidental offer letters sent early). Once documents are complete, it generates a customized offer letter using the candidate data (role, salary, contact info), converts the HTML into a clean PDF via an HTTP request to a conversion service, and retrieves the final file. Then it emails the PDF to the candidate, alerts the hiring manager in Slack, uploads the letter to Google Drive, and writes the Drive link back into the same Google Sheet. The sheet stays accurate without you babysitting it.

The workflow starts with a Sheets update and a document check. It branches into either “send reminder + mark pending” or “generate PDF + deliver + file.” Finally, it records the link and marks the candidate as Offer_Sent so your pipeline stays trustworthy.

What You’re Building

What Gets Automated

What You’ll Achieve

Watching Google Sheets for candidate status and document updates.
Sending Gmail reminders when onboarding documents are missing.
Generating a tailored offer letter and converting it from HTML to PDF.
Uploading the PDF to Google Drive and writing the link back to the sheet.

Save about 1 hour per hire by eliminating follow-ups and file handling.
Offer letters go out the same day instead of “when someone gets to it.”
Hiring managers get automatic Slack updates, so fewer check-in messages hit your inbox.
Your Google Sheet becomes a living audit trail, not a stale checklist.
Candidates get a smoother experience, which honestly matters more than people admit.

Expected Results

Say you hire 5 people this month. Manually, each offer typically takes about 20 minutes to verify docs, 15 minutes to format/export a PDF, 10 minutes to email, and another 10 minutes to file it and update the sheet, so roughly 1 hour per hire. With this workflow, you update one row in Google Sheets and the rest runs in the background: a minute to trigger, a short wait for PDF conversion, then it’s delivered, stored, and logged automatically. That’s about 5 hours back in a month, plus fewer mistakes.

Before You Start

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
Google Sheets for candidate tracker and statuses.
Gmail to send reminders and offer letters.
ConvertAPI credentials (get the API key from your ConvertAPI dashboard)

Skill level: Beginner. You’ll connect accounts and edit a few template fields, but you won’t be writing a bunch of code.

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

Step by Step

A candidate row changes in Google Sheets. The workflow monitors your tracker, so when you update a candidate’s document status or move them forward, it kicks off immediately.

Document status gets reviewed. An “If” check looks for missing onboarding documents and decides what happens next, so you don’t accidentally generate an offer letter for someone who isn’t ready.

Either a reminder goes out or an offer letter is created. If documents are pending, Gmail sends a clear reminder and the sheet is updated to Documents_Pending. If documents are complete, a code step composes the offer letter content, then an HTTP request sends it to the PDF conversion service and retrieves the finished file.

The PDF is delivered, stored, and logged. The candidate receives the offer letter via Gmail, the hiring manager gets a Slack notification, Google Drive stores the PDF, and Google Sheets records the Drive link and marks the candidate as Offer_Sent.

You can easily modify the email copy and the offer letter template to match your brand voice based on your needs. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Google Sheets Trigger

This workflow starts when a row changes in your onboarding spreadsheet.

Add and open Sheets Change Watcher.
Set Document to [YOUR_ID] and Sheet Name to Sheet1 (gid=0).
Set Poll Times to Every Minute.
Credential Required: Connect your Google Sheets credentials.

Step 2: Connect Google Sheets for Status Routing

The workflow checks document status and routes candidates into the correct path.

Open Review Document Status and set the condition to Document Status equals Pending using {{ $json["Document Status"] }}.
Ensure the false branch of Review Document Status goes to Compose Offer Letter for approved candidates.
Credential Required: Connect your Google Sheets credentials for downstream nodes Update Pending Status, Record Letter Link, and Mark Offer Sent.

⚠️ Common Pitfall: If the Document Status column uses a different value than Pending, the routing won’t work. Match the exact text in your sheet.

Step 3: Set Up Offer Letter Generation & PDF Conversion

Approved candidates trigger HTML generation and PDF conversion.

Open Compose Offer Letter and review the embedded HTML template in JavaScript Code. Update company details like Example Company, [YOUR_EMAIL], and [YOUR_PHONE] as needed.
In PDF Conversion Call, set URL to https://v2.convertapi.com/convert/html/to/pdf and Method to POST.
Keep Body Parameters with StoreFile=true and File mapped to data.
Set the Authorization header to [CONFIGURE_YOUR_TOKEN] in PDF Conversion Call.
In Parse PDF Output, set Operation to fromJson.
In Retrieve PDF File, set URL to {{ $json.data.Files[0].Url }}.

⚠️ Common Pitfall: If ConvertAPI credentials are missing or invalid, PDF Conversion Call will return an error and no PDF will be generated.

Step 4: Configure Output Actions (Email, Drive, Slack, Sheets)

After the PDF is retrieved, the workflow sends notifications, stores the file, and updates the spreadsheet. Retrieve PDF File outputs to Upload Letter to Drive and Email Offer Letter and Notify Manager Channel in parallel.

In Email Offer Letter, set Send To to {{ $('Review Document Status').item.json.Email }} and confirm the subject 🎉 Congratulations! Your Offer Letter from Example Company.
Credential Required: Connect your Gmail credentials for Email Offer Letter and Dispatch Missing Docs Email.
In Upload Letter to Drive, set Name to {{ $('Review Document Status').item.json['Candidate ID'] }} and choose your Folder ID as [YOUR_ID].
Credential Required: Connect your Google Drive credentials.
In Notify Manager Channel, set Channel to [YOUR_ID] and keep the message template using {{ $('Review Document Status').item.json.Name }} and {{ $('Review Document Status').item.json.Profession }}.
Credential Required: Connect your Slack credentials.
In Record Letter Link, set Candidate ID to {{ $('Review Document Status').item.json['Candidate ID'] }} and Offer Letter Link to {{ $json.webViewLink }}.
In Mark Offer Sent, set Candidate Status to Offer_Sent and match on Candidate ID.

⚠️ Common Pitfall: If the Drive upload fails, Record Letter Link will not receive webViewLink and the sheet update will be incomplete.

Step 5: Configure the Missing Documents Email Path

When documents are still pending, the workflow sends a reminder and updates the sheet.

Open Dispatch Missing Docs Email and verify Send To uses {{ $json.Email }}.
Keep the Subject as Reminder:{{ $json.Name }} Please submit your pending documents to proceed with your offer and verify the pending documents section uses {{ $json['Pending Documents'] }}.
In Update Pending Status, set Candidate Status to Documents_Pending and match on Candidate ID using {{ $('Review Document Status').item.json["Candidate ID"] }}.
Credential Required: Connect your Google Sheets credentials.

Step 6: Test and Activate Your Workflow

Validate both the pending-docs and approved-docs paths before going live.

Manually run the workflow with a test row where Document Status is Pending and confirm Dispatch Missing Docs Email sends and Update Pending Status updates the sheet.
Run again with Document Status not equal to Pending and confirm Compose Offer Letter → PDF Conversion Call → Parse PDF Output → Retrieve PDF File completes, then check the parallel actions (Drive upload, candidate email, and Slack notification).
Check that Record Letter Link and Mark Offer Sent update the candidate’s row in your sheet.
When everything works, toggle the workflow to Active for production use.

🔒

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 screen and confirm the Google account still has access to the spreadsheet.
If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
Default prompts in AI nodes are generic. Add your brand voice early or you’ll be editing outputs forever.

Quick Answers

What’s the setup time for this offer letter automation automation?

About 30 minutes if your accounts are already connected.

Is coding required for this offer letter automation?

No. You’ll mostly copy in an offer letter template and map fields from Google Sheets.

Is n8n free to use for this offer letter 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 ConvertAPI usage (typically a small per-file cost, depending on your plan).

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 offer letter automation workflow for different use cases?

Yes, and you should. You can replace Gmail with a shared inbox setup (still Gmail, just different credentials), tweak the “Compose Offer Letter” code step to match your contract language, and change the Google Drive folder destination in the upload step. Some teams also add a manager approval checkpoint by inserting a Slack message and only sending the offer after a reaction or a manual status change in Google Sheets.

Why is my Google Sheets connection failing in this workflow?

Usually it’s an expired Google authorization or the sheet moved to a Drive location your connected account can’t access. Reconnect Google Sheets in n8n, then re-select the spreadsheet in the nodes that reference it. Also check that the trigger still points to the right document and worksheet tab, because renaming tabs can break lookups.

What volume can this offer letter automation workflow process?

For most small teams, dozens of candidates per week is fine.

Is this offer letter automation automation better than using Zapier or Make?

For this workflow, n8n has a few advantages: more complex logic with branching at no extra cost, a self-hosting option for unlimited executions, and easier handling of “generate file then fetch file” patterns through HTTP requests. Zapier or Make can still do parts of this, but file conversion plus reliable status updates tends to get fiddly. If you only need “send an email when a row changes,” they may be quicker. If you want the full lifecycle with reminders, PDF generation, Drive filing, and a clean audit trail, n8n is usually the smoother build. Talk to an automation expert if you’re not sure which fits.

Once this is running, your spreadsheet stops being a wish and starts being the record. The workflow handles the repetitive follow-ups and filing so you can focus on the actual hiring decisions.

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": "",
"name": "Automated Offer Letter Workflow",
"versionId": "",
"meta": {
"instanceId": "a9383300ec1c7250db94d7487e5aacaa1a937508b31f1f5d5a3ce3d9e8e7eda1"
},
"nodes": [
{
"id": "flowpast-topbar-11916",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
20
],
"parameters": {
"color": 7,
"width": 870,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "7eefa653-1d50-48d2-9f3f-48323a0a1f1c",
"name": "Sheets Change Watcher",
"type": "n8n-nodes-base.googleSheetsTrigger",
"position": [
770,
140
],
"parameters": {
"options": [],
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "Onboarding Workflows"
}
},
"typeVersion": 1
},
{
"id": "6f075f9c-d612-4794-84c7-ed77dcdc2aa8",
"name": "Parse PDF Output",
"type": "n8n-nodes-base.extractFromFile",
"position": [
10,
320
],
"parameters": {
"options": [],
"operation": "fromJson"
},
"typeVersion": 1
},
{
"id": "f9b95280-3d09-47bc-aaaa-f37f00c7c9d7",
"name": "PDF Conversion Call",
"type": "n8n-nodes-base.httpRequest",
"position": [
20,
170
],
"parameters": {
"url": "https://v2.convertapi.com/convert/html/to/pdf",
"method": "POST",
"options": {
"response": {
"response": {
"responseFormat": "file"
}
}
},
"sendBody": true,
"contentType": "multipart-form-data",
"sendHeaders": true,
"bodyParameters": {
"parameters": [
{
"name": "StoreFile",
"value": "true"
},
{
"name": "File",
"parameterType": "formBinaryData",
"inputDataFieldName": "data"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "Authorization",
"value": "[CONFIGURE_YOUR_TOKEN]"
}
]
}
},
"notesInFlow": true,
"typeVersion": 4.2
},
{
"id": "5e209a30-88c2-4515-80c1-8a8780e9f7de",
"name": "Retrieve PDF File",
"type": "n8n-nodes-base.httpRequest",
"position": [
260,
360
],
"parameters": {
"url": "={{ $json.data.Files[0].Url }}",
"options": []
},
"typeVersion": 4.2
},
{
"id": "7d52b706-7c66-41f1-8634-8659701d6f96",
"name": "Notify Manager Channel",
"type": "n8n-nodes-base.slack",
"position": [
10,
490
],
"webhookId": "e6b41939-bc37-46f4-b536-0c8f6f4f9224",
"parameters": {
"text": "=\ud83d\udce2 New Candidate Update\n\nThe offer letter for {{ $('Review Document Status').item.json.Name }}({{ $('Review Document Status').item.json.Profession }}) has been sent.\nThis candidate is a new joining.\n\nPlease take note and prepare for the onboarding process.",
"select": "channel",
"channelId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultName": "new-channel"
},
"otherOptions": []
},
"typeVersion": 2.3
},
{
"id": "5b7bc055-daf7-4061-a709-5b99b148efef",
"name": "Review Document Status",
"type": "n8n-nodes-base.if",
"position": [
510,
180
],
"parameters": {
"options": [],
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "06e87a9e-4475-483d-a387-4656cc34760e",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json[\"Document Status\"] }}",
"rightValue": "=Pending"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "95d22c3f-5567-4920-bf4a-7461a1e6efa2",
"name": "Compose Offer Letter",
"type": "n8n-nodes-base.code",
"position": [
260,
120
],
"parameters": {
"jsCode": "// Get first input JSON\nconst data = $input.first().json;\n\n// Formal, long, corporate Offer Letter\nconst htmlContent = `\n<!doctype html>\n<html lang=\"en\">\n<head>\n  <meta charset=\"utf-8\" />\n  <title>Offer Letter</title>\n  <style>\n    body {\n      font-family: \"Times New Roman\", serif;\n      background: #fff;\n      color: #000;\n      padding: 60px;\n      font-size: 13pt;\n      line-height: 1.7;\n    }\n    .container {\n      max-width: 800px;\n      margin: auto;\n    }\n    header {\n      text-align: center;\n      margin-bottom: 40px;\n    }\n    header h1 {\n      font-size: 20pt;\n      margin: 0;\n      text-transform: uppercase;\n    }\n    header p {\n      margin: 4px 0;\n      font-size: 11pt;\n    }\n    .date {\n      text-align: right;\n      margin-bottom: 30px;\n    }\n    .subject {\n      font-weight: bold;\n      margin: 20px 0;\n      text-decoration: underline;\n    }\n    p {\n      margin: 12px 0;\n      text-align: justify;\n    }\n    .highlight {\n      font-weight: bold;\n    }\n    .section-title {\n      font-weight: bold;\n      margin-top: 18px;\n      text-decoration: underline;\n    }\n    .signature {\n      margin-top: 60px;\n    }\n    .signature p {\n      margin: 4px 0;\n    }\n    footer {\n      margin-top: 80px;\n      font-size: 10pt;\n      color: #555;\n      text-align: center;\n    }\n  </style>\n<link rel="preload" as="image" href="https://flowpast.s3.eu-north-1.amazonaws.com/featured_blog_images/107499.webp"><link rel="preload" as="image" href="https://flowpast.s3.eu-north-1.amazonaws.com/featured_blog_images/107499.webp"></head>
\n<body>\n  <div class=\"container\">\n    <header>\n      <h1>Example Company</h1>\n      <p>123 Business Street, City, State, PIN</p>\n      <p>Email: [YOUR_EMAIL] | Phone: [YOUR_PHONE]</p>\n    </header>\n\n    <div class=\"date\">Date: ${new Date().toLocaleDateString()}</div>\n\n    <p>To,<br>\n    <span class=\"highlight\">${data.Name || ''}</span><br>\n    Email: ${data.Email || ''}<br>\n    Phone: ${data.Phone || ''}</p>\n\n    <div class=\"subject\">Subject: Offer of Employment</div>\n\n    <p>Dear <span class=\"highlight\">${data.Name || ''}</span>,</p>\n\n    <p>We are pleased to offer you employment with <span class=\"highlight\">Example Company</span>. After a thorough evaluation of your qualifications, skills, and experience, we are confident in your ability to contribute significantly to our organization\u2019s success. We are excited to welcome you on board.</p>\n\n    <p>Your appointment is being made for the position assigned to you by our company. The total annual compensation will be <span class=\"highlight\">${data[\"Offer Salary\"] || ''}</span>. Additional benefits, allowances, and perquisites will be applicable as per company policy.</p>\n\n    <div class=\"section-title\">1. Position & Reporting</div>\n    <p>You will be designated as <span class=\"highlight\">${data.Profession || ''}</span> and will report to your designated manager or any other authority assigned by the company. Your duties and responsibilities will be as per the job description provided to you and may be modified by the management from time to time.</p>\n\n    <div class=\"section-title\">2. Probation Period</div>\n    <p>You will be on probation for a period of six (6) months from your date of joining. Upon successful completion of this probationary period, your performance will be reviewed and your services may be confirmed in writing. During probation, your services may be terminated with one month\u2019s notice from either side.</p>\n\n    <div class=\"section-title\">3. Working Hours</div>\n    <p>Your normal working hours will be as per company policy, subject to modifications depending upon business requirements. You may be required to work beyond standard hours in order to meet project deadlines and organizational commitments.</p>\n\n    <div class=\"section-title\">4. Leave Policy</div>\n    <p>You will be entitled to leave as per the leave policy of the company in force at the time. All leaves must be applied for and approved in advance by your reporting manager, except in cases of emergency.</p>\n\n    <div class=\"section-title\">5. Confidentiality & Non-Disclosure</div>\n    <p>You shall maintain the highest standards of confidentiality with respect to all proprietary and confidential information of the company. You shall not, under any circumstances, disclose, use, or exploit any such information without prior written consent of the management.</p>\n\n    <div class=\"section-title\">6. Termination of Employment</div>\n    <p>After confirmation, your employment may be terminated by either party by giving ninety (90) days written notice or payment of equivalent salary in lieu thereof. The company reserves the right to terminate employment immediately without notice in case of misconduct, breach of trust, or violation of company policies.</p>\n\n    <p>We look forward to a mutually rewarding association and are confident that your skills and dedication will add immense value to our organization.</p>\n\n    <p>Sincerely,</p>\n\n    <div class=\"signature\">\n      <p><strong>HR Manager</strong></p>\n      <p>Example Company</p>\n    </div>\n\n    <footer>\n      This is a computer-generated offer letter and does not require a physical signature.\n    </footer>\n  </div>\n</body>\n</html>\n`;\n\n// Convert HTML to binary for n8n\nconst buffer = Buffer.from(htmlContent, 'utf8');\nconst binaryData = {\n  data: buffer.toString('base64'),\n  mimeType: 'text/html',\n  fileName: `Offer_Letter_${data[\"Candidate ID\"] || 'Candidate'}.html`,\n};\n\n// Attach binary to first item\nitems[0].binary = { data: binaryData };\n\nreturn items;"
},
"typeVersion": 2
},
{
"id": "833faaf8-29d5-499d-967a-5e62339522c4",
"name": "Dispatch Missing Docs Email",
"type": "n8n-nodes-base.gmail",
"position": [
760,
490
],
"webhookId": "9aa69d57-8095-4e30-b20d-7e26567caf8c",
"parameters": {
"sendTo": "={{ $json.Email }}",
"message": "=Hello {{ $json.Name }},\n\nWe hope you are doing well.\n\nAs part of the joining process, we have reviewed your submitted documents. Currently, the following documents are still pending from your side:\n\n\ud83d\udccc Pending Documents:\n\n{{ $json['Pending Documents'] }}\n\n\nTo ensure smooth processing of your offer letter, we kindly request you to submit the above document(s) at the earliest.\n\nOnce we receive the pending documents, we will proceed with generating your offer letter.\n\nNext Steps:\n\u2705 Please upload the pending document(s) to the HR portal or reply to this email with the attachments.\n\u2705 Once verified, your offer letter will be shared immediately.\n\nWe appreciate your prompt action on this.\n\nBest regards,\nHR Team\nExample Company",
"options": [],
"subject": "=Reminder:{{ $json.Name }} Please submit your pending documents to proceed with your offer",
"emailType": "text"
},
"typeVersion": 2.1
},
{
"id": "a1e8ac99-2612-46db-9652-ea91675bf6f8",
"name": "Update Pending Status",
"type": "n8n-nodes-base.googleSheets",
"position": [
770,
650
],
"parameters": {
"columns": {
"value": {
"Candidate ID": "={{ $('Review Document Status').item.json[\"Candidate ID\"] }}",
"Candidate Status": "Documents_Pending"
},
"schema": [
{
"id": "Candidate ID",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Candidate ID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Pending Documents",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Pending Documents",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Submitted Documents",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Submitted Documents",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Document Status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Document Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Offer Salary",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Offer Salary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Profession",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Profession",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Candidate Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Candidate Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Offer Letter Link",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Offer Letter Link",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Candidate ID"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "Onboarding Workflows"
}
},
"typeVersion": 4.7
},
{
"id": "d7ada8e5-dd28-4b51-bbb0-0094a20a896b",
"name": "Upload Letter to Drive",
"type": "n8n-nodes-base.googleDrive",
"position": [
500,
300
],
"parameters": {
"name": "={{ $('Review Document Status').item.json['Candidate ID'] }}",
"driveId": {
"__rl": true,
"mode": "list",
"value": "My Drive"
},
"options": [],
"folderId": {
"__rl": true,
"mode": "id",
"value": "[YOUR_ID]"
}
},
"typeVersion": 3
},
{
"id": "769c9fcc-d4b9-470c-9d0b-0b784ecf471b",
"name": "Record Letter Link",
"type": "n8n-nodes-base.googleSheets",
"position": [
760,
360
],
"parameters": {
"columns": {
"value": {
"Candidate ID": "={{ $('Review Document Status').item.json['Candidate ID'] }}",
"Offer Letter Link": "={{ $json.webViewLink }}"
},
"schema": [
{
"id": "Candidate ID",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Candidate ID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Pending Documents",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Pending Documents",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Submitted Documents",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Submitted Documents",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Document Status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Document Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Offer Salary",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Offer Salary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Profession",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Profession",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Candidate Status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Candidate Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Offer Letter Link",
"type": "string",
"display": true,
"required": false,
"displayName": "Offer Letter Link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "number",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Candidate ID"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "Onboarding Workflows"
}
},
"typeVersion": 4.7
},
{
"id": "55338c56-fce3-4857-ae43-f183fcd54190",
"name": "Email Offer Letter",
"type": "n8n-nodes-base.gmail",
"position": [
270,
500
],
"webhookId": "8d1cdea2-02cb-4620-bb32-46626e18d062",
"parameters": {
"sendTo": "={{ $('Review Document Status').item.json.Email }}",
"message": "=\u2728 We are delighted to inform you that you have been selected for the position at Example Company.\nAttached to this email, you will find your official Offer Letter \ud83d\udcc4, which outlines your role, compensation, and other important details.\n\n\ud83e\udd1d We are excited to welcome you to our team and look forward to working together towards great success.\n\nIf you have any questions, feel free to reach out to us.\n\nBest Regards,\nHR Team\nExample Company",
"options": {
"attachmentsUi": {
"attachmentsBinary": [
[]
]
}
},
"subject": "=\ud83c\udf89 Congratulations! Your Offer Letter from Example Company"
},
"typeVersion": 2.1
},
{
"id": "c18319e0-5d4d-4a47-8409-15f9bc0c58ba",
"name": "Mark Offer Sent",
"type": "n8n-nodes-base.googleSheets",
"position": [
0,
650
],
"parameters": {
"columns": {
"value": {
"Candidate ID": "={{ $('Review Document Status').item.json['Candidate ID'] }}",
"Candidate Status": "Offer_Sent"
},
"schema": [
{
"id": "Candidate ID",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Candidate ID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Pending Documents",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Pending Documents",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Submitted Documents",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Submitted Documents",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Document Status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Document Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Offer Salary",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Offer Salary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Profession",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Profession",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Candidate Status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Candidate Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Offer Letter Link",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Offer Letter Link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "number",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Candidate ID"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "Onboarding Workflows"
}
},
"typeVersion": 4.7
}
],
"pinData": [],
"connections": {
"Parse PDF Output": {
"main": [
[
{
"node": "Retrieve PDF File",
"type": "main",
"index": 0
}
]
]
},
"Retrieve PDF File": {
"main": [
[
{
"node": "Upload Letter to Drive",
"type": "main",
"index": 0
},
{
"node": "Email Offer Letter",
"type": "main",
"index": 0
},
{
"node": "Notify Manager Channel",
"type": "main",
"index": 0
}
]
]
},
"PDF Conversion Call": {
"main": [
[
{
"node": "Parse PDF Output",
"type": "main",
"index": 0
}
]
]
},
"Compose Offer Letter": {
"main": [
[
{
"node": "PDF Conversion Call",
"type": "main",
"index": 0
}
]
]
},
"Upload Letter to Drive": {
"main": [
[
{
"node": "Record Letter Link",
"type": "main",
"index": 0
}
]
]
},
"Sheets Change Watcher": {
"main": [
[
{
"node": "Review Document Status",
"type": "main",
"index": 0
}
]
]
},
"Notify Manager Channel": {
"main": [
[
{
"node": "Mark Offer Sent",
"type": "main",
"index": 0
}
]
]
},
"Dispatch Missing Docs Email": {
"main": [
[
{
"node": "Update Pending Status",
"type": "main",
"index": 0
}
]
]
},
"Review Document Status": {
"main": [
[
{
"node": "Dispatch Missing Docs Email",
"type": "main",
"index": 0
}
],
[
{
"node": "Compose Offer Letter",
"type": "main",
"index": 0
}
]
]
}
}
}