How to Insert Scan Records into a Google Sheet

Step-by-Step Tutorial

Step 1: Sign-in to

1. Click the “Scans” link in the navigation bar at the top of the page.

Scan Navigation Link

2. Select ‘Save a CSV Download Link’

Save a CSV Download Link

3. Select either ‘Choose a Random name’ or ‘Enter a name’ and then select ‘Save Download Link’.

Adjust CSV Settings

4. Copy the download link

Copy the download link

Step 2: Log into your Google account

5. Click the ‘Apps’ icon in the navigation bar at the top of the page.

Select google apps

6.Select ‘Google Sheets

Select Google Sheets

7. Create a new Spread Sheet

Create a new spreadsheet

8. Select Row 1A

Select Row A1

9. Insert the download link into this formula:




[Note: Google Sheet’s IMPORTDATA() function currently updates sheets on an hourly basis. To enable faster updates please watch for updates from Google. You also may be able to find workarounds.]

10. Copy and then Paste the Formula into the Spreadsheet and press Enter

Insert formula into spreadsheet

11. The Spreadsheet should now be connected to that Download Link and automatically update itself as new scans are submitted.

Update spreadsheet with new scans