n8n Form Trigger to Google Sheets

This n8n workflow simplifies data collection from a web form and stores it in a Google Sheet. It's designed to be a straightforward way to capture user submissions without manual intervention, providing basic data transformation and batch processing capabilities.

What it does

1. Listens for Form Submissions: The workflow is triggered whenever a user submits data through an n8n form.
2. Edits Fields (Set): It processes the incoming form data, likely to rename, add, or remove fields to fit the desired Google Sheet structure.
3. Loops Over Items: If multiple items are submitted (e.g., an array of data), it processes them in batches.
4. Waits (Optional Delay): Introduces a brief pause between processing batches, which can be useful for rate limiting or preventing overwhelming downstream services.
5. Makes an HTTP Request: Sends an HTTP request, potentially to another API or service, using the processed form data.
6. Merges Data: Combines the output from different branches of the workflow or previous steps, ensuring all relevant data is available for the next stage.
7. Executes Custom Code: Allows for advanced data manipulation or custom logic using JavaScript.
8. Appends to Google Sheets: Takes the final processed data and adds it as new rows to a specified Google Sheet.

Prerequisites/Requirements

• n8n Instance: A running n8n instance to host the workflow.
• Google Sheets Account: A Google account with access to Google Sheets.
• Google Sheets Credential (in n8n): An n8n credential configured for Google Sheets to allow the workflow to write data.
• n8n Form: The workflow expects to be triggered by an n8n Form. You will need to design and configure this form within n8n.
• HTTP Request Target: If the "HTTP Request" node is active, you'll need the endpoint URL and any necessary authentication details for the external service it interacts with.

Setup/Usage

1. Import the Workflow:
   • Copy the provided JSON code.
   • In your n8n instance, go to "Workflows" and click "New".
   • Click the "Import from JSON" button and paste the copied JSON.
2. Configure Credentials:
   • Locate the "Google Sheets" node.
   • Click on the "Credential" field and select an existing Google Sheets credential or create a new one. Ensure it has write access to your target spreadsheet.
3. Configure the n8n Form Trigger:
   • Locate the "On form submission" (n8n Form Trigger) node.
   • Configure your form fields as needed. This form will be the entry point for your data.
4. Configure "Edit Fields (Set)":
   • Adjust the "Edit Fields" node to transform the incoming form data into the structure required for your Google Sheet. You might rename fields, add new ones, or remove unnecessary data.
5. Configure "HTTP Request" (if active):
   • If the "HTTP Request" node is enabled, update its URL, method, headers, and body according to the external API you wish to call.
6. Configure "Code" (if active):
   • If the "Code" node is enabled, review and adjust the JavaScript logic to perform any custom data processing.
7. Configure "Google Sheets" Node:
   • Specify the "Spreadsheet ID" and "Sheet Name" where you want to append the data.
   • Ensure the "Operation" is set to "Append Row".
8. Activate the Workflow:
   • Once configured, click the "Activate" toggle in the top right corner of the n8n editor to enable the workflow.

Now, any submission to your n8n form will automatically trigger this workflow, process the data, and add it to your specified Google Sheet.