Connect Consolto and Google Sheets

Consolto collects leads when visitors start a chat or ask for a video call on your website. FlowMattic adds each of those leads to Google Sheets, so consultants, clinics and small agencies keep one shared list of everyone who reached out, with their contact details and message, ready for follow-up by whoever is free.

Try FlowMattic free See example workflows

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

Try a pairing

When this happens in Consolto1 trigger

Do this in Google Sheets19 actions

1. TriggerNew Lead

2. ActionAdd New Row

When Consolto fires New Lead, 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

Consolto 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 new Consolto lead in a sheet

Each visitor who leaves details in the widget becomes a row with name, email, phone and message, so no enquiry stays only in the chat history.

New LeadAdd New Row

View the template

Update returning visitors instead of adding them again

People often come back to the widget. Search the email first, then a Router adds the latest message to the visitor's existing row or creates a row for someone new.

New LeadLookup Row DataRouterUpdate RowAdd New Row

Sort each enquiry by topic with an AI step

An AI Agent reads the visitor's message and returns a topic and urgency, written into their own columns, so the sheet can be sorted by what people actually asked about.

New LeadAI AgentAdd New Row

Send a follow-up email the next morning

Log the lead, wait with a Delay, then email the visitor a short note and a booking link, so an after-hours enquiry gets a reply when the office opens.

New LeadAdd New RowDelayEmail (SMTP)

Tidy names and numbers before they reach the list

Chat forms collect whatever visitors type. Trim spaces and fix the capitalisation of names with a Text Formatter, so the list is ready for a call sheet.

New LeadText FormatterAdd New Row

Set up: Consolto leads in a sheet

At the end, each lead collected by your Consolto widget adds a row to your leads sheet.

Prepare the leads sheet
Add a header row with Date, Name, Email, Phone and Message.
Trigger on New Lead
Create a workflow with Consolto and New Lead, and set up the connection the trigger asks for in your Consolto account.
Leave a test lead
Open your site, start a chat in the widget and leave your details so FlowMattic captures a lead.
Add the row
Connect Google Sheets, add Add New Row, map the lead fields to the columns, test and switch the workflow on.

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

From Consolto	To Google Sheets
Name	Name
Email	Email
Phone	Phone
Message	Message
Created at	Date

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 fields depend on what your Consolto widget asks visitors for, so the mapping above is an example. Map from a test lead after setting up the widget.
A visitor who leaves details twice creates two leads. Use the lookup example if the sheet should hold one row per person.
Rows added to the sheet by hand do not appear in Consolto. The workflow runs from Consolto to Sheets.

Consolto

Integration page

Triggers (1)

New LeadTriggers when a new lead is collected in consolto.

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

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

One list for every enquiry

Chat and video leads land in a sheet the whole team can see, so follow-up does not depend on who was online when the visitor wrote.

Visitor details stay on your server

Names, emails and messages pass through your own WordPress site to Google, not through another automation account.

More enquiries, same cost

Runs are unlimited, so a busy month of chat leads costs no more in FlowMattic than a quiet one.

Common questions

Which Consolto leads reach the sheet?

Every lead Consolto collects from your widget starts the New Lead workflow. Use a Filter after the trigger if you only want leads that include a phone number or a particular page.

Can I stop repeat visitors creating duplicate rows?

Yes. Add Lookup Row Data on the email column and a Router. Update Row handles visitors already in the sheet, Add New Row handles new ones.

Can I reply to the lead automatically?

Yes. After Add New Row, add Email (SMTP) to send a reply from your own mail server, with a Delay first if you want it to arrive later.

Can the AI step rate how urgent a lead is?

Yes. Give the AI Agent the visitor's message and ask for a topic and urgency in a fixed format, then map its answer to columns in Add New Row.

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

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