← n8n Builder & Seller Stack Layer 05 — webhooks
Layer 05 · Build

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.

Apps used Webhook, Google Sheets, Apps Script, Gmail Difficulty Intermediate Build time 40–55 min
00

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.

01

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.

02

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
    })
  });
}
  1. Replace YOUR_N8N_WEBHOOK_URL with the URL you copied, keeping the quotes.
  2. Save, then open Triggers (clock icon) → Add Trigger → event source "From spreadsheet" → event type On edit.
  3. 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.
03

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.

04

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.

05

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.

06

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.

07

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.

08

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.
09

Sources

SourceUsed 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 nodeReceiving the Apps Script POST request
Google Apps Script docs, "Triggers"Firing on every spreadsheet edit
Google Apps Script docs, UrlFetchAppSending the row's data to the webhook