Skip to main content

​
Overview

Workshop supports two modes for connecting Google Sheets:
ModeAuthenticationBest For
Public SheetSheet URL onlyNon-sensitive data shared via “Anyone with the link”
Private SheetGCP Service Account JSONConfidential data restricted to specific accounts
Choose the tab below that matches your use case.

​
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

CredentialDescription
Spreadsheet URLThe sharing link to your public Google Sheet

​
Making Your Sheet Public

1

Open your Google Sheet

Navigate to your Google Sheet in the browser.
2

Open sharing settings

Click the Share button in the top-right corner.
3

Set to public

Under General access, change from “Restricted” to “Anyone with the link”. Set permission to Viewer. Click Done.
4

Copy the URL

Copy the URL from your browser’s address bar. It looks like:
https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit#gid=0

​
Connecting to Workshop

1

Open Hub > Connectors

Open the Workshop Hub and click Connectors.
2

Select Public Google Sheet

Click the Public Google Sheet card.
3

Enter details

Enter a Connection Name (e.g., “Product Catalog”) and paste your Spreadsheet URL.
4

Save

Click Add Connection.
Workshop accepts URLs in any standard Google Sheets format (/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.
Public sheets are appropriate for sample datasets, publicly available information, and shared reference materials. Avoid making sheets public if they contain personal information, financial data, or business-sensitive content.To revoke public access, change the sheet back to Restricted in sharing settings.

​
Using Your Connection

Once connected (either mode), ask Workshop to work with your spreadsheet data: 
Show me the first few rows from my spreadsheet

Using my Google Sheet connection, create a summary of all entries in column A

Create a chart from my Google Sheet data showing sales by month

​
Working with Multiple Tabs

If your spreadsheet has multiple tabs, specify which one: 
Show me data from the "Sales Q4" tab in my spreadsheet
By default, Workshop reads from the first sheet if no tab name is specified.
Workshop works best with spreadsheets under 10,000 rows. For very large datasets, consider using a database connector or BigQuery instead.

​
Troubleshooting

IssueSolution
”Unable to access spreadsheet” (public)Verify the sheet is set to “Anyone with the link”. Try opening the URL in an incognito window.
”Permission denied” (private)Ensure the sheet is shared with the service account client_email.
”Invalid JSON” (private)Verify you copied the entire JSON file contents without extra characters.
”Google Sheets API not enabled” (private)Enable the Google Sheets API in your GCP project and wait a few minutes.

​
Learn More