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.

Best answer

Getting Alexa to echo data from MySQL database

  • 3 November 2022
  • 3 replies
  • 246 views
D

Hi, I'm trying to get Alexa to provide some data from a MySQL database. The test action gets a row of data: Six values. But, I can't publish the zap. Steps:

 

1. Trigger Phrase Spoken in Amazon Alexa - gets green tick

Alexa app chosen

Trigger Phrase Spoken Three phrases

2. Find Row via Custom Query in MySQL - gets green tick

Tested and a full row of six values are received

The Zap status says I need to add another step.

I want Alexa to read out the values.

Any idea what that step may be?

 

 

icon

Best answer by Danvers 3 November 2022, 14:15

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

3 replies

Danvers
Userlevel 7
Badge +12

Hi @Doug Packer, welcome to the Community!

The Alexa trigger can be used to start a Zap, but it’s not possible to send a command/information back to Alexa. In this case, you’re seeing the error because the Zap has started and found the row in SQL but then doesn’t have anywhere to send the information. 

I understand that you want Alexa to read the information back to you, but unfortunately that’s not possible with the Zapier Alexa integration. You could have the Zap send you an email/text/other notification with the information. If you’re technically minded, you could also take a look at building an Alexa ‘Skill’ using the Alexa developer documentation. If you’re able to create a skill that can receive information from a webhook, you could add a webhook step on the end of your Zap that will send the information to Alexa that way. 

I hope that helps, let us know if you have any questions!

R
Userlevel 4
Badge +7

Hey there @Doug Packer, looking at what our Alexa app supports I only see it offering a trigger step, and no actions: https://zapier.com/apps/amazon-alexa/integrations#triggers-and-actions

Because of this, Zapier does not have an official way of sending data BACK to Alexa.  Taking a look at the Alexa API, during a quick perusal of this information I don’t see any methods that they support sending data back to Alexa via API.  There may be a way but I don’t see a clear path forward in general, and can confirm there is no action in our Alexa app to do what you wish presently.  Sorry to not have better news!

D

Thanks folks -

Indeed I did use Zapier to send the data in an email, which did show me how to make a Zap work, but that doesn’t fit the need.

I’ll look at the developer documentation and see if I can develop a skill.

 

Cheers :-) 

Terms & Conditions