Connect AnyChat and Google Sheets

AnyChat captures leads through chat flows and forms on your website. FlowMattic writes those answers to Google Sheets from your WordPress site, so the sales team has one lead list that shows which chat flow each person came through, what they asked for and whether they have been in touch before.

Try FlowMattic free See example workflows

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

Try a pairing

When this happens in AnyChat2 triggers

Do this in Google Sheets19 actions

1. TriggerForm Submission

2. ActionAdd New Row

When AnyChat fires 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

AnyChat 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

Log every AnyChat form submission in Google Sheets

Visitors who fill in the chat form become rows with their name, email and answers, so sales can follow up from a list instead of the chat inbox.

Form SubmissionAdd New Row

View the template

Save the answers from each chat flow run

Chat flows ask qualifying questions such as budget or timeline. Each run writes those answers to the sheet, so you can see which flows bring serious leads.

Custom Chat Flow EventAdd New Row

Give each chat flow its own tab

A Router reads the flow name, so pricing questions, demo bookings and support requests land in separate tabs owned by the right team.

Custom Chat Flow EventRouterAdd New Row

Update returning visitors instead of adding them twice

The workflow looks up the email first. Someone who chats again gets their row updated with the latest answers and date, keeping one row per person.

Form SubmissionLookup Row DataRouterUpdate Row

Summarise long chat answers for the sales team

An AI Agent turns a visitor's free-text answers into one line and a lead score column, so reps can sort the sheet by who is most ready to buy.

Custom Chat Flow EventAI AgentAdd New Row

Write only finished flows with an email address

A Filter passes chat flow runs that reached the end and collected an email, so half-finished chats with no way to reply stay out of the lead list.

Custom Chat Flow EventFilterAdd New Row

Set up: chat form leads into a sheet

At the end, every AnyChat form submission is added to your Google Sheet as a new row.

Prepare the sheet
Add a header row for the questions your chat form asks, such as Name, Email, Phone, Question and Page.
Connect Google Sheets
Under Connects in FlowMattic, add Google Sheets with an account that can edit the spreadsheet.
Start with Form Submission
Create a workflow with the AnyChat Form Submission trigger, follow its instructions to send AnyChat events to it and submit the chat form once.
Add New Row
Add Google Sheets Add New Row, map the captured answers to columns, test the step and switch the workflow on.

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

From AnyChat	To Google Sheets
Name	Name
Email	Email
Phone	Phone
Message	Question
Page URL	Page

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

Custom Chat Flow Event fires each time any chat flow runs, including flows that end early. Filter on the flow name or a required answer before writing rows.
The fields depend on the questions in your form or flow, so the mapping above is an example. Run each flow once so FlowMattic captures its answers.
These workflows log AnyChat answers in the sheet; they do not reply to the visitor. Follow up by email or phone from the details in the row.

AnyChat

Integration page

Triggers (2)

Custom Chat Flow EventTriggers when any chat flow is executed.
Form SubmissionTriggers when a visitor submits the form.

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

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

Chat leads join the sales list

Answers from chat flows and forms land in the same sheet the team already uses for follow-up calls.

See which flows work

With the flow name in every row, you can count leads per flow and rewrite the ones that do not convert.

Every conversation, same price

FlowMattic runs on your WordPress site with unlimited runs, so busy chat days do not add per-task costs.

Common questions

How do I send AnyChat leads to Google Sheets?

Connect Google Sheets under Connects, create a workflow with the AnyChat Form Submission trigger and submit a test entry. Add Add New Row, map the answers to columns and switch the workflow on.

What is the difference between the two AnyChat triggers?

Form Submission runs when a visitor submits an AnyChat form. Custom Chat Flow Event runs whenever a chat flow is executed, so it suits flows that ask questions step by step.

Can I log chats from several flows in one sheet?

Yes. Use Custom Chat Flow Event with a Router on the flow name. Each path writes to its own tab, or one tab with a Flow column if you prefer a single list.

Can the team be told about each new chat lead?

Yes. Add an Email (SMTP) step after the sheet step that sends the lead's details to your sales inbox, or a step for the team chat app you connect in FlowMattic.

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

Start automating AnyChat 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. AnyChat integration 1.0.0, Google Sheets integration 2.2.4.