How to scan barcodes into Google SheetsEnterprise feature
You can create a real-time link between Orca Scan and Google Sheets by creating an Orca Scan cloud sheet. Scanned barcodes and data entered from the device will then be available in your Google Sheet - removing the need to import/export data.
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.
- Get the export link from your Orca sheet
- Add the IMPORTDATA formula
- Paste the export link
1. Get the export link from your Orca sheet
Click Settings on the Sheet you want to set up
Activate and copy the link
Now, over to Google Sheets...
2. Add the IMPORTDATA formula
Place the curser in the A1 cell and add the =IMPORTDATA=( formula to the first cell of your sheet.
3. Paste the export link
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!
Hit enter and wait for your data to load.
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.
- Google pulls data from your Orca Scan every 60 minutes.
- Clearing your Orca Sheet will also clear the data from your Google Sheet
We're always happy to help, simply chat with us live or drop us an email.