Skip to main content

I tried to connect Google Sheets to ChatGPT through Zap, but it keeps failing.
Even with the simplest prompt, the new API, and every model, it still fails. (+ I even tried turning my laptop off and on again.)
What do I have to do to fix this problem?

 

Hi ​@yunjeong 

Help links for using ChatGPT/OpenAI app in Zaps: https://zapier.com/apps/chatgpt/integrations#help


Hey ​@yunjeong, just checking in 👋 Did the guides Troy shared a link to help to get that error fixed?

If not, perhaps it’s unable to process the request as it doesn’t understand the instructions it’s been given. It looks like “Hello” has been used as the input for both the User Message and Instructions fields:

87d31b602d38278d725d8973fe78b06b.png
If you adjust the prompting to give ChatGPT clear instructions on what you’re expecting it to do does that help to get rid of the error?

Looking forward to hearing from you!


Hey ​@yunjeong 
Please provide clear instructions for ChatGPT. The trigger will be data coming from a Google Sheet. Once ChatGPT receives the input from the Google Sheet, explain exactly what ChatGPT should do with that input.