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 create a GPT that adds user's email and responses to a Google Sheets row and triggers email flow?

As Custom GPTs will become public I am wanting to create a GPT that creates a new spreadsheet row on Google Sheets when a user submits their email and provides a response to further questions.

 

ie User starts chat and to proceed they will need to confirm whether they are a subscriber with their email address. They will then submit their email which I would then want to be added to a new Google Sheet row. Once added to a new row I will then setup a Zapier flow to send the user a confirmation email and a code, which they can then input into the GPT to proceed and engage further.

 

Is this possible as I know there is a lot that can be done with AI Actions but just need some further guidance around Google Sheets and being able to have anyone engage with the GPT and be able to subscribe and engage with the GPT.

Hi @abarrell2, welcome to the Community! 👋

Am I correct in assuming that the Google Sheet spreadsheet that the GPT will be checking and writing to is one that the user will not have access to?

Asking as the AI action will want to connect to the spreadsheet using the user’s own account details, not yours:
e0dbfc07425240054661257a52f16c2b.png

If it needs to connect to your own private Google Sheets spreadsheet then I wonder if Zapier ChatBots (beta) might work better for the desired workflow. It can be embedded you could put on a page that requires the subscriber to be logged in to gain access to it. Once logged in, subscribers could then have an conversation with the chatbot and actions could be set up to trigger a Zap to carry out any necessary actions. We’ve got a tutorial on How to create a custom AI chatbot with Zapier which might be helpful in setting that up.

Do you think that sort of approach might work? If I’ve misunderstood things or you run into any trouble on that at all just let us know! 🙂

Terms & Conditions