How to Insert Scan Records into a Google Sheet
Step-by-Step Tutorial
Sign into CodeREADr.com
1. Select the “Scans” in the Navigation Bar
2. Select ‘Save a CSV Download Link’
3. Set Name of CSV File
Select either ‘Choose a Random name’ or ‘Enter a name’ and then select ‘Save Download Link’
4. Copy the Download Link
Log into your Google Account
5. Select the ‘Apps’ Icon in the Navigation Bar
6. Select ‘Google Sheets’
7. Create a New Spreadsheet
8. Insert Download Link into Formula
Add the CSV download link from Step 4 to the 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.]
9. Add the Updated Formula to the Spreadsheet
Copy and paste the formula into cell 1A of the spreadsheet, then press enter.
The Spreadsheet should now be connected to that Download Link
and automatically update itself as new scans are submitted.