Is there a specific app this action is for?

BigQuery - The current Pipedream BigQuery integration only requests the BigQuery OAuth scope, but does not include the Google Drive scope. This prevents users from querying BigQuery external tables that are backed by Google Sheets or other Google Drive files.

Problem Description

When querying a BigQuery external table that references a Google Sheet (or any Drive file), the following error occurs:

Access Denied: BigQuery BigQuery: Permission denied while getting Drive credentials.

This happens because the BigQuery OAuth connection in Pipedream does not include the Google Drive scope, which is required by Google Cloud to access external tables backed by Drive data.

API Documentation

Google Cloud Documentation:
https://cloud.google.com/bigquery/docs/external-data-drive

Relevant excerpt from Google's documentation:

"Accessing data hosted within Drive requires an additional OAuth scope."

Required OAuth Scopes:

Scope	Description
https://www.googleapis.com/auth/bigquery	Current scope (already included)
https://www.googleapis.com/auth/drive.readonly	Required for querying external tables backed by Drive/Sheets

Alternative (broader scope):

• https://www.googleapis.com/auth/drive (full Drive access)

Technical Details

When authenticating with BigQuery using OAuth, the scopes must include both:

scopes = [
    "https://www.googleapis.com/auth/bigquery",
    "https://www.googleapis.com/auth/drive.readonly"
]

This is a well-documented requirement. Similar issues have been resolved in other tools:

• dbt-core: https://github.com/dbt-labs/dbt-core/issues/1518
• dbt-bigquery: https://github.com/dbt-labs/dbt-bigquery/issues/23
• Metabase: https://github.com/metabase/metabase/issues/13001

Proposed Solution

Add the https://www.googleapis.com/auth/drive.readonly scope to the BigQuery OAuth connection in Pipedream. This would allow users to:

1. Query BigQuery external tables backed by Google Sheets
2. Query BigQuery external tables backed by any Google Drive file (CSV, JSON, Avro)

Use Case

We use BigQuery external tables to mirror Google Sheets data (e.g., company_news_gsheet_mirror.client_data). This is a common pattern for:

• Syncing spreadsheet data to BigQuery for analysis
• Creating live connections between Sheets and BigQuery
• Building data pipelines that combine structured data with user-maintained spreadsheets

Currently, we cannot query these tables through Pipedream's BigQuery integration, which blocks our automation workflows.