Fetch a Remote CSV in Google Sheets with Basic Auth

source code

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

Leave a Reply

Your email address will not be published. Required fields are marked *


This site uses Akismet to reduce spam. Learn how your comment data is processed.