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!
Every time a new event is created in a Google calendar, Integromat will automatically add that event to your Google Sheets spreadsheet as a new row. The spreadsheet will be then sent to a specified email address. The template uses this example spreadsheet.
When a new leave in shared Google calendar is added or the leave is prolonged, the dates of the leave are uploaded in Status Hero. Conversely, when a leave is deleted, the dates in Status Hero are cancelled. Please ensure that employees in case of shortening the length of their leave first delete all the leave and then upload updated shorter leave! Otherwise the deleted days will not be cancelled in Status Hero.
Receives data passed to the function INTEGROMAT used in a sheet. Sheets Add-On required.
Triggers when a cell is updated. Watches only changes made in Google Sheet app. Sheets Add-On required.
Watches for new rows.
Triggers when an event is created, updated, deleted, started or ended in a selected calendar.
Appends a new row to the bottom of the table.
Adds a new sheet.
Cleares a specific cell.
Clears values from a specific row.
Creates a new spreadsheet.
Deletes a specific row.
Deletes a specific sheet.
Gets a specific cell.
Returns processed data as a result of the INTEGROMAT function. Sheets Add-On required.
Updates a specific cell.
Updates a row.
Clears a primary calendar. This operation deletes all events associated with the primary calendar of an account.
Creates a new calendar.
Creates a new access control rule.
Creates a new event.
Deletes a calendar.
Deletes an access control rule.
Deletes an event.
Returns metadata for a calendar.
Returns metadata of an access control rule.
Returns metadata for an event in the specific calendar.
Returns free/busy information for a set of calendars.
Performs an arbitrary authorized API call.
Updates an existing calendar.
Updates an existing access control rule.
Updates an existing event.
Gets a range content.
Gets a list of all sheets in a spreadsheet.
Returns results matching the given criteria.
Returns results matching the given criteria. This module doesn't return a row number.
Returns the rules in the access control list for the calendar.
Returns the calendars on the user's calendar list.
Searches for events on the specified calendar.