logo Windmill Hub
Login
All items

Get Spreadsheet

Script gsheets Verified

by rossmccrann ยท 7/27/2022

Use in Windmill

The script

Submitted by hugo989 Typescript (fetch-only)
Verified 5 days ago
All edits
Permalink
1 
//native
2
3 
type Gsheets = {
4 
  token: string;
5 
};
6 
export async function main(gsheets_auth: Gsheets, spreadsheetId: string) {
7 
  const token = gsheets_auth["token"];
8
9 
  const GET_SPREADSHEET_URL = `https://sheets.googleapis.com/v4/spreadsheets/${spreadsheetId}`;
10
11 
  const response = await fetch(GET_SPREADSHEET_URL, {
12 
    method: "GET",
13 
    headers: {
14 
      Authorization: "Bearer " + token,
15 
      "Content-Type": "application/json",
16 
    },
17 
  });
18
19 
  return await response.json();
20 
}
21
Other submissions
  • Submitted by rossmccrann Deno
    Created 397 days ago
    All edits
    Permalink
    1 
    type Gsheets = {
    2 
      token: string;
    3 
    };
    4 
    export async function main(gsheets_auth: Gsheets, spreadsheetId: string) {
    5 
      const token = gsheets_auth["token"];
    6
    7 
      const GET_SPREADSHEET_URL = `https://sheets.googleapis.com/v4/spreadsheets/${spreadsheetId}`;
    8
    9 
      const response = await fetch(GET_SPREADSHEET_URL, {
    10 
        method: "GET",
    11 
        headers: {
    12 
          Authorization: "Bearer " + token,
    13 
          "Content-Type": "application/json",
    14 
        },
    15 
      });
    16
    17 
      return await response.json();
    18 
    }
    19