Integrace Google Sheets, Google Drive, Help Scout

Google Sheets
Help Scout
Google Drive
Vyzkoušejte Integromat ZDARMA
Integromat je pro běžné použití zdarma.

Co je to Integromat?

GmailWatch emailsGoogle SheetsAdd a rowGmailIterate attachmentsRouterFacebookCreate a postArchiveCreate an archiveDropboxUpload a fileDocuments onlyImages onlyKdyž přijde nový emailPřidej řádek do sheetuZpracuj přílohyjednu po druhé ...Nahraj fotky na zeďZazipuj dokumentyNahraj archiv

Integromat automatizuje procesy, které děláte ručně. Propojuje aplikace, přenáší a transformuje data. To vše neustále 24 hodin denně, bez nutnosti Vašeho zásahu. Pouze nastavte, co má dělat a nechte ho pracovat za Vás. Šetřete svůj čas!

Spouštěče

Google Sheets

Perform a Function OKAMŽITÝ

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

Google Sheets

Watch Changes OKAMŽITÝ

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 Drive

Watch All Files

Triggers when a file is created of modified.

Google Drive

Watch Comments

Triggers when a comment is created or updated on a selected file.

Google Drive

Watch Files in a Folder

Triggers when a file is created or modified in a selected folder.

Google Drive

Watch Folders

Triggers when a new folder is created or modified.

Google Drive

Watch Shared Drives

Triggers when a new shared drive is created.

Help Scout

Watch Conversations OKAMŽITÝ

Triggers when one or more of the following events occur (Conversation Agent Reply Created, Conversation Assigned, Conversation Created, Conversation Customer Reply Created, Conversation Deleted, Conversation Merged, Conversation Moved, Conversation Note Created, Status Changed in Conversation, Tags Created, Edited, Removed, or Merged in Conversation).

Help Scout

Watch Customers OKAMŽITÝ

Triggers when a customer is created.

Help Scout

Watch Satisfaction Rating OKAMŽITÝ

Triggers when a satisfaction rating is received.

Akce

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 Drive

Copy a File

Makes a copy of an existing file.

Google Drive

Create a File from Text

Creates a file from a text plain.

Google Drive

Create a Folder

Creates a new folder.

Google Drive

Create a Shared Drive

Creates a new shared drive.

Google Drive

Delete a File/Folder

Permanently deletes a file or folder owned by the user without moving it to the trash. 

Google Drive

Delete a Shared Drive

Deletes a shared drive without any content.

Google Drive

Download a File

Downloads a file.

Google Drive

Get a Shared Drive

Gets a shared drive's metadata by ID.

Google Drive

Get a Share Link

Gets a share link for file or folder.

Google Drive

Make an API Call

Performs an arbitrary authorized API call.

Google Drive

Move a File/Folder

Moves a file or folder to a different location in Google Drive.

Google Drive

Move a File/Folder to Trash

Moves a file or folder to trash.

Google Drive

Update a File

Updates a file's metadata and/or content.

Google Drive

Update a Shared Drive

Updates an existing shared drive. For admins only.

Google Drive

Upload a File

Uploads a new file.

Help Scout

Create Conversation

Creates a conversation in a mailbox with at least one thread.

Help Scout

Create Customer

Creates a new customer.

Help Scout

Create Email

Creates a new email for an existing customer

Help Scout

Create Chat Handle

Creates a new chat handle for an existing customer.

Help Scout

Create or Update Address

Creates or updates an address for an existing customer.

Help Scout

Create Phone

Creates a new phone number for an existing customer.

Help Scout

Create Social Profile

Creates a new social profile for an existing customer.

Help Scout

Create Thread

Creates a new thread of chat, customer, note, phone, and reply.

Help Scout

Create Website

Creates a new website for an existing customer.

Help Scout

Delete Address

Deletes an address of a customer.

Help Scout

Delete Conversation

Deletes a conversation.

Help Scout

Delete Email

Deletes an email of a customer.

Help Scout

Delete Chat Handle

Deletes a chat handle of a customer.

Help Scout

Delete Phone

Deletes a phone number of a customer.

Help Scout

Delete Social Profile

Deletes a social profile of a customer.

Help Scout

Delete Website

Deletes a website of a customer.

Help Scout

Get Address

Gets the address of a customer with a given ID.

Help Scout

Get Conversation

Gets information about a conversation by ID.

Help Scout

Get Customer

Gets information about a mailbox by ID.

Help Scout

Get Mailbox

Gets information about a mailbox by ID.

Help Scout

Make an API Call

Performs an arbitrary authorized API call.

Help Scout

Update Conversation

Updates conversation data.

Help Scout

Update Customer

Updates customer data.

Help Scout

Update Email

Updates an email of a customer.

Help Scout

Update Chat Handle

Updates a chat handle of a customer.

Help Scout

Update Phone

Updates a phone number of a customer.

Help Scout

Update Social Profile

Updates a social profile of a customer.

Help Scout

Update Thread

Updates an existing thread.

Help Scout

Update Website

Updates a website of a customer.

Vyhledávače

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 Drive

Get a Folder ID for a Path

Retrieves a folder ID for a folder path.

Google Drive

Search for Files/Folders

Searches for files or folders based on search criteria.

Google Drive

Search for Shared Drives

Searches for Google Shared Drives with query options.

Help Scout

List Conversations

Lists and filters all conversations.

Help Scout

List Customers

Lists and filters all customers

Help Scout

List Emails

Gets a list of customer email addresses.

Help Scout

List Chat Handles

Gets a list of chat handles for a given customer.

Help Scout

List Mailboxes

Gets a list of the mailboxes.

Help Scout

List Mailbox Folders

Gets a list of mailbox folders.

Help Scout

List Tags

Gets a list of tags.

Help Scout

List Threads

Gets a list of threads.