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
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
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!
The Zappy Awards are back
We're celebrating the Zapier builders making AI transformation happen. Winners get a published story on zapier.com, a trophy, $5,000 cash, and a feature at ZapConnect. Nominate yourself or a peer by July 24th, 2026.
Log in to the Community
No account yet? Create an account
Use your Zapier credentials
Log in with ZapierEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.