Google Sheets

Connect GridWork HQ to your Google account and read or write rows to Google Sheets from pipeline nodes.

Prerequisites

• Google account with access to the sheets you want to use
• Sheets must not have restricted scopes (GridWork cannot access restricted sheets)

Connect to Google Sheets

1. In GridWork HQ, go to Settings > Integrations > Google Sheets.
2. Click Connect with Google.
3. Authorize GridWork to access your sheets (read and write permissions).
4. Select which Google accounts or shared drives to allow.
5. Click Authorize.

What It Enables

Once connected, pipeline nodes can interact with Google Sheets. You can:

• Read rows from a sheet as structured data.
• Write new rows to a sheet (e.g., append pipeline results).
• Filter and sort data before reading.
• Use sheets as a data source or destination for pipeline workflows.

Disconnect from Google Sheets

1. Go to Settings > Integrations > Google Sheets.
2. Click Remove or Disconnect.
3. Also revoke access in your Google Account security settings at myaccount.google.com/permissions.