Google Sheets workflows

Google Sheets workflows send each completed form submission to a spreadsheet row.

Connect Google Sheets

1. Open Integrations from the app sidebar.
2. Choose Google Sheets.
3. Select Connect account and approve Google Sheets access in the Fomr-branded connection flow.

Reconnect the same account any time from the Integrations page if Google access expires or is revoked.

Only admins and team members with integration-management permission can connect, reconnect, or disconnect Google Sheets accounts. Free organizations can connect 1 Google Sheets account. Pro organizations can connect unlimited Google Sheets accounts.

Create a workflow

1. Open a form.
2. Select Workflows in the editor header.
3. Create a workflow.
4. Add a Trigger node and a Google Sheets node.
5. Connect the trigger to the Google Sheets action.
6. Select the Google Sheets node and choose the connected account and a name for the new spreadsheet.
7. Save the node.
8. Enable the workflow.

The workflow starts paused, and Fomr checks your connected Google account before turning it on. Once enabled, Fomr creates a spreadsheet for the workflow and writes each submission to a Submissions sheet. After the spreadsheet is created, the node settings show a link to it instead of the name field. Each workflow sends to one spreadsheet, and that destination stays the same once it’s created.

Column mapping

Fomr keeps the Submissions sheet aligned with the form’s Responses table. The first row contains the visible column labels, and new completed submissions are appended to the bottom of the sheet.

Each completed submission includes:

• Submitted at
• Answer values for each question

Question IDs, submission IDs, and form names are not written as sheet columns. If you add columns of your own to the sheet, Fomr leaves them in place, and new form questions are added to the right of the sheet.

Retries and duplicates

Open Executions from the workflow header to review recent workflow runs. Each execution shows the latest workflow status and expands to action statuses with timestamps.

If an action fails, you can retry it from the execution details. Actions that already succeeded are not run again, so retrying won’t create duplicate rows.

Plan behavior

Free organizations can connect 1 Google Sheets account and enable one workflow per form. Pro organizations can connect unlimited Google Sheets accounts and enable more workflows per form, up to the workflow authoring limits.

If an organization downgrades to Free, Fomr keeps one enabled workflow per form and pauses the rest.