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;
}
Submitted by admin 486 days ago
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;
}
Submitted by admin 490 days ago
import * as wmill from "https://deno.land/x/windmill@v1.85.0/mod.ts";
export async function main(gsheets_auth: wmill.Resource<"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;
}
Submitted by adam186 618 days ago
import * as wmill from "https://deno.land/x/windmill@v1.70.1/mod.ts";
export async function main(gsheets_auth: wmill.Resource<"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;
}
Submitted by adam186 653 days ago
import * as wmill from "https://deno.land/x/windmill@v1.24.1/mod.ts";
export async function main(gsheets_auth: wmill.Resource<"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;
}
Submitted by rossmccrann 869 days ago