Build: Google Sheets Mini-App
Turn a spreadsheet into an internal tool: check a box to email an invoice, change a status dropdown to trigger the next step in a client's pipeline. This is the build that finally makes webhooks and HTTP methods click, because you can watch the request fire in real time.
What we're building, and why
A webhook is n8n's ear permanently open to the internet: the instant anything sends data to its URL, the workflow fires — no polling, no delay. Almost every app without a native n8n integration can still reach n8n this way, including a spreadsheet, once it's told how to send the request. This build wires a Google Sheet so that editing certain cells kicks off real automation.
Add a webhook trigger
Add trigger → Webhook. Change the HTTP method from the default GET to
POST — the near-universal convention for "something just happened, here's the data,"
and the single most common first mistake (leaving it on GET and waiting forever for
data that's arriving as POST). Click Listen for test event, then copy
the Test URL for the next step.
Wire the sheet with Apps Script
In the spreadsheet: Extensions → Apps Script. Paste in a script that, on every edit, sends the entire changed row (plus which column and row number changed) as a POST request to your n8n webhook URL.
function onEditTrigger(e) {
var sheet = e.range.getSheet();
var row = e.range.getRow();
var rowValues = sheet.getRange(row, 1, 1, sheet.getLastColumn()).getValues()[0];
UrlFetchApp.fetch("YOUR_N8N_WEBHOOK_URL", {
method: "post",
contentType: "application/json",
payload: JSON.stringify({
row: row,
column: e.range.getColumn(),
values: rowValues
})
});
}
- Replace
YOUR_N8N_WEBHOOK_URLwith the URL you copied, keeping the quotes. - Save, then open Triggers (clock icon) → Add Trigger → event source "From spreadsheet" → event type On edit.
- Authorize the script with your Google account — you'll see an "unverified app" warning since this is your own script, not a published one; click Advanced → Go to project (unsafe) to proceed.
Route by which column changed
Edit any cell in the sheet and confirm the webhook receives the payload. Add a Switch
node on column so different columns trigger different logic — e.g. column 9 (a "Send
Calendar" checkbox) takes one path, column 10 (a "Status" dropdown) takes another.
Only act on real changes
A checkbox fires this webhook whether it's being checked or unchecked — you only want the
automation to run in one direction. Add a Filter: condition = the changed value
(Text) equals "true". Unchecking the box, or any accidental double-click, is silently discarded instead of re-sending a calendar link.
Take action: send a calendar link
Add Gmail → Send a message to the lead's email (from the same row's data), with a booking link in the body. Now checking one box in a spreadsheet — no code, no n8n canvas open — sends a live email.
Stage-based automation
On the "Status" column path, add a second Switch keyed on the dropdown's new value — New Lead, Sales Call, Onboarding — and give each stage its own action: send a proposal, send a contract and invoice, or send an onboarding form. Moving a deal through your pipeline by changing one dropdown is the same mechanism a much more expensive CRM sells as a headline feature.
Go live
Flip the workflow to Active, then swap the Apps Script URL from the
Test webhook URL to the Production URL shown on the Webhook node (identical
except it drops -test from the path). The test URL only listens while you're actively
watching the canvas — production traffic needs the production URL.
Variations worth selling
- Any form builder without a native n8n node (Fillout, Tally, Typeform's raw webhook) plugs in exactly the same way — a webhook is a webhook regardless of source.
- Wire a "generate content" button in a content-calendar sheet to create a matching Drive folder and notify an editor.
- This pattern is the cheapest possible "custom internal tool" you can sell a small business — a spreadsheet they already know how to use, with automation bolted on.
Sources
| Source | Used for |
|---|---|
| Jono Catliff (Automatable), "n8n 8 Hour Masterclass — Build & Sell AI Agents (Automate Anything)" | Primary source for this build's workflow steps |
| n8n docs, Webhook node | Receiving the Apps Script POST request |
| Google Apps Script docs, "Triggers" | Firing on every spreadsheet edit |
| Google Apps Script docs, UrlFetchApp | Sending the row's data to the webhook |