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.

Question

How to connect GoogleSheets to GPT and send response with Gmail?

  • October 23, 2024
  • 2 replies
  • 15 views
K

Hi, How do I automate this process:

  1. Send new response row from GoogleFormSheets to ChatGPT, with a prompt describing how to process data. 
  2. Send response that is generated by ChatGPT to PDF format. PDF page should be formatted in my predefined way (logo, footnote...).
  3. Send PDF as a attachment from my Gmail to an email adress received in a form. Mail should include my predefined, nonpersonalized text content.

Thank you for any support!

Kuba

Did this topic help you find an answer to your question?
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

JammerS
Forum|alt.badge.img+6
  • JammerSZapier Staff
  • Zapier Staff
  • 2435 replies
  • October 24, 2024

Hi @Kuba.1,

 

Welcome to the Community.

 

You can automate generating and sending PDFs based on Google Form responses using Google Apps Script, Zapier, and a PDF generation service. First, set up a trigger in Google Apps Script to initiate a function whenever a new form response is submitted, which then sends the response to ChatGPT via the OpenAI API. After receiving the ChatGPT response, use a PDF generation service like PDFMonkey or DocSpring to create a PDF. Finally, use Google Apps Script to email the PDF as an attachment to the email address in the form response. While this is a high-level overview, detailed coding and setup will be necessary for implementation.

SamB
Community Manager
Forum|alt.badge.img+11
  • SamBCommunity Manager
  • Community Manager
  • 7597 replies
  • October 30, 2024

Hi @Kuba.1!

Just wanted to check in here to see how things are progressing. Did Jammer’s reply help to get you pointed in the right direction?

Happy to lend a hand if you’d like any further help on this, just let us know! 🙂

Terms & Conditions