Connect OpenPhone and Google Sheets

Keep a spreadsheet record of what happens on your OpenPhone numbers. FlowMattic writes incoming texts, completed calls and call summaries to Google Sheets, and turns sheet rows into OpenPhone contacts or outgoing texts. Useful for small sales and support teams who report on calls from a shared sheet.

Try FlowMattic free See example workflows

15 triggers 30 actions 6 example workflows 1 ready-made template Unlimited runs

Try a pairing

When this happens in OpenPhone9 triggers

Do this in Google Sheets19 actions

1. TriggerMessage Received

2. ActionAdd New Row

When OpenPhone fires Message Received, 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

OpenPhone 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

Add each incoming OpenPhone text as a row

The sender's number, the message and the time are logged together, so the team can see every conversation on a shared number in one list.

Message ReceivedAdd New Row

View the template

Keep a call log with duration and direction

Call Completed writes who called, which number answered, how long it lasted and whether it was inbound or outbound, which gives managers a weekly call report.

Call CompletedAdd New Row

Save the call summary next to the call

When OpenPhone finishes its summary, Lookup Row Data finds the call's row by ID and Update Row adds the summary, so the log reads as notes, not just numbers.

Call Summary CompletedLookup Row DataUpdate Row

Text tomorrow's appointments from a sheet every evening

A Schedule reads tomorrow's rows, the Iterator goes through them and Send Text Message reminds each customer from your business number.

ScheduleGet RowsIteratorSend Text Message

Create OpenPhone contacts from a list of leads

Each lead added to the sheet becomes an OpenPhone contact with a name and company, so the next call from that number shows who it is.

New Spreadsheet RowCreate Contact

Keep the contact sheet current when details change

Contact Updated finds the contact's row and rewrites it, so a sheet shared with people outside OpenPhone always has the latest name and number.

Contact UpdatedLookup Row DataUpdate Row

Set up: incoming texts as rows

At the end, every text that arrives on your OpenPhone number is a new row in your sheet.

Prepare the sheet
Add columns such as From, To, Message, Received and Conversation ID.
Connect both apps
Under Connects in FlowMattic, add OpenPhone with an API key from your OpenPhone workspace and Google Sheets with an account that can edit the sheet.
Start with Message Received
Create a workflow with OpenPhone and Message Received, then text your OpenPhone number from another phone so FlowMattic captures a sample.
Write the row
Add Google Sheets Add New Row, map the sender, recipient, body and time, test the step and switch the workflow on.

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

From OpenPhone	To Google Sheets
From	From
To	To
Text	Message
Created at	Received
Conversation ID	Conversation ID

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

Call Summary Completed and Call Transcript Completed arrive after the call ends. Write the call ID in its own column so later steps can find the row.
Message Received fires for every incoming text on the number. Add a Filter on the recipient number if you only want one line logged.
Texts sent from a sheet go out from your OpenPhone number, so test with your own phone first and keep an opt-out column for customers who ask to stop.

OpenPhone

Integration page

Triggers (9)

Call CompletedTriggers when a call is completed.
Call RingingTriggers when a call starts ringing.
Call Recording CompletedTriggers when a call recording is completed.
Call Transcript CompletedTriggers when the call transcript is available.
Call Summary CompletedTriggers when the call summary is generated.
Message ReceivedTriggers when a new message is received.
Message DeliveredTriggers when a message is delivered.
Contact UpdatedTriggers when a contact is updated.
Contact DeletedTriggers when a contact is deleted.

Actions (11)

List CallsRetrieve a list of call records from OpenPhone
Get Call RecordingRetrieve call recording by call ID
Get Call SummaryRetrieve call summary by call ID
Get Call TranscriptRetrieve call transcript by transcript ID
Get Contact by IDRetrieve a specific contact by ID
Create ContactCreate a new contact in OpenPhone
Get Contact Custom FieldsRetrieve available custom fields for contacts
Send Text MessageSend a text message from your OpenPhone number
Get a Message by IDRetrieve a specific message by its unique identifier
Update a Contact by IDUpdate an existing contact by its unique identifier
List ContactsRetrieve a list of contacts with filtering options

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

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

Call records you can chart

Calls and texts become rows, so you can count calls per teammate or per day with the sheet's own formulas.

The sheet can text back

Reminders and follow-ups go out from your business number using rows your team already keeps.

No limit on logged calls

FlowMattic runs on your own WordPress site with unlimited runs, so a busy phone line costs the same to log as a quiet one.

Common questions

Can I log OpenPhone calls and texts in Google Sheets?

Yes. Use Message Received for texts and Call Completed for calls, each followed by Google Sheets Add New Row. Two small workflows give you a text log and a call log.

Can I add the AI call summary to the sheet?

Yes. A workflow on Call Summary Completed can look up the call's row by its call ID and update a Summary column. Call Transcript Completed works the same way for the full transcript.

Can I send texts from rows in a sheet?

Yes. Start from New Spreadsheet Row, or from a Schedule with Get Rows and an Iterator, and use Send Text Message with the phone number and message from each row.

Do I need a paid OpenPhone plan?

You need an OpenPhone workspace that can create an API key, because FlowMattic connects with one. Check your OpenPhone plan's API access before you start.

Can I record when a contact is deleted?

Yes. Contact Deleted is a trigger, so a workflow can find that contact's row with Lookup Row Data and mark it removed or delete it with Delete Row.

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

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