This page is archived. Please refer to https://sites.google.com/site/barcodetosheets/setup-guide for most updated setup guide.


Setup Guide (Archived)

(for app version 1.7 or above)

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

Make sure you select **can edit** (NOT can view / can comment) when asked

Step 2. Enter the sheet details in the app

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

For this image, SpreadsheetID would be 1RwPt-bfNzl0qyai11ItkUkpm13Ldlaa-psND1NmSP0s and Sheet Name would be Sheet1.


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. sending timestamp and geolocation along with the scanned barcodes, or other app effects), visit "Settings" in the app.

Last updated: 26th June 2020