Automated Form Data Collection to Google Sheets and Webflow

This n8n workflow automates the process of capturing form submissions from a Webflow site and storing the data in a Google Sheet for easy management and analysis. It enhances data collection efficiency by automatically preparing and appending form data along with a submission timestamp. The workflow also includes helpful notes for self-hosted users on integrating Webflow with OAuth2 authentication.

The workflow starts with a Webflow trigger node that listens for form submissions on a specific Webflow site. When a form is submitted, it triggers the ‘Prepare Fields’ code node which extracts the form data and adds the current date and time to each submission. This step ensures that each entry is timestamped for better tracking.

Next, the data is sent to the ‘Append New Row’ Google Sheets node, which automatically creates new rows with the submitted data. This node maps the form fields like Name, Email, and Message to corresponding columns in a specified Google Sheet, allowing seamless data accumulation even if the sheet starts empty.

Additionally, the workflow provides detailed sticky notes with critical instructions for users, including disabling legacy APIs in Webflow and steps for setting up OAuth2 credentials for Webflow API integration. These notes help users troubleshoot and configure their environment correctly.

This workflow is ideal for website owners who want to streamline their lead collection, customer inquiries, or feedback data directly into Google Sheets, enabling better data management, reporting, and follow-up actions without manual intervention.