I'm currently working on a Zap where a trigger returns line item data in a comma-separated string format. For example, the quote might include a single field like this:
Codes: A01, B02, C03, D04 Quantities: 1, 2, 3, 4 Prices: 100, 200, 300, 400
What I want to achieve is for Zapier to treat these as four distinct line items in the next step—each with its corresponding code, quantity, and price—so that I can pass them into a table or line item field (e.g. in Xero, Google Sheets, or an invoice tool).
Could you please advise:
-
Whether this kind of transformation is possible natively in Zapier.
-
If yes, what is the best approach? (e.g., Formatter > Text > Split + Looping by Zapier?) Or perhaps int a table
-
If not, do you recommend using a Code step or a third-party tool like Webhooks or a Zapier-integrated parser?
I'd love a step-by-step guide or example setup for handling this type of conversion.
Thanks so much in advance!
