Google Sheets, Survey123, SmartEmailing, Komerční banka, Xero, Copper Integrations

Google Sheets
Komerční banka
Copper
SmartEmailing
Survey123
Xero
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!

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.

Survey123

Watch survey INSTANT

Triggers when a survey response is submitted.

Xero

Watch receipts

Triggers when a new receipt is added or an existing receipt is updated.

Xero

Watch invoices

Triggers when a new invoice is added or an existing invoice is updated.

Xero

Watch credit notes

Triggers when a new credit note is added or an existing credit note is updated.

Xero

Watch bank transactions

Triggers when a new transaction is added or an existing transaction is updated.

Xero

Watch bank transfers

Triggers when a new bank transfer is created.

Xero

Watch employees

Triggers when a new employee is added or an existing employee is updated.

Xero

Watch purchase orders

Triggers when a new order is added or an existing order is updated.

Xero

Watch contacts

Triggers when a contact is created or updated.

Xero

Watch payments

Triggers when a payment is created or updated.

Copper

Listen for Company Events INSTANT

Receives notifications about company creation/deletion/update.

Copper

Listen for Lead Events INSTANT

Receives notifications about lead creation/deletion/update.

Copper

Listen for Opportunity Events INSTANT

Receives notifications about opportunity creation/deletion/update.

Copper

Listen for Person Events INSTANT

Receives notifications about person creation/deletion/update.

Copper

Listen for Project Events INSTANT

Receives notifications about project creation/deletion/update.

Copper

Listen for Task Events INSTANT

Receives notifications about task creation/deletion/update.

Transformers

Komerční banka

Parser of account balance emails

Processes the text of an email message with account balance information and gets data that can be further used.

Komerční banka

Parser of transaction email alerts

Processes the text of an email with information about account transactions and gets data that can be further used.

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

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.

Survey123

Create feature report

Create feature report from custom template.

SmartEmailing

Create or Update Contact

You can create or update existing contact

SmartEmailing

Get Campaign Sent Stats

Returns sent stats for newsletters

SmartEmailing

Unsubscribe Contact

Unsubscribes contact from selected contact lists.

Xero

Create a receipt

Creates a new receipt.

Xero

Get a receipt

Returns information about a receipt with a given ID.

Xero

Create an invoice

Creates a new invoice.

Xero

Get an invoice

Returns information about an invoice with a given ID.

Xero

Create a credit note

Creates a new credit note.

Xero

Get a credit note

Returns information about a credit note with a specified ID.

Xero

Create a bank transaction

Creates a new bank transaction.

Xero

Get a bank transaction

Returns information about a transaction with a specified ID.

Xero

Create a bank transfer

Transfers a specified amount from one account to another.

Xero

Create an employee

Creates a new employee.

Xero

Create a purchase order

Creates a new purchase order.

Xero

Get a purchase order

Returns information about a purchase order with a specified ID.

Xero

Create a contact

Creates a new contact.

Xero

Update a contact

Updates a contact by ID.

Xero

Archive a contact

Archives a contact with a given ID.

Xero

Create a contact group

Creates a new contact group.

Xero

Add a contact to a contact group

Adds a contact to a specified contact group.

Xero

Remove a contact from a contact group

Removes a contact from a contact group.

Xero

Delete a contact group

Deletes a contact group with a specified ID.

Xero

Create a history note

Adds a note to a record.

Xero

Create an item

Creates a new item.

Xero

Get a contact

Retrieves contact information by ID.

Xero

Get an account

Returns information about an acccount with a specified ID.

Xero

Get an invoice URL

Retrieves Xero online invoice URL.

Xero

Get an item

Searches for an item by item ID or item code.

Xero

Get a payment

Retrieves information about a payment with a specified ID.

Xero

Get bank statements report

Returns bank statements for a selected bank account.

Xero

Get bank summary

Returns the balances and cash movements for each bank account.

Xero

Get history of changes

Retrieves the changes made to a given object.

Xero

Search for a contact

Searches for a contact by name or email.

Xero

Search for an account

Finds an account by ID, name, or code.

Xero

Search for an invoice

Searches for an invoice

Xero

Search for a tax rate

Finds a tax rate by name.

Xero

Send an invoice via email

The email will be sent to the primary email address of the contact on the invoice. The invoice must be of Type ACCREC and a valid Status for sending (SUMBITTED,AUTHORISED or PAID).

Xero

Update an employee

Updates an employee by ID.

Xero

Update an invoice

Updates an invoice with a given ID.

Xero

Update an item

Updates an item by ID.

Xero

Update a payment

Use this method to apply payments to approved AR and AP invoices or refund AR or AP credit notes.

Xero

Upload a file

Uploads a file to an invoice, receipt, contact or another item.

Copper

Convert Lead

Converts a selected lead to a person in the system (optionally assigns company and opportunity).

Copper

Create Activity

Creates a new activity.

Copper

Create Company

Creates a new company.

Copper

Create Lead

Creates a new lead.

Copper

Create Opportunity

Creates a new opportunity.

Copper

Create Person

Creates a new person.

Copper

Create Project

Creates a new project.

Copper

Create Task

Creates a new task.

Copper

Get Activity

Gets details for a selected activity ID.

Copper

Get Company

Gets details for a selected company ID.

Copper

Get Lead

Gets details for a selected lead ID.

Copper

Get Opportunity

Gets details for a selected opportunity ID.

Copper

Get Person

Gets details for a selected person ID.

Copper

Get Project

Gets details for a selected project ID.

Copper

Get Task

Gets details for a selected task ID.

Copper

Get User

Gets details for a selected user ID.

Copper

Relate Opportunity to Person

Relates an existing opportunity to an existing person in the system.

Copper

Remove Activity

Removes the activity with a given ID.

Copper

Remove Company

Removes the company with a given ID.

Copper

Remove Lead

Removes the lead with a given ID.

Copper

Remove Opportunity

Removes the opportunity with a given ID.

Copper

Remove Opportunity from Person

Removes a related opportunity from a person.

Copper

Remove Person

Removes the person with a selected ID.

Copper

Remove Project

Removes the project with a selected ID.

Copper

Remove Task

Removes the task with a selected ID.

Copper

Remove Webhook Subscription

Removes the webhook subscription with a selected ID.

Copper

Update Company

Updates a selected company.

Copper

Update Lead

Updates a selected lead.

Copper

Update Opportunity

Updates a selected opportunity.

Copper

Update Person

Updates a selected person.

Copper

Update Project

Updates a selected project.

Copper

Update Task

Updates a selected task.

Searches

Google Sheets

Get Range Values

Gets a range content.

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.

Copper

List Activities

Lists all activities related to a connected account.

Copper

List Companies

Lists all companies related to a connected account.

Copper

List Company's Activities

Lists all activities for a selected company.

Copper

List Leads

Lists all leads related to a connected account.

Copper

List Lead's Activities

Lists all activities related to a connected account.

Copper

List Opportunities

Lists all opportunities related to a connected account.

Copper

List People

Lists all people related to a connected account.

Copper

List Person's Activities

Lists all activities of a selected person.

Copper

List Projects

Lists all projects related to a connected account.

Copper

List Tasks

Lists all tasks related to a connected account.

Copper

List Users

Lists all users related to a connected account.

Copper

View Opportunities Related to Person

Shows all opportunities related to the person with a selected ID.

Copper

View Records Related to Person

Shows all records related to the person with a selected ID.