Connect Google Drive and Google Sheets integrations

Effortlessly automate your workflow by integrating Google Drive as a trigger and Google Sheets as an action with Make, allowing you to automatically update and organize data with just a few clicks. Revolutionize your daily tasks today!

Trigger
Select a trigger...
Google Drive

Triggers when a file is created of modified.

Google Drive

Triggers when a comment is created or updated on a selected file.

Google Drive

Triggers when a file is created or modified in a selected folder.

Google Drive

Triggers when a new folder is created or modified.

Google Drive

Triggers when a new shared drive is created.

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

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

Google Sheets

Appends a new row to the bottom of the table.

Google Sheets

Adds a new sheet.

Google Sheets

Appends multiple rows to the bottom of the table.

Google Sheets

Updates multiple rows.

Google Sheets

Clears a specific cell.

Google Sheets

Clears values from a specific row.

Google Sheets

Clears a specified range of values from a spreadsheet.

Google Sheets

Copies a sheet to another spreadsheet.

Google Sheets

Creates a new spreadsheet.

Google Sheets

Creates a new spreadsheet from a template sheet.

Google Sheets

Deletes a conditional format rule at the given index. All subsequent rules' indexes are decremented.

Google Sheets

Deletes a specific row.

Google Sheets

Deletes a specific sheet.

Google Sheets

Gets a specific cell.

Google Sheets

Performs an arbitrary authorized API call.

Google Sheets

Returns processed data as a result of the MAKE_FUNCTION or INTEGROMAT function. Sheets Add-On required.

Google Sheets

Renames a specific sheet.

Google Sheets

Updates a specific cell.

Google Sheets

Updates a row.

Google Sheets

Returns a sheet’s content defined by range values.

Google Sheets

Gets a list of all sheets in a spreadsheet.

Google Sheets

Returns results matching the given criteria.

Google Sheets

Returns results matching the given criteria. This module doesn't return a row number.

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 Drive and Google Sheets integrations.

Unlock seamless automation with Make by integrating Google Sheets as a trigger and Google Drive as an action. Imagine automatically updating your Google Drive with the latest files from Google Sheets or ensuring that every time a new file is added to Google Sheets, the relevant data is extracted and organized in Google Drive. With Make, these tasks can be set up in just a few clicks. Experience the simplicity and efficiency of automating your daily tasks by leveraging the full potential of these applications. Try Make today and revolutionize your workflow by integrating Google Sheets and Google Drive!

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 Drive and Google Sheets workflows.

Discover how to automate and optimize your workflows with Google Drive and Google Sheets. Learn more about centralized file management, automated data entry, and seamless event tracking.

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

  • 1

    Login to Your Make Account

    Start by logging into your Make platform account.

  • 2

    Add Google Drive Module

    Add the Google Drive module to your workflow to get started.

  • 3

    Create Google Drive Connection

    Click 'Create a connection' and sign in with your Google account to link Google Drive.

  • 4

    Add Google Sheets Module

    Add the Google Sheets module to your workflow next.

  • 5

    Create Google Sheets Connection

    Click 'Create a connection' and sign in with your Google account to link Google Sheets.

  • Get started free

    Unlock Effortless Efficiency: Integrate Google Drive and Google Sheets

    Enhance productivity by integrating Google Drive and Google Sheets. Automate data entry, centralized file management, optimize workflows, track events seamlessly, and improve data handling.

    Automated Data Entry

    Automatically add data from various sources into Google Sheets for streamlined record-keeping.

    Centralized File Management

    Store and organize your Google Sheets attachments directly in Google Drive for easy access and management.

    Workflow Optimization

    Enhance your workflows by automating repetitive tasks like saving Gmail attachments and updating spreadsheets.

    Seamless Event Tracking

    Track and log events from Google Calendar into Google Sheets with automated email notifications.

    FAQ

    What are the benefits of integrating Google Drive with Make?
    How can integrating Google Sheets with Make improve my business processes?
    What unique features do I get by connecting Google Sheets to other apps using Make?
    Is it difficult to set up these integrations on Make, especially if I'm not tech-savvy?
    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