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 be pushed automatically into your Google Sheets.


If you’ve not done so already, log in 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

1. Go to the Integrations menu

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

Click on the 'Integrations' button at the top of the sheet
Click on the 'Integrations' button at the top of the sheet

2. Activate and copy the URL

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

Enable Public URL access and copy the Live Data URL to the clipboard
Enable Public URL access and copy the Live Data URL to the clipboard

3. Save updates in Orca

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

Click save to confirm the integration changes
Click save to confirm the integration changes

Now, let’s head over to Google Sheets…


4. Add Import Formula

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

Add =IMPORTDATA into the A1 cell of an empty Google sheet
Add =IMPORTDATA into the A1 cell of an empty Google sheet

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!

Paste in the URL within the brackets
Paste in the URL within the brackets

6. Load the data

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

Click enter to load your Orca Scan data into the Google sheet
Click enter to load your Orca Scan data into the Google sheet

URL export configurations

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

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

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 the changes into your Google Sheet.

Important:


Questions?

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

Ready to start scanning?