Skip to main content

Make Waves ’26 Step into AI’s glass box. Prague, 19–20 Oct.

Register now (opens in a new tab)
Google Sheets
Google Drive

Connect Google Sheets and Google Drive integrations

Unlock the potential of Google Sheets & Google Drive: automate tasks, enhance collaboration, and increase efficiency with Make.

Get started free

Create a custom workflow

Revolutionize your workflow with Make by seamlessly integrating Google Sheets and Google Drive, automating updates, backups, and reports to keep your data organized and your productivity soaring.

Create a custom workflow

Every automation starts with a trigger and an action. Select one from each app to generate a workflow tailored to your needs.

Google Sheets
Trigger: Perform a Function
Google Drive
Action: Select an action
1. Select a trigger

  • Receives data from the MAKE_FUNCTION or INTEGROMAT functions used in a sheet. Please note, the Sheets Add-On is required.

  • Triggers when a cell is updated. Watches only changes made in Google Sheet app. Sheets Add-On required.

  • Triggers when a new row is added.

2. Select an action

  • Makes a copy of an existing file.

  • Creates a file from a text plain.

  • Creates a new file or folder shortcut.

  • Creates a new folder.

  • Creates a new shared drive.

  • Deletes a file's revision.

  • Permanently deletes a file or folder owned by the user without moving it to the trash. 

  • Deletes a shared drive without any content.

  • Downloads a file.

  • Gets a specified file's revision.

  • Retrieves a file or folder path for an ID.

  • Gets a share link for file or folder.

  • Gets a shared drive's metadata by ID.

  • This is the module to maintain/edit google-custom connection

  • Performs an arbitrary authorized API call.

  • Moves a file or folder to a different location in Google Drive.

  • Moves a file or folder to trash.

  • Renames an existing folder.

  • Revokes a file or folder access.

  • Updates a file's metadata and/or content.

  • Updates an existing file's revision.

  • Updates an exisitng file or folder access.

  • Updates an existing shared drive. For admins only.

  • Uploads a new file.

Select a trigger and an action

Create workflow (opens in a new tab)

Triggers and actions

Integrate Google Drive and Google Sheets using Make to revolutionize your workflow and productivity. Set up automatic transfers from Google Drive to Google Sheets, ensuring your files are always up-to-date and organized. By syncing your Google Drive directly with your documents in Google Sheets, you can automate backups and create a streamlined, error-free data management system. Use Google Drive as a trigger to update records or generate reports seamlessly in Google Sheets. Experience the transformative power of automation and see how effortlessly you can integrate Google Drive and Google Sheets to elevate your business operations.

Add a Conditional Format Rule
Creates a new conditional format rule at the given index. All subsequent rules' indexes are incremented.
Action
Add a Row
Appends a new row to the bottom of the table.
Action
Add a Sheet
Adds a new sheet.
Action
Bulk Add Rows (Advanced)
Appends multiple rows to the bottom of the table.
Action
Bulk Update Rows (Advanced)
Updates multiple rows.
Action
Clear a Cell
Clears a specific cell.
Action
Clear a Row
Clears values from a specific row.
Action
Clear Values from a Range
Clears a specified range of values from a spreadsheet.
Action
Copy a File
Makes a copy of an existing file.
Action
Load more

How to set up Google Sheets and Google Drive in 5 easy steps

Date

·

Duration

Step 1

Log in to Make

Start by logging into your Make account.

Date

·

Duration

Step 2

Connect Google Sheets

Add a Google Sheets module to your Make scenario and authenticate your Google account.

Date

·

Duration

Step 3

Connect Google Drive

Add a Google Drive module to your Make scenario and authenticate your Google account.

Date

·

Duration

Step 4

Grant Permissions

Follow the on-screen prompts to grant permissions for the Google services.

Date

·

Duration

Step 5

Edit Your Scenario

Once connected, you can customize your scenario by adding more Google Drive modules.

Enhance Efficiency and Collaboration by Integrating Google Sheets and Google Drive

By integrating Google Sheets and Google Drive, automate data collection, streamline document management, enhance team collaboration, boost workflow efficiency, and unlock advanced functionalities.

Date

·

Duration

Automated Data Collection

Automatically populate Google Sheets with data from files stored in Google Drive, enhancing data organization and accessibility.

Date

·

Duration

Streamlined Document Management

Easily save and organize attachments from Google Sheets entries into Google Drive for centralized storage and retrieval.

Date

·

Duration

Enhanced Collaboration

Facilitate team collaboration by synchronizing updates made on Google Sheets with files in Google Drive, ensuring everyone has access to the latest information.

Date

·

Duration

Increased Workflow Efficiency

Reduce repetitive tasks by automating processes such as saving email attachments directly to Google Drive and logging details in Google Sheets.

Popular Google Sheets and Google Drive workflows

Connect Google Sheets and Google Drive with Make. Automate manual tasks, sync real-time data, and build more efficient workflows.

App Families

Create Canva designs with data from Google Sheets and upload to Google Drive

Easily design in Canva using data from Google Sheets, then upload your creations to Google Drive. Boost your workflow with this integrated approach.

Create Canva designs with data from Google Sheets and upload to Google Drive
Use template
App Families

Create a post in Instagram for new Google sheets rows

Every time a new row is added to your Google Sheets spreadsheet, Make will automatically create a photo post to Instagram from a file from Google Drive. The template uses this example spreadsheet.

Create a post in Instagram for new Google sheets rows
Use template
App Families

Upload new videos to YouTube and LinkedIn automatically

Enhance your online presence by seamlessly uploading fresh video content to YouTube and LinkedIn. Engage audiences and boost visibility with automated uploads, ensuring your latest videos reach your followers promptly and effectively.

Upload new videos to YouTube and LinkedIn automatically
Use template
Load more

Support

FAQs

Everything you need to know about Make. Can't find the answer you're looking for? Please chat to our team.

By integrating Google Sheets with Make, you can connect it to hundreds of other applications such as Shopify, Discord, WooCommerce, Telegram Bot, MailChimp, and Facebook. This allows you to automate repetitive tasks, such as data entry, updating records, and sending notifications, improving your workflow efficiency and productivity.

Unfortunately, the description for integrating Google Drive with Make is not available, but generally, by integrating Google Drive, you can automate the management of your files. This could include actions such as syncing files across platforms, automatically sorting documents, sharing files, or backing up data, thereby simplifying file management and saving time.

Yes, integrating Google Sheets with Make provides unique features such as the ability to automate data transfer between Google Sheets and various apps like Shopify and WooCommerce. For instance, you can automate the update of inventory records, sales data, or customer information across different platforms without manual intervention, ensuring data consistency and accuracy.

Setting up integrations on Make is designed to be user-friendly. The platform offers various templates and a drag-and-drop interface to help you create workflows easily. Even if you're not tech-savvy, you can follow step-by-step guides and use pre-built scenarios to integrate and automate tasks with Google Sheets and Google Drive effortlessly.