Skip to main content

 

I’m getting the following data from an API

n
>
{
"keyword_data": {
"id": 657125,
"name": "abarth 124 spider review"
},
"positions": {
"2022-08-11": 3
},
"positions_mobile": {
"2022-08-11": 4
}
},
{
"keyword_data": {
"id": 657126,
"name": "abarth 124 spider price"
},
"positions": {
"2022-08-11": 5
},
"positions_mobile": {
"2022-08-11": 7
}
}
]
]

 

and I was wondering if there’s a way to turn this into a google sheet with columns like

keyowrd_data positions date positions_mobile date  
abarth 124 spider review 3 2022-08-11 4 2022-08-11  
   

 

     

 

I’ve been trying to parse the data through the CODE step but I’m not being able to get the correct code.
I was wondering if this is something you could help me with?

 

Thanks

 

 

Hey @agarbre ,

 

Yes this is possible. You can write a Javascript code for this.


Thanks @jayeshkumarbhatia for answering.
That’s what I’m not being able to do right now.

Tried different scripts but can’t make it work.