Offer Letter Generation & Onboarding
Generates a PDF offer letter when a candidate is ready, emails it, uploads a copy, notifies the manager on Slack and tracks onboarding status. Candidates with missing documents get a reminder.

On this page
How it works
- A candidate row update in Google Sheets starts the workflow.
- If documents are pending, a reminder email is sent.
- Otherwise an offer letter is built and converted to PDF.
- The letter is emailed, uploaded and linked in the sheet.
- The manager is notified on Slack and the status is updated.
Use cases
- HR teams
- Staffing firms
- High-volume hiring
What you need
This workflow connects to these apps.
- Gmail
- Slack
- Google Sheets
You'll need an n8n instance, on n8n Cloud or self-hosted, and these credentials. Our credentials guide shows how to create each one.
- Gmail account
- Google Drive account
- Google Sheets Trigger account
- Google Sheets account
- Slack account
Data setup
Create these tables with these exact column names before the first run.
| Table | Columns |
|---|---|
| Onboarding Workflows → Sheet1Google Sheets | Candidate IDCandidate StatusOffer Letter Link |
Setup
- Download the JSON and import it into n8n with Import from File, or copy it and paste it onto an empty canvas. The import guide walks through both.
- Connect the credentials listed above.
- Point the Sheets, Airtable, Drive, and Slack nodes at your own files and channels.
- Replace placeholder emails, phone numbers, and form links with your own.
- Times use the America/New York timezone and dates use MM/DD/YYYY. Change them if you need to, then test and activate. The setup guide covers this step by step.
Nodes
| Node | Type |
|---|---|
| Google Sheets Trigger | googleSheetsTrigger |
| Get PDF | extractFromFile |
| PDF Generate | httpRequest |
| Download PDF | httpRequest |
| Send a message to Manager | slack |
| Check Document Status(If Document Status is Pending) | if |
| Create Offer Letter | code |
| Send Missing Document Email | gmail |
| Change Status | googleSheets |
| Upload Offer Letter | googleDrive |
| Add Offer Letter in Sheet | googleSheets |
| Send Offer Letter To Candidate | gmail |
| Change Status in Sheet | googleSheets |
Frequently asked questions
Generates a PDF offer letter when a candidate is ready, emails it, uploads a copy, notifies the manager on Slack and tracks onboarding status. Candidates with missing documents get a reminder. It's a 14-node n8n workflow.
An n8n instance, on n8n Cloud or self-hosted, and credentials for Gmail, Google Drive, Google Sheets, and Slack. It uses only nodes that ship with n8n, so there's nothing else to install.
It works with 1 table in Google Sheets. Create it with the column names listed under Data setup on this page before the first run.
Download the JSON, then in n8n create a new workflow, open the menu in the top right, and choose Import from File. You can also copy the JSON and paste it onto an empty canvas.
Yes. It's free to download, import, and change, with no sign-up. You only pay for the apps it connects to, where those aren't free on your plan.



