← Microsoft Outlook + ClickFunnels integrations

Update or Create Contact with ClickFunnels API on New Contact Event (Instant) from Microsoft Outlook API

Pipedream makes it easy to connect APIs for ClickFunnels, Microsoft Outlook and 3,000+ other apps remarkably fast.

Trigger workflow on
New Contact Event (Instant) from the Microsoft Outlook API
Next, do this
Update or Create Contact with the ClickFunnels 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 ClickFunnels 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 Contact Event (Instant) trigger
    1. Connect your Microsoft Outlook account
    2. Configure Webhook renewal timer
  3. Configure the Update or Create Contact action
    1. Connect your ClickFunnels account
    2. Select a Team Id
    3. Select a Workspace Id
    4. Configure Email
    5. Optional- Configure First Name
    6. Optional- Configure Last Name
    7. Optional- Configure Phone Number
    8. Optional- Configure Time Zone
    9. Optional- Configure FB URL
    10. Optional- Configure Twitter URL
    11. Optional- Configure Instagram URL
    12. Optional- Configure Linkedin URL
    13. Optional- Configure Website URL
    14. Optional- Select one or more Tag Ids
    15. Optional- Configure Custom Attributes
  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

Description:Emit new event when a new Contact is created
Version:0.0.21
Key:microsoft_outlook-new-contact

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 common from "../common/common.mjs";

export default {
  ...common,
  key: "microsoft_outlook-new-contact",
  name: "New Contact Event (Instant)",
  description: "Emit new event when a new Contact is created",
  version: "0.0.21",
  type: "source",
  hooks: {
    ...common.hooks,
    async activate() {
      await this.activate({
        changeType: "created",
        resource: "/me/contacts",
      });
    },
    async deactivate() {
      await this.deactivate();
    },
  },
  methods: {
    ...common.methods,
    async getSampleEvents({ pageSize }) {
      return this.microsoftOutlook.listContacts({
        params: {
          $top: pageSize,
          $orderby: "createdDateTime desc",
        },
      });
    },
    emitEvent(item) {
      this.$emit({
        contact: item,
      }, this.generateMeta(item));
    },
    generateMeta(item) {
      return {
        id: item.id,
        summary: `New contact (ID:${item.id})`,
        ts: Date.parse(item.createdDateTime),
      };
    },
  },
  async run(event) {
    await this.run({
      event,
      emitFn: async ({ resourceId } = {}) => {
        const item = await this.microsoftOutlook.getContact({
          contactId: resourceId,
        });
        this.emitEvent(item);
      },
    });
  },
};

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

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.ReadWriteUser.ReadBasic.All

About Microsoft Outlook

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

Action

