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:
I think it’s possible. Just haven’t really run a query in zapier. I usually run them in phpmyadmin
Best answer by DanversBest answer by Danvers
Hi
It is possible 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!
+12Hi
It is possible 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!
Thank you!
Yes, that is a bummer that only 1 row would be returned.
Thank you anyway
+1Hi
I sent you a PM.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
