What's your biggest current challenge? Have your say in Community Polls along the right column.

Re: GetProductData formatting issues with Google Sheets

Solved

GetProductData formatting issues with Google Sheets

specklefarms
Excursionist
37 1 11

I've started a Scheduled Flow to run every day to grab items that have been updated and to dump them into a spreadsheet.

 

However, I'm having issues with the formatting. I'm It looks like it's putting all the items into one cell. I would need each item in the same column, in sequential cells.

 

Is there a syntax guide for this? I'm not a coder and the Shopify Dev site is incredibly dense.

Accepted Solution (1)
paul_n
Shopify Staff
1445 157 334

This is an accepted solution.

The action only adds 1 row at a time. If you need rows, then use a "For each" loop and put the Sheets action inside the loop. That will send one product at a time, assuming you are using "get product data"

Paul_N | Flow Product Manager @ Shopify
- Finding Flow useful? Leave us a review
- Need Flow help? Check out our help docs.
- Building for Flow? Check out Flow's dev docs.

View solution in original post

Replies 4 (4)

paul_n
Shopify Staff
1445 157 334

Use commas to create columns. Something like 

{{ field 1 }}, {{ field2 }}
Paul_N | Flow Product Manager @ Shopify
- Finding Flow useful? Leave us a review
- Need Flow help? Check out our help docs.
- Building for Flow? Check out Flow's dev docs.
specklefarms
Excursionist
37 1 11

I need them in rows.

paul_n
Shopify Staff
1445 157 334

This is an accepted solution.

The action only adds 1 row at a time. If you need rows, then use a "For each" loop and put the Sheets action inside the loop. That will send one product at a time, assuming you are using "get product data"

Paul_N | Flow Product Manager @ Shopify
- Finding Flow useful? Leave us a review
- Need Flow help? Check out our help docs.
- Building for Flow? Check out Flow's dev docs.
specklefarms
Excursionist
37 1 11

Ignore. This works. I used the wrong variable.