# POS Invoice to WhatsApp

**Category:** Retail  
**Tools:** Google Sheets, Google Drive, n8n  
**Nodes:** 10  
**Built by:** Forgent Systems

Each new POS order gets a PDF invoice, which is uploaded to Drive and sent to the customer on WhatsApp. The order status is updated in Google Sheets.

![Workflow](preview.webp)

## How it works

1. A new order row in Google Sheets starts the workflow.
2. Invoice data is prepared and a PDF is generated.
3. The PDF is uploaded to Drive.
4. The invoice is sent on WhatsApp and the order is marked complete.

## Use cases

- Retail shops
- Restaurants
- Small businesses moving away from paper bills

## Data setup

**Google Sheets** (tab: columns)

- **POS & Billing Automation → Sheet1**: _(columns as used in the nodes)_
- **POS & Billing Automation → Order Details**: `Phone Number`, `Status`

## Setup

1. In n8n open **Workflows → Import from File** and choose `workflow.json`.
2. Connect these credentials:
   - Google Drive account
   - Google Sheets Trigger account
   - Google Sheets account
   - Twilio 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`
- **Loop Over Items** — `n8n-nodes-base.splitInBatches`
- **Get PDF** — `n8n-nodes-base.extractFromFile`
- **PDF Generate** — `n8n-nodes-base.httpRequest`
- **Set Invoice Data** — `n8n-nodes-base.code`
- **Download PDF** — `n8n-nodes-base.httpRequest`
- **Upload PDF** — `n8n-nodes-base.googleDrive`
- **Sticky Note** — `n8n-nodes-base.stickyNote`
- **Append or update row in sheet** — `n8n-nodes-base.googleSheets`
- **Send invoice to Whatsapp** — `n8n-nodes-base.httpRequest`
