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:
- Create a free Ubiqod account
- Validate your email and connect to your Ubiqod account
- Have a Google account to use Google Sheet service
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.
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".
Click on the "Integrations" icons:
Select the Google Sheet "Connect" button:
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":
In case your Google Sheet gets several sheets, you must now select the one where you want data to be dispatched:
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
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"
Setup the Action "Compose a code" (do not pick a code list) and click on "Next".
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.
You can use the status column for your order picker to set the request as "done".