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:
The file limit is 100MB. |
| Query | Search Files |
Searches for a file. Options:
|
| Action | Fetch a linked File | Retrieves a linked file. |
| Action | Look Up a File |
Searches for a file. Options:
|
| 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.