ExploreConnectDocsChangelogPricingTemplatesPartnersString
Sign in
Sign up
← Microsoft Outlook + Trustpilot (Customer) integrations

Fetch Service Reviews with Trustpilot (Customer) API on New Email Event (Instant) from Microsoft Outlook API

Pipedream makes it easy to connect APIs for Trustpilot (Customer), Microsoft Outlook and 2,800+ other apps remarkably fast.

Trigger workflow on
New Email Event (Instant) from the Microsoft Outlook API
Next, do this
Fetch Service Reviews with the Trustpilot (Customer) API
No credit card required
Intro to Pipedream
▶
Watch us build a workflow
Watch us build a workflow
8 min
Watch now ➜

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

Developers ♥ Pipedream

Getting Started

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

  1. Select this integration
  2. Configure the New Email Event (Instant) trigger
    1. Connect your Microsoft Outlook account
    2. Configure Webhook renewal timer
    3. Optional- Select one or more Folder IDs to Monitor
  3. Configure the Fetch Service Reviews action
    1. Connect your Trustpilot (Customer) account
    2. Select a Business Unit ID
    3. Optional- Configure Language
    4. Optional- Configure Page
    5. Optional- Configure Star Rating
    6. Optional- Configure Internal Location ID
    7. Optional- Configure Per Page
    8. Optional- Select a Order By
    9. Optional- Configure Tag Group
    10. Optional- Configure Tag Value
    11. Optional- Configure Ignore Tag Value Case
    12. Optional- Configure Responded
    13. Optional- Configure Reference ID
    14. Optional- Configure Referral Email
    15. Optional- Configure Reported
    16. Optional- Configure Start Date Time
    17. Optional- Configure End Date Time
    18. Optional- Configure Source
    19. Optional- Configure Username
    20. Optional- Select a Find Reviewer
  4. Deploy the workflow
  5. Send a test event to validate your setup
  6. 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 Email Event (Instant) on Microsoft Outlook
Description:Emit new event when an email is received in specified folders.
Version:0.1.2
Key:microsoft_outlook-new-email

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.

Trigger Code

import md5 from "md5";
import common from "../common/common-new-email.mjs";
import sampleEmit from "./test-event.mjs";

export default {
  ...common,
  key: "microsoft_outlook-new-email",
  name: "New Email Event (Instant)",
  description: "Emit new event when an email is received in specified folders.",
  version: "0.1.2",
  type: "source",
  dedupe: "unique",
  methods: {
    ...common.methods,
    async getSampleEvents({ pageSize }) {
      const folders = this.folderIds?.length
        ? this.folderIds.map((id) => `/me/mailFolders/${id}/messages`)
        : [
          "/me/messages",
        ];

      const results = [];
      for (const folder of folders) {
        const { value: messages } = await this.microsoftOutlook.listMessages({
          resource: folder,
          params: {
            $top: pageSize,
            $orderby: "createdDateTime desc",
          },
        });
        results.push(...messages);
      }
      return results;
    },
    emitEvent(item) {
      if (this.isRelevant(item)) {
        this.$emit(
          {
            email: item,
          },
          this.generateMeta(item),
        );
      }
    },
    generateMeta(item) {
      return {
        id: md5(item.id), // id > 64 characters, so dedupe on hash of id
        summary: `New email (ID:${item.id})`,
        ts: Date.parse(item.createdDateTime),
      };
    },
  },
  async run(event) {
    const folders = this.folderIds?.length
      ? this.folderIds.map((id) => `/me/mailFolders/${id}/messages`)
      : [
        "/me/messages",
      ];

    for (const folder of folders) {
      await this.run({
        event,
        emitFn: async ({ resourceId } = {}) => {
          try {
            const item = await this.microsoftOutlook.getMessage({
              resource: folder,
              messageId: resourceId,
            });
            if (item.hasAttachments) {
              const attachments = await this.getMessageAttachments(item);
              item.attachments = attachments;
            }
            this.emitEvent(item);
          } catch {
            console.log(`Could not fetch message with ID: ${resourceId}`);
          }
        },
      });
    }
  },
  sampleEmit,
};

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.
LabelPropTypeDescription
Microsoft OutlookmicrosoftOutlookappThis component uses the Microsoft Outlook app.
N/Ahttp$.interface.httpThis component uses $.interface.http to generate a unique URL when the component is first instantiated. Each request to the URL will trigger the run() method of the component.
N/Adb$.service.dbThis component uses $.service.db to maintain state between executions.
Webhook renewal timertimer$.interface.timer

