tr Skip to content
Black Friday Lifetime FlowMattic from $399 One payment, unlimited workflows. Ends in --Days --Hrs --Min --Sec See the deal

Connect Tawk.to and Google Sheets

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 triggers 19 actions 7 example workflows 2 ready-made templates Unlimited 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.

Tawk.to app icon Google Sheets app icon 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.

Capture New TicketAdd New Row

View the template
Tawk.to app icon Google Sheets app icon

Keep a list of visitors who start a chat

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 StartAdd New Row

Tawk.to app icon Google Sheets app icon

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 EndAdd New Row

Tawk.to app icon Google Sheets app icon

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 StartLookup Row DataRouterUpdate Row

Tawk.to app icon Google Sheets app icon

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 TicketRouterAdd New Row

Tawk.to app icon Google Sheets app icon

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 TicketAI AgentAdd New Row

Tawk.to app icon Google Sheets app icon

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.

Chat StartDate/Time FormatterAdd New Row

Set up: every ticket in a sheet

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.

Import the ready-made template Beginner, about 5 min to set up
Log every new Tawk.to ticket in a sheet Template
  1. Tawk.to app icon 1. Trigger in Tawk.to Capture New Ticket
  2. Google Sheets app icon 2. Action in Google Sheets Add New Row

    Fields mapped from the earlier steps (a typical setup)

    From Tawk.toTo Google Sheets
    Created dateDate
    Requester nameName
    Requester emailEmail
    SubjectSubject
    MessageMessage
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.

Triggers (3)

  • Capture New TicketTriggers when a new ticket is created
  • Chat StartTriggers when a new chat is started
  • Chat EndTriggers when an active chat session ends
Google Sheets app icon

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

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.

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

Start automating Tawk.to and Google Sheets

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

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.