Hey everyone. I am trying to get my emails to be summarized by chatgpt then loaded to my google sheets document. Right now I can only get the test function to work. When I published the zap it has not worked since i have received emails since. On top of that the summarize includes a lot of code which is confusing. See attachments.
Question
Email-ChatGPT-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.
+14- Zapier Orchestrator & Solution Partner
Hi
Good question.
Help resources about using AI with Zaps: https://community.zapier.com/p/ai
The output of ChatGPT/OpenAI will only be as good as the prompt it’s provided.
One issue is that you have the dynamic variables all merged together.
You should put one on each line and include a static label for each.
e.g. Subject: [SUBJECT]
The Body content includes HTML.
It may be useful to add this Zap step first: Formatter > Text > Remove HTML Tags
You also have all the ChatGPT fields being merged into 1 GSheet field.
You probably want 1 column per field.
ZapConnect 2026 is coming
Join us September 23rd, 2026 for a free, one-day virtual event with 30+ sessions on AI automation. Get live build-alongs, playbooks, and strategies to lead AI transformation at your organization.
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.