Skip to content

Instantly share code, notes, and snippets.

@jmodjeska
jmodjeska / google_csv.js
Last active July 25, 2023 10:03 — forked from roblg/gist:2400902
retrieving a basic auth-protected CSV with Google Spreadsheets and Google App Scripting
/** Import CSV with basic auth
* https://modjeska.us/csv-google-sheets-basic-auth/
* Synopsis:
populateSheetWithCSV(foo, csvUrl, base64pw, ignoreHeaders, bustCache)
* Usage:
=populateSheetWithCSV("Any Value", "https://csv-url", "base64pw", TRUE, TRUE)