Before starting, this documenation is for Comeen 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. We'll build a Google App Script that will be called each time someone Create or Cancel an office attendance. Make a copy of our ready-to-use script.

  2. Make a copy of our Google Sheet template,

  3. Fill the URL of the Google Sheet in the Google App Script,

  4. Deploy the Google App Script,

  5. Paste the deployment link into Comeen.

You're all set!

Now, you can go further by buidling an office attendance dashboard with Google Data Studio!

Did this answer your question?