Skip to main content

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. 

Hi @Garrett P 

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: cSUBJECT]

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.

 


Thank you, that is very helpful!