Connect Ortto and Google Sheets

Ortto holds your audience: people, the fields you track about them, their tags and the activities they perform. FlowMattic copies those changes into Google Sheets as they happen, so a sales lead list, a tagged segment or an activity log can be shared with people who do not work in Ortto.

Try FlowMattic free See example workflows

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

Try a pairing

When this happens in Ortto5 triggers

Do this in Google Sheets19 actions

1. TriggerNew Record Created

2. ActionAdd New Row

When Ortto fires New Record Created, 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

Ortto 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 new Ortto record to a sheet

Every person created in Ortto becomes a row with email, name and source, giving sales or partners a list they can work from.

New Record CreatedAdd New Row

View the template

Keep a person's row current when their fields change

Fields Updated finds the row by email and rewrites the columns you watch, such as company or lifecycle stage, so the shared list does not go stale.

Fields UpdatedLookup Row DataUpdate Row

Build a tab for each tag you add

When a tag is added, a Router writes the person to the tab named after it, so a VIP or webinar segment can be shared as its own list.

Tag AddedRouterAdd New Row

Remove people from the segment tab when a tag comes off

Tag Removed looks the person up in the tag's tab and deletes their row, so the shared segment matches Ortto.

Tag RemovedLookup Row DataDelete Row

Log only the activities you care about

A Filter passes only the activity types you choose, for example form submissions or purchases, and writes each one to an activity log.

New ActivityFilterAdd New Row

Set up: new records as rows

When you finish, each new person created in Ortto is written to your sheet as a row.

Prepare the columns
Create a sheet with headers such as Email, First name, Last name, Source and Created.
Connect Google Sheets
Add a Google Sheets connection in Connects with an account that can edit the file.
Start with New Record Created
Create a workflow, choose the Ortto New Record Created trigger, and complete the setup the trigger step shows.
Add a test person
Create a record in Ortto so FlowMattic captures the fields that come with it.
Map and test
Add Google Sheets Add New Row, map the record fields to the columns, test it and switch the workflow on.

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

Ortto app icon — Built on the FlowMattic canvas. Test each step with real data, then switch the workflow on.

From Ortto	To Google Sheets
Email	Email
First name	First name
Last name	Last name
Source	Source
Created at	Created

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

Fields Updated fires for the fields you specify in the trigger, so choose the ones that matter to the sheet instead of every field.
Use email as the key in every tab. The update and tag-removal workflows find the row by it.
Field names depend on the custom fields in your Ortto account, so the mapping is an example.

Ortto

Integration page

Triggers (5)

New ActivityTriggers when a new activity occurs.
Fields UpdatedTriggers when the specified fields of a record is updated.
New Record CreatedTriggers when a new record is created.
Tag AddedTriggers when a tag is added to a record.
Tag RemovedTriggers when a tag is removed from a record.

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

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

Audience data on your server

Records and tags go from Ortto through your WordPress site to the sheet, with no other automation service holding them.

Large imports cost the same

Runs are unlimited, so importing thousands of people into Ortto does not use up a task allowance.

Segments people can open

Partners and sales staff can read a tagged list in a sheet without seats in Ortto.

Common questions

How do I sync Ortto contacts to Google Sheets?

Create a workflow with the Ortto New Record Created trigger and a Google Sheets Add New Row step. For updates, add a second workflow with Fields Updated that finds the row by email and runs Update Row.

Can I export one tagged segment?

Yes. Use Tag Added with a Router or Filter for that tag, and Tag Removed with Lookup Row Data and Delete Row, so the tab always lists the people who carry it.

Can I log email opens or purchases?

New Activity fires for the activities Ortto records. Add a Filter on the activity type so only the ones you want reach the log.

Will changes in the sheet go back to Ortto?

No. These workflows copy Ortto changes into the sheet. Edit people in Ortto and the sheet follows.

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

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