Jeremy Modjeska
  • Code
  • Pictures
  • Words
  • Home
  • Code
  • Pictures
  • Words
  • Home
  • Code
  • Pictures
  • Words

Fetch a Remote CSV in Google Sheets with Basic Auth

August 16, 2018

source code
jmodjeska / google_csv.js

This is a Google Apps Script custom function that facilitates importing a remote CSV file into your Google Sheets document. It provides for basic HTTP auth traversal. This is based upon an older solution described on the Redfin engineering blog, which no longer works (probably due to changes over time in Google Sheets functionality).

ABOUT

This personal website of Jeremy Modjeska is © by the author. All rights reserved. Code projects are licensed BY-NC-SA. This website is not suitable for carbon-based lifeforms.

Code | Pictures | Words