Split Product SKU, Color, Size, and Quantity from an email into multiple rows

1

Okay, so when a customer places an order on our website, it sends us a copy of their order confirmation.

I’m using Zapier to add these emails to a coda table.

I’m wanting to parse the email body to pull the products that were ordered into another table, so I can account for each order/item/color/size combination on it’s own row.

Does anyone know how to make a row button create several rows in a different table?

I tried using a combination of runactions(), formulamap() and addrow(), but just haven’t been able to get it to work.

Here is a link to the sample doc I made:

Let me know if there’s anything I can clarify.

Thanks,
Chris

2

I think I’m getting somewhere using Paul_Danyliuk’s while loop:

Now I just need to put the right data in the right column. Will still be a pretty big project, but I think that loop was the missing component.

3

Mission accomplished:

4

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