Step-by-Step Tutorial

How to Insert Scan Records into a Google Sheet

Step 1: Sign-in to codereadr.com

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

2. Select ‘Save a CSV Download Link’

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

4. 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.

6.Select ‘Google Sheets

7. Create a new Spread Sheet

8. Select Row 1A

9. Insert the download link into this formula:

=IMPORTDATA(“CSV_DOWNLOAD_LINK”)

Example:

=IMPORTDATA(“https://www.codereadr.com/share/db9e**************1822af_3U“)

[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

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