Review and approve Google Sheets orders by email and notify via LINE

by Jason ✓ · 141 views · created 2026-02-25 · Document Extraction

What this workflow does

This workflow has 28 nodes and runs on Google Sheets events (row added) (plus 1 other trigger). Along the way it connects Google Sheets and Gmail. It also calls api.line.me over HTTP.

How it runs

Trigger: On Google Sheets events (row added) (plus 1 other trigger).

1. New order? (If): checks a condition and branches into true / false
2. Extract Approval Params (Edit Fields (Set)): sets 3 fields: orderId, action, webhookToken
3. Config (Edit Fields (Set)): sets 4 fields: approverEmail, lineUserId, approvalThreshold…
4. Read Order from Sheets (Google Sheets): uses Google Sheets
5. Prepare Order Data (Edit Fields (Set)): sets 8 fields: orderId, customerName, amount…
6. Token Valid? (If): checks a condition and branches into true / false
7. Write Approval Token (Google Sheets): update
8. Already Processed? (If): checks a condition and branches into true / false
9. Respond – Invalid Token (Respond to Webhook): sends the response back to the webhook caller
10. Needs Approval? (If): checks a condition and branches into true / false

…plus 16 more steps. See the full node list below.

Services it uses

Google SheetsGmail

HTTP calls to: api.line.me

Before you upgrade to n8n 3.0

Nodes used (8)

• Google Sheets Triggern8n-nodes-base.googleSheetsTrigger
• Ifn8n-nodes-base.if
• Edit Fields (Set)n8n-nodes-base.set
• Google Sheetsn8n-nodes-base.googleSheets
• Gmailn8n-nodes-base.gmail
• HTTP Requestn8n-nodes-base.httpRequest
• Webhookn8n-nodes-base.webhook
• Respond to Webhookn8n-nodes-base.respondToWebhook

From the author

Automatically processes new orders added to Google Sheets. Small orders are approved instantly; large orders trigger an HTML email with one-click Approve / Reject links — each handled by an independent webhook, so multiple orders can be reviewed…

View the original on n8n.io → Check your own copy