Graph API expires Outlook notifications in 3 days, we auto-renew them in 2 days, see

Folder IDs to MonitorfolderIdsstring[]Select a value from the drop down menu.

Trigger 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.

Action

Fetch Service Reviews on Trustpilot (Customer)
Description:Get private reviews for a business unit. Response includes customer email and order ID. [See the documentation](https://developers.trustpilot.com/business-units-api#get-private-reviews-for-business-unit)
Version:0.1.0
Key:trustpilot-fetch-service-reviews

Trustpilot (Customer) Overview

The Trustpilot (Customer) API lets you tap into the rich pool of customer review data on Trustpilot. You can use it to automate the process of collecting and managing reviews, responding to feedback, and analyzing customer sentiment. With Pipedream's integration, you can trigger workflows based on new reviews, aggregate review data for analysis, and sync Trustpilot data with other services like CRMs, support tickets, and marketing tools.

Action Code

import trustpilot from "../../trustpilot.app.mjs";

export default {
  key: "trustpilot-fetch-service-reviews",
  name: "Fetch Service Reviews",
  description: "Get private reviews for a business unit. Response includes customer email and order ID. [See the documentation](https://developers.trustpilot.com/business-units-api#get-private-reviews-for-business-unit)",
  version: "0.1.0",
  type: "action",
  props: {
    trustpilot,
    businessUnitId: {
      propDefinition: [
        trustpilot,
        "businessUnitId",
      ],
    },
    language: {
      propDefinition: [
        trustpilot,
        "language",
      ],
    },
    page: {
      type: "integer",
      label: "Page",
      description: "The page to retrieve. If the page number requested is higher than the available number of pages, an empty array will be returned.",
      min: 1,
      default: 1,
      optional: true,
    },
    stars: {
      type: "string",
      label: "Star Rating",
      description: "Filter by reviews with a specific star rating. 1-5, separated by commas.",
      optional: true,
    },
    internalLocationId: {
      type: "string",
      label: "Internal Location ID",
      description: "Filter by reviews with a specific location",
      optional: true,
    },
    perPage: {
      type: "integer",
      label: "Per Page",
      description: "The number of reviews to retrieve per page",
      min: 1,
      max: 100,
      default: 20,
      optional: true,
    },
    orderBy: {
      type: "string",
      label: "Order By",
      description: "The order in which the results should be sorted",
      options: [
        {
          label: "Created At (Ascending)",
          value: "createdat.asc",
        },
        {
          label: "Created At (Descending)",
          value: "createdat.desc",
        },
        {
          label: "Stars (Ascending)",
          value: "stars.asc",
        },
        {
          label: "Stars (Descending)",
          value: "stars.desc",
        },
      ],
      default: "createdat.desc",
      optional: true,
    },
    tagGroup: {
      type: "string",
      label: "Tag Group",
      description: "Filtering reviews on Tag group",
      optional: true,
    },
    tagValue: {
      type: "string",
      label: "Tag Value",
      description: "Filtering reviews on Tag value",
      optional: true,
    },
    ignoreTagValueCase: {
      type: "boolean",
      label: "Ignore Tag Value Case",
      description: "Ignore tag value case",
      default: false,
      optional: true,
    },
    responded: {
      type: "boolean",
      label: "Responded",
      description: "Filter reviews by responded state",
      optional: true,
    },
    referenceId: {
      type: "string",
      label: "Reference ID",
      description: "Filter reviews by reference Id",
      optional: true,
    },
    referralEmail: {
      type: "string",
      label: "Referral Email",
      description: "Filter reviews by referral email",
      optional: true,
    },
    reported: {
      type: "boolean",
      label: "Reported",
      description: "Filter reviews by reported state",
      optional: true,
    },
    startDateTime: {
      type: "string",
      label: "Start Date Time",
      description: "Filter reviews by datetime range. If no time is specified, then time is implicitly `00:00:00`. Format: `2013-09-07T13:37:00`",
      optional: true,
    },
    endDateTime: {
      type: "string",
      label: "End Date Time",
      description: "Filter reviews by datetime range. If no time is specified, then time is implicitly `00:00:00`. Format: `2013-09-07T13:37:00`",
      optional: true,
    },
    source: {
      type: "string",
      label: "Source",
      description: "Filter reviews by source",
      optional: true,
    },
    username: {
      type: "string",
      label: "Username",
      description: "Filter reviews by user name",
      optional: true,
    },
    findReviewer: {
      type: "string",
      label: "Find Reviewer",
      description: "Filter reviews by Find Reviewer requests (contacted or not contacted)",
      options: [
        "contacted",
        "notContacted",
      ],
      optional: true,
    },
  },
  async run({ $ }) {
    const {
      businessUnitId,
      stars,
      language,
      page = 1,
      internalLocationId,
      perPage = 20,
      orderBy = "createdat.desc",
      tagGroup,
      tagValue,
      ignoreTagValueCase = false,
      responded,
      referenceId,
      referralEmail,
      reported,
      startDateTime,
      endDateTime,
      source,
      username,
      findReviewer,
    } = this;

    try {
      // Use the shared method from the app
      const result = await this.trustpilot.fetchServiceReviews($, {
        businessUnitId,
        stars,
        language,
        page,
        internalLocationId,
        perPage,
        orderBy,
        tagGroup,
        tagValue,
        ignoreTagValueCase,
        responded,
        referenceId,
        referralEmail,
        reported,
        startDateTime,
        endDateTime,
        source,
        username,
        findReviewer,
      });

      $.export("$summary", `Successfully fetched ${result.reviews.length} service review(s) for business unit ${businessUnitId}`);

      return result;
    } catch (error) {
      throw new Error(`Failed to fetch service reviews: ${error.message}`);
    }
  },
};

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.

LabelPropTypeDescription
Trustpilot (Customer)trustpilotappThis component uses the Trustpilot (Customer) app.
Business Unit IDbusinessUnitIdstringSelect a value from the drop down menu.
Languagelanguagestring

Filter reviews by language (ISO 639-1 code)

Pagepageinteger

The page to retrieve. If the page number requested is higher than the available number of pages, an empty array will be returned.

Star Ratingstarsstring

Filter by reviews with a specific star rating. 1-5, separated by commas.

Internal Location IDinternalLocationIdstring

Filter by reviews with a specific location

Per PageperPageinteger

The number of reviews to retrieve per page

Order ByorderBystringSelect a value from the drop down menu:{ "label": "Created At (Ascending)", "value": "createdat.asc" }{ "label": "Created At (Descending)", "value": "createdat.desc" }{ "label": "Stars (Ascending)", "value": "stars.asc" }{ "label": "Stars (Descending)", "value": "stars.desc" }
Tag GrouptagGroupstring

Filtering reviews on Tag group

Tag ValuetagValuestring

Filtering reviews on Tag value

Ignore Tag Value CaseignoreTagValueCaseboolean

Ignore tag value case

Respondedrespondedboolean

Filter reviews by responded state

Reference IDreferenceIdstring

Filter reviews by reference Id

Referral EmailreferralEmailstring

Filter reviews by referral email

Reportedreportedboolean

Filter reviews by reported state

Start Date TimestartDateTimestring

Filter reviews by datetime range. If no time is specified, then time is implicitly 00:00:00. Format: 2013-09-07T13:37:00

End Date TimeendDateTimestring

Filter reviews by datetime range. If no time is specified, then time is implicitly 00:00:00. Format: 2013-09-07T13:37:00

Sourcesourcestring

Filter reviews by source

Usernameusernamestring

Filter reviews by user name

Find ReviewerfindReviewerstringSelect a value from the drop down menu:contactednotContacted

Action Authentication

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

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

About Trustpilot (Customer)

Read reviews. Write reviews. Find companies you can trust.

More Ways to Connect Trustpilot (Customer) + Microsoft Outlook

Other Popular Integrations

Fetch Service Reviews with Trustpilot (Customer) API on New Attachment Received (Instant) from Microsoft Outlook API
Microsoft Outlook + Trustpilot (Customer)
 
Try it
Fetch Service Reviews with Trustpilot (Customer) API on New Contact Event (Instant) from Microsoft Outlook API
Microsoft Outlook + Trustpilot (Customer)
 
Try it
Fetch Product Reviews with Trustpilot (Customer) API on New Attachment Received (Instant) from Microsoft Outlook API
Microsoft Outlook + Trustpilot (Customer)
 
Try it
Fetch Product Reviews with Trustpilot (Customer) API on New Contact Event (Instant) from Microsoft Outlook API
Microsoft Outlook + Trustpilot (Customer)
 
Try it
Fetch Product Reviews with Trustpilot (Customer) API on New Email Event (Instant) from Microsoft Outlook API
Microsoft Outlook + Trustpilot (Customer)
 
Try it

Popular Triggers

New Attachment Received (Instant) from the Microsoft Outlook API

Emit new event when a new email containing one or more attachments arrives in a specified Microsoft Outlook folder.

 
Try it
New Contact Event (Instant) from the Microsoft Outlook API

Emit new event when a new Contact is created

 
Try it
New Email Event (Instant) from the Microsoft Outlook API

Emit new event when an email is received in specified folders.

 
Try it
New Email in Shared Folder Event from the Microsoft Outlook API

Emit new event when an email is received in specified shared folders.

 
Try it
New Conversations from the Trustpilot (Customer) API

Emit new event when a new conversation is started on Trustpilot. This source periodically polls the Trustpilot API to detect new customer-business conversations. Each event contains conversation details including participants, subject, business unit, and creation timestamp. Useful for tracking customer inquiries, support requests, and maintaining real-time communication with customers.

 
Try it

Popular Actions

Add Label to Email with the Microsoft Outlook API

Adds a label/category to an email in Microsoft Outlook. See the documentation

 
Try it
Approve Workflow with the Microsoft Outlook API

Suspend the workflow until approved by email. See the documentation

 
Try it
Create Contact with the Microsoft Outlook API

Add a contact to the root Contacts folder, See the documentation

 
Try it
Create Draft Email with the Microsoft Outlook API

Create a draft email, See the documentation

 
Try it
Download Attachment with the Microsoft Outlook API

Downloads an attachment to the /tmp directory. See the documentation

 
Try it

Explore Other Apps

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

HTTP / Webhook
HTTP / Webhook
Get a unique URL where you can send HTTP or webhook requests
Node
Node
Anything you can do with Node.js, you can do in a Pipedream workflow. This includes using most of npm's 400,000+ packages.
Python
Python
Anything you can do in Python can be done in a Pipedream Workflow. This includes using any of the 350,000+ PyPi packages available in your Python powered workflows.
Schedule
Schedule
Trigger workflows on an interval or cron schedule.
Pipedream Utils
Pipedream Utils
Utility functions to use within your Pipedream workflows
Notion
Notion
Notion is a new tool that blends your everyday work apps into one. It's the all-in-one workspace for you and your team.
OpenAI (ChatGPT)
OpenAI (ChatGPT)
OpenAI is an AI research and deployment company with the mission to ensure that artificial general intelligence benefits all of humanity. They are the makers of popular models like ChatGPT, DALL-E, and Whisper.
Anthropic (Claude)
Anthropic (Claude)
AI research and products that put safety at the frontier. Introducing Claude, a next-generation AI assistant for your tasks, no matter the scale.
Google Sheets
Google Sheets
Use Google Sheets to create and edit online spreadsheets. Get insights together with secure sharing in real-time and from any device.
Telegram
Telegram
Telegram, is a cloud-based, cross-platform, encrypted instant messaging (IM) service.
Google Drive
Google Drive
Google Drive is a file storage and synchronization service which allows you to create and share your work online, and access your documents from anywhere.
Google Calendar
Google Calendar
With Google Calendar, you can quickly schedule meetings and events and get reminders about upcoming activities, so you always know what’s next.
Shopify
Shopify
Shopify is a complete commerce platform that lets anyone start, manage, and grow a business. You can use Shopify to build an online store, manage sales, market to customers, and accept payments in digital and physical locations.
Supabase
Supabase
Supabase is an open source Firebase alternative.
MySQL
MySQL
MySQL is an open-source relational database management system.
PostgreSQL
PostgreSQL
PostgreSQL is a free and open-source relational database management system emphasizing extensibility and SQL compliance.
Premium
AWS
AWS
Amazon Web Services (AWS) offers reliable, scalable, and inexpensive cloud computing services.
Premium
Twilio SendGrid
Twilio SendGrid
Send marketing and transactional email through the Twilio SendGrid platform with the Email API, proprietary mail transfer agent, and infrastructure for scalable delivery.
Amazon SES
Amazon SES
Amazon SES is a cloud-based email service provider that can integrate into any application for high volume email automation
Premium
Klaviyo
Klaviyo
Email Marketing and SMS Marketing Platform
Premium
Zendesk
Zendesk
Zendesk is award-winning customer service software trusted by 200K+ customers. Make customers happy via text, mobile, phone, email, live chat, social media.
Premium
ServiceNow
ServiceNow
The smarter way to workflow
Slack
Slack
Slack is a channel-based messaging platform. With Slack, people can work together more effectively, connect all their software tools and services, and find the information they need to do their best work — all within a secure, enterprise-grade environment.
Microsoft Teams
Microsoft Teams
Microsoft Teams has communities, events, chats, channels, meetings, storage, tasks, and calendars in one place.
abcdefghijklmnopqrstuvwxyz#
Pipedream, Inc. — San Francisco, CA
AboutTwitterDocsCommunityTermsPrivacyTry String