Google Sheets, Prospero, Chatforma Integrations

What is Integromat?

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

Perform a Function INSTANT

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

Watch Changes INSTANT

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

Watch Rows

Watches for new rows.

Watch Declined Proposals INSTANT

Triggers when a proposal is declined

Watch Downloaded Proposals INSTANT

Triggers when a proposal is downloaded

Watch Opened Proposals INSTANT

Triggers when a proposal is opened

Watch Proposals

Trigger for all proposals.

Watch Published Proposals INSTANT

Triggers when a proposal is published

Watch Signed Proposals INSTANT

Triggers when a proposal is signed

Watch New User Input INSTANT

Triggers when new user input is found.

Actions

Add a Row

Appends a new row to the bottom of the table.

Add a Sheet

Adds a new sheet.

Clear a Cell

Cleares a specific cell.

Clear a Row

Clears values from a specific row.

Copy a Sheet

Copies a sheet to another spreadsheet.

Create a Spreadsheet

Creates a new spreadsheet.

Create a Spreadsheet from a Template

Creates a new spreadsheet from a template sheet.

Delete a Row

Deletes a specific row.

Delete a Sheet

Deletes a specific sheet.

Get a Cell

Gets a specific cell.

Make an API Call

Performs an arbitrary authorized API call.

Perform a Function - Responder

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

Update a Cell

Updates a specific cell.

Update a Row

Updates a row.

Create a Proposal

Creates a new draft or published proposal

Add a User to a Segment

Adds a specified user to a segment.

Delete a User from a Segment

Deletes a specified user from a segment.

Make an API Call

Performs an arbitrary authorized API call.

Send a Message to a Dialog

Sends a message to a dialog.

Send a Message to a Specific User

Sends a broadcast for a specified user.

Send a Message to a User Segment

Sends a broadcast to specified users segment.

Send a Specified Message

Sends a message or form by ID for a specified user.

Searches

Get Range Values

Gets a range content.

List Sheets

Gets a list of all sheets in a spreadsheet.

Search Rows

Returns results matching the given criteria.

Search Rows (Advanced)

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

List Bots

Gets a list of all bots.

List Dialogs Users

Gets users with opened dialogs.

List Forms

Gets a list all forms in specified bot.

List Messages

Gets a list messages in specified bot

List Segments

Gets a list of all users segments for a specified bot.

List User Messages

Gets a list of user messages in a dialog.

List Users

Lists a bot's users.