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 new spreadsheet name.
7. Save the node config.
8. Enable the workflow.

The workflow starts paused. Fomr validates the graph and connected Google account before enabling it. The Google Sheets action creates a spreadsheet for the workflow and writes submissions to a Submissions sheet. After the spreadsheet is created, the node settings show a link to the spreadsheet instead of the name field. The spreadsheet destination is locked after creation.

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. Fomr stores its internal question mapping in workflow metadata so question labels can be refreshed when the form changes. Existing sheet columns that Fomr does not manage are preserved, and new form questions are added to the right of the sheet.

Submitted timestamps and date/time answers are synced as raw strings. Dates and date-times use the stored UTC value, and time answers are written as time text.

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.

Failed actions can be retried from the execution details. Successful actions are not rerun. If Google accepts a row but Fomr cannot persist the execution state, Fomr retries the state write and rolls back the appended row if the state still cannot be saved. If Fomr cannot prove or complete the rollback, the action details show that manual review is needed.

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.