Google BigQuery and Google Drive integration

Save yourself the work of writing custom integrations for Google BigQuery and Google Drive and use n8n instead. Build adaptable and scalable Data & Storage, Development, workflows that work with your technology stack. All within a building experience you will love.

Get Started See n8n in action

How to connect Google BigQuery and Google Drive

Create a new workflow and add the first step

In n8n, click the "Add workflow" button in the Workflows tab to create a new workflow. Add the starting point – a trigger on when your workflow should run: an app event, a schedule, a webhook call, another workflow, an AI chat, or a manual trigger. Sometimes, the HTTP Request node might already serve as your starting point.

Build your own Google BigQuery and Google Drive integration

Create custom Google BigQuery and Google Drive workflows by choosing triggers and actions. Nodes come with global operations and settings, as well as app-specific parameters that can be configured. You can also use the HTTP Request node to query data from any app or service with a REST API.

Google BigQuery and Google Drive integration details

Google BigQuery

Many businesses use the Google Cloud service BigQuery for data reporting. BigQuery is categorized as an Advanced Data Connector. The amount of data that needs to be processed could be quite large (up to 10,000 columns and tens of millions of rows).

Google BigQuery node docs + examples

Google BigQuery credential docs

See Google BigQuery integrations

Related categories

Data & Storage Development

Google Drive

Google Drive is a storage and synchronization service offered by Google. It allows individuals and organizations to store all types of files on the cloud, sync it across different devices, and share it with others.

Google Drive node docs + examples

Google Drive credential docs

See Google Drive integrations

Related categories

Data & Storage

Other integrations with Google BigQuery

Other integrations with Google Drive

Save engineering resources

Reduce time spent on customer integrations, engineer faster POCs, keep your customer-specific functionality separate from product all without having to code.

Learn more

FAQs

FAQ

Can Google BigQuery connect with Google Drive?

Can I use Google BigQuery’s API with n8n?

Can I use Google Drive’s API with n8n?

Is n8n secure for integrating Google BigQuery and Google Drive?

How to get started with Google BigQuery and Google Drive integration in n8n.io?

Need help setting up your Google BigQuery and Google Drive integration?

Discover our latest community's recommendations and join the discussions about Google BigQuery and Google Drive integration.

Google Drive Search File/Folder Returns Folder Id, not Contents

September 26, 2024hubschrauber

Goal Trying to use the Google Drive node to get the list of files / sub-folders in a specified folder. Workflow Setup Based on this I set up the Google Drive node with: Resource: File/Folder , Operation: Search , Sear…

Open topic

Connecting to Google on localhost

July 18, 2024Jon

I am stuck on creating a Google Drive connection to my google account. I’ve been following guide in this Youtube video: https://www.youtube.com/watch?v=gZ6N2H3_vys&ab_channel=n8n I made sure the Google Drive API was en…

Open topic

Google Drive - Execute Workflow Trigger - Test shows different results vs triggered

June 28, 2024David O'Neil

I have a simple workflow calling the Google Drive search function passing in { “query”: “text” }. I have it pinned within the “Execute Workflow Trigger”. When I test the workflow from the editor, it returns the results …

Open topic