How to insert a JSON of items into a single row on Google Sheets

Beginner Questions
1

:bullseye: What is your goal?

i made gemini generate a JSON with different values that i want to add on the same row using google sheets.

:thinking: What is the problem?

how do i split the JSON and add the values to different columns?

3

Split JSON into columns in Google Sheets

You need to parse the JSON and map each value to a column.

Should i give you a step by step?

5

that would be helpful

6

Hey Yassin,

can you share a screenshot of what the JSON looks like? Or share it here directly?

7

I’m very sorry for responding very late currently busy with a client job just finished submitting it

8

@Yassin_Ehab I would be giving an instance let’s say you have a json data

  1. Add parse json module
  2. Click generate
  3. Add google sheet - Add row
    Do you understand this or i should explain further
9

To split a JSON in Google Sheets and put its values into separate columns, follow these steps:

  1. Put the JSON in a cell
  2. In the next columns, use a formula to pick each value.
  3. Copy or drag the formula down if you have more rows.