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

deno

Approved version

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 497 days ago

deno


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 500 days ago

deno

import * as wmill from "https://deno.land/x/windmill@v1.85.0/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 628 days ago

deno

import * as wmill from "https://deno.land/x/windmill@v1.70.1/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 663 days ago

deno

import * as wmill from "https://deno.land/x/windmill@v1.24.1/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 879 days ago

← Back to the list of replies