Route measurement data from a webhook to Google Sheets, email, or custom JS

by 3D Measure Up · 111 views · created 2026-02-04 · Document Extraction

What this workflow does

This workflow has 14 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Google Sheets.

How it runs

Trigger: When an HTTP POST request hits its webhook URL.

1. Workflow Configuration (Edit Fields (Set)): sets 4 fields: outputMode, googleSheetId, emailRecipient…
2. Validate Required Fields (If): checks a condition and branches into true / false
3. Parse and Normalize Data (Edit Fields (Set)): sets 11 fields: measurementId, timestamp, deviceId…
4. Error - Invalid Payload (Stop and Error): stops the run with an error
5. Send Error Response (Respond to Webhook): sends the response back to the webhook caller
6. Send Success Response (Respond to Webhook): sends the response back to the webhook caller
7. Route to Output Options (Switch): routes items into 4 branches
8. Save to Google Sheets (Google Sheets): append or update
9. Generate HTML Table (HTML): parses or builds HTML
10. Convert to CSV File (Convert to File): converts data to a file

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

Services it uses

Google Sheets

Before you upgrade to n8n 3.0

Nodes used (11)

• Ifn8n-nodes-base.if
• Edit Fields (Set)n8n-nodes-base.set
• Respond to Webhookn8n-nodes-base.respondToWebhook
• Switchn8n-nodes-base.switch
• Google Sheetsn8n-nodes-base.googleSheets
• HTMLn8n-nodes-base.html
• Convert to Filen8n-nodes-base.convertToFile
• Send Emailn8n-nodes-base.emailSend
• Coden8n-nodes-base.code
• Webhookn8n-nodes-base.webhook
• Stop and Errorn8n-nodes-base.stopAndError

From the author

Description This workflow helps developers and automation teams route measurement data from a webhook to multiple destinations using n8n. It is designed for measurement engines, 3D scanning systems, QA tools, and API-based platforms that send structured JSON…

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