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 |
|