Find Email with Microsoft Outlook API on New Row Added from Microsoft Excel API

Pipedream makes it easy to connect APIs for Microsoft Outlook, Microsoft Excel and 2,700+ other apps remarkably fast.

Trigger workflow on

New Row Added from the Microsoft Excel API

Next, do this

Find Email with the Microsoft Outlook API

No credit card required

▶

Watch us build a workflow

8 min

Watch now ➜

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

Developers ♥ Pipedream

Getting Started#

This integration creates a workflow with a Microsoft Excel trigger and Microsoft Outlook action. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

Select this integration
Configure the New Row Added trigger
1. Connect your Microsoft Excel account
2. Configure timer
3. Select a Folder ID
4. Select a Sheet ID
5. Select a Worksheet
Configure the Find Email action
1. Connect your Microsoft Outlook account
2. Configure info
3. Optional- Configure Filter
4. Optional- Configure Order By
5. Optional- Configure Max Results
Deploy the workflow
Send a test event to validate your setup
Turn on the trigger

Details#

This integration uses pre-built, source-available components from Pipedream's GitHub repo. These components are developed by Pipedream and the community, and verified and maintained by Pipedream.

To contribute an update to an existing component or create a new component, create a PR on GitHub. If you're new to Pipedream component development, you can start with quickstarts for trigger span and action development, and then review the component API reference.

Trigger#

New Row Added on Microsoft Excel

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

Version:0.0.1

Key:microsoft_excel-new-row-added

View on GitHub

Microsoft Excel Overview#

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.

Trigger Code#

import common from "../common/base-polling.mjs";

export default {
  ...common,
  key: "microsoft_excel-new-row-added",
  name: "New Row Added",
  description: "Emit new event when when a new row is added to an Excel worksheet",
  version: "0.0.1",
  type: "source",
  dedupe: "unique",
  methods: {
    ...common.methods,
    _getRowCount() {
      return this.db.get("rowCount");
    },
    _setRowCount(value) {
      this.db.set("rowCount", value);
    },
    generateMeta(item) {
      const ts = Date.now();
      return {
        id: `${item.address}${ts}`,
        summary: `${item.numRowsAdded} row(s) added`,
        ts,
      };
    },
  },
  async run() {
    const previousRowCount = this._getRowCount();

    const response = await this.microsoftExcel.getUsedRange({
      sheetId: this.sheetId,
      worksheet: this.worksheet,
    });

    const { rowCount } = response;

    this._setRowCount(rowCount);

    if (!previousRowCount || rowCount <= previousRowCount) {
      return;
    }

    response.numRowsAdded = rowCount - previousRowCount;
    this.emitEvent(response);
  },
};

Trigger Configuration#

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI and CLI.

Label	Prop	Type	Description
Microsoft Excel	`microsoftExcel`	`app`	This component uses the Microsoft Excel app.
N/A	`db`	`$.service.db`	This component uses `$.service.db` to maintain state between executions.
	`timer`	`$.interface.timer`
Folder ID	`folderId`	`string`	Select a value from the drop down menu.
Sheet ID	`sheetId`	`string`	Select a value from the drop down menu.
Worksheet	`worksheet`	`string`	Select a value from the drop down menu.

Trigger Authentication#

Microsoft Excel uses OAuth authentication. When you connect your Microsoft Excel account, Pipedream will open a popup window where you can sign into Microsoft Excel and grant Pipedream permission to connect to your account. Pipedream securely stores and automatically refreshes the OAuth tokens so you can easily authenticate any Microsoft Excel API.

Pipedream requests the following authorization scopes when you connect your account:

User.Reademailoffline_accessopenidprofileFiles.ReadWriteFiles.Read.AllUser.ReadCrossTenantInformation.ReadBasic.All

About Microsoft Excel#

You can use Microsoft Graph to allow web and mobile applications to read and modify Excel workbooks stored in OneDrive for Business, SharePoint site or Group drive.

Action#

Find Email on Microsoft Outlook

