When importData isn’t good enough: Retrieving CSV files behind basic auth with a Google Apps Script

(This post assumes you have some familiarity with Google Spreadsheets) For CSV files that are unprotected, Google Spreadsheets provides a really handy function: importData(url). There’s a short description of it in the list of Google Spreadsheet functions. If you just use this lovely function in cell A1 and pass it the URL of a CSV file, you’ll… Read More