Connecting TrackingTime to UpSheets

Question

Accepted Answer

Overview

You can connect UpSheets directly to TrackingTime to import your data and upload it to Xero. This streamlines the process and removes the need to export and import CSV files.

Enabling the Clockify Integration with UpSheets

TrackingTime data can be accessed by creating an API Token.

To enable this feature, complete the steps below.

To create an API key you must first Register for TrackingTime if you have not already done so.
After logging in, from the bottom left menu select Apps & Integrations from the menu and scroll down to the App Passwords section.

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/j0x2GOjMS3/resources/b1MFlACJEd/tracking-time-option.png (tracking-time-option)

Click Add Password and name it UpSheets. Click the button to copy the password.

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/j0x2GOjMS3/resources/qU35akeZdM/tracking-time-password.png (tracking-time-password)

IMPORTANT: Your API Key is made up of your TrackingTime email address and your password separated by a colon.

For example, if your email address is my@email.com and your generated password is P4ssw0rd - the API Key will be my@email.com:P4ssw0rd

Select Integrations from the menu in UpSheets and click the TrackingTime tab. Enter the API key and tab out of the field to confirm. If the API Key is valid the integration will now show as enabled.

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/j0x2GOjMS3/resources/0bm4bpAKcz/tracking-time-setup.png (tracking-time-setup)

Note: The API key will be masked after entry for security reasons once entered.