CODEWITHSUNDEEP
google-sheetsgoogle-cloud-platformgoogle-bigquerygoogle-sheets-api
Mauricio
Mauricio

Reputation: 3089

How do I read data from Google Sheets tab produced by BigQuery Data Connector?

We have a system that reads the values from the user's Google Sheets tab. The user selects the tab from which the data will be extracted. This process is working fine for ordinary tabs, but it's failing to read data from tabs that are Data Connector for BigQuery.

The Sheets API returns a HTTP 400 error stating that the range is not valid.

Details: Unable to parse range: Teams!A1:C10

I've looked into the Google Sheets API reference but could not find any example on how to get the values from a Sheets tab connected to BigQuery. Is it even possible?

Upvotes: 0

Views: 141

Answers (1)

Joevanie
Joevanie

Reputation: 605

You can use Connected Sheets to share BigQuery data from your Google Sheets spreadsheet. Note though from the official docs, "because VPC Service Controls does not support Sheets, you might not be able to access BigQuery data that VPC Service Controls is protecting." You can go over the documentations VPC Service Controls, configuring ingress and egress policies, and configuring access levels.

Upvotes: 0

Related Questions