Google Hotsheets provides an efficient way to link live employee data to Google Sheets, automate updates, and streamline collaboration.
Google Hotsheets overview
With Google Hotsheets, you can accomplish the following:
📄Link up to 10 queries that contain live employee data into an external spreadsheet, in a secure way and avoid doing specific calculations every time you run a query.
📄You automatically update the formula, charts and tables you added to your spreadsheet when using a new query on your Hotsheet.
📄Create graphs and pivot tables based on the query data.
📄Although you can't use Excel Hotsheets on MAC devices due to this not being supported, you can use any device that has access to Google Drive.
📄You can keep all files in one place, and securely share them with other Google users, adding restrictions to their access if necessary.
📄It's more secure than saving it to your desktop and emailing it to your team.
Create a Google Hotsheet
To create a Google Hotsheet, follow the steps below:
Log in to your Google Drive account and click New.
Select Google Sheets, then click Add-ons and select Get Add-ons.
If you already have this add-on, skip to step.
Click the Plus Free icon and select the relevant Google account.
Click Allow, then click Add-ons and select People Hotsheets.
Click Load Hotsheets and paste your API key.
To have access to the queries you wish to link to create an API key.
Select Add Query and type in the query name you wish to link, then click Load data.
📌Note: You can add up to 10 queries.
To update the Google Hotsheets, go back to the People Hotsheets add-on and select Refresh Hotsheet.
Share a Google Hotsheet
To share a Google Hotsheet you created with an employee:
In your Google Hotsheet, click Share.
Select Advanced and click the eye icon.
Edit the access options or set expiration to their access.
Click Done.