I am using an ajax call to access google sheets, to retrieve a range of values (e.g. sheet1!A1:A3)
The reply format is in json such as follows.
I want to insert value1 ... value3 into a listbox, but have difficulties accessing the items in the values array.
How is this done in C2 or C3 ?