Google Sheets, Google Drive Integrations

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


188
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.


60
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.


17
Create an Event Ticketing system with Google Sheets, Google Docs & Barcodes - Part 1

Create an Event Ticketing system with Google Sheets, Google Docs & Barcodes - Part 1

Every time a new row is added to your Google Sheets spreadsheet, Integromat will automatically create an event Ticket with a QR code and dynamic data. The template uses this example spreadsheet and this example ticket.


13
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.


8
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.


7
Create an Archive in CloudConvert with files imported from URLs stored in Google Sheets

Create an Archive in CloudConvert with files imported from URLs stored in Google Sheets

Get URLs of files in Google Sheets and create an archive with the files in CloudConvert. Upload the output archive to Google Drive.


4
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.


3
Create an Archive in CloudConvert using both upload & import URL methods

Create an Archive in CloudConvert using both upload & import URL methods

Create an Archive in CloudConvert with files imported from Google Drive and URLs stored in Google Sheets. Upload the output archive to Google Drive.


2

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

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

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