Connect to a postgres database and run a query. Format the results into a message and deliver it via SMS, email and/or Slack.
Configure the query_postgres
step with your database connection details and SQL query
Customize the message you want to deliver in the generate_message
step
Connect a Twilio account in the send_sms
step and set the To
and From
fields in E.164 format (e.g., +16175551212)
Then deploy and run a test job, or configure the trigger to run the workflow on a schedule (you can also change the trigger to run the workflow on an HTTP request or email).
email_me
step to send the message to the email account you registered with Pipedreamsend_to_slack