Is this possible: Spreadsheet update to Search MYSQL to Email

Question

I am familair with MYSQL queries and also familiar with zapier tasks when a spreadsheet updates.

Wondering if this is possible:

When our recieved inventory spreadsheet has a new row the zap would:

Search for the item name in our MYSQL order database
Return all the matches from the MYSQL DB (only customer name, email, telephone, state)
email us the results

I think it’s possible. Just haven’t really run a query in zapier. I usually run them in phpmyadmin

Danvers · Accepted Answer

Hi @IcarusZaps!Itispossible to run a query in MySQL using Zapier BUT the big caveat is that it will only return one row as opposed to all rows that match the query. So in this use case, I’m not sure that Zapier will be able to help you.As discussed in this post:We do have a feature request open for the ability to return multiple rows on a MySQL query. I’ve added you as an interested user on that feature request so that if the team adds that in, we’ll send you an email (we’ll also update the thread above).Sorry that I don’t have better news for you on that one!

IcarusZaps · Answer

Thank you!Yes, that is a bummer that only 1 row would be returned.Thank you anyway

Useful links

Code of conduct

Using the Community

Community expectations

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded