Query postgres database and send message to SMS, email and Slack
@pravin
code:
data:privatelast updated:2 years ago
@pravin/
Query postgres database and send message to SMS, email and Slack

Quickstart

  1. Configure the query_postgres step with your database connection details and SQL query

  2. Customize the message you want to deliver in the generate_message step

  3. 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).

Optional

  • Enable the email_me step to send the message to the email account you registered with Pipedream
  • Enable and configure send_to_slack