Google Sheets
Sync data between the platform and Google Sheets for reports, exports and data ingestion.
Send data to Google Sheets
You can send data from a workflow to a Google Sheets spreadsheet using the HTTP Request node with the Google Sheets API, or through an intermediary webhook with services like Zapier or Make.
- Prepare your Google Sheets spreadsheet with the corresponding columns.
- Configure authentication (API key or intermediary service).
- Add an HTTP Request node in your workflow pointing to the Google Sheets endpoint.
- Map the workflow data to the spreadsheet columns.
Read data from Google Sheets
Similarly, you can read data from a Google Sheets spreadsheet using the HTTP Request node with a GET to the Google Sheets API. The returned data can be used in subsequent workflow nodes for processing, validation or synchronization.
Use cases
- Export form responses to a shared spreadsheet.
- Sync inventories or catalogs from Sheets.
- Generate periodic reports in Sheets with workflow data.
- Feed workflows with data lists stored in Sheets.