Hi there,
I would like to know how can i filter information from the email body plain to a google sheet. Instead of adding all the information of the body plain, i would like to add only specific information to my google sheet, since the emails contain the same template just changing some specific characteristics.
Thank you, have a nice day.
Question
Filter information from emails to Google Sheets
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+6- Zapier Staff
- 3527 replies
Hi
Welcome to the Community.
Thanks for your question! Please set up a trigger using your email app (like Gmail or Email by Zapier) to extract info from email bodies and add it to Google Sheets. If your emails follow a template, use Email Parser by Zapier to highlight and extract key information. Optionally, add a filter to narrow which emails get processed. Then, set up a Google Sheets action to create a new row, map the parsed data to the correct columns, test the Zap, and turn it on to automate the process.
Feel free to ask if you need further help or have additional questions. We're here to assist you.
- Beginner
- 58 replies
Hey! Yes, you can totally do that.
Since your emails follow a consistent format, you can use the Formatter by Zapier → Text → Extract step to pull out just the specific fields you need (like name, date, etc.), then send only those to your Google Sheet.
Let me know if you want help setting up the extract rules — happy to guide you!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.