Query postgres database and send message to SMS, email and Slack

•@pravin•

•code:

•data:private•last updated:6 years ago

@pravin/

Query postgres database and send message to SMS, email and Slack

Connect to a postgres database and run a query. Format the results into a message and deliver it via SMS, email and/or Slack.

Quickstart

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

Optional

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