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