logo Windmill Hub
Login
All items
1

Get Values in Range

by
Published Jul 27, 2022
Script gsheets Verified
Use in Windmill

The script

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