Question

SQL Trigger to generate SQL query and save output to Amazon S3 to be emailed

  • 18 May 2021
  • 1 reply
  • 49 views


Hello everybody. 

I am new to Zapier and would like to create the following workflow:

 1) I want to regularly check if report is ready to send.
So: Trigger: New or updated row in MySQL. 
Let's say trigger noticed the report number 100 is ready. 


2)  Then I am querying SQL 
select * from x 
where project_id= {{project_id. }} (variable).

 

3)  Then I would like to save output of SQL query to S3. 

 

4) Then  I want to send an email  with a link to S3. 

 

Is it doable in Zapier?


 


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

1 reply

Userlevel 7
Badge +10

Hi @AndrewZap 

Sometimes it is best to test the integration for desired results. To get you started check out the ways people connect MySQL and Amazon S3 https://zapier.com/apps/mysql/integrations/amazon-s3

MySQL does have a new row trigger that supports custom queries. 

Amazon S3 has actions for Uploading a File or creating a text document. 

and Zapier supports sending emails with Outlook & Gmail 

so at a high level your integration looks possible but will come down to the specifics of what is returned from each step.