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.

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.