Connect Webhook to Google Sheets — Send Each New Event Instantly
Connect Webhook and Google Sheets in n8n: each new event is captured and sent straight to Google Sheets, in real time and completely hands-off.
- 1
Add the Webhook node
Start with a
Webhooknode — set theHTTP Methodto POST and copy the generated webhook URL — this is the address you give to any external service that should send data. SetResponse ModetoLast Node. This fires the workflow the moment a new event arrives. - 2
Map the fields with a Set node
Add a
Setnode after the trigger to shape the data cleanly. Create fields: readable values from the payload, e.g.eventto{{ $json.body.event ?? 'unknown' }}andmessageto{{ $json.body.message ?? JSON.stringify($json.body) }}. This turns the raw payload into tidy values your destination can use. - 3
Send it to Google Sheets
Add a
Google Sheetsnode set to operationAppend Row. Connect your Google account, choose theSpreadsheetandSheet(e.g. aLogtab), and map each field from the Set node to a matching column. Make sure row 1 of your sheet has headers with the same names. - 4
Activate and test
Click
Activatein the top-right of the canvas. Trigger a test event in Webhook, then confirm it appears in Google Sheets. Once it works, you're done — every new event now flows through automatically.
Frequently asked questions
Do I need any coding skills to set this up?
No. n8n is a visual, drag-and-drop tool. You connect your Webhook and Google Sheets accounts, point the nodes at the right form/sheet/channel, map the fields, and activate. No code required.
Can I send each event to more than one place at once?
Absolutely. Branch the workflow after the Set node: connect it to multiple destination nodes so the same event lands in Google Sheets and, say, Slack or a spreadsheet simultaneously.
Can I send each event to more than one place at once?
Absolutely. Branch the workflow after the Set node: connect it to multiple destination nodes so the same event lands in Google Sheets and, say, Slack or a spreadsheet simultaneously.
Keep every recipe free
FlowRecipesHub is free and always will be. If a workflow saved you time, chip in what you like — it helps us keep the lights on and build the next batch of automations for everyone.
One-tap support is being set up — check back soon. 💚
Secure checkout via Paddle · one-time, no account needed