Google Sheets - Multiple Rows, fill in the blanks? Shopify - Google Sheets

[AndrewH]

Hey Guys,
I have a sheet that is importing order lines from shopify.
When an order has multiple line items it is correctly making new lines, however date, order number etc do not duplicate into the next rows.
IS it possible to have these items duplicated, so that I can simply run lookups etc from these values?

 

[Pabblymember11]

Hey @AndrewH

Kindly share the workflow URL once in which you have created the workflow so that we can check on it and help you accordingly.

 

[AndrewH]

Hey @AndrewH

Kindly share the workflow URL once in which you have created the workflow so that we can check on it and help you accordingly.

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

 

[AndrewH]

Here is the link - any advise?

 

[Pabblymember11]

I have included a third and fourth step in your workflow. The third step will count the number of line items, and the fourth will replicate it as many times as there are values in each line item.

Please review this and note that you can duplicate the fourth step to repeat the given value.

 

[AndrewH]

Hey - unfortunately it is not working, I'm still getting blanks;

 

[Pabblymember11]

Hey @AndrewH

We have configured the functions to pass the date, order name, and email address to repeat the number of times the line items appear.

You can repeat the same action step for the other entities in your Google Sheets.