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!
Integromat lists members in Status Hero and checks whether all members exist in Google Sheets. If not, a new row with the missing (new) member's data is added in Google Sheets. By this way the list of members in Google Sheets is kept up to date. In this template is used this Spread Sheet.
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.
Every time a new row is added to Google Sheets, Integromat will automatically add a status activity to a member in Status Hero. This example uses the spreadsheet in this link.
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.
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.
Performs an arbitrary authorized API call.
Returns processed data as a result of the INTEGROMAT function. Sheets Add-On required.
Updates a specific cell.
Updates a row.
Adds a absence record for a member, by the ID or slug of the team member
Adds an activity to Status Hero.
Add a team-wide holiday.
Deletes an absent record for an individual team member, by the member's ID and date of the record.
Removes a team-wide holiday for the specified date.
Get a comment form a status update
Get a specific member from the team by the username.
Get a reaction from a status update.
Get a specific report from the team
Get a specific status from the team.
Get a specific status activity.
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.
List the details of every members in the team.
List all reports from the team
List all statuses from the team
List an array of tags that are configured for your team.
searches a collection of Status objects, ordered by descending date completed, where the designated tag is present.