Turn array into string for google sheet

hi! I am fairly new to N8N.

Describe the issue/error/question

Im getting this error from the google sheet node when trying to post some URLS on the google sheet ( after upgrading my instance) :

ERROR: Bad request - please check your parameters

My hypothesis is that it is because the iSET node i have before the google sheet is setting an array of URLS instead of a list of string URLS …

I think this might be the issue as it worked before today I upgraded my instance to .

Regardless of the cause my issue is this:

I need to read this input:

"images":
[
{
"id":
39423396118751,
"product_id":
7988875296991,
"position":
1,
"created_at":
"2023-01-24T13:23:45+01:00",
"updated_at":
"2023-01-24T13:23:45+01:00",
"alt":
null,
"width":
1536,
"height":
2048,
"src":
"https://cdn.shopify.com/s/files/1/0209/5389/0880/products/IMG_5203.jpg?v=1674563025",
"variant_ids":
[
],
"admin_graphql_api_id":
"gid://shopify/ProductImage/39423396118751"
},
{
"id":
39423396053215,
"product_id":
7988875296991,
"position":
2,
"created_at":
"2023-01-24T13:23:45+01:00",
"updated_at":
"2023-01-24T13:23:45+01:00",
"alt":
null,
"width":
1536,
"height":
2048,
"src":
"https://cdn.shopify.com/s/files/1/0209/5389/0880/products/IMG_5204_d0883891-3a46-40b4-b7a0-c7855f4bc377.jpg?v=1674563025",
"variant_ids":
[
],
"admin_graphql_api_id":
"gid://shopify/ProductImage/39423396053215"
},
{
"id":
39423395922143,
"product_id":
7988875296991,
"position":
3,
"created_at":
"2023-01-24T13:23:44+01:00",
"updated_at":
"2023-01-24T13:23:45+01:00",
"alt":
null,
"width":
1536,
"height":
2048,
"src":
"https://cdn.shopify.com/s/files/1/0209/5389/0880/products/IMG_5205_cd0c3fb4-d994-401c-af48-b44905f11bbf.jpg?v=1674563025",
"variant_ids":
[
],
"admin_graphql_api_id":
"gid://shopify/ProductImage/39423395922143"
},
{
"id":
39423396151519,
"product_id":
7988875296991,
"position":
4,
"created_at":
"2023-01-24T13:23:46+01:00",
"updated_at":
"2023-01-24T13:23:46+01:00",
"alt":
null,
"width":
1536,
"height":
2048,
"src":
"https://cdn.shopify.com/s/files/1/0209/5389/0880/products/IMG_5206_cf47356b-3daa-499d-8030-2bdae9d5b7bb.jpg?v=1674563026",
"variant_ids":
[
],
"admin_graphql_api_id":
"gid://shopify/ProductImage/39423396151519"
},
{
"id":
39423395889375,
"product_id":
7988875296991,
"position":
5,
"created_at":
"2023-01-24T13:23:44+01:00",
"updated_at":
"2023-01-24T13:23:46+01:00",
"alt":
null,
"width":
1536,
"height":
2048,
"src":
"https://cdn.shopify.com/s/files/1/0209/5389/0880/products/IMG_5207_e8afe982-d156-4325-b107-3ea0958a8068.jpg?v=1674563026",
"variant_ids":
[
],
"admin_graphql_api_id":
"gid://shopify/ProductImage/39423395889375"
},
{
"id":
39423396249823,
"product_id":
7988875296991,
"position":
6,
"created_at":
"2023-01-24T13:23:46+01:00",
"updated_at":
"2023-01-24T13:23:46+01:00",
"alt":
null,
"width":
1536,
"height":
2048,
"src":
"https://cdn.shopify.com/s/files/1/0209/5389/0880/products/IMG_5208_18ef449a-edb6-4a8c-9623-7e5e9f173921.jpg?v=1674563026",
"variant_ids":
[
],
"admin_graphql_api_id":
"gid://shopify/ProductImage/39423396249823"
},
{
"id":
39423396085983,
"product_id":
7988875296991,
"position":
7,
"created_at":
"2023-01-24T13:23:45+01:00",
"updated_at":
"2023-01-24T13:23:46+01:00",
"alt":
null,
"width":
1536,
"height":
2048,
"src":
"https://cdn.shopify.com/s/files/1/0209/5389/0880/products/IMG_5209_67d78d99-b896-491a-8f0d-081fe18709cd.jpg?v=1674563026",
"variant_ids":
[
],
"admin_graphql_api_id":
"gid://shopify/ProductImage/39423396085983"
},
{
"id":
39423396217055,
"product_id":
7988875296991,
"position":
8,
"created_at":
"2023-01-24T13:23:46+01:00",
"updated_at":
"2023-01-24T13:23:46+01:00",
"alt":
null,
"width":
1536,
"height":
2048,
"src":
"https://cdn.shopify.com/s/files/1/0209/5389/0880/products/IMG_5210_adf64a18-467b-4414-bf74-e070eab9d619.jpg?v=1674563026",
"variant_ids":
[
],
"admin_graphql_api_id":
"gid://shopify/ProductImage/39423396217055"
}
],

And get only the URLS on the “src” key in the “SET” node to post tot he google sheet node.

Until today I had done it through this formula in the SET node:
{{$jmespath($json.images, “[*].src” )}}

But today i noticed after i upgraded my instance to “[email protected]” that this formula wasn’t working anymore as I get an array like this:

Instead of a list of all the URLS which is what I want … but this is just a hypothesis .

Please help

What is the error message (if any)?

Please share the workflow

Share the output returned by the last node

Information on your n8n setup

  • n8n version: [email protected]
  • Database you’re using (default: SQLite):
  • Running n8n with the execution process [own(default), main]:
  • Running n8n via [Docker, npm, n8n.cloud, desktop app]: cloud

Hi @oly-dev, I am sorry to hear you are having trouble.

I already got back to you via email. It’d be great if you could avoid opening two separate requests for the same issue going forward.