1
Clear All Values
One script reply has been approved by the moderators Verified
Created by rossmccrann 862 days ago Viewed 12911 times
0
Submitted by rossmccrann Deno
Verified 862 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 ADD_WORKSHEET_URL = `https://sheets.googleapis.com/v4/spreadsheets/${spreadsheetId}:batchUpdate`;
12

13
  const body = {
14
    requests: [
15
      {
16
        updateCells: {
17
          range: {
18
            sheetId: sheetId,
19
          },
20
          fields: "userEnteredValue",
21
        },
22
      },
23
    ],
24
  };
25

26
  const response = await fetch(ADD_WORKSHEET_URL, {
27
    method: "POST",
28
    body: JSON.stringify(body),
29
    headers: {
30
      Authorization: "Bearer " + token,
31
      "Content-Type": "application/json",
32
    },
33
  });
34

35
  return await response.text();
36
}
37