How can I use Looping to create multiple rows in Google Sheets from a parsed email with multiple items?
I want to create a row (or rows) in a google sheet from an email that may have one or more items in it. The email parser looks like it’s working OK and see all of the items in the list. However without a loop it only creates one row in the google sheet, so I though I would add looper, but I can’t figure out how to configure it to actually loop. It stops at 1
Screenshots attached.
Page 1 / 1
Hi @Mary S
NOTE: The free email parser by Zapier is not very robust and if the email template can have a varying number of data points to parse, then the results of the parsed email may not be consistent.
Resources for email parsing:
Zap action: Looping - Create Loop from Line Items
That expects a data points that is an array of line items.
From your screenshots the email parser is returned individual data points:
You can try using this Zap action: Looping - Create Loop from Text
You can map each of the individual data points to their fields and separate each with a |.
Then set | as the Text Delimiter field value.
Hi @Mary S
I just came across this and wanted to check in—did Troy’s reply help you to get things sorted?
If it did, we’d love to mark it as the best answer to help others in the Community find the solution more easily.
And if you’re still running into any trouble, just let us know. We’d be happy to assist further!