Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • How Do I
  • How do I configure ChatGPT 4 to email analysis or insert it into a Google Docs formatted according to the template?

Hello, I am trying to make an automation that initiates when a Google Form is completed. This Zap should automatically convert the form responses into a CSV file. Following this, a new ChatGPT-4 thread should be generated, where this CSV file is uploaded along with a specific prompt for analysis.  

Subsequently, I would like the analysis provided by ChatGPT-4 to be either emailed directly to me or, preferably, inserted into a Google Document. This document should be formatted according to a predefined template which ChatGPT-4 can refer to for structuring the response appropriately.

I really don't know if it is possible... any help would be appreciated!

Hi there @Harvie, welcome to the Community! 👋

Yes, that should be possible! Perhaps you could try an app like EasyCSV that has a Create CSV File action to create the CSV file itself. Then from there, the ChatGPT app has a Conversation with Assistant action that would allow you to upload the file as well as give it a prompt for the analysis of the file. See our Use OpenAI's Assistants API with your Zaps for more details on OpenAI's Assistants API actions in your Zaps. And the Google Docs app has a Create Document from Text action (or a Create Document from Template action) that could be used to save the analysis in a new file. Or you could use it’s Append Text to Document if it needs to be added to an existing file.

Hope that helps to get you pointed in the right direction. Please do let us know if I’ve misunderstood your requirements here or if you run trouble on that at all! 

Terms & Conditions