Google Sheets, Google Docs, 1CRM Integrations

Google Docs
Google Sheets
1CRM
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.

Google Docs

Watch Documents

Triggers when a new document is created or modified in a specific folder.

1CRM

New Event INSTANT

Triggers when a record is created or updated.

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

Delete a Sheet

Deletes a specific sheet.

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.

Google Docs

Create a Document

Creates a new Google document by adding the content of HTML format.

Google Docs

Create a Document from a Template

Creates a copy of an existing template document and replaces any tags e.g. {{!notfound:name}}, {{!notfound:email}}. This module also allows users to replace images by new images with URLs.

Google Docs

Delete a Document

Deletes a document.

Google Docs

Download a Document

Downloads a document to a required format.

Google Docs

Get Content of a Document

Gets a content of a document.

Google Docs

Insert an Image to a Document

Inserts a new image with URL to a document. The original size of the image is entered or the image is resized as required by the user. The original image ratio is maintained.

Google Docs

Insert a Paragraph to a Document

Inserts or appends a new paragraph to an existing document.

Google Docs

Make All Links in a Document Clickable

Makes all links in a document clickable.

Google Docs

Make an API Call

Performs an arbitrary authorized API call.

Google Docs

Replace an Image with a New Image

Replaces an existing image with a new image with URL in the document. In order to fill the original image's bounds, the new image may be scaled or cropped.

Google Docs

Replace a Text in a Document

Replaces an old text by a new text in a document.

1CRM

Create a Record

Creates a record.

1CRM

Delete a Record

Removes a record.

1CRM

Get a Record

Returns details about a selected record.

1CRM

Get My Info

Returns information about the authenticated user.

1CRM

Make an API Call

Performs an arbitrary authorized API call.

1CRM

Update a Record

Updates a record.

1CRM

Upload a File

Uploads a file.

Searches

Google Sheets

Get Range Values

Gets a range content.

Google Sheets

List Sheets

Gets a list of all sheets in a spreadsheet.

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.

Google Docs

List Documents

Retrieves a list of documents.

1CRM

List Fields

Returns all fields for a selected module.

1CRM

List Modules

Returns all modules.

1CRM

Search for Records

Searches for records.