Hello Zapier Community,
I am working on an automation project and could use some advice on how to best approach a particular challenge. My goal is to automate a process that involves parsing an email body with multiple items, extracting those items, and then looking them up in a Google Sheet. Here's a brief overview of what I'm trying to accomplish:
Process Overview
Trigger: A Google Form submission, containing fields for the sender's email and the body of the email. The email body includes requests for pricing on multiple items, formatted like "Please send me your prices for 1x ZB2BY4953 and 2x ZB2BY9330."
Parsing Email Body: I need to parse the email body to extract individual items and their quantities. Each item is identified by a unique code (e.g., ZB2BY4953).
Looking Up Items in Google Sheets: Each extracted item needs to be looked up in a Google Sheet to retrieve item details like price, name, etc. The item code corresponds to a column in the sheet.
Output: The final step is to create a new row in a Google Sheet with the details of all the requested items.
Challenges
- I'm not sure how to handle the parsing of multiple items in the email body using Zapier.
- I need a way to loop through each extracted item to perform the Google Sheets lookup.
Question
- How can I set up Zapier to parse multiple items from an email body and then loop through each item to perform a lookup in Google Sheets?
- Are there any specific apps or features within Zapier that I should use for this purpose?
- Any guidance, tips, or suggestions on how to set up this workflow would be greatly appreciated!
Thank you in advance for your help!
Best regards,
David