How to scan barcodes into Google Sheets

You can create a real-time link between a sheet in Orca Scan and a Google Sheet from the web application. Scanned barcodes and data entered from the mobile app will then pushed automatically into your Google Sheets.

Requires a Business subscription plan

If you've not done so already, to your online Orca Scan account and create a Cloud Sheet. Once you've done that, use the following 3 steps to connect your sheet.

  1. Get the export link from your Orca sheet
  2. Add the IMPORTDATA formula
  3. Paste the export link

Start by navigating to the integrations settings on the sheet you want to export from.

Opening the sheet integration menu

Then Allow the Public URL access to activate the link and copy it to the clipboard.

Copying the Orca Scan unique sheet URL

3. Save updates in Orca

Finally, save the updates on the integrations settings to put all your changes to work.

Saving the integration changes

Now, let's head over to Google Sheets...

4. Add IMPORTDATA formula to Google Sheets

Place the cursor in the A1 cell and add the =IMPORTDATA formula to the first cell of your sheet.

Typing in the IMPORTDATA formula in a Google Sheets cell

Now add the export link from Orca Scan within the brackets =IMPORTDATA("replace-with-your-orca-sheet-url-here.csv") - be sure to include the quotation marks!

Pasting Orca Scan export link into Google Sheets cell

6. Load the data

Finally, click enter and load data from your Orca sheet into the Google sheet

Showing result of all scanned barcodes in a Google spreadsheet

URL export configurations

You can configure the data export by appending parameters to the URL, for example:

Function URL parameter
Change output format .html / .csv / .json / .xml
Include audit trail transactions=true
Include deltas for numeric columns deltas=true
Change date format datetimeformat=DD/MM/YYYY
Change time zone timezone=-03:00

Important: always use a ? before the first parameter and an & before each additional parameter, for example:

https://api.orcascan.com/sheets/sJ0KYsnp-9b7Rl7i?transactions=true&deltas=true

That's it!

You're done. Your Google Sheet will now mirror everything in your Orca Sheet. So if you add, update or delete a row inside Orca Scan, Google will automatically pull them changes into your Google Sheet.

Important:

  • Google pulls data from your Orca Scan every 60 minutes.
  • Clearing your Orca Sheet will also clear the data from your Google Sheet

Questions?

We're always happy to help, chat with us live or drop us an email.