Question

Email-ChatGPT-Google Sheets

  • 10 June 2023
  • 2 replies
  • 46 views

Userlevel 1

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. 


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 7
Badge +14

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: [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.

 

Userlevel 1

Thank you, that is very helpful!