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

•@psavkar•

•code:

•data:private•last updated:5 years ago

@psavkar/

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 with your database connection details and SQL query
Customize the message you want to deliver in the generate_message
Connect a Twilio account in the send_sms step (there is currently no built-in service for SMS)

Optional

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