Setup Guide

Setup Google Sheet and the app in 3 easy steps

Step 1. Create a Google Spreadsheet and share it with your Google account (with edit permission) so that your Google account can edit it

Do either A or B:

A: If share with specific people and groups, select **Editor** for them. (recommended)

B: If share with anyone via link, make sure it shows **can edit**

Step 2. Enter the sheet details in the app

To see Spreadsheet ID and Sheet Name, open the Google sheet in a web browser, then refer to the below image.

In this image, Spreadsheet ID would be 1RwPt-bfNzl0qyai11ItkUkpm13Ldlaa-psND1NmSP0s and Sheet Name would be Sheet1.

Hint: To avoid typing these on your phone, you may convert these into QR Codes using online QR code generators. Then use the app to capture the values directly.


Optional Settings

  • Start column: Start column of the table to insert data. If a table is found overlapping the start column, the data will be merged to that table.

  • Automatically create sheet if not exists (Available from app version 1.7)

If checked, the app will create the sheet when you next scan a barcode if the specified sheet is not found in the Google Spreadsheet.

  • Sheet name format (Available from app version 1.10)

    • Normal: Sheet name on Google Spreadsheet will be exactly as what you specified in the app

    • Date: Sheet name specified in the app (e.g. yyyy-MM-dd) will be converted to today's date/time as the sheet name in Google Spreadsheet (e.g. 2020-07-01). The date/time conversion logic uses java "Simple Date Format". For details, refer to "Date and Time Patterns" and "Examples" section in: https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html

Step 3. Starting scanning barcodes and QR codes

To customize this app (e.g. adding timestamp, geolocation to the barcodes, or other app features), visit "Settings" in the app.

Last updated: 22nd August 2021