Google BigQuery + Google Drive

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 File
Triggers when any new file is added (inside of any folder).
TriggerPolling
automatically do this!
Create Row
Creates a new row of data in a table. Note: Does not create a job.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

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

Supported triggers and actions

- Drive
Trigger
Polling
Try It
- Drive
- Folder
Trigger
Polling
Try It
- FileRequired
- Convert to Document?
- File Name
- Drive
- Folder
Action
Write
- Drive
- Folder
- FileRequired
- Export FormatRequired
Action
Write
- Drive
- Parent Folder
- Folder NameRequired
Action
Write

- Drive
- Folder
- File NameRequired
- File ContentRequired
- Convert to Document?
Action
Write
- Drive
- Folder
- File to ReplaceRequired
- FileRequired
- Convert to Document?
- File Name
- File Extension
- Idempotency Key
Action
Write

- Drive
- File IdRequired
- Sharing PreferenceRequired
- Organization Domain
Action
Write
- Drive
- Copy
- Folder
- File
- Name
- Description
- Starred
- Folder Color (RGB)
- Custom Properties
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- 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 IDRequired
Action
Search
- Folder NameRequired
- Search Type
- Drive
- Parent Folder
Action
Search
- Folder NameRequired
- Search Type
- Drive
- Parent Folder
Action
Search or write
- Project IDRequired
- DatasetRequired
- TableRequired
- Sort By ColumnRequired
- Unique ColumnRequired
Trigger
Polling
Try It
- Project IDRequired
- DatasetRequired
- TableRequired
- Unique ColumnRequired
- IS Operator
Trigger
Polling
Try It
- ProjectRequired
- DatasetRequired
- TableRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- RowsRequired
- Skip Invalid Rows
- Ignore Unknown Values
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Where ColumnRequired
- Where ValueRequired
- Update ColumnsRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Sort By Column
- Sort Direction
- Where ClauseRequired
Action
Search
- ProjectRequired
- DatasetRequired
- TableRequired
- Sort By Column
- Sort Direction
- Where ClauseRequired
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
- FileRequired
- Confirm deletionRequired
Action
Write
- Drive
- Folder
- FileRequired
- Convert to Document?
- File Name
- File Extension
- Idempotency Key
Action
Write
- FileRequired
- Drive
- FolderRequired
Action
Write
- Drive
- Folder
- FileRequired
- Email Address
- Permission ID
Action
Write
- Shared Drive NameRequired
- Theme ID
- Color RGB
- Background Image File ID
Action
Write
- FileRequired
- 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 IDRequired
Action
Search
- FilenameRequired
- Search Type
- Drive
- Folder
- File Types
Action
Search
- FilenameRequired
- Search Type
- Drive
- Folder
- File Types
- FileRequired
- Convert to Document?
- File Name
- File Extension
- Idempotency Key
Action
Search or write
- ProjectRequired
- Dataset
- Table
Trigger
Polling
Try It
- Project IDRequired
- Job IDRequired
- LocationRequired
Trigger
Polling
Try It
- ProjectRequired
- DatasetRequired
- TableRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Where ColumnRequired
- Where ValueRequired
Action
Write
- Project IDRequired
- SQL QueryRequired
- Location
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Project IDRequired
- Job IDRequired
- LocationRequired
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 more

Related categories

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 more

Google BigQuery + Google Drive

Create rows in Google BigQuery for new files in Google Drive

New File

New Folder

Copy File

Export File

Create Folder

Create File From Text

Replace File

Add File Sharing Preference

Update File or Folder Metadata

API Request (Beta)

Retrieve Files from Google Drive

Get File Permissions

Find a Folder

Find or Create Folder

New Row

Updated Row

Create Rows

Import Data

Update Row(s)

Find One Row

Find or Create Record

New File in Folder

Updated File

Delete File (Permanent)

Upload File

Move File

Remove File Permission

Create Shared Drive

Create Shortcut

Update File/Folder Name

Delete File

Retrieve File or Folder by ID

Find a File

Find or Create File

Query Job Completed (With Row Data)

New Job Completed

Create Row

Delete Rows

Run a Query

API Request (Beta)

Get Rows for Job Completed

About Google BigQuery

Related categories

About Google Drive

Related categories

Similar apps

Dropbox

Box

OneDrive