Edits history of script submission #65 for ' Create Worksheet (gsheets)'

• deno

  Ap­pro­ved version

  Edit in Windmill

  Embed

  type Gsheets = {
    token: string;
  };
  export async function main(
    gsheets_auth: Gsheets,
    spreadsheetId: string,
    title: string,
  ) {
    const token = gsheets_auth["token"];
  
    const ADD_WORKSHEET_URL = `https://sheets.googleapis.com/v4/spreadsheets/${spreadsheetId}:batchUpdate`;
  
    const body = {
      requests: [
        {
          addSheet: {
            properties: {
              title: title,
              gridProperties: {
                rowCount: 20,
                columnCount: 12,
              },
              tabColor: {
                red: 1.0,
                green: 0.3,
                blue: 0.4,
              },
            },
          },
        },
      ],
    };
  
    const response = await fetch(ADD_WORKSHEET_URL, {
      method: "POST",
      body: JSON.stringify(body),
      headers: {
        Authorization: "Bearer " + token,
        "Content-Type": "application/json",
      },
    });
  
    return await response.text();
  }
  

  Submitted by hugo697 374 days ago

• deno

  Edit in Windmill

  Embed

  type Gsheets = {
    token: string;
  };
  export async function main(
    gsheets_auth: Gsheets,
    spreadsheetId: string,
    title: string,
  ) {
    const token = gsheets_auth["token"];
  
    const ADD_WORKSHEET_URL = `https://sheets.googleapis.com/v4/spreadsheets/${spreadsheetId}:batchUpdate`;
  
    const body = {
      requests: [
        {
          addSheet: {
            properties: {
              title: title,
              gridProperties: {
                rowCount: 20,
                columnCount: 12,
              },
              tabColor: {
                red: 1.0,
                green: 0.3,
                blue: 0.4,
              },
            },
          },
        },
      ],
    };
  
    const response = await fetch(ADD_WORKSHEET_URL, {
      method: "POST",
      body: JSON.stringify(body),
      headers: {
        Authorization: "Bearer " + token,
        "Content-Type": "application/json",
      },
    });
  
    return await response.text();
  }
  

  Submitted by admin 1007 days ago

• deno

  Edit in Windmill

  Embed

  
  type Gsheets = {
    token: string;
  };
  export async function main(gsheets_auth: Gsheets,
      spreadsheetId: string,
      title: string,
  ) {
  
      const token = gsheets_auth["token"];
  
      const ADD_WORKSHEET_URL =
          `https://sheets.googleapis.com/v4/spreadsheets/${spreadsheetId}:batchUpdate`;
  
      const body = {
          "requests": [
              {
                  "addSheet": {
                      "properties": {
                          "title": title,
                          "gridProperties": {
                              "rowCount": 20,
                              "columnCount": 12
                          },
                          "tabColor": {
                              "red": 1.0,
                              "green": 0.3,
                              "blue": 0.4
                          }
                      }
                  }
              }
          ]
      }
  
      const response = await fetch(ADD_WORKSHEET_URL, {
          method: "POST",
          body: JSON.stringify(body),
          headers: {
              Authorization: "Bearer " + token,
              "Content-Type": "application/json",
          },
      });
  
      return await response.text();
  }

  Submitted by admin 1010 days ago

• deno

  Edit in Windmill

  Embed

  import * as wmill from "https://deno.land/x/[email protected]/mod.ts";
  
  export async function main(gsheets_auth: wmill.Resource<"gsheets">,
      spreadsheetId: string,
      title: string,
  ) {
  
      const token = gsheets_auth["token"];
  
      const ADD_WORKSHEET_URL =
          `https://sheets.googleapis.com/v4/spreadsheets/${spreadsheetId}:batchUpdate`;
  
      const body = {
          "requests": [
              {
                  "addSheet": {
                      "properties": {
                          "title": title,
                          "gridProperties": {
                              "rowCount": 20,
                              "columnCount": 12
                          },
                          "tabColor": {
                              "red": 1.0,
                              "green": 0.3,
                              "blue": 0.4
                          }
                      }
                  }
              }
          ]
      }
  
      const response = await fetch(ADD_WORKSHEET_URL, {
          method: "POST",
          body: JSON.stringify(body),
          headers: {
              Authorization: "Bearer " + token,
              "Content-Type": "application/json",
          },
      });
  
      return await response.text();
  }

  Submitted by adam186 1138 days ago

• deno

  Edit in Windmill

  Embed

  import * as wmill from "https://deno.land/x/[email protected]/mod.ts";
  
  export async function main(gsheets_auth: wmill.Resource<"gsheets">,
      spreadsheetId: string,
      title: string,
  ) {
  
      const token = gsheets_auth["token"];
  
      const ADD_WORKSHEET_URL =
          `https://sheets.googleapis.com/v4/spreadsheets/${spreadsheetId}:batchUpdate`;
  
      const body = {
          "requests": [
              {
                  "addSheet": {
                      "properties": {
                          "title": title,
                          "gridProperties": {
                              "rowCount": 20,
                              "columnCount": 12
                          },
                          "tabColor": {
                              "red": 1.0,
                              "green": 0.3,
                              "blue": 0.4
                          }
                      }
                  }
              }
          ]
      }
  
      const response = await fetch(ADD_WORKSHEET_URL, {
          method: "POST",
          body: JSON.stringify(body),
          headers: {
              Authorization: "Bearer " + token,
              "Content-Type": "application/json",
          },
      });
  
      return await response.text();
  }

  Submitted by adam186 1173 days ago

• deno

  Edit in Windmill

  Embed

  import * as wmill from "https://deno.land/x/[email protected]/mod.ts";
  
  export async function main(gsheets_auth: wmill.Resource<"gsheets">,
      spreadsheetId: string,
      title: string,
  ) {
  
      const token = gsheets_auth["token"];
  
      const ADD_WORKSHEET_URL =
          `https://sheets.googleapis.com/v4/spreadsheets/${spreadsheetId}:batchUpdate`;
  
      const body = {
          "requests": [
              {
                  "addSheet": {
                      "properties": {
                          "title": title,
                          "gridProperties": {
                              "rowCount": 20,
                              "columnCount": 12
                          },
                          "tabColor": {
                              "red": 1.0,
                              "green": 0.3,
                              "blue": 0.4
                          }
                      }
                  }
              }
          ]
      }
  
      const response = await fetch(ADD_WORKSHEET_URL, {
          method: "POST",
          body: JSON.stringify(body),
          headers: {
              Authorization: "Bearer " + token,
              "Content-Type": "application/json",
          },
      });
  
      return await response.text();
  }

  Submitted by rossmccrann 1389 days ago