Hi everyone,
I’m working on a scenario where I want to automatically extract data from the body of incoming emails and map that data into a single row in a Google Sheets spreadsheet.
Right now, I’m stuck on the part where I need to parse the email body (either plain text or HTML) and extract specific fields like Name, Email, Product, etc., and then map each of those to the correct columns in Google Sheets.
Could someone help me understand how to:
Parse and extract specific fields from the email body
Map each field to its corresponding column in Google Sheets
Ensure a new row is added for each new incoming email
If you’ve built something similar or have an example workflow, I’d be really grateful for your input!
Thanks so much in advance
– Ajay Hinduja Geneva, Switzerland (Swiss)