Prismatic logo
Connectors
Google Sheets
Icon

Google Sheets Connector

Quickly build integrations connecting your B2B SaaS to Google Sheets.

About the Google Sheets Connector

Manage spreadsheets, sheets, and rows in Google Sheets.

Actions

Actions are tasks that you add to your workflow. One action might update records in a third-party API, while another action might fetch a list of records.

Jump to actions

Triggers

Triggers cause workflows to run. Some triggers run on a schedule. Others are invoked by a webhook request, or poll an API for new data. If a connector does not have a built-in trigger, you can use a generic scheduled or webhook trigger.

Jump to triggers

FAQs

Learn more about this connector and related integration functionality.

Jump to FAQs

Actions

Action NameAction Description
Add WorksheetAdd a new Worksheet to a Google Sheet Document
Append RowsAppend new rows to a Worksheet
Clear WorksheetClear all data in the a Worksheet
Create SpreadsheetCreate a new Google Sheet Document
List RowsList the cell values of rows in a Worksheet
List ColumnsGet the headers of a Worksheet
List WorksheetsList information about all Worksheets in a Google Sheet Document
Remove WorksheetRemove a Worksheet from a Google Sheet Document
Set Header RowSet the column headings in a Worksheet
Update RowsUpdate call values of rows in a Worksheet
Raw RequestSend raw HTTP request to Google Sheets

Triggers

Trigger NameTrigger Description
Spreadsheet Change EventsReceive change notifications for a Google Spreadsheet. Automatically creates and manages a Google Drive push notification subscription when the instance is deployed, and removes the subscription when the instance is deleted.
API Connectors

Integrate with customers' other SaaS apps, fast

Prismatic’s API connectors make it easy to integrate other SaaS apps – without reinventing the wheel. Triggers, actions, and auth are fully handled. And they work with all of Prismatic’s options for building integrations:
  • Empower non-devs with a low-code designer
  • Give devs freedom to build completely in code
  • Let customers create their own workflows
Image