Admin How-To: Configuring Google Calendar Integration

A key component of Saltmine’s Utilization dataset is your organization’s room booking information. This information helps identify which rooms are being used, by what teams, and for how long. When cross-referenced with Sensor data, even more valuable insights become apparent.

To connect your organization’s Google Calendar to this feature, follow the steps below:

  1. On Google’s Admin Console, go to Security > Access and Data Control > API Controls
Manage Domain Wide Delegation
  1. Once opened, select ‘Add New’
  2. In the Client ID field, input 105692135575059631541 . This is Saltmine’s Google Cloud Platform Service Account unique id.
  3. Under OAuth scopes, add the following scopes:
  1. Click Authorize  
  1. Ensure that the room resources are tagged under the Meeting Space category. To do this, go to Directory > Buildings and resources > Manage Resources. Tip: You can quickly list all resources tagged under Meeting space by clicking on Add a filter > Resource category > Meeting space then click apply. 
  2. Provide your Customer ID and Primary Admin email address to Saltmine. They can be found in Account > Account Settings. 

What is Space Temperature?

Space Temperature or Utilization

Includes a brand new component that allows to ingest, process and display utilization data from various sources such as room booking, sensors and badging data. 

  • Ability to upload manually or through SFTP(Secure File Transfer Protocol) the following types of utilization data: Room Booking, Sensors and Badging data.
  • Mapping External rooms with Saltmine blocks through “Block-Room ID” field on the Designer.


Measure: Companies have a whole host of products & solutions deployed in their workplace with the singular aim to collect data around occupancy & employee movement.

Aggregate: Saltmine brings your multiple disorganized datasets and organizes them under one roof. By combining these sources you can run predictive analytics and make your data more dynamic.

Make it actionable: This connected data is now made contextual to your projects so you can take actions on it. This data is now also the basis of your new ‘dynamic’ design guidelines.

Space Tempertaure is accessible in 3 places within Saltmine

  1. Utilization Dashboard displaying the aggregated data for Spaces and Attendance.
    • “Spaces” represent room booking and sensor data.
    • “Attendance” represents badging data, representing the attendance of employees by office builging or floor and department.
  2. Utilization data on the Program with new enhanced columns:
    •  “Utilization %” – Average percentage of occupancy of specific block or block sub-types.
    • “Group Distribution” – Group of people occupied the room split based on number of attendees. Example: 
      • Group of two people: 50%
      • Group of three people: 30%
      • Group of four people: 20
  3. Heat map on design

How to access Utilization?

1. Utilization Dashboard


“Attendance” on Utilization Dashboard

Time Spent in the office – the aggregated percentage of attendance per department over a period of time.

Average Attendance – Average number of hours spent in the office.

Space Occupancy Trend – Number of employees coming to the office on the given data.

2. Utilization in Program Analysis

3. Heat Map

Red: Highest Utilization

Yellow: Medium Utilization

Green: Lowest Utilization

Also see How to set up Space Temperature?

How to set up Space Temperature?

This is an add-on feature. Reach out to your Customer Success Manager for a demo!

Step-by-step Guide:

Space data: Room booking and sensors

  1. Submit Digitization request with room ID’s corresponding to the Room booking/Sensor exports.
  2. Import Room Booking or Sensor data. (Download ‘Sample CSV File’ data for template)
  3. To visualize and analyze Heat Maps, open the design file -> turn on ‘Utilization Heatmap’. Select data source and time frames to view the heatmap.

Attendance data: Badging

  1. Import badging data. (Download ‘Sample CSV File’ data for template)
  2. Import badge reader data to let the system know where each badge reader is located. (Download ‘Sample CSV File’ data for template)

Block-room ID
Access Utilization Dashboard
Import Data