What are you trying to achieve?
I’m trying to combine multiple items from a collection inside an array to a single text to be added to a google spreadsheet.
What I have is:
[
{
“status”: “success”,
“allIdeas”: {
“results”: [
{
“id”: “720eb9314f1e366a9700aab4b1a4430a-us”,
“keyword”: “italian pasta salad”,
“country”: “us”,
“difficultyLabel”: “Hard”,
“volumeLabel”: “MoreThanTenThousand”,
“updatedAt”: “2024-06-26T15:10:52Z”
},
{
“id”: “aa1c8c50fceb02fed82bbd9a9e312688-us”,
“keyword”: “italian pasta”,
“country”: “us”,
“difficultyLabel”: “Medium”,
“volumeLabel”: “MoreThanOneThousand”,
“updatedAt”: “2024-06-26T17:03:58Z”
},
{
“id”: “5eacf787cbb363d0b8cb7a1ab756f504-us”,
“keyword”: “italian pasta salad recipe”,
“country”: “us”,
“difficultyLabel”: “Hard”,
“volumeLabel”: “MoreThanOneThousand”,
“updatedAt”: “2024-06-26T06:00:15Z”
},
{
“id”: “282f9ef8a8e45742e85bb7bbb88ae8c3-us”,
“keyword”: “italian pasta recipes”,
“country”: “us”,
“difficultyLabel”: “Medium”,
“volumeLabel”: “MoreThanOneThousand”,
“updatedAt”: “2024-06-27T04:45:47Z”
},
{
“id”: “132b55eabee199cebc93211896189761-us”,
“keyword”: “italian pasta dishes”,
“country”: “us”,
“difficultyLabel”: “Medium”,
“volumeLabel”: “MoreThanOneThousand”,
“updatedAt”: “2024-06-26T08:54:18Z”
},
{
“id”: “b38c265bf59bf4c49cd0e34bf8001f0d-us”,
“keyword”: “traditional italian pasta fagioli recipe”,
“country”: “us”,
“difficultyLabel”: “Medium”,
“volumeLabel”: “MoreThanOneThousand”,
“updatedAt”: “2024-06-26T13:19:53Z”
},
{
“id”: “030ca8a2d91b7e3b174b9db34361433a-us”,
“keyword”: “italian pasta salad recipes”,
“country”: “us”,
“difficultyLabel”: “Hard”,
“volumeLabel”: “MoreThanOneThousand”,
“updatedAt”: “2024-06-22T11:01:56Z”
So I need to collect specific data from the collection inside the array, which are:
keyword / difficultyLabel / volumeLabel / updatedAt
And add them as single text, one per line, into a google spread sheet cell.
What would give me the following final structure:
italian pasta salad / Hard / MoreThanTenThousand / 2024-06-26T15:10:52Z
italian pasta / Medium / MoreThanOneThousand / 2024-06-26T17:03:58Z
italian pasta salad recipe / Hard / MoreThanOneThousand / 2024-06-26T06:00:15Z
…
What is the best way to do that?
Thank you very much!!
Steps taken so far
Parse a json, get the information from the json text and add it a google spreadsheet
