Capture Website Data in Google Sheets via Webhook - n8n Workflow

API developers needing a simple, serverless logging mechanism.
Marketers capturing form submissions or lead data without dedicated database setup.
Users looking for foundational n8n templates for data ingestion.
Anyone needing to automate data transfer from web services into structured Google Sheets using a straightforward n8n workflow.

This powerful n8n workflow provides a robust solution for instantly transforming real-time event data into structured spreadsheet entries. By utilizing the dedicated Webhook n8n trigger, you can receive payloads (like form submissions, API calls, or IoT device data) and seamlessly pipe that information into Google Sheets. This specific n8n workflow is crucial for building simple, scalable data pipelines without requiring complex backend code. For users new to automation, this setup offers excellent n8n templates that showcase immediate value and practical application of the core n8n node functionality.

This n8n workflow initiates upon receiving an HTTP POST request to its designated URL, managed by the Webhook n8n trigger. Once triggered, the entire JSON payload sent to the Webhook is automatically forwarded to the Google Sheets n8n node. This Google Sheets n8n node then extracts the relevant fields from the payload and appends a new row to the specified spreadsheet range (Problems!A:D). The workflow is designed for immediate, reliable data logging, ensuring that every incoming request captured by the n8n trigger is documented in your spreadsheet.

1. Copy the provided n8n workflow JSON code.


2. In your n8n instance, click "+ New" -> "Import from JSON".


3. Paste the code and save the new n8n workflow.


4. Credential Setup: Click on the "Google Sheets" n8n node and create or select your Google Sheets API credentials. Ensure the service account has write access to the target spreadsheet.


5. Configuration: Update the sheetId parameter in the Google Sheets n8n node to match your desired spreadsheet ID, and adjust the range if necessary to match your sheet structure.


6. Activation: Activate the n8n workflow. The Webhook n8n trigger will now generate a unique URL which you will use as the endpoint for sending your data from external services.

Webhook (n8n trigger):
Function: Acts as the primary n8n trigger, initiating the n8n workflow upon receiving an HTTP request.
Key Configuration: Path is set to /webhook. Response Mode is configured to return the result of the last n8n node (Google Sheets), confirming success back to the caller.
Google Sheets (n8n node):
Function: Takes the data payload received by the Webhook n8n trigger and appends it as a new row in a specific Google Sheet, fulfilling the primary goal of this n8n workflow.
Key Configuration: The operation is designed for appending data. The target range is explicitly defined as Problems!A:D. A specific sheetId (17fzSFl1BZ1njldTfp5lvh8HtS0-pNXH66b7qGZIiGRU) is configured to ensure data lands in the correct spreadsheet, making this n8n node highly specific to your target dataset.