Google Sheets, CommCare, OfficeRnD Integrations

CommCare
Google Sheets
OfficeRnD
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.

CommCare

Watch New Case INSTANT

Triggers when a new case is created.

CommCare

Watch New Form Submission INSTANT

Triggers when a new form is submitted.

CommCare

Watch New or Updated Case INSTANT

Triggers when a new case is created or an existing case is modified.

CommCare

Watch Updated Case INSTANT

Triggers when an existing case is modified.

OfficeRnD

Watch Contracts

Triggers when a new contract is added.

OfficeRnD

Watch Members

Triggers when a new member is added.

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.

CommCare

Make an API Call

Performs an arbitrary authorized API call.

OfficeRnD

Create a Booking

Creates a booking.

OfficeRnD

Create a Fee

Creates a fee.

OfficeRnD

Create a Member

Creates a member.

OfficeRnD

Create a Membership

Creates a membership.

OfficeRnD

Create an Event

Creates an event.

OfficeRnD

Create a Post

Creates a new post.

OfficeRnD

Delete a Booking

Deletes a booking.

OfficeRnD

Delete a Fee

Deletes a fee.

OfficeRnD

Delete a Member

Deletes a member.

OfficeRnD

Delete a Membership

Deletes a membership.

OfficeRnD

Delete an Event

Deletes an event.

OfficeRnD

Get a Booking

Retrieves a booking by ID.

OfficeRnD

Get a Fee

Retrieves an individual fee object.

OfficeRnD

Get a Member

Retrieves an individual member.

OfficeRnD

Get a Membership

Retrieves individual membership.

OfficeRnD

Get an Event

Gets a single event by eventId.

OfficeRnD

Get a Post

Gets a single post by postId.

OfficeRnD

Make an API Call

Performs an arbitrary authorized API call.

OfficeRnD

Update a Booking

Updates a booking.

OfficeRnD

Update a Fee

Updates a fee.

OfficeRnD

Update a Member

Updates a member.

OfficeRnD

Update a Membership

Updates a Membership.

OfficeRnD

Update an Event

Updates an event.

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.

OfficeRnD

List Bookings

Retrieves all bookings.

OfficeRnD

List Events

Retrieves all events.

OfficeRnD

List Fees

Retrieves all fee objects.

OfficeRnD

List Members

Retrieves all members.

OfficeRnD

List Memberships

Retrieves all memberships.

OfficeRnD

List Posts

Retrieves all posts.