1
Delete Worksheet
One script reply has been approved by the moderators Verified
Created by rossmccrann 631 days ago Viewed 4283 times
0
Submitted by rossmccrann Deno
Verified 631 days ago
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