IntegrationsOneDriveGoogle Bigquery
OneDrive + Google Bigquery

Connect OneDrive and Google Bigquery to Build Intelligent Automations

Choose a Trigger

OneDrive

When this happens...

Choose an Action

Google Bigquery

Automatically do this!

Use the Built-in Integrations

Actions and Triggers

When this happensTriggers

A trigger is an event that starts a workflow.

New File

New File

Triggers when a new file is added.

New Folder

New Folder

Trigger when new folder is added.

Request a new Trigger for OneDrive

Do thisActions

Action is the task that follows automatically within your OneDrive integrations.

Create a Folder

Create a Folder

Creates a folder.

Create New Text File

Create New Text File

Creates a new text file with a plain text content.

Find File

Find File

Find a file by name

Find Folder

Find Folder

Finds a folder by name

Run a Query

Run a Query

run a sql query against a table in bigquery.

Get Rows for Job Completed

Get Rows for Job Completed

Gets batch of rows from completed jobs in BigQuery

We'll help you get started

Our team is all set to help you!

Customer support expert avatarTechnical support expert avatarAutomation specialist expert avatarIntegration expert avatar

Frequently Asked Questions

How do I start an integration between OneDrive and Google Bigquery?

To start, connect both your OneDrive and Google Bigquery accounts to viaSocket. Once connected, you can set up a workflow where an event in OneDrive triggers actions in Google Bigquery (or vice versa).

Can we customize how data from OneDrive is recorded in Google Bigquery?

Absolutely. You can customize how OneDrive data is recorded in Google Bigquery. This includes choosing which data fields go into which fields of Google Bigquery, setting up custom formats, and filtering out unwanted information.

How often does the data sync between OneDrive and Google Bigquery?

The data sync between OneDrive and Google Bigquery typically happens in real-time through instant triggers. And a maximum of 15 minutes in case of a scheduled trigger.

Can I filter or transform data before sending it from OneDrive to Google Bigquery?

Yes, viaSocket allows you to add custom logic or use built-in filters to modify data according to your needs.

Is it possible to add conditions to the integration between OneDrive and Google Bigquery?

Yes, you can set conditional logic to control the flow of data between OneDrive and Google Bigquery. For instance, you can specify that data should only be sent if certain conditions are met, or you can create if/else statements to manage different outcomes.

OneDrive

About OneDrive

Microsoft OneDrive is a file hosting service operated by Microsoft. First released in August 2007, it allows registered users to store, share and sync their files. OneDrive also works as the storage backend of the web version of Microsoft 365 / Office.

Learn More
Google Bigquery

About Google Bigquery

BigQuery is Google's serverless and highly scalable enterprise data warehouse, designed to make all your data analysts productive.

Learn More