What do you want to automate

with Microsoft Excel and Amazon SES?

Prompt, edit and deploy AI agents that connect to Microsoft Excel, Amazon SES and 2,500+ other apps in seconds.

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

Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo
Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo
Create Email Template with Amazon SES API on New Cell Value Changed from Microsoft Excel API
Microsoft Excel + Amazon SES
 
Try it
Create Email Template with Amazon SES API on New Item Updated (Instant) from Microsoft Excel API
Microsoft Excel + Amazon SES
 
Try it
Create Email Template with Amazon SES API on New Row Added from Microsoft Excel API
Microsoft Excel + Amazon SES
 
Try it
Create Email Template with Amazon SES API on New Spreadsheet Created (Instant) from Microsoft Excel API
Microsoft Excel + Amazon SES
 
Try it
Get Email Template with Amazon SES API on New Cell Value Changed from Microsoft Excel API
Microsoft Excel + Amazon SES
 
Try it
New Cell Value Changed from the Microsoft Excel API

Emit new event when when a specific cell's value changes in an Excel worksheet

 
Try it
New Row Added from the Microsoft Excel API

Emit new event when when a new row is added to an Excel worksheet

 
Try it
New Spreadsheet Created (Instant) from the Microsoft Excel API

Emit new event when a new Excel spreadsheet is created.

 
Try it
New Spreadsheet Updated (Instant) from the Microsoft Excel API

Emit new event when an Excel spreadsheet is updated.

 
Try it
Add a Worksheet Tablerow with the Microsoft Excel API

Adds rows to the end of specific table. See the documentation

 
Try it
Create Email Template with the Amazon SES API

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

 
Try it
Add Row with the Microsoft Excel API

Insert a new row into a specified Excel worksheet. See the documentation

 
Try it
Get Email Template with the Amazon SES API

Get an email template. See the docs

 
Try it
Find Row with the Microsoft Excel API

Find a row by column and value in an Excel worksheet. See the documentation

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

Overview of Microsoft Excel

The Microsoft Excel API on Pipedream allows you to automate spreadsheet tasks, manipulate data, and integrate Excel with other apps and services. Through Pipedream, you can create serverless workflows that react to events, perform operations on Excel files like reading, writing, updating cells, and managing worksheets. This API turns Excel into a powerful tool for data analysis, report generation, and task automation without manual intervention.

Connect Microsoft Excel

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    microsoft_excel: {
      type: "app",
      app: "microsoft_excel",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://graph.microsoft.com/v1.0/me`,
      headers: {
        Authorization: `Bearer ${this.microsoft_excel.$auth.oauth_access_token}`,
      },
    })
  },
})

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

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
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()
  },
})

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

Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo
Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo