Airtable + Google Drive

Log new Google Drive files in Airtable

Keep a record of every file that gets added to your most important Google Drive folders with this integration. Set it up, and whenever a file is added to the Google Drive folder you select, Zapier will automatically log that file's details to an Airtable database.

When this happens...
New File in Folder
Triggers when a new file is added directly to a specific folder (but not its subfolders).
TriggerScheduled
automatically do this!
Create Record
Creates a new record with auto-populating fields.
ActionWrite

Try this template

Free 14-day trial

5,000+ supported apps

Supported triggers and actions

What does this mean?

- Drive
  The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.
Trigger
Scheduled
Try It
- Drive
  The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.
- Folder
  Check a specific folder for new subfolders. Keep clicking to go inside folders. Please note: new folders added to subfolders inside the folder you choose here will NOT trigger this Zap. Defaults to the top-level folder if none is picked.
Trigger
Scheduled
Try It
- FileRequired
  File to Copy
- Convert to Document?
  If yes, we will tell Google to convert this into an editable document.
- File Name
  By default, we name the new copy as "Copy of {original file name}".
- Drive
  The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.
- Folder
  Folder to put the new copy into. Keep clicking to drill down into child folders. Defaults to the same folder as the source file's.
Action
Write
- Drive
  The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.
- Parent Folder
  Select where to create this new folder. Keep clicking the dropdown to go inside folders. Defaults to the top-level folder if left blank.
- Folder NameRequired
Action
Write
- Drive
  The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.
- Folder
  Folder where to place file. Keep clicking the dropdown to go inside folders. Defaults to the top-level folder if left blank.
- File NameRequired
- File ContentRequired
  Use plain text.
- Convert to Document?
  If yes, we will tell Google to convert this into an editable document.
Action
Write

- Drive
  The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.
- File IdRequired
- Sharing PreferenceRequired
  This will add a group that the file is shared with, but not remove any existing groups it is shared with. Sharing with an organization is only valid for G Suite users.
- Organization Domain
  Domain name of your G Suite organization (required if you chose a "Sharing Preference" that includes your organization). Example: yourcompany.com
Action
Write
- Api Docs Info
  API docs for Google Drive are located here https://developers.google.com/drive/api/v3/reference
- HTTP MethodRequired
- URLRequired
  Requests can only be made to domains associated by this application.
- Query String Parameters
  These params will be URL-encoded and appended to the URL when making the request.
- Headers
  Authentication headers are included automatically
- Additional Request Headers
  Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.
- Body
  Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example, {"foo": "bar"} is perfectly valid.
Action
Write

- Folder NameRequired
- Drive
  The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.
- Parent Folder
  Keep clicking the dropdown to go inside folders. Defaults to the top-level folder if left blank.
Action
Search
- Folder NameRequired
- Drive
  The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.
- Parent Folder
  Select where to create this new folder. Keep clicking the dropdown to go inside folders. Defaults to the top-level folder if left blank.
Action
Search or write
- BaseRequired
- TableRequired
- Help Text
  You must have at least one "Last Modified Time" type column in your Table in order to use this Trigger. Learn more about those here.
- Which timestamp field should this Zap use to check for updates?Required
  When this column changes to a new timestamp, your Zap will trigger on the corresponding record. Note: Must be a Last Modified Time column type.
- Limit to View
  Filter on updates to a specific View in your Table.
- Include file contents?
  Returns an extra File field with file contents. Set this field to Yes if you have trouble with Airtable file URLs expiring. File contents greater than 100MB will cause an error.
Trigger
Scheduled
Try It
- BaseRequired
  Base in which to create the record.
- TableRequired
Action
Write
- BaseRequired
  Base to search for a record.
- TableRequired
  Pick an Airtable table that you want to search.
- Search by Field
  Pick a field from the base to match against the search value.
- Search Value
  The value of unique identifier for the record.
- Search Formula
  (ADVANCED) Alternatively, you can use an Airtable search formula to find records based on advanced conditions and any number of fields. Learn more.
- Limit to View
  Limit the search to a specific view. Useful for sorting results.
- Include file contents?
  Returns an extra File field with file contents. Set this field to Yes if you have trouble with Airtable file URLs expiring. File contents greater than 100MB will cause an error.
Action
Search
- BaseRequired
  Base in which to create the record.
- TableRequired
  Pick an Airtable table that you want to search.
- Search by Field
  Pick a field from the base to match against the search value.
- Search Value
  The value of unique identifier for the record.
- Search Formula
  (ADVANCED) Alternatively, you can use an Airtable search formula to find records based on advanced conditions and any number of fields. Learn more.
- Limit to View
  Limit the search to a specific view. Useful for sorting results.
- Include file contents?
  Returns an extra File field with file contents. Set this field to Yes if you have trouble with Airtable file URLs expiring. File contents greater than 100MB will cause an error.
Action
Search or write

- Drive
  The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.
- Folder
  Check a specific folder for new files. Keep clicking to go inside folders. Please note: new files added to subfolders inside the folder you choose here will NOT trigger this Zap. Defaults to the top-level folder if none is picked.
Trigger
Scheduled
Try It
- Drive
  The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.
- Folder
  Check a specific folder for updated files. Keep clicking to go inside folders. Please note: files updated within 5 minutes after creation or located in subfolders of the folder you choose here will NOT trigger this Zap. Defaults to the top-level folder if none is picked.
- Include Deleted
  Should this trigger also on files that are deleted?
Trigger
Scheduled
Try It
- Drive
  The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.
