Download a Google sheet via Deno

download_sheet.deno.js

import * as google from "https://esm.sh/@googleapis/sheets";
import { stringify } from "https://esm.sh/csv-stringify/sync";

var clientID = Deno.env.get("GOOGLE_OAUTH_CLIENT_ID");
var secret = Deno.env.get("GOOGLE_OAUTH_CONSUMER_SECRET");

var spreadsheetId = "1R78UCHNrc2VrTuObhduVZNpgSZJDV5-kuw8S4gzJV9k";

var HOME = Deno.env.get("HOME");

var tokenFile = Deno.readTextFileSync(HOME + "/.google_oauth_token");
var token = JSON.parse(tokenFile);

var headers = new Headers();
headers.set("Authorization", "Bearer " + token.access_token);

var endpoint = "https://sheets.googleapis.com/v4/spreadsheets/";

var sheet = await fetch(endpoint + spreadsheetId, {
  headers
}).then(r => r.json());

for (var tab of sheet.sheets) {
  var url = `${endpoint}${spreadsheetId}/values/'${encodeURIComponent(tab.properties.title)}'!A:Z`;
  var response = await fetch(url, { headers }).then(r => r.json());
  var { values } = response;
  var csv = stringify(values);
  Deno.writeTextFileSync(`./out/${tab.properties.title.replace(/(\/|\s)+/g, "_")}.deno.csv`, csv);
}