In Google Sheets
fills 100 columns with numbers 1-100.
inserts my JSON data keys and values into corresponding rows.
How can I set this up so that for each column, I change the number for the JSON file?
I tried combining these two functions but it just errors. =ArrayFormula(ImportJSON("http://www.domain.com/sample&row(1:100)&.json", ""))
Now this works:
but it's not putting the number in the desired spot. It's just adding it before each cell.