Connect Google Sheets with Google Drive

Connect Google Sheets with Google Drive to scale and automate your operations.

Explore automation templates

Automate Google Sheets and Google Drive
with Pluga integrations

Trusted by over 10.000 amazing companies

Google Sheets and Google Drive
your way

Check out the available triggers and actions in the automation of apps Google Sheets + Google Drive

Trigger
Google Sheets

New added row

When a new row is added on Google Sheets

Line No.

Trigger
Google Sheets

For each row created/updated

For each row created or updated in Google Sheets

Nº da linha

Trigger
Google Drive

New file

With each new file in Google Drive

ID of the file.

Name of the file.

Public URL (link) to the file

File creation date and time (ISO format)

File creation date and time (format: DD/MM/YYYY HH:mm )

File creation date (format: DD/MM/YYYY)

File creation time (format: HH:mm )

File size in bytes

Short description of the file.

ID of the shared drive the file resides in. Only populated for items in shared drives.

Final component of the fullFileExtension (Available only for binary content files)

Full file extension (Available only for binary content files)

Link to open the file in an editor or viewer

Action
Google Sheets

Insert row in spreadsheet

add data to a new row on a Google Sheets spreadsheet

Columns

Action
Google Sheets

Insert/update row in spreadsheet

add or update data in Google Sheets spreadsheet's row(s)

Action
Google Drive

Move file

Move file on Google Drive

File ID Required

Destination folder selection mode Required

Destination folder

Destination folder (dynamic ID)

Action
Google Sheets

Insert multiple rows in spreadsheet (only for multiple items)

add the data to multiple rows in a Google Sheets spreadsheet

Action
Google Drive

Upload a file

send a file to Google Drive

File link (URL) Required

File name

Premium Action
Google Sheets

Search rows in a spreadsheet

Search rows in a spreadsheet in Google Sheets

Search Column Required

Condition

Search value

Additional filters

Result limit

No rows found?

Action
Google Drive

Create folder

Create folder in Google Drive

Folder name Required

How to integrate Google Sheets and Google Drive on Pluga

Boost this flow in your workflow

With Pluga, you connect Google Sheets + Google Drive to build anything from the simplest integration to the most advanced flows, with several layers of logic.

  • Basic 1

    Pick the source app and the trigger

    Choose which app starts the automation and which event works as the trigger. For example, "With each new file in Google Drive".

  • Basic 2

    Set the destinations and the actions

    Select the apps that make up the flow with Google Sheets and what Pluga should run automatically at each step. Example: "add data to a new row on a Google Sheets spreadsheet"

  • Basic 3

    Map the information

    Point out, visually, which data from the source app should fill in each field of the destination action.

  • Intermediate

    Only move forward when it makes sense

    Set "AND" or "OR" conditions so the automation only runs in the cases that matter

  • Intermediate

    Pause the flow for as long as you need

    Set the automation to wait minutes, hours or days and resume the next action on its own

  • Intermediate

    Standardize data across apps

    Adjust dates, numbers and characters to the format the next app expects to receive

  • Advanced

    Send data in several directions

    Route each piece of data down the right path within a single flow, according to specific conditions

  • Advanced

    Add a code block

    Run JavaScript or Python in the middle of the automation to transform data before the next step

  • Advanced

    Create loops

    Take lists of items, go through each row and run the same action for every one of them

  • Advanced

    Use generative AI

    Send data to an AI assistant or agent and use the response in the next step

  • Advanced

    Connect to (almost) any app

    Send and receive data through a dedicated URL, and connect to apps that are not integrated with Pluga

  • Advanced

    Requests to external APIs

    Query or send data to any external API inside your automation

Google Sheets

Google Sheets

Spreadsheet

Connect Google Sheets to 133+ apps with Pluga and turn your work into a productive machine. Centralize data from several apps in a single spreadsheet, keep your reports updated in real time and use the spreadsheet as a bridge between the apps you already work with.

Google Drive

Google Drive

Google

Connect Google Drive to 133+ apps with Pluga and turn your work into a productive machine. Connect Google’s tools to the other apps you work with: sync data between them and automate everyday tasks without switching tabs all day.

Frequently Asked Questions

  • By automating Google Sheets with Google Drive on Pluga, you can automate various manual tasks that reduce productivity for those who perform them, while also avoiding human errors. The best part is that the process is simple and doesn’t require typing a single line of code.

  • On Pluga, you can make several automations for free with the free plan. Additionally, you have the option to try all the features for 7 days at no cost to create automations between Google Sheets, Google Drive, and even other apps.

    We also offer three other plans, with prices ranging from $17 to $71 per month, which include premium automations and features, as well as a higher volume of events and automations. For companies with specific needs, we have the Enterprise plan, designed to offer customized solutions beyond the resources available in other plans.

    Check Pluga's pricing page for more details.