List Events with Microsoft Outlook Calendar API on New Page Opened from Google Analytics API

Pipedream makes it easy to connect APIs for Microsoft Outlook Calendar, Google Analytics and 2,900+ other apps remarkably fast.

Trigger workflow on

New Page Opened from the Google Analytics API

Next, do this

List Events with the Microsoft Outlook Calendar 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 Google Analytics trigger and Microsoft Outlook Calendar action. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

Select this integration
Configure the New Page Opened trigger
1. Connect your Google Analytics account
2. Configure timer
3. Configure View Id
Configure the List Events action
1. Connect your Microsoft Outlook Calendar account
2. Optional- Configure Filter
3. Optional- Configure Order By
4. Optional- Configure Max Results
5. Optional- Configure Include Recurring
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 Page Opened on Google Analytics

Description:Emit new event when a page is viewed

Version:0.1.1

Key:google_analytics-page-opened

View on GitHub

Google Analytics Overview#

The Google Analytics API unlocks the power of your analytics data, enabling automated access to custom reports, real-time statistics, and user behavior analysis. With it, you can extract actionable insights, push data to other platforms, and tailor your business strategy with precision. Leveraging Pipedream's serverless platform, these capabilities can be seamlessly integrated into workflows that trigger actions in other apps, send alerts, or even feed data warehouses for deeper analysis.

Trigger Code#

import analytics from "../../google_analytics.app.mjs";
import { DEFAULT_POLLING_SOURCE_TIMER_INTERVAL } from "@pipedream/platform";
import utils from "../../common/utils.mjs";

export default {
  key: "google_analytics-page-opened",
  version: "0.1.1",
  name: "New Page Opened",
  description: "Emit new event when a page is viewed",
  type: "source",
  dedupe: "unique",
  props: {
    analytics,
    db: "$.service.db",
    timer: {
      type: "$.interface.timer",
      default: {
        intervalSeconds: DEFAULT_POLLING_SOURCE_TIMER_INTERVAL,
      },
    },
    viewId: {
      propDefinition: [
        analytics,
        "viewId",
      ],
    },
  },
  hooks: {
    async deploy() {
      const startDate = utils.monthAgo();
      this._setStartDate(startDate);
      await this.processEvent();
    },
  },
  methods: {
    _getPageViews() {
      return this.db.get("pageViews");
    },
    _setPageViews(pageViews) {
      this.db.set("pageViews", pageViews);
    },
    _getStartDate() {
      return this.db.get("startDate");
    },
    _setStartDate(startDate) {
      this.db.set("startDate", startDate);
    },
    generateMeta(pageViews, startDate) {
      const ts = Date.now();
      return {
        id: ts,
        summary: `${pageViews} page views since ${startDate}`,
        ts,
      };
    },
    async processEvent() {
      const startDate = this._getStartDate();
      const data = {
        resource: {
          reportRequests: [
            {
              viewId: this.viewId,
              dateRanges: [
                {
                  startDate,
                  endDate: "today",
                },
              ],
              metrics: [
                {
                  expression: "ga:pageviews",
                },
              ],
            },
          ],
        },
      };
      const { data: report } = await this.analytics.queryReports(data);

      const previousPageViews = this._getPageViews();
      const pageViews = report.reports[0].data.totals[0].values[0];

      if (!previousPageViews || pageViews > previousPageViews) {
        this._setPageViews(pageViews);
        const meta = this.generateMeta(pageViews, startDate);
        this.$emit(report, meta);
      }
    },
  },
  async run() {
    await this.processEvent();
  },
};

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
Google Analytics	`analytics`	`app`	This component uses the Google Analytics app.
N/A	`db`	`$.service.db`	This component uses `$.service.db` to maintain state between executions.
	`timer`	`$.interface.timer`
View Id	`viewId`	`string`	ID of the view to monitor. Can be found on your Google Analytics Dashboard -> Admin -> View Setting

Trigger Authentication#

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

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

emailprofilehttps://www.googleapis.com/auth/analytics.edithttps://www.googleapis.com/auth/analytics.readonly

About Google Analytics#

Google Analytics enables you to measure and report on user activity on websites, web and mobile apps, and internet-connected devices.

Action#

List Events on Microsoft Outlook Calendar

Description:Get a list of event objects in the user's mailbox. [See the documentation](https://learn.microsoft.com/en-us/graph/api/user-list-events)

Version:0.0.4

Key:microsoft_outlook_calendar-list-events

View on GitHub

Microsoft Outlook Calendar Overview#

The Microsoft Outlook Calendar API provides programmatic access to a user's calendar events, allowing for the creation, retrieval, update, and deletion of events within Outlook calendars. With Pipedream, you can integrate these calendar operations into workflows that automate tasks involving scheduling, event management, and coordination with other services. Whether it's triggering actions when new events are created, syncing calendar events with other scheduling tools, or managing attendees, Pipedream's serverless platform enables you to build custom automations with minimal overhead.

Action Code#

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

