Public Google Sheet
Use this mode when your sheet is shared with “Anyone with the link” and contains non-sensitive data. No API keys or service accounts required — just the URL.What You’ll Need
Making Your Sheet Public
Open your Google Sheet
Navigate to your Google Sheet in the browser.
Open sharing settings
Click the Share button in the top-right corner.
Set to public
Under General access, change from “Restricted” to “Anyone with the link”. Set permission to Viewer. Click Done.
Copy the URL
Copy the URL from your browser’s address bar. It looks like: Connecting to Workshop
Open Hub > Connectors
Open the Workshop Hub and click Connectors.
Select Public Google Sheet
Click the Public Google Sheet card.
Enter details
Enter a Connection Name (e.g., “Product Catalog”) and paste your Spreadsheet URL.
Save
Click Add Connection.
/edit, /view, or just the sheet ID path).Security Considerations
When you make a sheet public, anyone with the URL can view all data in it. Treat the URL as a credential.
Private Google Sheet
Use this mode when your sheet is restricted to specific users and contains sensitive or confidential data. Requires a Google Cloud Platform (GCP) service account.Requires a Google Cloud project. Accessing private sheets requires a GCP service account, which involves creating a project and sharing your sheet with the service account email. If you prefer simpler setup, consider making your sheet public and using the Public mode instead.
What You’ll Need
Setting Up Access
Create a GCP project
Go to the Google Cloud Console. Click Select a project > New Project, enter a name (e.g., “Workshop Sheets Access”), and click Create. Enable the Google Sheets API
Go to APIs & Services > Library, search for “Google Sheets API”, and click Enable.
Create a service account
Go to IAM & Admin > Service Accounts, click Create Service Account, enter a name (e.g., “Workshop Sheets Reader”), and click Create and Continue. Select the Viewer role, then click Done.
Download the JSON key
Click on the service account, go to the Keys tab, click Add Key > Create new key, select JSON, and click Create. The file downloads automatically. Note the client_email field inside it.
Share your sheet with the service account
Open your Google Sheet, click Share, paste the service account’s client_email (looks like name@project.iam.gserviceaccount.com), set permission to Viewer, uncheck “Notify people”, and click Share.
The client_email in your JSON file looks like: your-service-account@your-project.iam.gserviceaccount.com. You must share your sheet with this email for the connection to work.
Connecting to Workshop
Open Hub > Connectors
Open the Workshop Hub and click Connectors.
Select Private Google Sheet
Click the Private Google Sheet card.
Enter details
Enter a Connection Name, paste the Spreadsheet URL, and paste the full contents of your Service Account JSON key file.
Save
Click Add Connection.
Security Considerations
- The service account only has access to sheets explicitly shared with it
- Share with Viewer permission unless Workshop needs to write data
- Once connected, you can delete the JSON key file from your downloads — Workshop stores credentials securely
- To revoke access, remove the service account email from the sheet’s sharing settings
