This topic describes the requirements and provides step‑by‑step instructions to integrate Google Sheets and Automate Studio.
Prerequisites:
- Tenant Administrator Access
You must be a tenant administrator to configure the environment and generate client credentials for Google Sheets integration.
- Google Cloud Platform (GCP) Project with OAuth Consent Screen:
You must have a GCP project with an OAuth Consent Screen configured. This allows the add-on to request and manage permissions for accessing your Google Sheets and Drive data securely.
- Enabled APIs: The following APIs must be enabled in your GCP project to allow the Studio with Google Sheets to function correctly:
- Google Drive API
- Google Sheets API
- DOC API
- userinfo.profile API