Connect my QR code Tracker to Google Sheet

Learn how to set up a Google Sheet to insert rows by scanning a Qod (or pressing an IoT-button).

Let's imagine you want to organize an in-store pickup service

You are looking for a simple way to organize the customer queue and improve the pickup delay.

Every time a customer arrives, he scans a QR code and enters his order number.

The request is immediately recorded in a spreadsheet displayed on a computer in your backroom. Your order picker see the notification and bring along the order to the counter.

Before you start: requirements

Before using this connector, you need to:

Prepare your Google Sheet

Connect to your Google account and create a new Sheet named "Pickup backlog".

Configure the following labels in the first row:

  • A: Timestamp
  • B: Site
  • C: Order
  • D: Geofencing
  • E: Status

Select column D (corresponding to geofencing) to add a Conditional Formatting:

  • if cell value = 1 color its background in green,
  • if value = 0 set a red background color.

Create a Google Sheet

Geofencing uses customer's GPS coordinates to ensure he was on Site when scanning the QR code. If the customer refuses to share his position or if he is not on Site, geofencing returns a 0 value (it will corresponds to the red color).

Setup your Dispatch Group

Connect to the Ubiqod platform and select the "Dipatch Groups" menu.

Create a new group, name it "Google Sheet pickup service". You can specify further details in the description field. Then, click on "+ NEW". Create a Dispatch group step 1

Click on the "Integrations" icons: Create a Dispatch group step 1

Select the Google Sheet "Connect" button: Google Sheet connector for Ubiqod

Name your integration. You can use your Google Sheet name, i.e "Pickup backlog" for example.

Copy the Google Sheet URL and paste it in the corresponding field. Then, click on "Retrieve Spreadsheet data": Select a Google Sheet url

In case your Google Sheet gets several sheets, you must now select the one where you want data to be dispatched: Select a Google Sheet tab

Click on "Next" to map Google Sheet columns to Qod fields:

  • Column A: Timestamp
  • Column B: Site label
  • Column C: Action value
  • Column D: GPS condition
  • Column E: leave it empty

Map Google Sheet fields

Here is the list of fields available for mapping!

Click on "Finish". Your Sheet is connected with this Dispatch Group. Let's now configure your Qod!

Create a Qod (QR code tracker)

Your Qod must be linked to a Site, so first create a Site corresponding to your store location. For details on how to create a Site, How to create a site.

Once your Site created, select the "Custom Qods" menu and click on "New":

  • Name your Qod
  • Select the previously created Site
  • Select the previously set up Dispatch Group
  • Click on "Next"

Qod creation

Setup the Action "Compose a code" (do not pick a code list) and click on "Next". Qod action configuration

In the "Setup conditions tab", ensure GPS condition is checked and click on "Create".

Congrats! everything is ready to be tested:

  • Display the QR code by clicking on the corresponding icon
  • Scan it with your smartphone
  • Enter your order number and validate
  • Your Google Sheet updates.

Google Sheet update

You can use the status column for your order picker to set the request as "done".