Connect to a postgres database and run a query. Format the results into a message and deliver it via SMS, email and/or Slack.
query_postgres step with your database connection details and SQL query
Customize the message you want to deliver in the
Connect a Twilio account in the
send_sms step and set the
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_mestep to send the message to the email account you registered with Pipedream