Connectors

/

Google Drive

Data replication

Sync Google Drive data anywhere.

Unify your operations with the only connector you’ll ever need. Move large volumes of data with best-in-class replication, or build production-ready AI agents directly on your data.

  • Certified
  • Alpha
  • 11 entities
  • Read & write
Google Drive

Everything Google Drive can do in Airbyte

  • Sync to your warehouse

    Land Google Drive data in 50+ destinations on a schedule you control.

  • Live entity actions

    Read, create, update and delete Google Drive records at runtime through typed entity actions.

  • Context store search

    Query synced Google Drive data with filters, sorting and semantic search, without spending Google Drive API rate limits.

  • Incremental syncs

    Pull only the records that changed since the last run instead of reloading everything.

What to know before you sync Google Drive

  • Support levelCertified
  • Available onCloud, Self-Managed Enterprise
  • Connector version0.5.32
  • Release stageAlpha

Sync capabilities

  • Full Refresh SyncSupported
  • Incremental SyncSupported
  • NamespacesNot supported
  • File transferSupported
  • Destinations50+ Airbyte connectors

Set up in 9 steps

  1. Go to the Airbyte dashboard and click on "Sources" on the left-hand side of the screen.
  2. Click on the "Create New Source" button and select "Google Drive" from the list of available connectors.
  3. Enter a name for your Google Drive source and click on "Next".
  4. You will be prompted to enter your Google Drive credentials. Click on "Add New Account" and enter your Google email address and password.
  5. Once you have entered your credentials, click on "Authorize" to allow Airbyte to access your Google Drive account.
  6. Select the folders or files you want to sync with Airbyte by clicking on the checkboxes next to them.
  7. Click on "Test" to ensure that your Google Drive source is working properly.
  8. If the test is successful, click on "Create Source" to save your Google Drive source in Airbyte.
  9. You can now use your Google Drive source to create data integrations and sync your data with other destinations.

Supported Google Drive actions

  • List

    Read live records straight from the Google Drive API.

  • Get

    Fetch a single record by ID.

  • Create

    Write a new record back into Google Drive.

  • Update

    Patch fields on an existing record.

  • Delete

    Remove a record.

  • Download

    Pull the binary contents of an attachment.

  • Context Store Search

    Query synced data with filters and sorting, with no API rate limits.

  • Semantic Search

    Natural-language search across synced Google Drive records.

Full parameter-level details live in the Google Drive entity reference.

Authenticate Google Drive once

    • Recommended

    Authenticate via Google (OAuth)

  • Service Account Key Authentication

What teams build with Google Drive

List all files in my Google Drive

Show me details for a recent file

Download a recent file from my Drive

Export a recent Google Doc as PDF

Export a recent Google Sheet as CSV

Show me the content of a recent file

List all shared drives I have access to

Show me details for a shared drive I have access to

Show permissions for a recent file

List comments on a recent file

Show replies to a recent comment on a file

Show revision history for a recent file

Get my Drive storage quota and user info

List files in a folder I have access to

Create a new file in Google Drive

Upload a document to Drive

Delete a file from Drive

Move a file to a different folder

Show me files modified in the last week

What changes have been made since my last sync?

Common questions

Didn't find your answer?
Please don't hesitate to reach out.

Talk to sales

No. One Google Drive authorization powers both the scheduled syncs that land data in your destination and the entity actions your agents call at runtime.

No. Entity actions read and write through the Google Drive API as they are called, so they work immediately. Context store search is the exception: it queries data Airbyte has already synced, which is what lets it filter and sort without spending API rate limits.

ETL, an acronym for Extract, Transform, Load, is a vital data integration process. It involves extracting data from diverse sources, transforming it into a usable format, and loading it into a database, data warehouse or data lake. This process enables meaningful data analysis, enhancing business intelligence.

1. File metadata: The API allows you to extract information about files stored in Google Drive, such as the file name, size, creation date, and modification date.
2. File content: You can extract the content of files stored in Google Drive, such as text, images, and videos.
3. File sharing information: The API allows you to extract information about who has access to a file, including their email addresses and permission levels.
4. User information: You can extract information about the users who have access to a file, such as their email addresses and profile pictures.
5. Folder structure: The API allows you to extract information about the folder structure of a user's Google Drive, including the names and IDs of folders.
6. Revision history: You can extract information about the revision history of a file, including the date and time of each revision and the user who made the revision.
7. Comments: The API allows you to extract information about comments made on a file, including the text of the comment, the user who made the comment, and the date and time of the comment.
8. Activity: You can extract information about the activity on a file, including when it was last viewed, edited, or shared.

1. Go to the Airbyte dashboard and click on "Sources" on the left-hand side of the screen.
2. Click on the "Create New Source" button and select "Google Drive" from the list of available connectors.
3. Enter a name for your Google Drive source and click on "Next".
4. You will be prompted to enter your Google Drive credentials. Click on "Add New Account" and enter your Google email address and password.
5. Once you have entered your credentials, click on "Authorize" to allow Airbyte to access your Google Drive account.
6. Select the folders or files you want to sync with Airbyte by clicking on the checkboxes next to them.
7. Click on "Test" to ensure that your Google Drive source is working properly.
8. If the test is successful, click on "Create Source" to save your Google Drive source in Airbyte.
9. You can now use your Google Drive source to create data integrations and sync your data with other destinations.

The most prominent ETL tools to transfer data to include: Airbyte, Fivetran, StitchData, Matillion, Talend Data Integration. These tools help in extracting data from various sources (APIs, databases, and more), transforming it efficiently, and loading it into and other databases, data warehouses and data lakes, enhancing data management capabilities.

ELT, standing for Extract, Load, Transform, is a modern take on the traditional ETL data integration process. In ELT, data is first extracted from various sources, loaded directly into a data warehouse, and then transformed. This approach enhances data processing speed, analytical flexibility and autonomy.

ETL and ELT are critical data integration strategies with key differences. ETL (Extract, Transform, Load) transforms data before loading, ideal for structured data. In contrast, ELT (Extract, Load, Transform) loads data before transformation, perfect for processing large, diverse data sets in modern data warehouses. ELT is becoming the new standard as it offers a lot more flexibility and autonomy to data analysts.

Start moving Google Drive data today

Free for 14 days on Airbyte Cloud. One connection powers your scheduled syncs and your live Google Drive actions.