About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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 use AI to generate email responses based on a live Google Sheets stock list?
Question

How do I use AI to generate email responses based on a live Google Sheets stock list?

  • 4 November 2023
  • 5 replies
  • 64 views
A
Userlevel 1
Badge

Hi

 

possibly not strictly speaking a zapier question but

 

i want to be able to have an AI generate email responses to inbound sales emails with reference to a live stock list in google sheets.

 

we are a property company and we rent out music studios  

 

email in: hi - do you have any music studios available?

 

response: hi - yes we have three music studios available they are 100, 200 and 300 square feet and they are all available from November 1st. 
 

any advice greatly appreciated!

 

thanks

 

 

 

 

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

5 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @ABABAB 

Good question.

You can add Zap steps to find records in a GSheet to then use the returned row(s) data in the AI prompt.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
A
Userlevel 1
Badge

Thanks as ever for your reply @Troy Tessalone 

When you say the “AI prompt”, what exactly do you mean by this?

 

I’m hoping you mean the AI that is crafting our email responses?

 

Thank you 

Troy Tessalone
Userlevel 7
Badge +14

@ABABAB 

You need to provide a prompt to the AI for how to draft email responses.

e.g. draft an email response based on this info that is 3 sentences in length.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
A
Userlevel 1
Badge

Amazing thanks 

 

How would I make a zap that would do this?

 

Starting with the trigger “receive email”

 

thanks so much 

ken.a
Userlevel 7
Badge +6

Hi @ABABAB,

I’m jumping in to see if I can help!

Here is how I see the Zap for the workflow that you have in mind:

  1. Trigger: Gmail - New Email
  2.  Action: Google Sheets - Lookup Spreadsheet Row
  3. Action: ChatGPT - New Conversation
  4. Action: Gmail - Send Email

Please note that this is only my rough estimate on how you should set up your desired workflow. With that being said, I’d recommend reaching out to one of our certified Zapier Experts that can help streamline your workflow. You can reach our Zapier Experts here: https://zapier.com/experts

Hopefully, this helps!

Terms & Conditions