我可以从多个数据源创建单个HighCharts图表（在本例中为多个GoogleSheets）

I’m trying to use data from multiple GoogleSheets to produce a single HighChart graph. I’d like to do this without moving all the data into one area of a single spreadsheet, particularly as I want to use the drilldown option which would make it difficult to collect all the data together. I thought I could pass the columns as an array and then reference the array in the data property of my chart, but I’m struggling to do that with even one column from one sheet.I’m trying to use data from multiple GoogleShee