Connect Google Sheets and Google Drive integrations

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.

Trigger
Select a trigger...
Google Sheets

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

Google Sheets

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

Google Sheets

Triggers when a new row is added.

Google Sheets
Google Drive
Get started freeNo credit card requiredNo time limit on Free plan
Action
Select an action...
Google Drive

Makes a copy of an existing file.

Google Drive

Creates a new file or folder shortcut.

Google Drive

Creates a file from a text plain.

Google Drive

Creates a new folder.

Google Drive

Creates a new shared drive.

Google Drive

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

Google Drive

Deletes a file's revision.

Google Drive

Deletes a shared drive without any content.

Google Drive

Downloads a file.

Google Drive

Retrieves a file or folder path for an ID.

Google Drive

Gets a specified file's revision.

Google Drive

Gets a shared drive's metadata by ID.

Google Drive

Gets a share link for file or folder.

Google Drive

Performs an arbitrary authorized API call.

Google Drive

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

Google Drive

Moves a file or folder to trash.

Google Drive

Renames an existing folder.

Google Drive

Revokes a file or folder access.

Google Drive

Updates a file's metadata and/or content.

Google Drive

Updates an exisitng file or folder access.

Google Drive

Updates an existing file's revision.

Google Drive

Updates an existing shared drive. For admins only.

Google Drive

Uploads a new file.

Google Drive

Retrieves a folder ID for a folder path.

Google Drive

Retrieves a list of file's revisions.

Google Drive

Searches for files or folders based on search criteria.

Google Drive

Searches for Google Shared Drives with query options.

Trusted by thousands of fast-scaling organizations around the globe

Finn logoBamboo HR logoSpotify logoBNY logoBolt logoRoche logo

Automate your work. Build something new.

Just drag and drop apps to automate existing workflows or build new complex processes. Solve problems across all areas and teams.

greenhouse-facebook-twitter-linkedin-integration

Build your Google Sheets and Google Drive integrations.

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.

Google Sheets
Add a Conditional Format Rule

Creates a new conditional format rule at the given index. All subsequent rules' indexes are incremented.

Action
Google Sheets
Add a Row

Appends a new row to the bottom of the table.

Action
Google Sheets
Add a Sheet

Adds a new sheet.

Action
Google Sheets
Bulk Add Rows (Advanced)

Appends multiple rows to the bottom of the table.

Action
Google Sheets
Bulk Update Rows (Advanced)

Updates multiple rows.

Action
Google Sheets
Clear Values from a Range

Clears a specified range of values from a spreadsheet.

Action
Google Sheets
Clear a Cell

Clears a specific cell.

Action
Google Sheets
Clear a Row

Clears values from a specific row.

Action
Google Drive
Copy a File

Makes a copy of an existing file.

Action

Popular Google Sheets and Google Drive workflows.

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

How to setup Google Sheets and Google Drive in 5 easy steps

  • 1

    Log in to Make

    Start by logging into your Make account.

  • 2

    Connect Google Sheets

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

  • 3

    Connect Google Drive

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

  • 4

    Grant Permissions

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

  • 5

    Edit Your Scenario

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

  • Get started free

    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.

    Automated Data Collection

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

    Streamlined Document Management

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

    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.

    Increased Workflow Efficiency

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

    FAQ

    What benefits can I get from integrating Google Sheets with Make?
    How can I integrate Google Drive using Make?
    Are there any unique features I should know about when integrating Google Sheets with Make?
    Will it be difficult to set up these integrations on Make?
    What is a scenario?
    What is a module?

    How it works

    Traditional no-code iPaaS platforms are linear and non-intuitive. Make allows you to visually create, build, and automate without limits.

    image (48)

    Trusted by 500,000+ Makers

    "Make really helped us to scale our operations, take the friction out of our processes, reduce costs, and relieved our support team. It is difficult to not become a fan."

    Head of Operations at Teleclinic

    "Make drives unprecedented efficiency within our business in ways we never imagined. It’s having an extra employee (or 10) for a fraction of the cost."

    COO at Shop Accelerator Martech

    "The simplicity, flexibility and ability to build real complex automations without any knowledge of programming makes it the best thing since sliced bread."

    Product Owner at Smaily

    "True citizen development in the entire company. Make is present in every department, empowering the company to offer a unique customer experience."

    CTO & Co-founder at FINN