Google Sheets, Chatwork, sms77.io Integrations

Chatwork
Google Sheets
sms77.io
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.

Chatwork

Watch Events INSTANT

Watches account events or room events.

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

Make an API Call

Performs an arbitrary authorized API call.

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.

Chatwork

Approve a Contact Approval Request

Approves a contact approval requests.

Chatwork

Create a Groupchat

Creates a groupchat.

Chatwork

Create a Room Message

Sends a message to a room.

Chatwork

Create a Room Task

Creates a task in a room.

Chatwork

Decline a Contact Approval Request

Declines a contact approval request.

Chatwork

Delete or Leave a Groupchat

Deletes or leaves a groupchat.

Chatwork

Get a Room

Retrieves a room (groupchat room, direct message room or mychat room).

Chatwork

Get a Room's File

Retrieves a file from a room.

Chatwork

Get a Room's Message

Retrieve a message from a room.

Chatwork

Get a Room's Task

Retrieves a task from a room.

Chatwork

Make an API Call

Performs an arbitrary authorized API call.

Chatwork

Update a Groupchat

Updates a groupchat.

Chatwork

Update a Groupchat's Members

Updates the members of a room.

sms77.io

Create a Contact

Creates a new contact.

sms77.io

Delete a Contact

Deletes a contact.

sms77.io

Edit a Contact

Edit a contact with given ID. Please be aware of that at this point you need to set all values at once or they will be unset. Example: You have a contact named "Peter" with with phone number "01234567890". If you submit the action omitting the phone number, it will now be empty. This action cannot be undone, so be careful.

sms77.io

Get Balance

Returns the account balance for given API key.

sms77.io

Get Pricing

Retrieves the pricing information for a specific country or all.

sms77.io

Get SMS Status

Retrieves the status information for a single SMS message ID.

sms77.io

Lookup CNAM

Performs a Calling Name Delivery lookup.

sms77.io

Lookup Format

Query the national and international format of any mobile phone number. In addition, you will receive the corresponding network operator for the phone number as information (without porting information).

sms77.io

Lookup HLR

Performs a Home Location Register lookup.

sms77.io

Lookup MNP

Performs a Mobile Number Portability lookup.

sms77.io

Make an API Call

Performs an arbitrary authorized API call.

sms77.io

Make a Voice Call

Send a text to speech voice call to any number.

sms77.io

Send SMS

Sends one/mutiple SMS to one/mutiple user(s).

sms77.io

Validate for Voice

Validates caller IDs for our Voice API. Returns a code on successful validation. Simultaneously the given number receives a call from us where the recipient needs to enter the code via DTMF.

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.

Chatwork

List a Room's Files

Retrieves all the files of a room.

Chatwork

List a Room's Members

Retrieves all the members of a room.

Chatwork

List a Room's Messages

Retrieves all the messages of a room.

Chatwork

List a Room's Tasks

Retrieves all the tasks of a room.

Chatwork

List Contacts

Retrieves all your contacts.

Chatwork

List my Contact Approval Requests

Retrieves all contact approval requests you've received.

Chatwork

List my Tasks

Retrieves all your tasks.

Chatwork

List Rooms

Retrieves all your rooms (groupchat room, direct message room or mychat room).

sms77.io

Get Analytics

Get detailed statistics of your account.

sms77.io

List Contacts

Retrieves all contacts.