Connect 123 Form Builder and Google Sheets

123 Form Builder collects registrations, orders, surveys and applications, and many teams then copy the entries into a spreadsheet. FlowMattic writes each submission into Google Sheets from your WordPress site, sorting entries into tabs, updating people who submit twice, adding reference numbers and stopping registrations once the seats are gone.

Try FlowMattic free See example workflows

7 triggers 19 actions 7 example workflows 1 ready-made template Unlimited runs

Try a pairing

When this happens in 123 Form Builder1 trigger

Do this in Google Sheets19 actions

1. TriggerNew Form Submission

2. ActionAdd New Row

When 123 Form Builder fires New Form Submission, FlowMattic runs Add New Row in Google Sheets with the data from that event.

You build this in the FlowMattic workflow builder on your own site. See the setup steps

123 Form Builder and Google Sheets workflows you can build

Each one uses only triggers and actions the two integrations ship today, plus FlowMattic's own tools. Where the library has a ready-made template, import it instead of building from scratch.

Write every 123 Form Builder entry to Google Sheets

Each submission becomes one row with the answers in your columns, so staff work from a shared sheet instead of logging in to the form account.

New Form SubmissionAdd New Row

Ready-made template

Log only entries that contain a chosen answer

A Filter checks one field, such as a product interest or a yes to a callback, and writes only matching entries, so the sheet holds the ones someone must act on.

New Form SubmissionFilterAdd New Row

View the template

Update the row when the same person submits again

Look the email up in the sheet first. A Router updates the person's existing row with their latest answers and adds a row only for a new address.

New Form SubmissionLookup Row DataRouterUpdate Row

Give each department its own tab

A general enquiry form asks which team you need. A Router writes sales, support and billing entries to separate tabs, so each team owns its list.

New Form SubmissionRouterAdd New Row

Number each submission with a running reference

Counter adds the next number to every entry, giving applications, orders or tickets a reference such as REQ-0142 in the sheet that staff can quote back to people.

New Form SubmissionCounterAdd New Row

Stop adding registrations once the seats are taken

Get Row Count checks how many people are already on the list. A Filter writes the new registration only while the count is under your limit, so a workshop is never overbooked on paper.

New Form SubmissionGet Row CountFilterAdd New Row

Add a short summary of long answers

An AI Agent condenses each long comment or application answer into one line and writes it to a summary column next to the full text, so reviewers can scan the sheet.

New Form SubmissionAI AgentAdd New Row

Set up: every entry in Google Sheets

When you finish, each new 123 Form Builder submission is added to your Google Sheet as one row.

Prepare the sheet
Add a header row to your Google Sheet with one column per form field you want, plus a Submitted column.
Connect Google Sheets
Add a Google Sheets connection under Connects with an account that can edit the spreadsheet.
Start from New Form Submission
Create a workflow with the 123 Form Builder New Form Submission trigger, set it up for your form and submit a test entry so FlowMattic captures the fields.
Map Add New Row
Add a Google Sheets step with Add New Row, choose the spreadsheet and tab, map the fields to the columns, test it and switch the workflow on.

From 123 Form Builder	To Google Sheets
Name	Name
Email	Email
Phone	Phone
Message	Message
Submission date	Submitted

Triggers and actions in this pair

A trigger starts a workflow. An action is something FlowMattic does in the app as a step.

Good to know

123 Form Builder has no actions in FlowMattic, so editing the sheet cannot change the form or its entries. Workflows start from a new submission.
The field list depends on your form, so the mapping above is an example. Add the columns before the first test so every field has a place.
Lookup Row Data needs a column that is unique per person, usually email. Without one, a repeat submission cannot find its earlier row.

123 Form Builder

Integration page

Triggers (1)

New Form SubmissionTriggers when new form submission is received

Google Sheets

Integration page

Triggers (6)

New Spreadsheet RowTrigger when a new row is added to the spreadsheet
New Or Updated Spreadsheet RowTrigger when a row is updated in the spreadsheet
Deleted Spreadsheet RowTrigger when a row is deleted from the spreadsheet
Update Cell DataTrigger when any cell is updated in the spreadsheet
Update Specific Cell DataTrigger when a specific cell is updated in the spreadsheet
Update Specific Column ValueTrigger when a specific column value is updated in the spreadsheet

Actions (19)

Add New RowAdd a new row with mapped data
Update RowUpdate existing row in specific spreadsheet with mapped data
Delete RowDelete row by ID in specific spreadsheet
Clear Row DataClear data or row by ID in specific spreadsheet
Lookup Row DataSearch for data in specific spreadsheet
Get Cell DataGet data for particular cell in specific spreadsheet
Update Cell DataUpdate data for particular cell in specific spreadsheet
Get Row CountGet total number of rows in specific spreadsheet
Get Row DataGet rows data from the sheet based on specified range
Create Spreadsheet ColumnCreate a new column in specific spreadsheet
Create New SheetCreate a new sheet in specific spreadsheet
Import CSV or JSON to Existing SheetImport CSV or JSON data to existing sheet in specific spreadsheet
Copy SheetCopy a sheet to another or within the same spreadsheet
Get RowsRetrieve rows in JSON format for use with Iterator
Export sheet to CSVExport the selected sheet to CSV format and save to WordPress Media Library
Export Sheet to ExcelExport the spreadsheet to Excel (.xlsx) format and save to WordPress Media Library
Export Sheet to PDFExport the spreadsheet to PDF format and save to WordPress Media Library
Export Sheet to OpenDocumentExport the spreadsheet to OpenDocument (.ods) format and save to WordPress Media Library
Export Sheet to TSVExport the selected sheet to TSV format and save to WordPress Media Library

Why run this pair with FlowMattic

123 Form Builder and Google Sheets connect through FlowMattic on your own site, with no separate automation account in the middle and no charge per run.

A sheet your whole team can use

Entries arrive in a Google Sheet anyone with access can sort, comment on and share, without extra seats on the form account.

Busy forms cost the same

Runs are unlimited on every plan, so a registration rush or a seasonal survey adds no automation cost.

Checks happen before the row

Filter, Router, Counter and Get Row Count decide where an entry goes and whether it belongs, on your own WordPress server.

Common questions

How do I set up the 123FormBuilder Google Sheets integration?

Connect Google Sheets under Connects, start a workflow with the 123 Form Builder New Form Submission trigger, send a test entry, then add Add New Row and map each field to a column. Switch it on and each new entry becomes a row.

Can old entries be added to the sheet?

The trigger fires for new submissions only. Export earlier entries from 123 Form Builder and use Import CSV or JSON to Existing Sheet once, then let the workflow handle new ones.

Can each form get its own sheet?

Yes. Build one workflow per form, each pointing at its own spreadsheet or tab, or use a Router on a field that names the form.

Can I start a new tab each month?

Yes. Use Create New Sheet on a monthly Schedule to add the tab, and point Add New Row at a sheet name built from the date.

Do uploaded files come through?

File upload fields usually arrive as links. Map the link to a column and anyone with access to the file can open it from the sheet.

Did not find your answer? You can browse the help center or ask us directly.

Start automating 123 Form Builder and Google Sheets

Install FlowMattic, connect both accounts and import a template. Every run stays on your own server.

Try FlowMattic free See pricing

30-day money-back guarantee Unlimited workflows and runs Self-hosted

Reviewed 23 Oct 2026. The example workflows are written with AI from the real triggers and actions of both integrations and checked against them. 123 Form Builder integration 1.0, Google Sheets integration 2.2.4.