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 Drive
Google Sheets

Connect Google Drive and Google Sheets integrations

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.

Get started free

Create a custom workflow

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!

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 Drive
Trigger: Watch All Files
Google Sheets
Action: Select an action
1. Select a trigger

  • Triggers when a file is created or modified.

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

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

  • Triggers when a new folder is created or modified.

  • Triggers when a new shared drive is created.

2. Select an action

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

  • Appends a new row to the bottom of the table.

  • Adds a new sheet.

  • Appends multiple rows to the bottom of the table.

  • Updates multiple rows.

  • Clears a specific cell.

  • Clears values from a specific row.

  • Clears a specified range of values from a spreadsheet.

  • Copies a sheet to another spreadsheet.

  • Creates a new spreadsheet.

  • Creates a new spreadsheet from a template sheet.

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

  • Deletes a specific row.

  • Deletes a specific sheet.

  • Gets a specific cell.

  • Performs an arbitrary authorized API call.

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

  • Renames a specific sheet.

  • Updates a specific cell.

  • Updates a row.

Select a trigger and an action

Create workflow (opens in a new tab)

Triggers and actions

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!

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 Drive and Google Sheets in 5 easy steps

Date

·

Duration

Step 1

Login to Your Make Account

Start by logging into your Make platform account.

Date

·

Duration

Step 2

Add Google Drive Module

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

Date

·

Duration

Step 3

Create Google Drive Connection

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

Date

·

Duration

Step 4

Add Google Sheets Module

Add the Google Sheets module to your workflow next.

Date

·

Duration

Step 5

Create Google Sheets Connection

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

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.

Date

·

Duration

Automated Data Entry

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

Date

·

Duration

Centralized File Management

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

Date

·

Duration

Workflow Optimization

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

Date

·

Duration

Seamless Event Tracking

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

Popular Google Drive and Google Sheets workflows

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

Integrating Google Drive with Make allows you to automate file management tasks such as organizing, updating, and sharing documents. This integration can save time by automatically syncing files, creating backups, and streamlining collaboration across your team, improving overall workflow efficiency.

Using Google Sheets with Make enables you to automate data collection, analysis, and reporting by connecting it with other applications like Shopify, Discord, and WooCommerce. This can help you manage sales data, track inventory, and update customer information without manual input, thus enhancing accuracy and saving time.

With Make, you can set up automated workflows (called 'scenarios') that connect Google Sheets to hundreds of apps like Telegram Bot, MailChimp, and Facebook. This lets you automate complex processes such as sending automatic notifications, updating marketing campaign data, and syncing contact lists, all triggered by changes in your Google Sheets.

Make offers a user-friendly interface that enables even non-technical users to set up integrations with ease. It provides pre-built templates and a drag-and-drop feature for building scenarios, making it simple to connect Google Drive and Google Sheets to other applications without any coding knowledge.