# Offer Letter Generation & Onboarding

**Category:** HR & Recruitment  
**Tools:** Gmail, Slack, Google Sheets  
**Nodes:** 14  
**Built by:** Forgent Systems

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.

![Workflow](preview.webp)

## How it works

1. A candidate row update in Google Sheets starts the workflow.
2. If documents are pending, a reminder email is sent.
3. Otherwise an offer letter is built and converted to PDF.
4. The letter is emailed, uploaded and linked in the sheet.
5. The manager is notified on Slack and the status is updated.

## Use cases

- HR teams
- Staffing firms
- High-volume hiring

## Data setup

**Google Sheets** (tab: columns)

- **Onboarding Workflows → Sheet1**: `Candidate ID`, `Candidate Status`, `Offer Letter Link`

## Setup

1. In n8n open **Workflows → Import from File** and choose `workflow.json`.
2. Connect these credentials:
   - Gmail account
   - Google Drive account
   - Google Sheets Trigger account
   - Google Sheets account
   - Slack account
3. Point the Sheets / Airtable / Drive / Slack nodes at your own resources (structure above).
4. Replace placeholder emails, phone numbers and `YOUR-FORM-ID` links with your own.
5. Times use the America/New_York timezone and dates use MM/DD/YYYY. Adjust if needed.
6. Run a test execution, then activate.

## Nodes

- **Google Sheets Trigger** — `n8n-nodes-base.googleSheetsTrigger`
- **Get PDF** — `n8n-nodes-base.extractFromFile`
- **PDF Generate** — `n8n-nodes-base.httpRequest`
- **Download PDF** — `n8n-nodes-base.httpRequest`
- **Send a message to Manager** — `n8n-nodes-base.slack`
- **Sticky Note** — `n8n-nodes-base.stickyNote`
- **Check Document Status(If Document Status is Pending)** — `n8n-nodes-base.if`
- **Create Offer Letter** — `n8n-nodes-base.code`
- **Send Missing Document Email** — `n8n-nodes-base.gmail`
- **Change Status** — `n8n-nodes-base.googleSheets`
- **Upload Offer Letter** — `n8n-nodes-base.googleDrive`
- **Add Offer Letter in Sheet** — `n8n-nodes-base.googleSheets`
- **Send Offer Letter To Candidate** — `n8n-nodes-base.gmail`
- **Change Status in Sheet** — `n8n-nodes-base.googleSheets`
