List Worksheets

type Gsheets = {

  token: string;

};

export async function main(gsheets_auth: Gsheets, spreadsheetId: string) {

  const token = gsheets_auth["token"];

  const GET_WORKSHEET_URL = `https://sheets.googleapis.com/v4/spreadsheets/${spreadsheetId}?&fields=sheets.properties`;

  const response = await fetch(GET_WORKSHEET_URL, {

    method: "GET",

    headers: {

      Authorization: "Bearer " + token,

      "Content-Type": "application/json",

    },

  });

  const text = await response.json();

  let list = [];

  for (let i in text["sheets"]) {

    list.push({

      sheetId: text["sheets"][i]["properties"]["sheetId"],

      title: text["sheets"][i]["properties"]["title"],

    });

  }

  return list;

}