benborgers / opensheet

💾 An API to get a Google Sheet as JSON, no authentication required.
https://opensheet.elk.sh
MIT License
632 stars 121 forks source link

How to create arrays? #29

Closed Pilag6 closed 8 months ago

Pilag6 commented 8 months ago

For example. If I want to have many images in one "key", how can I do it in the Google Sheet?

images: ["image1.jpg", "image2.jpg","image3.jpg", "image4_.jpg"]

benborgers commented 8 months ago

Hi - what's the format of your sheet? Do you have a URL that you can share?

Pilag6 commented 8 months ago

https://opensheet.elk.sh/14zGBELpJ1_uUSRAjKmLoYDpkMGySKLpiIQSW4XeGkH8/1

I would like to have more than 1 image:

image

benborgers commented 8 months ago

Ah I understand, but I'm not sure that's possible in Google Sheets itself?

tiagorangel1 commented 7 months ago

@Pilag6 You can just use [image1, image2, image3] and then JSON.parse it.