Connect Form2chat and Google Sheets

Form2chat sends website form submissions straight to chat apps, which is quick to read but easy to lose once the thread scrolls on. Google Sheets keeps a record that can be sorted, assigned and counted. FlowMattic copies every Form2chat submission into a sheet from your own WordPress site, so the chat message and the lead list come from the same form.

Try FlowMattic free See example workflows

7 triggers 19 actions 6 example workflows 2 ready-made templates Unlimited runs

Try a pairing

When this happens in Form2chat1 trigger

Do this in Google Sheets19 actions

1. TriggerNew Form Submission

2. ActionAdd New Row

When Form2chat 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

Form2chat 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.

Ready-made template

Copy each Form2chat submission into a sheet

The enquiry still arrives in chat, and a row with the name, contact details and message is kept as a list nobody has to rebuild from old messages.

New Form SubmissionAdd New Row

View the template

Sort enquiries into tabs by form

A Router reads which form was used, such as quote request or support, and writes the row to that tab, so each team sees only its own enquiries.

New Form SubmissionRouterAdd New Row

Keep empty and test submissions out of the list

A Filter stops submissions with no phone number or message, so the lead sheet only counts enquiries someone can answer.

New Form SubmissionFilterAdd New Row

Update the row when the same person writes again

Look up the phone number or email first. A Router updates the existing row with the newest message, or adds a row for a first-time enquirer.

New Form SubmissionLookup Row DataRouterUpdate Row

Add a readable received date to each enquiry

Date/Time Formatter writes the submission time in your own timezone and format, so the sheet shows when a lead came in at a glance.

New Form SubmissionDate/Time FormatterAdd New Row

Log the enquiry and email the visitor a confirmation

Visitors who reach you through chat may not get an email trail. After the row is written, Email (SMTP) sends them a short confirmation they can keep.

New Form SubmissionAdd New RowEmail (SMTP)

Set up: submissions copied to a sheet

At the end, every Form2chat submission is also stored as a row in your lead sheet.

Add headers
In the sheet, create columns that match your form, for example Name, Phone, Email, Message, Form and Received.
Connect Form2chat and Google
Under Connects, add your Form2chat account and a Google account that can edit the lead sheet.
Capture a submission
Start a workflow on the Form2chat New Form Submission trigger and fill in your website form once so the fields are captured.
Write the row
Add Add New Row, map each form field to its column, test the step and turn the workflow on.

Import the ready-made template Beginner, about 5 min to set up

From Form2chat	To Google Sheets
Name	Name
Phone	Phone
Email	Email
Message	Message
Form name	Form
Submitted at	Received

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

The columns come from your own form, so the mapping above is an example. Add a field to the form and you also add a column to map.
Phone numbers typed in different ways will not match in a lookup. Text Formatter can strip spaces and dashes before the row is written.
Add an Owner and Status column for your team to fill in, so the sheet doubles as a simple follow-up board.

Form2chat

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

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

Chat for speed, sheet for records

Your team keeps replying in chat while the sheet answers how many enquiries came in last month and who handled them.

Form data passes through your site

Each submission goes from Form2chat to the sheet through your own WordPress server, not another automation company's account.

No limit on enquiries

Runs are unlimited, so a busy contact form costs the same on FlowMattic as a quiet one.

Common questions

Will my Form2chat messages still go to chat after I add this?

Yes. FlowMattic adds a copy to the sheet alongside what Form2chat already does. Your chat delivery keeps working as it is.

Can I have one sheet for several website forms?

Yes. Use one tab with a Form column, or add a Router after the trigger so each form writes to its own tab in the same spreadsheet.

How do I avoid two rows for the same person?

Run Lookup Row Data on the phone number or email, then use a Router: Update Row when the person is already there, Add New Row when they are new.

Can I track who followed up each lead?

Yes. Add Owner and Status columns that your team fills in by hand. FlowMattic writes the new rows and leaves those columns alone.

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

Start automating Form2chat 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 27 Oct 2026. The example workflows are written with AI from the real triggers and actions of both integrations and checked against them. Form2chat integration 1.0.0, Google Sheets integration 2.2.4.