I have a trouble with a code retrieved here. From a Google Sheet (GS) file I copied a Google App Script (GAS) code consisting of code.gs, index.html and js.html.

In the js.html tab, in some fields, I would like the content of the drop-down menu defined by “items: […]” to be taken from the Google Sheet, e.g. from a tab named EXAMPLE_1. Do you know how I can modify the code to get the result I need?

  city: {
    label: "Città",    // Era City
    type: "select",
    value: "",
    items: ["Lahore", "Kasur", "Islmabad", "Japan", "Karachi"], //I want to pull array from GS
    disabled: false,
    placeholder: "",
    rules: [(v) => !!v || "This is required!"],

Sorry, but I can’t enclose the code for the three tabs Code.gs, index.html and js.html (Your question appears to be spam.).

I have looked for information on how to take the contents of a column from google sheet and bring it into html, but I cannot make it into an array. E.g.

Pull data from a google sheet and display as simple html text