Edits history of script submission #37 for ' Add Rows (gsheets)'

• deno

  Ap­pro­ved version

  Edit in Windmill

  Embed

  type Gsheets = {
    token: string;
  };
  export async function main(
    gsheets_auth: Gsheets,
    sheet_id: string,
    values: Array<Array<any>>,
    range: string = "Sheet1",
  ) {
    const body = {
      values: values,
    };
  
    const valueInputOption = "USER_ENTERED";
    const insertDataOption = "INSERT_ROWS";
    const includeValuesInResponse = true;
    const APPEND_URL = `https://sheets.googleapis.com/v4/spreadsheets/${sheet_id}/values/${range}:append/?valueInputOption=${valueInputOption}&insertDataOption=${insertDataOption}&includeValuesInResponse=${includeValuesInResponse}`;
  
    const token = gsheets_auth["token"];
  
    const response = await fetch(APPEND_URL, {
      method: "POST",
      body: JSON.stringify(body),
      headers: {
        Authorization: "Bearer " + token,
        "Content-Type": "application/json",
      },
    });
  
    const result = await response.json();
  
    return { result: result };
  }
  

  Submitted by admin 460 days ago

• deno

  Edit in Windmill

  Embed

  
  type Gsheets = {
    token: string;
  };
  export async function main(
    gsheets_auth: Gsheets,
    sheet_id: string,
    values: Array<Array<any>>,
    range: string = 'Sheet1'
  ) {
    const body = {
      "values": values,
    };
  
    const valueInputOption = "USER_ENTERED";
    const insertDataOption = "INSERT_ROWS";
    const includeValuesInResponse = true;
    const APPEND_URL =
      `https://sheets.googleapis.com/v4/spreadsheets/${sheet_id}/values/${range}:append/?valueInputOption=${valueInputOption}&insertDataOption=${insertDataOption}&includeValuesInResponse=${includeValuesInResponse}`;
  
    const token = gsheets_auth["token"];
  
    const response = await fetch(APPEND_URL, {
      method: "POST",
      body: JSON.stringify(body),
      headers: {
        Authorization: "Bearer " + token,
        "Content-Type": "application/json",
      },
    });
  
    const result = await response.json();
  
    return { result: result };
  }

  Submitted by admin 463 days ago

• deno

  Edit in Windmill

  Embed

  import * as wmill from "https://deno.land/x/windmill@v1.85.0/mod.ts";
  
  export async function main(
    gsheets_auth: wmill.Resource<"gsheets">,
    sheet_id: string,
    values: Array<Array<any>>,
    range: string = 'Sheet1'
  ) {
    const body = {
      "values": values,
    };
  
    const valueInputOption = "USER_ENTERED";
    const insertDataOption = "INSERT_ROWS";
    const includeValuesInResponse = true;
    const APPEND_URL =
      `https://sheets.googleapis.com/v4/spreadsheets/${sheet_id}/values/${range}:append/?valueInputOption=${valueInputOption}&insertDataOption=${insertDataOption}&includeValuesInResponse=${includeValuesInResponse}`;
  
    const token = gsheets_auth["token"];
  
    const response = await fetch(APPEND_URL, {
      method: "POST",
      body: JSON.stringify(body),
      headers: {
        Authorization: "Bearer " + token,
        "Content-Type": "application/json",
      },
    });
  
    const result = await response.json();
  
    return { result: result };
  }

  Submitted by adam186 592 days ago

• deno

  Edit in Windmill

  Embed

  import * as wmill from "https://deno.land/x/windmill@v1.70.1/mod.ts";
  
  export async function main(
    gsheets_auth: wmill.Resource<"gsheets">,
    sheet_id: string,
    values: Array<Array<any>>,
    range: string = 'Sheet1'
  ) {
    const body = {
      "values": values,
    };
  
    const valueInputOption = "USER_ENTERED";
    const insertDataOption = "INSERT_ROWS";
    const includeValuesInResponse = true;
    const APPEND_URL =
      `https://sheets.googleapis.com/v4/spreadsheets/${sheet_id}/values/${range}:append/?valueInputOption=${valueInputOption}&insertDataOption=${insertDataOption}&includeValuesInResponse=${includeValuesInResponse}`;
  
    const token = gsheets_auth["token"];
  
    const response = await fetch(APPEND_URL, {
      method: "POST",
      body: JSON.stringify(body),
      headers: {
        Authorization: "Bearer " + token,
        "Content-Type": "application/json",
      },
    });
  
    const result = await response.json();
  
    return { result: result };
  }

  Submitted by adam186 626 days ago

