Google BigQuery + Google Drive

Google BigQuery + Google Drive integrations

Create rows in Google BigQuery for new files in Google Drive

Streamline your file management and data analysis process by seamlessly integrating Google Drive and Google BigQuery. With this workflow, any new file added to your Google Drive will instantly create a corresponding row in Google BigQuery. It's an efficient automation that saves you manual data entry time and lets you focus on analyzing your BigQuery data.

When this happens...
New FileTriggers when any new file is added (inside of any folder).
TriggerPolling
automatically do this!
Create RowCreates a new row of data in a table. Note: Does not create a job.
ActionWrite

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

More things you can do with Google Drive and Google BigQuery

Discover other triggers and actions you can use with Google Drive and Google BigQuery

- Drive
Trigger
Polling
Try It
- Drive
- Folder
Trigger
Polling
Try It
- File
  Required
- Convert to Document?
- File Name
- Drive
- Folder
Action
Write
- Drive
- Folder
- File
  Required
- Export Format
  Required
Action
Write
- Drive
- Parent Folder
- Folder Name
  Required
Action
Write

- Drive
- Folder
- File Name
  Required
- File Content
  Required
- Convert to Document?
Action
Write
- Drive
- Folder
- File to Replace
  Required
- File
  Required
- Convert to Document?
- File Name
- File Extension
- Idempotency_key
Action
Write

- Drive
- File_id
  Required
- Sharing Preference
  Required
- Organization Domain
Action
Write
- Drive
- Copy
- Folder
- File
- Name
- Description
- Starred
- Folder Color (RGB)
- Custom Properties
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
Retrieve Files from Google Drive
This action sends a GET request to the Google Drive API to retrieve a list of files based on specific query parameters.
Action
Write
- Drive
- Folder
- File ID
  Required
Action
Search
- Folder Name
  Required
- Search_type
- Drive
- Parent Folder
Action
Search
- Folder Name
  Required
- Search_type
- Drive
- Parent Folder
Action
Search or write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
  Required
- Unique Column
  Required
Trigger
Polling
Try It
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Unique Column
  Required
- IS Operator
Trigger
Polling
Try It
- Project
  Required
- Dataset
  Required
- Table
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Rows
  Required
- Skip Invalid Rows
- Ignore Unknown Values
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Where Column
  Required
- Where Value
  Required
- Update Columns
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
- Sort Direction
- Where Clause
  Required
Action
Search
- Project
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
- Sort Direction
- Where Clause
  Required
Action
Search or write

- Drive
- Folder
- Include Subfolders?
- Subfolder Depth Limit
- Include Deleted Files?
Trigger
Polling
Try It
- Drive
- Folder
- Include_deleted
Trigger
Polling
Try It
- Drive
- Folder
- File
  Required
- Confirm deletion
  Required
Action
Write
- Drive
- Folder
- File
  Required
- Convert to Document?
- File Name
- File Extension
- Idempotency_key
Action
Write
- File
  Required
- Drive
- Folder
  Required
Action
Write
- Drive
- Folder
- File
  Required
- Email Address
- Permission ID
Action
Write
- Shared Drive Name
  Required
- Theme ID
- Color RGB
- Background Image File ID
Action
Write
- File
  Required
- Drive
- Folder
Action
Write
- Drive
- Folder
- File to Replace
- File/Folder Name
- Rename Folder?
- Extension_copy
Action
Write
Delete File
This action will delete a file in Google Drive. You will need to provide the file ID.
Action
Write
- Drive
- File or Folder ID
  Required
Action
Search
- Filename
  Required
- Search_type
- Drive
- Folder
- File_types
Action
Search
- Filename
  Required
- Search_type
- Drive
- Folder
- File_types
- File
  Required
- Convert to Document?
- File Name
- File Extension
- Idempotency_key
Action
Search or write
- Project
  Required
- Dataset
- Table
Trigger
Polling
Try It
- Project ID
  Required
- Job ID
  Required
- Location
  Required
Trigger
Polling
Try It
- Project
  Required
- Dataset
  Required
- Table
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Where Column
  Required
- Where Value
  Required
Action
Write
- Project ID
  Required
- SQL Query
  Required
- Location
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Project ID
  Required
- Job ID
  Required
- Location
  Required
Action
Search

About Google BigQuery

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

Learn moreLearn moreHelpHelp

Related categories

Databases

Google

Premium

About Google Drive

Google Drive is Google's file sync app that lets you store all of your files online alongside your Google Docs documents, and keep them synced with all of your devices.

Learn moreLearn moreHelpHelp

Related categories

File Management & Storage

Google

Similar apps

Dropbox

File Management & Storage

Box

File Management & Storage

OneDrive

File Management & Storage, Microsoft