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

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

Gmail

Watch emails

Triggers when a new email is received to be processed according to specified criteria.

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 .

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.

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

Gmail

Send an email

Sends a new email.

Gmail

Create a draft

Creates a new draft and adds it to a selected folder.

Gmail

Move an email

Moves a chosen email or a draft to a selected folder.

Gmail

Copy an email

Copies an email or a draft into a selected folder.

Gmail

Mark an email as read

Marks an email or a draft in a selected directory as read by setting the "Read" flag.

Gmail

Mark an email as unread

Marks an email or draft in a selected directory as unread by setting the "Unread" flag.

Gmail

Delete an email

Removes an email or a draft from a selected folder.

Gmail

Modify email labels

Modifies labels on the specified email message.

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.

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

Gmail

Iterate attachments

Iterates through received attachments.

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.

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