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.
⚡ Troy Tessalone - AutomationAce.com | Platinum Zapier Solution Partner | #1 Zapier Community Contributor
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.