Synchronize your Comeen Workplace presences in a Google Sheet

1- Synchronize presences in a Google Sheet

• Set up the script
• Add librairies
• Generate the authetification url
• Connect your Comeen Workplace account
• Run the script
• Add an automatic update

2- Use data in a DataStudio.

Synchronize presences in a Google Sheet

To start, create a dedicated Google Sheet.

Set up the script

Then go to: https://script.google.com/u/0/home/projects/1pSciwISnY_Sh_hdmrZzjrcAcE0oLx4Ljy7mh5CfntKX3AaAKZ_RkeESI

Click on Make a copy:

Copy the url of the AppScript and send it to your referent at Comeen:

We will then send you yourClientID and ClientSecret.
You will have to paste them here:

 Get the url of your GSheets:

then paste it in between the "" of the GOOGLE_SHEET_URL attribute:

Choose the range of data synchronization:

You can also use startOfMonth(); and endOfMonth(); to have the script automatically take the current month:

Or startOfYear(); and endOfYear(); to have the script automatically take the current year:

The larger the range, the longer the script will run.

Add librairies

Click on Librairies:

Add ID 1B7FSrk5Zi6L1rSxxTDgDEUsPzlukDsi4KGuTMorsTQHhGBzBkMun4iDF and click on Look up:

Choose the latest version and click on Add:

Generate the authetification url

Run the Script:

Click on Review permissions:

Select your account:

Click on Allow:

Once the script is finished, get the URL in the logs:

Connect your Comeen Workplace account

Open it in a browser and connect your Comeen Workplace account (The account must be Space Administrator):

Click on Allow:

Run the script

Once connected, go back to the script and run:

You will now see the presence on your GSheets:

Add an automatic update

Go to Triggers:

Add Trigger:

Select the refresh time of the GSheets and click on Save:

You can now use this data in a DataStudio.

Use data in a DataStudio.

Create a DataStudio and select Google Sheets:

Select your GSheets and click on Add:

Click on Add to report:

You can now design your DataStudio: