Listing all office attendance in a Google Sheet file

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!