Prerequisites

• A Ubiqod account – You can sign up here and get 100 free Credits to test.

• A Google account – If you don’t have one, create one here.

• Time – Allow about an hour in a quiet place to follow the steps carefully.

We recommend being familiar with Google Sheets before starting.

Step 1: Install the Taqt Timesheet add-on

1. Open a new Google Spreadsheet.

2. Go to Extensions > Add-ons > Get add-ons.

3. Search for Taqt Timesheet and click on the app.

4. Click Install > Continue, then accept permissions.

5. After installation, a new submenu will appear under Extensions > Taqt Timesheet.

If you don’t see it immediately, wait a few minutes and reload the page.

For Google Workspace users

You can choose Admin installation (to make it available for all team members) or individual installation. If options are restricted, contact your admin.

Step 2: Configure your regional settings

1. Go to File > Settings.

2. Set your correct Time zone and Country.

3. Click Save.

If you change the time zone later, you’ll need to reconfigure the link in the Ubiqod interface to reflect this change.

Step 3: Initialize the app

1. Go to Extensions > Taqt Timesheet > Create Sheets (Initial setup).

2. Authorize the app when prompted.

3. Select your preferred date format and click Continue.

4. Wait for confirmation before interacting with the spreadsheet.
   

If stuck on loading, it may be due to multiple signed-in Google accounts. Try:

• Logging out of all accounts and signing into only the one for this spreadsheet.

• Or use incognito mode with just one Google login.
  

Do not modify the tabs and the columns of the spreadsheet, as this could break the App.

Your screen should look like this at the end of the process:

Step 4: Configure Ubiqod

Create a site

1. In the Sites section of the Ubiqod interface, click Create.
   

2. Enter a name like Site A and an address or GPS coordinates.

3. Click Create to save.

Create an interface

1. In Interfaces, click Create and choose Single Choice in The QR code Forms tab.
   

2. Name your From (e.g., Clocks IN/OUT Interface).

In the Advanced parameters:

• Optional: Add worker instructions.

• Optional: Show tracker name.

• Optional: Activate geofencing.

• Enable Protection / Identification (numeric input or scan).

• Recommended in production: Remember the code or identifier.
  

• Recommended in production: Validate PIN code before sending.

In the Edit tab, configure two buttons:

• Label: Arrive / Reference: 1

• Label: Depart / Reference: 2
  

Important: If you change the labels Arrive and Depart, update cells B4 and B5 in the spreadsheet to match.

Click Create.

Create a dispatch

1. In Dispatch, click Create, and choose Google Sheets.
   

2. Name it (e.g., Clocks IN/OUT Dispatch).

3. If it's your first time using Google Sheets:

   • Click the + next to “Select a Google Sheets Connection”.

   • Name it and click Sign in with Google, then accept.

4. Paste the URL of your spreadsheet into the URL field (should look like https://docs.google.com/spreadsheets/d/5gHgasV3wi4YH46LamJxhOPbbqV8bNOHaH34mpMmOKFY/edit?gid=0)  .

5. Click Retrieve spreadsheet data.
   

6. In "Select a sheet", choose: Logs

7. Match the fields as follows:

Your screen should look like this:

Create a tracker (QR code)

1. In Trackers > QOD, click + QOD.

2. Name it (e.g., Timekeeping).

3. Select the form, site, and dispatch you created.

4. Click Create.
   

Configure an Ubiqod Key (optional)

1. Go to Trackers > Ubiqod Key.

2. If your key doesn’t appear, follow the relevant setup guide.

3. Assign the interface, site, and dispatch.

4. Click Update.

Step 5: Test the employee tracking app

Scan the QR code or Ubiqod Key. Follow the on-screen steps:

• Choose Arrive or Depart

• Enter your personal PIN or scan your badge

In the spreadsheet:

• The Logs tab shows raw data

• The Tracking tab formats it as a timesheet
  

You should see a screen similar to:

If nothing appears in Tracking, check the button labels match the ones in the spreadsheet (cells B4 and B5).