• deno

  Edit in Windmill

  Embed

  import * as wmill from "https://deno.land/x/windmill@v1.23.0/mod.ts";
  
  export async function main(
    gsheets_auth: wmill.Resource<"gsheets">,
    sheet_id: string,
    values: Array<Array<any>>,
    range: string = 'Sheet1'
  ) {
    const body = {
      "values": values,
    };
  
    const valueInputOption = "USER_ENTERED";
    const insertDataOption = "INSERT_ROWS";
    const includeValuesInResponse = true;
    const APPEND_URL =
      `https://sheets.googleapis.com/v4/spreadsheets/${sheet_id}/values/${range}:append/?valueInputOption=${valueInputOption}&insertDataOption=${insertDataOption}&includeValuesInResponse=${includeValuesInResponse}`;
  
    const token = gsheets_auth["token"];
  
    const response = await fetch(APPEND_URL, {
      method: "POST",
      body: JSON.stringify(body),
      headers: {
        Authorization: "Bearer " + token,
        "Content-Type": "application/json",
      },
    });
  
    const result = await response.json();
  
    return { result: result };
  }

  Submitted by fatonramadani 834 days ago

• deno

  Edit in Windmill

  Embed

  import * as wmill from "https://deno.land/x/windmill@v1.23.0/mod.ts";
  
  export async function main(
    gsheets_auth: wmill.Resource<"gsheets">,
    sheet_id: string,
    values: Array<Array<any>>,
  ) {
    const body = {
      "values": values,
    };
  
    const valueInputOption = "USER_ENTERED";
    const insertDataOption = "INSERT_ROWS";
    const includeValuesInResponse = true;
    const range = "Sheet1";
    const APPEND_URL =
      `https://sheets.googleapis.com/v4/spreadsheets/${sheet_id}/values/${range}:append/?valueInputOption=${valueInputOption}&insertDataOption=${insertDataOption}&includeValuesInResponse=${includeValuesInResponse}`;
  
    const token = gsheets_auth["token"];
  
    const response = await fetch(APPEND_URL, {
      method: "POST",
      body: JSON.stringify(body),
      headers: {
        Authorization: "Bearer " + token,
        "Content-Type": "application/json",
      },
    });
  
    const result = await response.json();
  
    return { result: result };
  }

  Submitted by rossmccrann 844 days ago

• deno

  Edit in Windmill

  Embed

  import * as wmill from "https://deno.land/x/windmill@v1.23.0/mod.ts";
  
  export async function main(
    gsheets_auth: wmill.Resource<"gsheets">,
    sheet_id: string,
    values: Array<Array<number>>,
  ) {
    const body = {
      "values": values,
    };
  
    const valueInputOption = "USER_ENTERED";
    const insertDataOption = "INSERT_ROWS";
    const includeValuesInResponse = true;
    const range = "Sheet1";
    const APPEND_URL =
      `https://sheets.googleapis.com/v4/spreadsheets/${sheet_id}/values/${range}:append/?valueInputOption=${valueInputOption}&insertDataOption=${insertDataOption}&includeValuesInResponse=${includeValuesInResponse}`;
  
    const token = gsheets_auth["token"];
  
    const response = await fetch(APPEND_URL, {
      method: "POST",
      body: JSON.stringify(body),
      headers: {
        Authorization: "Bearer " + token,
        "Content-Type": "application/json",
      },
    });
  
    const result = await response.json();
  
    return { result: result };
  }

  Submitted by rossmccrann 844 days ago