Hello, I’m trying to use Flow to export an order’s line items to a google sheet - to then be uploaded as csv file for dropship fulfillment. Is there a way to use flow to populate the spreadsheet in the same formatting a when we export order csv files directly from the admin? I’m currently only ge…

To output the delimiter except on the last item you could replace ## with: {% if forloop.last %}{% else %}##{% endif %} You might also be able to write, but I haven’t tested: {% unless forloop.last %}##{% endunless %}

hi @paul_n i have test the script, but it gave me an error, any idea ? 10:40:04 AM Notice Execution started 10:40:04 AM Error TypeError: Cannot read property ‘length’ of undefined result [email removed] Code.gs:14

You might need to get that answered by an expert in Google Sheets. It seems to suggest that something is missing in the data. But it requires lots more info to troubleshoot.

Hi Paul, I am having a slight issue with my flow path to google sheets. I see Shopify flow creates a new column for every “,” (comma) its sees. The problem I am having is that I have a lot of my product titles with commas in them; therefore its creating unwanted columns. I used you google script wh…

You need to find and replace commas like: {{ order.title | replace:',', '' }}

You would put the | replace part after any field name you are using that might have commas

i have test this but always give me a ## output at the end, what i’m a doing wrong ? {{order.name}}, {% for lineItems_item in order.lineItems %}{% if lineItems_item.product.totalInventory <= 0 %}{{lineItems_item.name}}::{{lineItems_item.currentQuantity}}{% if forloop.last %}{% else %}##{% endif %}…

The script is incomplete it seems; you need to first receive the trigger from Sheets when a row is added. I think it should be this - it works on manual row additions, but it’s not working from Sheets yet for me: function onEdit(e) { const outputSheetName = "Copy of Transactions" const spreadsheet …

(onEdit is a reserved trigger / callback in google App Scripts)

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

Shopify Plus

Manny98 September 19, 2022, 6:05pm 11

Where would I place that code?

Topic		Replies	Views
Exporting Fulfilled orders data to google sheets Shopify Plus flow	10	350	July 17, 2023
Shopify Flow inserts all data in one row in Google Sheets Shopify Plus	21	462	March 11, 2025
Shopify Flow: export orders to Google Sheets (one liner per order, even if multiple products ordered Shopify Plus Tacking-Tools	13	370	February 4, 2025
Shopify flow: Add line items to Google Sheets rows when a new order is placed error Shopify Plus seo	1	114	February 24, 2025
Shopify Flow - Orders to Google Sheet Variable Question Shopify Apps shopify-apps	1	70	April 8, 2024

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

Related topics