Review and approve Google Sheets orders by email and notify via LINE
Go to Workflow
Jason Chuang
Description
Quick overview
Process new orders from Google Sheets automatically. Small orders are approved right away. Large orders get an email with one-click Approve and Reject links, and several orders can be reviewed at the same time without blocking each other. Every outcome is sent to LINE.
How it works
A Google Sheets Trigger polls the sheet for new rows. Rows that already have a status are skipped.
Each order gets a unique token written back to its row.
The order amount is compared with an approval threshold (default: 500). Small orders are approved instantly.
Large orders trigger a Gmail email with styled HTML Approve and Reject buttons. Each link carries the order's token.
A click goes to an n8n Webhook, which validates the token every time. Tampered or expired links return a 403 error page, and a link that was already used shows a friendly message. Each order is handled independently, so there is no Wait node holding up the queue.
Every outcome (auto-approved, approved, rejected) is sent as a LINE push notification and written back to the sheet with a reviewedAt timestamp.
Setup
Create a Google Sheet with these columns: orderId, customerName, amount, approvalToken, status.
Add Google Sheets and Gmail credentials in n8n, then point the trigger and the Sheets nodes to your sheet.
Connect your LINE Messaging API channel and set who should receive the push notifications.
Set the approval threshold and the email address of the person who reviews large orders.
Activate the workflow. The Approve and Reject links only work while it is active.
Add one small and one large test order to check both paths.
Requirements
A Google account with Google Sheets and Gmail
A LINE Messaging API channel
An n8n instance the reviewer's browser can reach, so the email links can call the webhook
Customization
Change the approval threshold to match your order sizes.
Additional info
Built by Jason Chuang (AI process automation consultant) — https://jasonchuang.com
Want more automation templates? https://jasonchuang0818.gumroad.com/l/n8n-content-automation-bundle
This workflow was created by Jason Chuang and shared publicly on the n8n community template library. n8nFind indexes it for discovery — the workflow remains the property of its original creator.