1 | type Gsheets = { |
2 | token: string; |
3 | }; |
4 | export async function main( |
5 | gsheets_auth: Gsheets, |
6 | spreadsheetId: string, |
7 | sheetId: number, |
8 | ) { |
9 | const token = gsheets_auth["token"]; |
10 |
|
11 | const DELETE_WORKSHEET_URL = `https://sheets.googleapis.com/v4/spreadsheets/${spreadsheetId}:batchUpdate`; |
12 |
|
13 | const body = { |
14 | requests: [ |
15 | { |
16 | deleteSheet: { |
17 | sheetId: sheetId, |
18 | }, |
19 | }, |
20 | ], |
21 | }; |
22 |
|
23 | const response = await fetch(DELETE_WORKSHEET_URL, { |
24 | method: "POST", |
25 | body: JSON.stringify(body), |
26 | headers: { |
27 | Authorization: "Bearer " + token, |
28 | "Content-Type": "application/json", |
29 | }, |
30 | }); |
31 |
|
32 | return await response.text(); |
33 | } |
34 |
|