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

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

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

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

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.

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.

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.

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.

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