Connect Oneflow and Google Sheets

Oneflow takes your contracts from draft to signature and through their lifecycle. FlowMattic writes Oneflow contract events into Google Sheets from your WordPress site, so sales, legal and finance share a tracker of what was sent, opened, signed, declined or left to expire, and which signed contracts are coming up for renewal.

Try FlowMattic free See example workflows

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

Try a pairing

When this happens in Oneflow31 triggers

Do this in Google Sheets19 actions

1. TriggerContract Publish

2. ActionAdd New Row

When Oneflow fires Contract Publish, 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

Oneflow 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 published Oneflow contract

Each contract sent for signing becomes a row with its name, counterparty, value and date, the start of a tracker that later events fill in.

Contract PublishAdd New Row

View the template

Mark the contract signed on its row

When every party has signed, look up the contract ID and write the signed date, so sales and finance can see closed deals without asking.

Contract SignLookup Row DataUpdate Row

Note when the counterparty first opens the contract

Participant First Visit finds the contract's row and fills an Opened column, so the account owner knows whether a quiet customer has even looked.

Participant First VisitLookup Row DataUpdate Cell Data

Record declined contracts with the date

A declined contract is marked on its row, giving sales a list of lost deals to review and a reason column to fill in after the call.

Contract DeclineLookup Row DataUpdate Row

List contracts whose signing period expired

Contracts that go overdue are added to a Chase tab, then an email reminds the account owner to send a new period or follow up.

Contract Signing Period ExpireAdd New RowEmail (SMTP)

Build a list of ended contracts for renewal

When a contract's lifecycle ends, it is added to a Renewals tab with the counterparty and end date, so account managers plan the next agreement.

Contract Lifecycle State EndAdd New Row

Set up: published contracts as rows

At the end, every Oneflow contract you publish for signing is added to your Google Sheet as one row.

Prepare the sheet
Add a header row such as Contract ID, Name, Counterparty, Value, Owner, Published, Opened and Signed.
Connect Google Sheets
In FlowMattic, open Connects and add a Google Sheets connection with an account that can edit the tracker.
Start with Contract Publish
Create a workflow with the Oneflow Contract Publish trigger and add its webhook URL in Oneflow's extensions settings, as the trigger describes, then publish a test contract.
Add New Row
Add Google Sheets Add New Row, map the contract fields to the columns, test the step and switch the workflow on.

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

From Oneflow	To Google Sheets
Contract ID	Contract ID
Contract name	Name
Counterparty name	Counterparty
Contract value	Value
Owner	Owner
Published date	Published

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

Contract Sign fires for the contract as a whole, while Participant Sign fires for each person who signs. Use Contract Sign for the Signed column, or a three-party contract writes three updates.
Keep the Oneflow contract ID in every row. Sign, decline, visit and expiry workflows use it with Lookup Row Data.
The fields above are an example. Data fields you add to Oneflow templates come through with the event, so check a test before mapping.

Oneflow

Integration page

Triggers (31)

Contract Lifecycle State StartTriggers when the contract began its first period, and its lifecycle state was changed to active.
Contract PublishTriggers when the contract state has changed from draft to pending.
Comment CreateTriggers when a comment has been added to the contract.
Participant CreateTriggers when a participant has been added to the contract.
Contract Lifecycle State New PeriodTriggers when the contract enters a new period.
Party CreateTriggers when a party has been added to the contract.
Product CreateTriggers when a product has been added to the contract.
Contract SignFollow the below steps to set the webhooks-Log in to your Oneflow account.On the left side of your dashboard navigate to "Settings", click on "Extensions", and enable the webhook by clicking on "Enable".Click on the "Create webhook button", copy the above webhook URL, paste it into the "URL" field, and click on the "Confirm" button.Click on the below "Capture Webhook Response" button and do a test record so that the webhook response can be captured here. Learn more
Contract Signature ResetTriggers when the signatures in the contract were reset when the contract was changed after one or more signatories had signed it.
Contract Signing Period ExpireTriggers when the period during which the contract was supposed to be signed has expired, so its state changed to overdue.
Contract Signing Period ReviveTriggers when another period during which the contract is supposed to be signed has begun, so its state changed to pending.
Participant DeligateTriggers when a participant has been delegated.
Participant Delivery FailureTriggers when a participant fails to get an invitation to the contract.
Participant First VisitTriggers when a participant opens the contract for the first time.
Participant PublishTriggers when a participant receives access to the contract.
Participant SignTriggers when a participant has signed the contract.
Participant Signature ResetTriggers when a participant's signature was reset when a change was made to the contract after the participant had signed it.
Contract Lifecycle State EndTriggers when the contract has expired and its lifecycle state has been changed to ended.
Contract Lifecycle State CancelTriggers when the signed and recurring contract has been canceled.
Contract Lifecycle State TerminateTriggers when the contract was terminated and its lifecycle state was changed to ended .
Contract Content UpdateTriggers when the contract's content has been updated after being sent to the counterparty.
Data Field UpdateTriggers when the attributes of a data field have been updated.
Participant UpdateTriggers when the attributes of a participant have been updated.
Party UpdateTriggers when the attributes of a party have been updated.
Product UpdateTriggers when the attributes of a product have been updated.
Contract DeclineTriggers when the contract state has been changed to declined .
Participant DeclineTriggers when a participant has declined the contract.
Contract DeleteTriggers when a contract has been deleted.
Participant DeleteTriggers when a participant has been deleted.
Party DeleteTriggers when a party has been removed from the contract.
Product DeleteTriggers when a product has been removed from the contract.

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

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

Contract data stays on your server

Counterparty names and contract values pass from Oneflow through your own WordPress site into the sheet, not through an outside automation account.

Every lifecycle event is covered

Runs are unlimited, so tracking visits, signatures, declines and renewals on every contract needs no bigger plan.

One tracker for sales, legal and finance

Each team reads the same sheet, so the question of whether a contract was signed is answered without opening Oneflow.

Common questions

Can Google Sheets show each Oneflow contract's status?

Yes. Add a row with Contract Publish, then build workflows on Contract Sign, Contract Decline and Contract Signing Period Expire that find the row by contract ID and update it.

What is the difference between Contract Sign and Participant Sign?

Contract Sign fires once the contract is signed. Participant Sign fires for each participant. Use Participant Sign if you want a column per signer.

Can I see who has not opened a contract?

Yes. Participant First Visit writes the date someone first opened it. Filter the sheet for published contracts with an empty Opened column.

Can I plan renewals from the sheet?

Yes. Contract Lifecycle State End, Contract Lifecycle State Cancel and Contract Lifecycle State Terminate can each add the contract to a Renewals or Ended tab with the date.

Does the sheet change anything in Oneflow?

No. Data moves from Oneflow to Google Sheets. Contracts are still created, sent and signed in Oneflow.

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

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