Connect Assembly and Google Sheets

Use Assembly and Google Sheets in the same FlowMattic workflow. Below are the triggers and actions both integrations offer; pick one of each to see how the two connect.

Try FlowMattic free See triggers and actions

29 triggers 19 actions 2 ready-made templates Unlimited runs

Try a pairing

When this happens in Assembly23 triggers

Do this in Google Sheets19 actions

1. TriggerClient Created

2. ActionAdd New Row

When Assembly fires Client 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.

Triggers and actions in this pair

A trigger starts a workflow. An action is something FlowMattic does in the app as a step.

Assembly

Integration page

Triggers (23)

Client CreatedTriggers when a client is created.
Company CreatedTriggers when a company is created.
File CreatedTriggers when a new file has been uploaded to a file channel.
Link CreatedTriggers when a new link has been created in a file channel.
Folder CreatedTriggers when a new folder has been created in a file channel.
Message Channel CreatedTriggers when a message channel has been created in the workspace.
Notification CreatedTriggers when a notification has been sent to a client or internal user.
Form Response CompletedTriggers when a form response has been submitted by a client.
Contract RequestedTriggers when a contract has been assigned to a client by an internal user.
Contract SignedTriggers when a contract has been signed by a client.
Message SentTriggers when a message has been sent (by a client or internal user).
Client ActivatedTriggers when a client authenticates in the portal for the first time.
Client UpdatedTriggers when any properties for a client are modified.
Company UpdatedTriggers when any properties for a company are modified.
File UpdatedTriggers when a file has been renamed or moved within a file channel.
Folder UpdatedTriggers when a folder has been renamed or moved within a file channel.
Link UpdatedTriggers when a link has been renamed or moved within a file channel.
Client DeletedTriggers when a client is put into an irreversible, deleted state.
Company DeletedTriggers when a company is put into an irreversible, deleted state.
File DeletedTriggers when a file has been deleted within a file channel.
Folder DeletedTriggers when a folder has been deleted within a file channel.
Link DeletedTriggers when a link has been deleted within a file channel.
Message Channel DeletedTriggers when a message channel has been deleted in the workspace.

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