Guide: GoogleSheets: Labour

How do core concepts map to Tenzo?

Key: ✅  Supported    🚸  Work in Progress    ❌  Not supported

                                                   

Location	✅ Location
Shift (actual)	❌ NOT SUPPORTED
Shift (planned)	❌ NOT SUPPORTED
Salaried workers	❌ NOT SUPPORTED
Hours	❌ NOT SUPPORTED
Employee	❌ NOT SUPPORTED
Role	✅ Role
House Part	✅ House Part
Actual Cost	✅ Amount
Overheads	❌ NOT SUPPORTED
Holiday	❌ NOT SUPPORTED
Breaks	❌ NOT SUPPORTED
Overtime	❌ NOT SUPPORTED
Exception costs / one-off costs	❌ NOT SUPPORTED
Borrowed / loaned employees	❌ NOT SUPPORTED

Data Ingestion

Real-time optionally available?	❌
Default polling frequency	Every 6 hours
Data retrieved on each poll	All data in the sheet
Historical data	All data in the sheet

How do I connect this data to Tenzo?

GoogleSheets can be connected directly inside of the Tenzo app. This is the template you should be using

If you have an Enterprise account, you can talk to your Customer Success Manager and they will connect this for you.

How do I populate the template?

You can delete the columns that are not relevant for what you are uploading (e.g. house part, role, etc.) and just leave the ones you will be filling.

Please note that for the template to work, dates need to be in the same formatting you find at the top of the template, YYYY-MM-DD:

How do I compare G-Sheet data to data in Tenzo?

Access the GoogleSheet and compare the daily total by line. 

You will then be able to see the same number by selecting one day within Tenzo’s “Labour by Location” view.  

Exceptions

None

#integrations #labour