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.
- Get the export link from your Orca sheet
- Add the IMPORTDATA formula
- 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.
2. Activate and copy the URL
Then Allow the Public URL access to activate the link and copy it to the clipboard.
3. Save updates in Orca
Finally, save the updates on the integrations settings to put all your changes to work.
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.
5. 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!
6. Load the data
Finally, click enter and load data from your Orca sheet 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:
- 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.