Description:Search for an email in Microsoft Outlook. [See the documentation](https://learn.microsoft.com/en-us/graph/api/user-list-messages)

Version:0.0.7

Key:microsoft_outlook-find-email

View on GitHub

Microsoft Outlook Overview#

The Microsoft Outlook API on Pipedream allows you to automate email-related tasks, manage calendars, and handle contacts effortlessly. With the API, you can trigger workflows on new emails, send emails programmatically, and synchronize calendars across platforms, among other functions. Pipedream's serverless platform facilitates the connection between Outlook and a myriad of other apps for efficient automation workflows.

Action Code#

import microsoftOutlook from "../../microsoft_outlook.app.mjs";

export default {
  key: "microsoft_outlook-find-email",
  name: "Find Email",
  description: "Search for an email in Microsoft Outlook. [See the documentation](https://learn.microsoft.com/en-us/graph/api/user-list-messages)",
  version: "0.0.7",
  type: "action",
  props: {
    microsoftOutlook,
    info: {
      type: "alert",
      alertType: "info",
      content: "When you specify `$filter`, the service infers a sort order for the results. If you use both `$orderby` and `$filter` to get messages, because the server always infers a sort order for the results of a `$filter`, you must [specify properties in certain ways](https://learn.microsoft.com/en-us/graph/api/user-list-messages#using-filter-and-orderby-in-the-same-query).",
    },
    filter: {
      type: "string",
      label: "Filter",
      description: "Filters results. For example, `contains(subject, 'meet for lunch?')` will include messages whose subject contains ‘meet for lunch?’. [See documentation](https://learn.microsoft.com/en-us/graph/filter-query-parameter) for the full list of operations.",
      optional: true,
    },
    orderBy: {
      type: "string",
      label: "Order By",
      description: "Order results by a property. For example, `receivedDateTime desc` will order messages by the received date in descending order.",
      optional: true,
    },
    maxResults: {
      propDefinition: [
        microsoftOutlook,
        "maxResults",
      ],
    },
  },
  async run({ $ }) {
    const items = this.microsoftOutlook.paginate({
      fn: this.microsoftOutlook.listMessages,
      args: {
        $,
        params: {
          "$filter": this.filter,
          "$orderby": this.orderBy,
        },
      },
      max: this.maxResults,
    });

    const emails = [];
    for await (const item of items) {
      emails.push(item);
    }

    $.export("$summary", `Successfully retrieved ${emails.length} message${emails.length != 1
      ? "s"
      : ""}.`);
    return emails;
  },
};

Action Configuration#

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI.

Label	Prop	Type	Description
Microsoft Outlook	`microsoftOutlook`	`app`	This component uses the Microsoft Outlook app.
Filter	`filter`	`string`	Filters results. For example, `contains(subject, 'meet for lunch?')` will include messages whose subject contains ‘meet for lunch?’. See documentation for the full list of operations.
Order By	`orderBy`	`string`	Order results by a property. For example, `receivedDateTime desc` will order messages by the received date in descending order.
Max Results	`maxResults`	`integer`	The maximum number of results to return

Action Authentication#

Microsoft Outlook uses OAuth authentication. When you connect your Microsoft Outlook account, Pipedream will open a popup window where you can sign into Microsoft Outlook and grant Pipedream permission to connect to your account. Pipedream securely stores and automatically refreshes the OAuth tokens so you can easily authenticate any Microsoft Outlook API.

Pipedream requests the following authorization scopes when you connect your account:

User.Reademailoffline_accessopenidprofileMail.ReadWriteMail.SendMailboxSettings.ReadWriteIMAP.AccessAsUser.AllPOP.AccessAsUser.AllSMTP.SendCalendars.ReadWriteContacts.ReadWrite

About Microsoft Outlook#

Microsoft Outlook lets you bring all your email accounts and calendars in one convenient spot.

More Ways to Connect Microsoft Outlook + Microsoft Excel#

Other Popular Integrations#

Update Worksheet Tablerow with Microsoft Excel API on New Contact Event (Instant) from Microsoft Outlook API

Microsoft Outlook + Microsoft Excel

Find Email with Microsoft Outlook API on New Row Added from Microsoft Excel API

Pipedream makes it easy to connect APIs for Microsoft Outlook, Microsoft Excel and 2,700+ other apps remarkably fast.

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

Developers ♥ Pipedream

1-24of2,700+apps by most popular

1
-
24
of
2,700+
apps by most popular