export default {
  key: "microsoft_outlook_calendar-list-events",
  name: "List Events",
  description: "Get a list of event objects in the user's mailbox. [See the documentation](https://learn.microsoft.com/en-us/graph/api/user-list-events)",
  version: "0.0.4",
  annotations: {
    destructiveHint: false,
    openWorldHint: true,
    readOnlyHint: true,
  },
  type: "action",
  props: {
    microsoftOutlook,
    filter: {
      type: "string",
      label: "Filter",
      description: "Filters results. For example, `contains(subject, 'meet for lunch?')` will include events whose title 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: "Orders results. For example, `displayName desc` will sort the results by Display Name in decending order.",
      default: "createdDateTime desc",
      optional: true,
    },
    maxResults: {
      type: "integer",
      label: "Max Results",
      description: "The maximum number of results to return",
      optional: true,
    },
    includeRecurring: {
      type: "boolean",
      label: "Include Recurring",
      description: "Whether to include recurring events",
      optional: true,
      reloadProps: true,
    },
  },
  additionalProps() {
    if (!this.includeRecurring) {
      return {};
    }
    return {
      startDateTime: {
        type: "string",
        label: "Start Date Time",
        description: "The start date and time of the time range, represented in ISO 8601 format. For example, `2019-11-08T19:00:00-08:00`",
      },
      endDateTime: {
        type: "string",
        label: "End Date Time",
        description: "The end date and time of the time range, represented in ISO 8601 format. For example, `2019-11-08T20:00:00-08:00`",
      },
    };
  },
  async run({ $ }) {
    const params = {
      "$orderby": this.orderBy,
      "$filter": this.filter,
      "$top": this.maxResults,
    };

    const { value = [] } = !this.includeRecurring
      ? await this.microsoftOutlook.listCalendarEvents({
        $,
        params,
      })
      : await this.microsoftOutlook.listCalendarView({
        $,
        params: {
          ...params,
          startDateTime: this.startDateTime,
          endDateTime: this.endDateTime,
        },
      });

    const events = !this.includeRecurring
      ? value.filter((event) => !event.recurrence)
      : value;

    $.export("$summary", `Successfully retrieved ${events.length} event${events.length === 1
      ? ""
      : "s"}`);

    return events;
  },
};

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 Calendar	`microsoftOutlook`	`app`	This component uses the Microsoft Outlook Calendar app.
Filter	`filter`	`string`	Filters results. For example, `contains(subject, 'meet for lunch?')` will include events whose title contains ‘meet for lunch?’. See documentation for the full list of operations.
Order By	`orderBy`	`string`	Orders results. For example, `displayName desc` will sort the results by Display Name in decending order.
Max Results	`maxResults`	`integer`	The maximum number of results to return
Include Recurring	`includeRecurring`	`boolean`	Whether to include recurring events

Action Authentication#

Microsoft Outlook Calendar uses OAuth authentication. When you connect your Microsoft Outlook Calendar account, Pipedream will open a popup window where you can sign into Microsoft Outlook Calendar 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 Calendar API.

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

User.Reademailoffline_accessopenidprofileCalendars.ReadWrite

About Microsoft Outlook Calendar#

The calendar and scheduling component of Outlook that is fully integrated with email, contacts, and other features

More Ways to Connect Microsoft Outlook Calendar + Google Analytics#

Other Popular Integrations#

Create Calendar Event with Microsoft Outlook Calendar API on New Page Opened from Google Analytics API

Google Analytics + Microsoft Outlook Calendar

Try it

Update Calendar Event with Microsoft Outlook Calendar API on New Page Opened from Google Analytics API

Google Analytics + Microsoft Outlook Calendar

Try it

Delete Calendar Event with Microsoft Outlook Calendar API on New Page Opened from Google Analytics API

Google Analytics + Microsoft Outlook Calendar

Try it

Get Free/Busy Schedule with Microsoft Outlook Calendar API on New Page Opened from Google Analytics API

Google Analytics + Microsoft Outlook Calendar

Try it

Run Report with Google Analytics API on New Calendar Event (Instant) from Microsoft Outlook Calendar API

Microsoft Outlook Calendar + Google Analytics

Try it

Popular Triggers#

New Page Opened from the Google Analytics API

Emit new event when a page is viewed

Try it

New Calendar Event (Instant) from the Microsoft Outlook Calendar API

Emit new event when a new Calendar event is created

Try it

New Calendar Event Update (Instant) from the Microsoft Outlook Calendar API

Emit new event when a Calendar event is updated

Try it

New Upcoming Calendar Event from the Microsoft Outlook Calendar API

Emit new event when a Calendar event is upcoming, this source is using reminderMinutesBeforeStart property of the event to determine the time it should emit.

Try it

Popular Actions#

Create GA4 Property with the Google Analytics API

Creates a new GA4 property. See the documentation

Try it

Create Key Event with the Google Analytics API

Creates a new key event. See the documentation

Try it

Run Report with the Google Analytics API

Return report metrics based on a start and end date. See the documentation

Try it

Run Report in GA4 with the Google Analytics API

Returns a customized report of your Google Analytics event data. Reports contain statistics derived from data collected by the Google Analytics tracking code. See the documentation

Try it

Create Calendar Event with the Microsoft Outlook Calendar API

Create an event in the user's default calendar. See the documentation

Try it