Before starting, this documentation is for Comeen Workplace Admin users.
For some reasons you could want to build a file with all your office attendaces.
One use case is to build a dashboard to see who's coming this week, no matter if it's a teammate of you or not.
To achieve this goal, we'll:
1- Make a copy of our Google Sheet template,

2- Add Google App Script :
We'll build a Google App Script that will be called each time someone Create or Cancel an office attendance.
Go to ready-to-use script. Select all code and copy.

Go back to your GSheets, click on Extensions > Apps Script:

Delete the existing code and paste the new code:

Add the url of your GSheets here:

3- Deploy the Script
Click on Deploy > New deployement:

Select Web app type:

Fill in the information and click on Deploy:

Copy Web app url:

4- Paste the deployment link into Comeen Workplace.
Go to your dashboard > Settings and click on Integrations > Webhooks.
Paste the Web app url on:
-
presence_created: A new presence has been added by a user
-
presence_destroyed: A presence has been removed by a user

Click on Save.
You're all set!
Now, you can go further by buidling an office attendance dashboard with Google Data Studio!
Comments
0 comments
Please sign in to leave a comment.