Generate and track offer letters with Google Sheets, Docs, Drive and Gmail
Ready for 3.0Ready 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 21 nodes and runs on Google Sheets events (row added) (plus 1 other trigger). Along the way it connects Google Sheets, Google Drive, Google Docs and Gmail.
How it runs
Trigger: On Google Sheets events (row added) (plus 1 other trigger).
- If: checks a condition and branches into true / false
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- Copy Template (Google Drive): copy
- Check Response is Locked? (If): checks a condition and branches into true / false
- Update a offer letter (Google Docs): update
- Code: runs custom JavaScript code
- Document to PDF (Google Drive): download
- Switch: routes items into 3 branches
- Save PDF to drive (Google Drive): uses Google Drive
- Update Status to Accepted (Google Sheets): update
…plus 9 more steps. See the full node list below.
Services it uses
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 (9)
- Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Google Drive
n8n-nodes-base.googleDrive - Google Docs
n8n-nodes-base.googleDocs - Gmail
n8n-nodes-base.gmail - Webhook
n8n-nodes-base.webhook - Switch
n8n-nodes-base.switch - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Code
n8n-nodes-base.code
From the author
How it works This workflow automates the full offer letter lifecycle, from generation to final candidate response tracking. When a new row with a Pending status is added to Google Sheets, it creates a personalized offer letter using a Google Docs template.…