Automate offer letters & notifications with Google Sheets, Gmail & Slack
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 13 nodes and runs on Google Sheets events. Along the way it connects Google Sheets, Slack, Gmail and Google Drive. It also calls v2.convertapi.com over HTTP.
How it runs
Trigger: On Google Sheets events.
- Check Document Status(If Document Status is Pending) (If): checks a condition and branches into true / false
- Send Missing Document Email (Gmail): uses Gmail
- Create Offer Letter (Code): runs custom JavaScript code
- Change Status (Google Sheets): append or update
- PDF Generate (HTTP Request): calls v2.convertapi.com (POST)
- Get PDF (Extract from File): extracts data from a file (from json)
- Download PDF (HTTP Request): calls an HTTP API
- Upload Offer Letter (Google Drive): uses Google Drive
- Send Offer Letter To Candidate (Gmail): uses Gmail
- Send a message to Manager (Slack): uses Slack
…plus 2 more steps. See the full node list below.
Services it uses
HTTP calls to: v2.convertapi.com
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 - Extract from File
n8n-nodes-base.extractFromFile - HTTP Request
n8n-nodes-base.httpRequest - Slack
n8n-nodes-base.slack - If
n8n-nodes-base.if - Code
n8n-nodes-base.code - Gmail
n8n-nodes-base.gmail - Google Sheets
n8n-nodes-base.googleSheets - Google Drive
n8n-nodes-base.googleDrive
From the author
✅ What problem does this workflow solve? Hiring teams often struggle with document follow-ups, offer letter generation, and stakeholder communication. Manual checks, email back-and-forth, and missing files slow down hiring and create chaos during onboarding.…