Google Sheets, ImgBB, Marketo, Office 365 People, Elasticsearch Integrations

Elasticsearch
Google Sheets
ImgBB
Marketo
Office 365 People
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.

Office 365 People

Watch contacts

Triggers when a new contact 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

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.

ImgBB

Upload photo

Uploads a photo

Marketo

Add Leads to List

Adds a given set of person records to a target static list. There is a limit of 300 lead ids per request. Required Permissions: Read-Write Lead

Marketo

Associate Cookie to Lead

Associates a known Marketo lead record to a munchkin cookie and its associated web activity history. Required Permissions: Read-Write Lead

Marketo

Schedule Campaign

Remotely schedules a batch campaign to run at a given time. My tokens local to the campaign's parent program can be overridden for the run to customize content. When using the "cloneToProgramName" parameter described below, this endpoint is limited to 20 calls per day. Required Permissions: Execute Campaign

Marketo

Trigger Campaign

Passes a set of leads to a trigger campaign to run through the campaign's flow. The designated campaign must have a Campaign is Requested: Web Service API trigger, and must be active. My tokens local to the campaign's parent program can be overridden for the run to customize content. A maximum of 100 leads are allowed per call. Required Permissions: Execute Campaign

Office 365 People

Create a contact

Creates a new contact.

Office 365 People

Update a contact

Updates a contact

Office 365 People

Delete a contact

Deletes a contact.

Elasticsearch

Query

Executes a query.

Elasticsearch

Query with Basic Auth

Executes a query against server secured with Basic Auth.

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.

Marketo

Describe Lead Object

Returns metadata about lead objects in the target instance, including a list of all fields available for interaction via the APIs.

Marketo

Get Static Lists

Returns a set of static list records based on given filter parameters. Required Permissions: Read-Only Lead, Read-Write Lead

Marketo

Is Member of Static List

Checks if leads are members of a given static list. Required Permissions: Read-Write Lead

Marketo

Search Campaigns

Returns a list of campaign records. Required Permissions: Read-Only Campaigns, Read-Write Campaigns

Marketo

Search Leads by Filter

Returns a list of up to 300 leads based on a list of values in a particular field. Required Permissions: Read-Only Lead, Read-Write Lead

Marketo

Search Leads by Program

Retrieves a list of leads which are members of the designated program. Required Permissions: Read-Only Lead, Read-Write Lead

Marketo

Search Leads by Static List

Retrieves person records which are members of the given static list. Required Permissions: Read-Only Lead, Read-Write Lead

Office 365 People

Search for contacts

Searches for contacts that match a specified text.

Integrate Google Sheets, ImgBB, Marketo, Office 365 People, Elasticsearch with these services