Google Sheets, PayPal, Intercom, CSV, AWS Redshift Integrations

AWS Redshift
CSV
Google Sheets
PayPal
Intercom
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.

PayPal

New notification INSTANT

Triggers when a new notification is received.

PayPal

Watch payments

Triggers when a new payment is made or a payment setting is changed.

PayPal

Watch plans

Triggers when a new plan is added.

PayPal

Watch transactions

Triggers when a new transaction related to a specified agreement is made .

Intercom

Watch Company INSTANT

Receives notification if company was created.

Intercom

Watch Conversations INSTANT

Receives notifications from conversation object.

Intercom

Watch Leads INSTANT

Receives notification from lead object.

Intercom

Watch Users INSTANT

Receives notifications from user object.

Intercom

Watch User Tags INSTANT

Receives notification from user tag object.

Transformers

CSV

Parse CSV

Parses a CSV file.

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.

PayPal

Create a plan

Creates and activates a billing plan.

PayPal

Activate a plan

Sets a billing plan to the ACTIVE state. Users will be able to subscribe it.

PayPal

Deactivate plan

Sets a billing plan to the INACTIVE state. Users will not be able to subscribe to it.

PayPal

Delete a plan

Permanently removes a billing plan.

PayPal

Get plans

Gets information about billing plans in a specified state.

PayPal

Create an agreement (Step 1)

Creates a subcription agreement and returns an approval url link to obtain buyer's approval.

PayPal

Execute an agreement (Step 2)

Executes a subscription agreement approved by a buyer after Step 1.

PayPal

Suspend an agreement

Suspends an agreement previously approved by a user.

PayPal

Reactivate an agreement

Reactivates a previously suspended agreement.

PayPal

Cancel agreement

Cancels an agreement previously approved by a user.

PayPal

Get agreement transactions

Returns all transactions related to a specific agreement.

PayPal

Set outstanding agreement amounts

Sets an outstanding agreement amount.

PayPal

Get subscription agreement details

Returns subscription agreement details.

PayPal

Create a payment (Step 1)

Creates a new payment order and returns an approval url link to obtain buyer's approval.

PayPal

Execute a payment (Step 2)

Executes a payment approved by a buyer after Step 1.

PayPal

Bill outstanding amount

Bills an outstanding or a preset amount of an agreement.

PayPal

Get billing plan details

Gets details about a specific billing plan.

Intercom

Add to Group Conversation as Admin

Adds a customer to group conversation.

Intercom

Add to Group Conversation as Customer

Adds a customer to group conversation.

Intercom

Admin Initiated Conversation

Sends message or email to admin.

Intercom

Close a Conversation

Closes a conversation with or without reply.

Intercom

Convert a Lead to User

If the User exists, then the Lead will be merged into it, the Lead deleted and the User returned. If the User does not exist, the Lead will be converted to a User, with the User identifiers replacing it's Lead identifiers.

Intercom

Create a Note

Creates a note for a specific user.

Intercom

Create or Update Company

Creates or updates a company using Intercom fields including your custom fields. NOTE: Companies will be only visible in Intercom when there is at least one associated user.

Intercom

Create or Update Tag

Creates or updates a tag. Tag names are case insensitive.

Intercom

Create User or Lead

Creates new user or lead using Intercom fields including your custom fields.

Intercom

Delete Customer from Group Conversation

Deletes a customer from specific conversation.

Intercom

Delete Tag

Deletes a specific tag.

Intercom

Delete User or Lead

Deletes either user or lead.

Intercom

Mark a Conversation as Read

Marks conversation within Intercom as read.

Intercom

Reply to Conversation

Replies to a specific conversation.

Intercom

Reply to Users Last Conversation

Replies to last conversation you had with specific user.

Intercom

Snooze a Conversation

Snoozes a conversation until selected time.

Intercom

Tag or Untag Contacts

Tags or untags users, leads or companies.

Intercom

Unassign Conversation

Assigns a conversation to be unassigned when admin replies to a conversation.

Intercom

Unsnooze a Conversation

Sets conversation back to open.

Intercom

Update User or Lead

Updates an existing user or lead.

Intercom

User or Lead Initiated Conversation

Creates a new user or lead initiated message.

Intercom

View Admin

Views a specific admin.

Intercom

View a Single Conversation

Shows information about a single message from conversation.

Intercom

View Company

Views specific company.

Intercom

View Note

Views specific note for specific user.

Intercom

View Segment

Views specific segment for user or company.

Intercom

View User or Lead

Views either user or lead.

AWS Redshift

Delete Records

Delete records based on SQL WHERE query

AWS Redshift

Get Records

Retrieve records based on SQL WHERE query

AWS Redshift

Insert Record

Insert a new record in Redshift

AWS Redshift

Update Records

Update records based on SQL WHERE query

Aggregators

CSV

Create CSV

Merges selected text items and returns them in the CSV format.

CSV

Create CSV (advanced)

Merges selected text items and returns them in the CSV format. Employs Data structure to define CSV columns in the resulting CSV file.

Iterators

PayPal

Retrieve payment definitions

Enables to process each payment definition for a billing plan separately.

PayPal

Retrieve transactions

Enables to process transactions one at a time.

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.

Intercom

List Admins

Lists all admins on your Intercom.

Intercom

List Companies

Fetches a list of companies. NOTE: Companies will be only visible in Intercom when there is at least one associated user.

Intercom

List Company Users

Lists users belonging to the company.

Intercom

List Conversations

Lists all conversations on your Intercom.

Intercom

List Notes

Lists notes for users.

Intercom

List Segments

Lists all segments on your Intercom.

Intercom

List Tags

List all tags on your Intercom.

Intercom

List Users or Leads

List either users or leads.

Integrate Google Sheets, PayPal, Intercom, CSV, AWS Redshift with these services