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