Google Drive channel

Go to the Channel Catalog to learn more about what plans have access to this channel. Sign into Quickbase, and then go to Pipelines > Channels.

Before you start using this channel, you need to update your Google Workspace account to allow the connection to the Quickbase connector. Learn more in the help article

Google Drive is a file storage and synchronization service which allows users to store files on their servers, synchronize files across devices, and share files.

How to connect

On the My pipelines page, select Create Pipeline.
Search for or select a step, and then select it to add it to the pipeline.
When you add a step to a pipeline, it is added to the canvas of the pipeline designer.
Expand the Connection section of the step, and add the required information.

Connect to Google Docs

Expand Google Drive and click Connect to Google Docs.
Review the permissions that Pipelines will receive once connected. Your permissions are based on your existing Google account. You can select specific permissions or allow all the options. Google Drive permissions are required. When finished click Connect to Google Drive.
Note: Depending on the permissions granted, integration and functionality will be affected.
You may need to sign in with your Google credentials. This is required to set up the connection between Google Drive and Pipelines.
Agree to allow Pipelines access to your Google account by clicking Allow.

How to reconnect

You may need to reconnect your account to a channel. Reasons may be (but not limited to):

If you need to connect a different account.
Authorization updates, such as a changed password.
Editing the access rights that Pipelines has to the channel.

To reconnect:

Select a pipeline that already has this channel in it.
Open a step that contains this channel.
Under account, select Connect (or reconnect) and follow the process above, How to connect.

Steps

The steps you can use with Google Drive are: Folders, Files, and Permissions.

Note: You cannot use jinja expressions in trigger conditions unless explicitly specified as possible.

