Tawk.to handles the conversation, but managers still ask how many chats came in, who they were from and which tickets are open. FlowMattic writes Tawk.to tickets and chats into Google Sheets from your WordPress site, so support leads, sales and owners can count, sort and review them in a spreadsheet anyone on the team can open.
9 triggers19 actions7 example workflows2 ready-made templatesUnlimited runs
Try a pairing
When this happens in Tawk.to3 triggers
Do this in Google Sheets19 actions
1. TriggerCapture New Ticket
2. ActionAdd New Row
When Tawk.to fires Capture New Ticket, 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
Tawk.to 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 Tawk.to ticket in a sheet
Each ticket becomes a row with the requester, subject and message, giving the team a searchable list of support requests outside the Tawk.to dashboard.
Sales teams get a row for each chat with the visitor's name, email and the page they were on, ready for follow-up calls or a mailing list import.
Chat Start→Add New Row
Record finished chats for weekly support review
When a chat ends, its details are written to a review tab, so a team lead can go through the week's conversations and spot the questions that keep coming back.
Chat End→Add New Row
Update the row when a visitor chats again
Look the email up first. A Router updates the returning visitor's row with the latest chat date and adds a row only for someone new, so the list stays one row per person.
Chat Start→Lookup Row Data→Router→Update Row
Send tickets to each department's tab
A Router reads the ticket's department or subject and writes billing, technical and sales tickets to separate tabs, so each group works only its own queue.
Capture New Ticket→Router→Add New Row
Tag each ticket's topic and urgency with AI
An AI Agent reads the ticket message and adds a topic and an urgency label in their own columns, so the sheet can be sorted to show the pressing tickets first.
Capture New Ticket→AI Agent→Add New Row
Find the busiest chat hours to plan cover
Date/Time Formatter turns each chat's start time into a weekday and hour column, so a pivot table shows when visitors write in and when you need people online.
When you finish, each ticket created in Tawk.to is added to your Google Sheet as a new row.
1
Prepare the sheet
Add a header row such as Date, Name, Email, Subject and Message to a new Google Sheet.
2
Connect Google Sheets
Add a Google Sheets connection under Connects with an account that can edit that spreadsheet.
3
Start from Capture New Ticket
Create a workflow with the Tawk.to Capture New Ticket trigger, connect it to your Tawk.to property as the trigger setup shows, and create a test ticket.
4
Map Add New Row
Add a Google Sheets step with Add New Row, choose the spreadsheet and tab, map the ticket fields, test it and switch the workflow on.
Fields mapped from the earlier steps (a typical setup)
From Tawk.to
To Google Sheets
Created date
Date
Requester name
Name
Requester email
Email
Subject
Subject
Message
Message
Built on the FlowMattic canvas. Test each step with real data, then switch the workflow on.
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
These workflows only write to the sheet, so a sheet edit does not reply to a chat or close a ticket. Workflows start from a ticket, chat start or chat end.
Visitor name and email are only there when the visitor gave them, for example in a pre-chat form, so expect some empty cells on chat rows.
The field names above are examples. Check the captured test data for the exact fields your Tawk.to property sends.
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
Tawk.to and Google Sheets connect through FlowMattic on your own site, with no separate automation account in the middle and no charge per run.
Chat numbers anyone can read
Owners and managers see tickets and chats in a spreadsheet they already know, without needing a seat in the chat dashboard.
Busy days cost the same
Runs are unlimited on every plan, so a sale or launch that floods the chat widget adds no automation cost.
Visitor details stay on your server
Names, emails and messages pass from Tawk.to through your own WordPress site to Google, not through an outside automation account.
Common questions
How does the Tawk.to Google Sheets integration work?
FlowMattic receives Tawk.to events, such as a new ticket, a chat starting or a chat ending, and writes each one to Google Sheets as a row with the fields you map. You build it on the FlowMattic workflow builder in WordPress.
Can I log full chat conversations?
Use the Chat End trigger and map whichever chat fields Tawk.to sends with it. Test with a real chat first and check the captured data to see what is included.
Can the sheet send messages back to Tawk.to?
No. Tawk.to has triggers only in FlowMattic, so data flows from Tawk.to into Google Sheets and not the other way.
Can tickets and chats go to separate tabs?
Yes. Build one workflow per trigger, each with its own Add New Row step pointed at a different tab, or a Router if one trigger should split across tabs.
How do I count chats per day?
Add a date column from the trigger, then use a pivot table or COUNTIF in Google Sheets. Get Row Count can also read the total inside a workflow.
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. Tawk.to integration 1.0, Google Sheets integration 2.2.4.