Connect Chili Piper and Google Sheets

Chili Piper books and routes meetings between prospects and your reps. FlowMattic records each booking in Google Sheets and follows it as it is rescheduled, reassigned or canceled. Revenue teams get a meeting log they can report on by rep, source or week, and marketing can see which forms are turning into calls.

Try FlowMattic free See example workflows

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

Try a pairing

When this happens in Chili Piper3 triggers

Do this in Google Sheets19 actions

1. TriggerNew Meeting

2. ActionAdd New Row

When Chili Piper fires New Meeting, 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

Chili Piper 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 Chili Piper meeting in a sheet

Every booking, whatever the source, adds a row with the prospect, assigned rep, meeting type and start time, a single list of booked meetings for the sales team.

New MeetingAdd New Row

View the template

Refresh the row when a meeting is rescheduled or reassigned

Meeting Updated finds the meeting by its ID and writes the new time and rep, so the log never shows a call at a time it no longer happens.

Meeting UpdatedLookup Row DataUpdate Row

Mark canceled meetings so no-shows are not miscounted

When a prospect or rep cancels, set the row's status to canceled with the date. Reports on meetings held then leave those rows out.

Canceled MeetingLookup Row DataUpdate Cell Data

Give each rep or region a tab of their own

A Lookup Table maps the assigned rep to a region, and a Router writes each meeting to that region's tab, so team leads see only their own bookings.

New MeetingLookup TableRouterAdd New Row

Track meetings booked from inbound forms

Filter bookings by source so only meetings from your website forms reach marketing's sheet, which shows which pages produce sales calls.

New MeetingFilterAdd New Row

Write start times in your team's time zone

Prospects book from many time zones. Convert the start time to your office zone before it is written, so the sheet reads the same for every rep.

New MeetingDate/Time FormatterAdd New Row

Set up: new meetings in a log

At the end, every meeting booked through Chili Piper adds a row to your meeting log.

Create the meeting log
Add a header row with Meeting ID, Prospect, Email, Company, Rep, Meeting type, Start time and Status.
Trigger on New Meeting
Create a workflow with Chili Piper and New Meeting, and follow the trigger's steps to send Chili Piper's meeting events to FlowMattic.
Book a test meeting
Book one meeting through a Chili Piper link or form so FlowMattic captures the meeting fields.
Add the row
Connect Google Sheets, add Add New Row, map the meeting ID, prospect and rep to the columns, test and switch on.

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

From Chili Piper	To Google Sheets
Meeting ID	Meeting ID
Prospect name	Prospect
Prospect email	Email
Assignee	Rep
Meeting type	Meeting type
Start time	Start time

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

Keep Chili Piper's meeting ID in its own column. The update and cancel workflows search for it to find the right row.
New Meeting fires for every booking regardless of source. Filter on the source or meeting type if a sheet should hold only some of them.
The log follows Chili Piper. Editing a row does not reschedule or cancel the meeting.

Chili Piper

Integration page

Triggers (3)

New MeetingTriggers for every new meeting booked, regardless of the source.
Meeting UpdatedTriggered whenever a meeting is updated, for example if it's reassigned or rescheduled.
Canceled MeetingTriggers when a user or prospect cancels the meeting from any via source.

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

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

Meeting reports without CRM exports

Leaders can pivot bookings by rep, week or source directly in the sheet, with cancellations already marked.

Prospect details stay on your server

Names, emails and companies pass through your own WordPress site on the way to Google, not through another automation account.

Busy booking weeks cost the same

Runs are unlimited, so a campaign that fills every rep's calendar is logged at no extra cost.

Common questions

Does a rescheduled meeting create a second row?

Not if you use Meeting Updated with Lookup Row Data and Update Row. The meeting's existing row gets the new time and rep instead of a duplicate.

Can I see canceled meetings separately?

Yes. Canceled Meeting can mark the existing row as canceled, or add the meeting to a separate cancellations tab with Add New Row if you prefer to keep the log untouched.

Does it include meetings booked from any source?

Yes. New Meeting fires for every booked meeting regardless of where it was booked, so links, forms and handoffs all reach the sheet.

Can each rep see only their own meetings?

Route each booking by assignee to a tab or spreadsheet per rep, then share each file only with the person it belongs to.

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

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