Google Sheets Integrations

Google Sheets is an online spreadsheet app allowing you to create and format spreadsheets and work with others.

Create a new spreadsheet and edit with others at the same time - from your computer, phone or tablet
Create charts and graphs
Get stuff done with or without an internet connection
Work with Microsoft Excel files
iOS and Android apps available

Triggers

Actions

Select rows

Returns rows that match the criteria specified on a selected worksheet.

Add a worksheet

Delete a worksheet

Add a row

Update a row

Delete a row

Update a cell

Get a cell

Returns the contents of a specified cell.

Google Sheets integrations

Save new Google Tasks to a Google Sheets spreadsheet

Every time a new task is added to a specified Google Tasks List, Integromat will automatically add that task to a selected Google Sheets spreadsheet as a new row.

Add new incoming emails to a Google Sheet spreadsheet as new rows

Every time you receive a new email, Integromat will automatically insert selected data from the email to a new row in a Google Sheets spreadsheet.

Send Twilio SMS message to all recipients listed in a Google Sheets spreadsheet

Integromat will automatically send your predefined Twilio SMS message to all recipients listed in a Google Sheet spredsheet. Create a table according to this example and in the column Text enter whatever text you wish to use for the SMS message.

Update selected Google Sheets rows with Google Analytics visits to specific websites

Every time this scenario is run, Integromat will automatically update selected Google Sheets rows with Google Analytics data. This template monitors the number of visits to specified websites for last 7 and 365 days. It uses a spreadsheet created according to this example.

Add data from email alerts received from Fio banka to a Google Sheet spreadsheet as new rows

Every time you receive a new email from Fio banka providing information about your account as requested in Internetbanking, Integromat will automatically add selected data from the email to a new row in a Google Sheet spreadsheet. This template uses a table created according to this example .

Register new Paypal payments in the system of electronic sales registration, send received Fiscal identification codes to your customers via email and record your sales in a Google spreadsheet

Every time a new payment is received via PayPal, Integromat will automatically register the sale in the EET system. The received Fiscal identification code will then be sent via email to your customer and recorded in a Google spreadsheet. This template uses a spreadsheet created according to this example.

Save new WooCommerce orders to a Google Sheets spreadsheet

Every time a new order is created in WooCommerce, Integromat will automatically add it to a new row in a Google Sheet spreadsheet. The template uses a sheet created according to this example sheet.

E-mail, Raiffeisenbank and Google Sheets integration

This scenario will process your account statement which you receive from Raiffeisenbank via email. Each account movement will be inserted as a new data row to a selected Google Sheets Spreadsheet. You can modify the scenario as you like. You may set the scenario to record incoming payments directly to your company information system , database or an online shopping system.