Google Sheets, Google Drive Integrations

Google Drive
Google Sheets
Try Integromat for FREE
No credit card. You'll love it.

What is Integromat?

GmailWatch emailsGoogle SheetsAdd a rowGmailIterate attachmentsRouterFacebookCreate a postArchiveCreate an archiveDropboxUpload a fileDocuments onlyImages onlyWhen new email arrivesAdd a row to a sheetProcess attachmentsone by one ...Post images to pageZip all documentsUpload archive

Integromat will automate processes that you currently handle manually. It is not only capable of connecting apps but can also transfer and transform data. It works 24 hours a day, seven days a week and does not require your intervention. Simply set Integromat to do what you want and let it work for you. Save your time!

Google Sheets, Google Drive integrations

Add new Google Calendar events to a Google Sheets spreadsheet as new rows and email it to a specified email address

Add new Google Calendar events to a Google Sheets spreadsheet as new rows and email it to a specified email address

Every time a new event is created in a Google calendar, Integromat will automatically add that event to your Google Sheets spreadsheet as a new row. The spreadsheet will be then sent to a specified email address. The template uses this example spreadsheet.


294
Get a Google Sheet spreadsheet with 15 days weather forecast via email

Get a Google Sheet spreadsheet with 15 days weather forecast via email

Integromat will automatically add 15 days weather forecast to a Google Sheets spreadsheet as new rows and send that spreadsheet to an email address you specify. The template uses this example spreadsheet.


105
Convert a File in CloudConvert using method import from URL and upload the files to Google Drive

Convert a File in CloudConvert using method import from URL and upload the files to Google Drive

Download files from URLs stored in Google Sheets and convert the files to a specified format. After the conversion, upload the files to Google Drive.


68
Create a post in Instagram for new Google sheets rows

Create a post in Instagram for new Google sheets rows

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


46
Add info and links of Zoom recordings to a Google Sheet and upload to Google Drive

Add info and links of Zoom recordings to a Google Sheet and upload to Google Drive

When a recording is completed on Zoom, this scenario instantly receives the details, adds the info and the recording's link to a Google Sheet and uploads the file to Google Drive. This template uses this Google Sheet example.


37
Save Gmail emails and attachments to Google Sheets and Google Drive

Save Gmail emails and attachments to Google Sheets and Google Drive

Use this template to save a Gmail message to your Google Sheets spreadsheet as a new row and its attachments to Google Drive.


35
Generate an HTML/CSS Invoice from new Google Sheets rows

Generate an HTML/CSS Invoice from new Google Sheets rows

Every time a new row is added to your Google Sheets spreadsheet, Integromat will automatically generate an invoice with HTML/CSS to Image and upload it to Google Drive. The template uses this example spreadsheet and the following HTML invoice model.


32
Capture a Website by CloudConvert and upload the output files to Google Drive

Capture a Website by CloudConvert and upload the output files to Google Drive

Get URLs of websites in Google Sheets and make captures of them in CloudConvert. Upload the output files to Google Drive.


19
Add a new record to Google Sheets about a new project in BeLazy and upload files to Google Drive

Add a new record to Google Sheets about a new project in BeLazy and upload files to Google Drive

When a new project is approved, data of the project are stored in a Google Sheets spreadsheet and the files are uploaded to Google Drive. If the file is bigger than 50MB, the e-mail with the notification about this issue is sent to Gmail.


15

Triggers

Google Sheets

Perform a Function INSTANT

Receives data passed to the function INTEGROMAT used in a sheet. Sheets Add-On required.

Google Sheets

Watch Changes INSTANT

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

Google Sheets

Watch Rows

Watches for new rows.

Google Drive

Watch All Files

Triggers when a file is created of modified.

Google Drive

Watch Comments

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

Google Drive

Watch Files in a Folder

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

Google Drive

Watch Folders

Triggers when a new folder is created or modified.

Google Drive

Watch Shared Drives

Triggers when a new shared drive is created.

Actions

Google Sheets

Add a Row

Appends a new row to the bottom of the table.

Google Sheets

Add a Sheet

Adds a new sheet.

Google Sheets

Clear a Cell

Cleares a specific cell.

Google Sheets

Clear a Row

Clears values from a specific row.

Google Sheets

Create a Spreadsheet

Creates a new spreadsheet.

Google Sheets

Delete a Row

Deletes a specific row.

Google Sheets

Delete a Sheet

Deletes a specific sheet.

Google Sheets

Get a Cell

Gets a specific cell.

Google Sheets

Make an API Call

Performs an arbitrary authorized API call.

Google Sheets

Perform a Function - Responder

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

Google Sheets

Update a Cell

Updates a specific cell.

Google Sheets

Update a Row

Updates a row.

Google Drive

Copy a File

Makes a copy of an existing file.

Google Drive

Create a File from Text

Creates a file from a text plain.

Google Drive

Create a Folder

Creates a new folder.

Google Drive

Create a Shared Drive

Creates a new shared drive.

Google Drive

Delete a File/Folder

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

Google Drive

Delete a Shared Drive

Deletes a shared drive without any content.

Google Drive

Download a File

Downloads a file.

Google Drive

Get a Shared Drive

Gets a shared drive's metadata by ID.

Google Drive

Get a Share Link

Gets a share link for file or folder.

Google Drive

Make an API Call

Performs an arbitrary authorized API call.

Google Drive

Move a File/Folder

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

Google Drive

Move a File/Folder to Trash

Moves a file or folder to trash.

Google Drive

Update a File

Updates a file's metadata and/or content.

Google Drive

Update a Shared Drive

Updates an existing shared drive. For admins only.

Google Drive

Upload a File

Uploads a new file.

Searches

Google Sheets

Get Range Values

Gets a range content.

Google Sheets

List Sheets

Gets a list of all sheets in a spreadsheet.

Google Sheets

Search Rows

Returns results matching the given criteria.

Google Sheets

Search Rows (Advanced)

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

Google Drive

Get a Folder ID for a Path

Retrieves a folder ID for a folder path.

Google Drive

Search for Files/Folders

Searches for files or folders based on search criteria.

Google Drive

Search for Shared Drives

Searches for Google Shared Drives with query options.

Integrate Google Sheets, Google Drive with these services