Description:Searches for a contact by email and updates it, or creates a new one if not found. [See the documentation](https://developers.myclickfunnels.com/reference/upsertcontact)
Version:0.0.2
Key:clickfunnels-update-create-contact

ClickFunnels Overview

The ClickFunnels API lets you interact programmatically with your ClickFunnels account, giving you control over your funnels, contacts, purchases, and more. With Pipedream, you can automate workflows that respond to a variety of triggers, such as new contacts or purchases. By connecting ClickFunnels with other apps available on Pipedream, you can streamline your sales process, sync data across platforms, and create powerful marketing automation.

Action Code

import clickfunnels from "../../clickfunnels.app.mjs";
import {
  clearObj, parseObject,
} from "../../common/utils.mjs";

export default {
  key: "clickfunnels-update-create-contact",
  name: "Update or Create Contact",
  description: "Searches for a contact by email and updates it, or creates a new one if not found. [See the documentation](https://developers.myclickfunnels.com/reference/upsertcontact)",
  version: "0.0.2",
  annotations: {
    destructiveHint: true,
    openWorldHint: true,
    readOnlyHint: false,
  },
  type: "action",
  props: {
    clickfunnels,
    teamId: {
      propDefinition: [
        clickfunnels,
        "teamId",
      ],
    },
    workspaceId: {
      propDefinition: [
        clickfunnels,
        "workspaceId",
        ({ teamId }) => ({
          teamId,
        }),
      ],
    },
    email: {
      propDefinition: [
        clickfunnels,
        "email",
      ],
    },
    firstName: {
      type: "string",
      label: "First Name",
      description: "The contact's first name.",
      optional: true,
    },
    lastName: {
      type: "string",
      label: "Last Name",
      description: "The contact's last name.",
      optional: true,
    },
    phoneNumber: {
      type: "string",
      label: "Phone Number",
      description: "The contact's phone number.",
      optional: true,
    },
    timeZone: {
      type: "string",
      label: "Time Zone",
      description: "The contact's time zone.",
      optional: true,
    },
    fbUrl: {
      type: "string",
      label: "FB URL",
      description: "The contact's Facebook URL.",
      optional: true,
    },
    twitterUrl: {
      type: "string",
      label: "Twitter URL",
      description: "The contact's twitter URL.",
      optional: true,
    },
    instagramUrl: {
      type: "string",
      label: "Instagram URL",
      description: "The contact's instagram URL.",
      optional: true,
    },
    linkedinUrl: {
      type: "string",
      label: "Linkedin URL",
      description: "The contact's linkedin URL.",
      optional: true,
    },
    websiteUrl: {
      type: "string",
      label: "Website URL",
      description: "The contact's website URL.",
      optional: true,
    },
    tagIds: {
      propDefinition: [
        clickfunnels,
        "tagId",
        ({ workspaceId }) => ({
          workspaceId,
        }),
      ],
      optional: true,
      type: "string[]",
      label: "Tag Ids",
      description: "An empty array is ignored here. If you wish to remove all tags for a Contact, use the Update Contact endpoint. A non-empty array overwrites the existing array.",
    },
    customAttributes: {
      type: "object",
      label: "Custom Attributes",
      description: `Custom attributes are usually added in ClickFunnels to a contact when they submit forms that contain custom contact attributes. Here you can directly create them during contact modification.
        Custom attributes are provided as key-value pairs:
        A key that does not exist, will create a new custom contact attribute.
        A key that already exists, will update the value of an existing custom contact attribute.
        Empty or null values, will set the custom attribute values to empty strings. A key that has special characters or spaces will be automatically converted to snake_case (For example, 'Favorite Food! 🥑' will be converted to 'favorite_food').
        Empty keys will trigger a bad request response. Also, non-object inputs for custom_attributes(e.g. an array or string), it will be ignored.
        Keys that are default properties on the Contact resource or variations of it will result in an error. E.g., 'first_name', 'First Name', etc. are not valid inputs.
        `,
      optional: true,
    },
  },
  async run({ $ }) {
    const {
      data, status,
    } = await this.clickfunnels.upsertContact({
      $,
      returnFullResponse: true,
      workspaceId: this.workspaceId,
      data: {
        contact: clearObj({
          email_address: this.email,
          first_name: this.firstName,
          last_name: this.lastName,
          phone_number: this.phoneNumber,
          time_zone: this.timeZone,
          fb_url: this.fbUrl,
          twitter_url: this.twitterUrl,
          instagram_url: this.instagramUrl,
          linkedin_url: this.linkedinUrl,
          website_url: this.websiteUrl,
          tag_ids: parseObject(this.tagIds),
          custom_attributes: parseObject(this.customAttributes),
        }),
      },
    });

    $.export("$summary", `Contact with Id: ${data.id} has been ${status === 200
      ? "updated"
      : "created"} successfully.`);
    return data;
  },

};

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
ClickFunnelsclickfunnelsappThis component uses the ClickFunnels app.
Team IdteamIdstringSelect a value from the drop down menu.
Workspace IdworkspaceIdstringSelect a value from the drop down menu.
Emailemailstring

The email address of the contact

First NamefirstNamestring

The contact's first name.

Last NamelastNamestring

The contact's last name.

Phone NumberphoneNumberstring

The contact's phone number.

Time ZonetimeZonestring

The contact's time zone.

FB URLfbUrlstring

The contact's Facebook URL.

Twitter URLtwitterUrlstring

The contact's twitter URL.

Instagram URLinstagramUrlstring

The contact's instagram URL.

Linkedin URLlinkedinUrlstring

The contact's linkedin URL.

Website URLwebsiteUrlstring

The contact's website URL.

Tag IdstagIdsstring[]Select a value from the drop down menu.
Custom AttributescustomAttributesobject

Custom attributes are usually added in ClickFunnels to a contact when they submit forms that contain custom contact attributes. Here you can directly create them during contact modification.
Custom attributes are provided as key-value pairs:
A key that does not exist, will create a new custom contact attribute.
A key that already exists, will update the value of an existing custom contact attribute.
Empty or null values, will set the custom attribute values to empty strings. A key that has special characters or spaces will be automatically converted to snake_case (For example, 'Favorite Food! 🥑' will be converted to 'favorite_food').
Empty keys will trigger a bad request response. Also, non-object inputs for custom_attributes(e.g. an array or string), it will be ignored.
Keys that are default properties on the Contact resource or variations of it will result in an error. E.g., 'first_name', 'First Name', etc. are not valid inputs.

Action Authentication

ClickFunnels uses API keys for authentication. When you connect your ClickFunnels account, Pipedream securely stores the keys so you can easily authenticate to ClickFunnels APIs in both code and no-code steps.

About ClickFunnels

Marketing funnels made easy.

More Ways to Connect ClickFunnels + Microsoft Outlook

Apply Tag to Contact with ClickFunnels API on New Contact Event (Instant) from Microsoft Outlook API
Microsoft Outlook + ClickFunnels
 
Try it
Apply Tag to Contact with ClickFunnels API on New Email Event (Instant) from Microsoft Outlook API
Microsoft Outlook + ClickFunnels
 
Try it
Remove Tag from Contact with ClickFunnels API on New Contact Event (Instant) from Microsoft Outlook API
Microsoft Outlook + ClickFunnels
 
Try it
Remove Tag from Contact with ClickFunnels API on New Email Event (Instant) from Microsoft Outlook API
Microsoft Outlook + ClickFunnels
 
Try it
Update or Create Contact with ClickFunnels API on New Email Event (Instant) from Microsoft Outlook API
Microsoft Outlook + ClickFunnels
 
Try it
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 Contact Identified (Instant) from the ClickFunnels API

Emit new event when a fresh or formerly anonymous contact is identified via email address or contact number.

 
Try it
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
3,000+
apps by most popular

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.
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.
HTTP / Webhook
HTTP / Webhook
Get a unique URL where you can send HTTP or webhook requests
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.
Schedule
Schedule
Trigger workflows on an interval or cron schedule.
Pipedream Utils
Pipedream Utils
Utility functions to use within your Pipedream workflows
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.
AWS
AWS
Premium
Amazon Web Services (AWS) offers reliable, scalable, and inexpensive cloud computing services.
Twilio SendGrid
Twilio SendGrid
Premium
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
Klaviyo
Klaviyo
Premium
Klaviyo unifies your data, channels, and AI agents in one platform—text, WhatsApp, email marketing, and more—driving growth with every interaction.
Zendesk
Zendesk
Premium
Zendesk is award-winning customer service software trusted by 200K+ customers. Make customers happy via text, mobile, phone, email, live chat, social media.
ServiceNow
ServiceNow
Premium
Beta
The smarter way to workflow
Slack
Slack
Slack is the AI-powered platform for work bringing all of your conversations, apps, and customers together in one place. Around the world, Slack is helping businesses of all sizes grow and send productivity through the roof.
Microsoft Teams
Microsoft Teams
Microsoft Teams has communities, events, chats, channels, meetings, storage, tasks, and calendars in one place.