Type	Name	Description
Folders
Trigger	Folder Created	Triggers when a folder is created. Select the Google Drive account to use for this trigger and search for files in the specified shared drive. If you don't specify the shared drive, files created by, opened by, and shared directly with the user, and files in My Drive are searched.
Trigger	Folder Updated	Triggers when a folder is updated. Select the Google Drive account to use for this trigger and search for files in the specified shared drive. If you don't specify the shared drive, files created by, opened by, and shared directly with the user, and files in My Drive are searched.
Action	Create a folder	Creates a folder. Select the Google Drive account to use for this folder and search for files in the specified shared drive. If you don't specify the shared drive, files created by, opened by, and shared directly with the user, and files in My Drive are searched. Specify the parent and the name of the new folder. You can also link this folder to another resource instance so that later you can fetch one from the other and vice-versa.
Action	Update a folder	Updates a folder. Select the Google Drive account to use for this folder and search for files in the specified shared drive. If you don't specify the shared drive, files created by, opened by, and shared directly with the user, and files in My Drive are searched. Specify the parent and the name of the folder.
Action	Delete a folder	Deletes a folder. Select the Google Drive account to use for this folder and search for files in the specified shared drive. If you don't specify the shared drive, files created by, opened by, and shared directly with the user, and files in My Drive are searched.
Query	Search Folders	Searches for the selected account for folders and returns a list. Select the Google Drive account to use for this folder and search for files in the specified shared drive. If you don't specify the shared drive, files created by, opened by, and shared directly with the user, and files in My Drive are searched. In Sheets Export Format, you can select the export format to use when transferring native Google Sheets files to another system. Spreadsheet files uploaded without converting to Google Sheets will be downloaded in their original format. In Documents Export Format, specify the export format to use when transferring native Google Docs files to another system. Document files uploaded without converting to Google Docs will be downloaded in their original format. In Drawings Export Format, specify the export format to use when transferring native Google Drawings files to another system. Files uploaded without converting to Google Drawings will be downloaded in their original format In Slides Export Format, specify the Export format to use when transferring native Google Slides files to another system. Files uploaded without converting to Google Slides will be downloaded in their original format. In Search Query you can search with a query, including the API search parameters.
Action	Fetch a Linked Folder	Retrieves a linked folder.
Action	Look Up a Folder	Searches for a folder.
Files
Trigger	File Created	Triggers when a file is created. Select the Google Drive account to use for this trigger and search for files in the specified shared drive. If you don't specify the shared drive, files created by, opened by, and shared directly with the user, and files in My Drive are searched.
Trigger	File Updated	Triggers when a file is updated. Select the Google Drive account to use for this trigger and search for files in the specified shared drive. If you don't specify the shared drive, files created by, opened by, and shared directly with the user, and files in My Drive are searched.
Trigger	File Deleted	Triggers when a file is deleted. Select the Google Drive account to use for this trigger and search for files in the specified shared drive. If you don't specify the shared drive, files created by, opened by, and shared directly with the user, and files in My Drive are searched.
Action	Update a File	Updates a file. Select the Google Drive account to use for this folder and search for files in the specified shared drive. If you don't specify the shared drive, files created by, opened by, and shared directly with the user, and files in My Drive are searched. The file limit is 100MB.
Action	Delete a File	Deletes a file. Select the Google Drive account to use for this folder and search for files in the specified shared drive. If you don't specify the shared drive, files created by, opened by, and shared directly with the user, and files in My Drive are searched.
Action	Move File to Folder	Moves a file to a specific folder.
Action	Remove File from folder	Removes a file from a specific folder.
Action	Upload a File	Uploads a file. Options: Sheets Export Format Update pipe inherits the options from the source. Export format to use when transferring native Google Sheets files to another system. Spreadsheet files uploaded without converting to Google Sheets will be downloaded in their original format. Documents Export Format Update pipe inherits the options from the source. Export format to use when transferring native Google Docs files to another system. Document files uploaded without converting to Google Docs will be downloaded in their original format. Drawings Export Format Look Up a File, Upload a File, Search Files. Update pipe inherits the options from the source. Export format to use when transferring native Google Drawings files to another system. Drawing files uploaded without converting to Google Drawings will be downloaded in their original format. Slides Export Format Update pipe inherits the options from the source. Export format to use when transferring native Google Slides files to another system. Presentation files uploaded without converting to Google Slides will be downloaded in their original format. The file limit is 100MB.
Query	Search Files	Searches for a file. Options: Sheets Export Format Update pipe inherits the options from the source. Export format to use when transferring native Google Sheets files to another system. Spreadsheet files uploaded without converting to Google Sheets will be downloaded in their original format. Documents Export Format Update pipe inherits the options from the source. Export format to use when transferring native Google Docs files to another system. Document files uploaded without converting to Google Docs will be downloaded in their original format. Drawings Export Format Look Up a File, Upload a File, Search Files. Update pipe inherits the options from the source. Export format to use when transferring native Google Drawings files to another system. Drawing files uploaded without converting to Google Drawings will be downloaded in their original format. Slides Export Format Update pipe inherits the options from the source. Export format to use when transferring native Google Slides files to another system. Presentation files uploaded without converting to Google Slides will be downloaded in their original format.
Action	Fetch a linked File	Retrieves a linked file.
Action	Look Up a File	Searches for a file. Options: Sheets Export Format Update pipe inherits the options from the source. Export format to use when transferring native Google Sheets files to another system. Spreadsheet files uploaded without converting to Google Sheets will be downloaded in their original format. Documents Export Format Update pipe inherits the options from the source. Export format to use when transferring native Google Docs files to another system. Document files uploaded without converting to Google Docs will be downloaded in their original format. Drawings Export Format Update pipe inherits the options from the source. Export format to use when transferring native Google Drawings files to another system. Drawing files uploaded without converting to Google Drawings will be downloaded in their original format. Slides Export Format Update pipe inherits the options from the source. Export format to use when transferring native Google Slides files to another system. Presentation files uploaded without converting to Google Slides will be downloaded in their original format.
Permissions
Action	Create a Permission	Creates a permission.
Action	Delete a Permission	Deletes a permission.
Query	Search Permissions	Searches for a permission.
Action	Look Up a Permission	Looks up a permission.

Limits

You should limit your uploads to 30MB per file.

Examples of usage

The following is an example of a use of Google Drive in Pipelines.

Employee onboarding and user provisioning

A new employee record, created in our Quickbase app, triggers the creation of a new permissionsd for the new user in Google Drive.

A new employee's information is added in our Quickbase HR app.
Our pipeline, triggered by this addition, creates a permission in Google Drive using this data.