Sync Submissions to Google Sheets
The Workflow Automation addon includes a Google Sheets step that appends a new row to a spreadsheet on every submission. This is the fastest way to build a live submission dashboard your whole team can access.
In Google Sheets, create a new spreadsheet. Add a header row with column names matching your form fields: Date, Name, Email, Message. Leave the rest of the sheet empty — Formcierge will append rows below the header.
Open the form in the builder, click Workflows, and add a new workflow (or open an existing one). Add a Google Sheets — Append Row step.
Click Connect Google Account and authenticate with the Google account that owns the spreadsheet. You only need to do this once — the connection is saved in your WordPress options table.
Select the spreadsheet and sheet from the dropdowns. The field mapper appears — drag form fields onto the matching columns, or use the autocomplete to type a merge tag:
Save the form and submit a test entry. Open your Google Sheet — a new row should appear with the submission data. Check the Workflow Logs if the row doesn't appear; the most common issue is a missing or expired Google auth token.
The Google Sheets integration appends rows in real time with no polling delay. Combine it with Google Sheets formulas and charts to build a live analytics dashboard that updates on every submission.