Integrate the Database API with the Amazon SES API

Setup the Database API trigger to run a workflow which integrates with the Amazon SES API. Pipedream's integration platform allows you to integrate Database and Amazon SES remarkably fast. Free for developers.

Start for free — no credit card required

Watch a demo

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Popular Database and Amazon SES Actions#

Query SQL Database with the Database API

Execute a SQL Query. See our docs to learn more about working with SQL in Pipedream.

Try it

Create Email Template with the Amazon SES API

Create a HTML or a plain text email template. See the docs

Try it

Get Email Template with the Amazon SES API

Get an email template. See the docs

Try it

Send Email with the Amazon SES API

Send an email using Amazon SES. Supports simple email messaging. See the docs

Try it

Send Templated Email with the Amazon SES API

Send an email replacing the template tags with values using Amazon SES. See the docs

Try it

Overview of Database#

The Database API on Pipedream allows users to execute SQL commands directly within workflows, enabling rich and dynamic data manipulation and storage. It supports PostgreSQL, MySQL, and SQLite, making it a versatile option for managing data across various database systems. With this API, users can perform tasks such as data insertion, querying, updates, and deletions, directly within their automations, facilitating real-time data processing and integration across multiple platforms.

Connect Database#

import postgresql from "@pipedream/postgresql";

export default {
  props: {
    postgresql,
    sql: {
      type: "sql",
      auth: {
        app: "postgresql",
      },
      label: "PostreSQL Query",
    },
  },
  async run({ $ }) {
    const args = this.postgresql.executeQueryAdapter(this.sql);
    const data = await this.postgresql.executeQuery(args);
    return data;
  },
};

Overview of Amazon SES#

Amazon Simple Email Service (SES) is a powerful cloud-based email sending service designed to help digital marketers and application developers send marketing, notification, and transactional emails. With the SES API, you can reliably send emails at scale, manage sender reputations, view email sending statistics, and maintain a high deliverability rate. Leveraging Pipedream's capabilities, you can integrate SES seamlessly into serverless workflows, automate email responses based on triggers from other apps, and analyze the effectiveness of your email campaigns by connecting to data analytics platforms.

Connect Amazon SES#

module.exports = defineComponent({
  props: {
    amazon_ses: {
      type: "app",
      app: "amazon_ses",
    }
  },
  async run({steps, $}) {
    const AWS = require("aws-sdk")
    const { accessKeyId, secretAccessKey } = this.amazon_ses.$auth
    
    const ses = new AWS.SES({
      accessKeyId, 
      secretAccessKey,
      region: 'us-east-1',
    })
    
    const sesParams = {
      Destination: {
        ToAddresses: ["<your email here>"],
      }, 
      Message: {
        Body: {
          Html: {
            Charset: "UTF-8", 
            Data: "<h1>This is a test</h1>",
          }, 
            Text: {
            Charset: "UTF-8", 
            Data: "This is a test",
          }
        }, 
        Subject: {
          Charset: "UTF-8", 
          Data: "Test email",
        }
      },
      Source: "<your from address here", 
    };
    
    this.resp = await ses.sendEmail(sesParams).promise()
  },
})

Start for free — no credit card required

Watch a demo