How can I use Flow to add order rows to a Google sheet?

Shopify Plus
2

The Sheets action does one row at a time. We are looking to make it possible to do each lineItem as a row, but there is a way to do this now. Basically you need to separate each line item by a delimiter like “##” and then split the row in Sheets using a script.

Here is a sample Sheet that has the script, which you can copy to your account. FYI, the script is under “Apps Script” in the “Extensions” menu

https://docs.google.com/spreadsheets/d/1w9qSHe_hccBQ90dSPSVESWTFNWhdLhgMmtq6VE5ZPRA/edit?usp=sharing

2 Likes