This article shows how to implement a simple QR-code-based staff check-in system using the Ubiqod platform and the free Skiply Timesheet app for Google Sheets.

Prerequisites

• A Ubiqod account – You can sign up here and get 100 free Ubiqoins 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 Skiply Timesheet add-on

1. Open a new Google Spreadsheet.

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

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

4. Click Install > Continue, then accept permissions.

5. After installation, a new submenu will appear under Extensions > Skiply 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

To make sure time formats work properly:

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 > Skiply 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.

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.
   

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

In the General options:

• Optional: Add worker instructions.

• Optional: Show tracker name.

• Optional: Activate geofencing.

• Enable PIN protection.

• Optional: Enable scan mode for QR badge use.

• Optional: Activate PIN memory.

In the Edit tab, create 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.

5. Click Retrieve spreadsheet data.

6. Match the fields as follows:

Click Create.

Create a tracker (QR code)

1. In Trackers > QOD, click + Code.

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

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

4. Click Create.

Configure an Ubiqod Key

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

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