Skip to main content

I have an MYSQL database connected to Zapier.

It’s my order table

Each order has a order_id

I’d like to only search the last 200 lines

For a specific  order for order_status that equals the number 20

Then, send an email via my connected GMAIL to a colleague

 

Is that possible?

Hello! Yes - It should be possible - Are you running into any particular problems here?

Only possible in zapier if there is one such row. If there are more, then the query will not retrieve all the information.

Hi, @IcarusZaps! If you were able to find the query that you needed for this, we’d love to hear about it 🙂

Terms & Conditions