| 1 | type Gsheets = {
 | 
 | 2 |   token: string;
 | 
 | 3 | };
 | 
 | 4 | export async function main(gsheets_auth: Gsheets, spreadsheetId: string) {
 | 
 | 5 |   const token = gsheets_auth["token"];
 | 
 | 6 | 
 | 
 | 7 |   const GET_WORKSHEET_URL = `https://sheets.googleapis.com/v4/spreadsheets/${spreadsheetId}?&fields=sheets.properties`;
 | 
 | 8 | 
 | 
 | 9 |   const response = await fetch(GET_WORKSHEET_URL, {
 | 
 | 10 |     method: "GET",
 | 
 | 11 |     headers: {
 | 
 | 12 |       Authorization: "Bearer " + token,
 | 
 | 13 |       "Content-Type": "application/json",
 | 
 | 14 |     },
 | 
 | 15 |   });
 | 
 | 16 |   const text = await response.json();
 | 
 | 17 | 
 | 
 | 18 |   let list = [];
 | 
 | 19 |   for (let i in text["sheets"]) {
 | 
 | 20 |     list.push({
 | 
 | 21 |       sheetId: text["sheets"][i]["properties"]["sheetId"],
 | 
 | 22 |       title: text["sheets"][i]["properties"]["title"],
 | 
 | 23 |     });
 | 
 | 24 |   }
 | 
 | 25 | 
 | 
 | 26 |   return list;
 | 
 | 27 | }
 | 
 | 28 | 
 |