- Folder
  Folder where to place file. Keep clicking the dropdown to go inside folders. Defaults to the top-level folder if left blank.
- FileRequired
  A file to be uploaded. Can be an actual file or a public URL. See this help doc for more information
- Convert to Document?
  If yes, we will tell Google to convert this into an editable document.
- File Name
  By default, we use the same name and extension as the original file.
- File Extension
  Advanced: Can only be used if you also specify a file name.
- Idempotency Key
Action
Write
- FileRequired
  File to Move
- Drive
  The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.
- FolderRequired
  Destination folder to move into. Keep clicking to drill down into child folders.
Action
Write
- Drive
  The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.
- Folder
  Folder to find/replace this file into. Keep clicking to drill down into child folders. Places at the top-level if none picked.
- File to ReplaceRequired
- FileRequired
  A file to be uploaded. Can be an actual file or a public URL. See this help doc for more information
- Convert to Document?
  If yes, we will tell Google to convert this into an editable document.
- File Name
  By default, we use the same name and extension as the original file.
- File Extension
  Advanced: Can only be used if you also specify a file name.
- Idempotency Key
Action
Write
- FileRequired
  File to create a shortcut to
- Drive
  The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.
- Folder
  Destination folder for shortcut. Keep clicking to drill down into child folders.
Action
Write
- File NameRequired
- Drive
  The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.
- Folder
- File Types
  Restrict the search to specific file types. If you only want a single file extension, you can simply add that to the name search above.
Action
Search
- File NameRequired
- Drive
  The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.
- Folder
  Folder where to place file. Keep clicking the dropdown to go inside folders. Defaults to the top-level folder if left blank.
- File Types
  Restrict the search to specific file types. If you only want a single file extension, you can simply add that to the name search above.
- FileRequired
  A file to be uploaded. Can be an actual file or a public URL. See this help doc for more information
- Convert to Document?
  If yes, we will tell Google to convert this into an editable document.
- File Name
  By default, we use the same name and extension as the original file.
- File Extension
  Advanced: Can only be used if you also specify a file name.
- Idempotency Key
Action
Search or write
- BaseRequired
- TableRequired
- Limit to View
  (Optional) Limit to records added to a specific View, and return records in the View order.
- Include file contents?
  Returns an extra File field with file contents. Set this field to Yes if you have trouble with Airtable file URLs expiring. File contents greater than 100MB will cause an error.
Trigger
Scheduled
Try It
- BaseRequired
  Base in which to create the record.
- TableRequired
Action
Write
- BaseRequired
  Pick the Airtable base containing the records you wish to update.
- TableRequired
  Pick the Airtable table containing the records you wish to update.
- RecordRequired
  Pick the Airtable record that you wish to update.
Action
Write
- BaseRequired
  Base to search for a record.
- TableRequired
  Pick an Airtable table that you want to search.
- Search by Field
  Pick a field from the base to match against the search value.
- Search Value
  The value of unique identifier for the record.
- Search Formula
  (ADVANCED) Alternatively, you can use an Airtable search formula to find records based on advanced conditions and any number of fields. Learn more.
- Limit to View
  You can optionally limit the search to a specific view id.
Action
Search
- BaseRequired
  Base in which to create the record.
- TableRequired
  Pick an Airtable table that you want to search.
- Search by Field
  Pick a field from the base to match against the search value.
- Search Value
  The value of unique identifier for the record.
- Search Formula
  (ADVANCED) Alternatively, you can use an Airtable search formula to find records based on advanced conditions and any number of fields. Learn more.
- Limit to View
  You can optionally limit the search to a specific view id.
Action
Search or write

About Airtable

Organize anything with Airtable, a modern database created for everyone. Airtable is a fast and flexible way to create tables to keep track of anything, from sales leads to vacation planning to inventory management.

Learn more

Related categories

Databases

Similar apps

Quick Base

Databases

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

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

Related categories

Similar apps

Dropbox

File Management & Storage

Box

File Management & Storage

OneDrive

File Management & Storage, Microsoft

Get started for free

You can't add more hours to the day. Zapier is the next best thing.

By signing up, you agree to Zapier's terms of service and privacy policy.

Airtable + Google Drive

Log new Google Drive files in Airtable

New File

Drive

New Folder

Drive

Folder

Copy File

FileRequired

Convert to Document?

File Name

Drive

Folder

Create Folder

Drive

Parent Folder

Folder NameRequired

Create File from Text

Drive

Folder

File NameRequired

File ContentRequired

Convert to Document?

Add File Sharing Preference

Drive

File IdRequired

Sharing PreferenceRequired

Organization Domain

API Request (Beta)

Api Docs Info

HTTP MethodRequired

URLRequired

Query String Parameters

Headers

Additional Request Headers

Body

Find a Folder

Folder NameRequired

Drive

Parent Folder

Find or Create Folder

Folder NameRequired

Drive

Parent Folder

New or Updated Record

BaseRequired

TableRequired

Help Text

Which timestamp field should this Zap use to check for updates?Required

Limit to View

Include file contents?

Create Records (With Line Item Support)

BaseRequired

TableRequired

Find Many Records (With Line Item Support)

BaseRequired

TableRequired

Search by Field

Search Value

Search Formula

Limit to View

Include file contents?

Find or Create Record(s) (With Line Item Support)

BaseRequired

TableRequired

Search by Field

Search Value

Search Formula

Limit to View

Include file contents?

New File in Folder

Drive

Folder

Updated File

Drive

Folder

Include Deleted

Upload File

Drive

Folder