-1

Link to GitHub

I am receiving a blank white window running. Would someone be able to provide input on what needs to be entered in lines 10 and 12 of code.gs?

I attempted to enter the ID of the tab where the data is located on for line 10 and had the tab number of where I want the graph to appear but still having issues. Any help is greatly appreciated.

Md. Rakibul Islam
  • 2,140
  • 1
  • 7
  • 14
Court1007
  • 3
  • 2
  • 1
    You are required to post a [mcve] here, **within your question**, and [not a link](https://meta.stackoverflow.com/a/254430/162698) to any other site. – Rob Aug 29 '23 at 06:48

1 Answers1

0

lines 10 and 12 of code.gs

  • Line 10 - this is the ID of your spreadsheet.

    • Open you spreadsheet and look at the URL. The ID consists of letters, numbers, hyphens, or underscores. There's a very good explanation here that shows exactly how to find the id.
    • insert the ID between the double quotation marks on line 10
    • BEFORE var ssID = "",
    • AFTER var ssID = "1wjyxtbWo06IOTF1ilTyQ3tLUidlEiEsOuXJGcbFXcPY", (this is MY id, you should type in your own.
    • do NOT delete the comma at the end of Line 10

  • Line 12:

    • if the sheet with your Sankey data is the first (or only) sheet in the spreadsheet, then do nothing
    • if the sheet with your Sankey data is NOT the first (or only) sheet in the spreadsheet, then move it so that it the first sheet in the list of sheets
Tedinoz
  • 5,911
  • 3
  • 25
  • 35
  • Thank you so much, it turns out I was putting the wrong values and an AD block was running that prevented the chart from loading. – Court1007 Aug 29 '23 at 12:25