Loading
Loading
  • Home

  • Automation with Zapier

  • Zapier tutorials

Zapier tutorials

9 min read

How to integrate ChatGPT with Microsoft Outlook

By Elena Alston · July 12, 2023
Screenshot of outlook and chatgpt logos on a lilac background

Since Zapier started integrating with ChatGPT, I've been discovering new ways to optimize my many workflows with AI. From writing blog posts—and publishing them—to helping me write product descriptions and adding them to Google Sheets, AI is a handy assistant. 

Yet one of the biggest challenges I face at work involves my email inbox. Whether it's responding to emails, retrieving tasks from team members, or even making sure company announcements don't get lost in the mix, integrating my email tool (Microsoft Outlook) with ChatGPT via Zapier was a no-brainer. I've discovered a ton of handy use cases that make sure I'm always on top of my inbox—and my workload. 

New to Zapier? It's workflow automation software that lets you focus on what matters. Combine user interfaces, data tables, and logic with 6,000+ apps to build and automate anything you can imagine. Sign up for free.

Table of contents

To get started with a Zap template—what we call our pre-made workflows—just click on the button. It only takes a few minutes to set up. You can read more about setting up Zaps here.

Popular ways to integrate Microsoft Outlook with ChatGPT

There are plenty of ways to integrate Microsoft Outlook and ChatGPT. If there's a tedious, manual task you do every day (like writing emails to customers at scale), you can easily use ChatGPT to write automatic responses based on your own instructions. Here are some of the most popular ways to automate Outlook and ChatGPT. 

To get started with a Zap template—what we call our pre-made workflows—just click on the button. It only takes a few minutes to set up. You can read more about setting up Zaps here.

Store conversations or customer information for later

Whenever you chat with ChatGPT directly on chat.openai.com, it stores your conversations in the left hand panel. The ChatGPT Zapier integration also has the ability to remember and "store" conversations in a similar way—within your Zaps.

It does this when you provide a specific memory key (like an email address or ID number) inside your Zaps. That's extremely handy in the context of leads or clients, as you could create 10 different "conversations" about the same client across different Zaps and apps, and ChatGPT will remember them in future scenarios.  

For example, imagine a specific customer, called John Doe, emails you with a question. You could have a Zap set up with ChatGPT that remembers the context from that email. 

You might also have other Zaps that process Zendesk tickets or CRM updates. By using the same memory key (in this case John Doe's email address) inside these Zaps, ChatGPT can associate the conversations with that specific person, allowing it to remember the context of a conversation. 

You could then build a Zap with John's specific memory key that asks ChatGPT to create a profile based on all the things ChatGPT now "knows" about John from the context it's gathered through those separate Zaps. 

Create ChatGPT conversations from new Microsoft Outlook emails

Create ChatGPT conversations from new Microsoft Outlook emails
  • Microsoft Outlook logo
  • ChatGPT logo
Microsoft Outlook + ChatGPT

Analyze and write email responses at scale

Let's face it: in a lot of cases, those emails you're writing on a daily basis are carbon copies of each other. Whether you're answering customer questions, reaching out to leads, or following up on a project with your team, you can use these Zaps to automatically write and send email responses based on a template or instructions you give ChatGPT.

You can also personalize these Zaps further by prompting ChatGPT to analyze incoming emails based on a lead's level of interest in your product, for example. You can also ask it to identify email as spam or mark it as urgent, and even create templated responses that include calendar links so folks can book time with you. 

Create email summaries

Staying on top of my email inbox daily struggle. Between important company information that gets sent out to customer emails that require immediate attention, things can easily get lost in the mix. So if you spend too much time skimming emails days after they're sent out, these Zaps can help. 

They keep you organized by creating digests of email summaries or summarizing specific emails and then sharing that information in an app you do regularly use—like Slack. 

Get an AI-generated daily digest of your emails in Slack

Get an AI-generated daily digest of your emails in Slack
  • Microsoft Outlook logo
  • Slack logo
Microsoft Outlook + ChatGPT + Digest by Zapier + 1 more

Retrieve tasks from emails

Ever get sent emails from a team member asking you to do something? Instead of manually copying and pasting project information into your task management tool, you can set up these Zaps to do the heavy lifting for you. 

ChatGPT can take a task you're sent, summarize it, pinpoint collaborators, or even add outlines and a brief. The  Zap will then automatically add that info to your project management tool. Whether you're extracting tasks word-for-word or adding more context, you can stay on top of your emails—and your tasks.  

Add contact details—and context—to your CRM

Prospects generally reach out in a number of ways. If a lead fills out one of your forms, for example, you'll usually receive an email notification with those details. Or perhaps a potential customer reached out directly to your support email with a question. Whatever the case, you can use ChatGPT to extract that data and add it to your CRM or database with additional context—helping you to stay on top of your most important contacts.  

Write and publish blog posts  

Have a specific email thread set up to manage your blog content? Whether you receive emails from your team about specific blog ideas or you get notified via email any time a specific blog post is requested, you can use ChatGPT to help you produce an entire article, from meta titles to blog content. 

Even if you're just using something as simple as the subject line to indicate the blog post topic, you can set up these Zaps to create the meta descriptions, gather the SEO keywords, write the post, and even publish the article in your content management system. 

Manage your calendar 

Ever felt like you need a personal assistant to manage your calendar?

Whether you want to schedule automated follow-ups after specific calls with clients or  receive detailed notifications (with additional context) in Teams or Slack when a new calendar event is created, you can use these Zaps to help. 

ChatGPT can draft follow up emails based on a template you give it or send personalized, human-sounding notifications in Slack to help you stay on top of your schedule. 

Connect Microsoft Outlook with ChatGPT

As you can see, there are a lot of ways to integrate Microsoft Outlook and ChatGPT using Zapier. For the sake of this tutorial though, we're going to focus on one of the workflows we mentioned above—analyzing a lead's email and updating those details in your CRM. 

Before you begin

Before you create a Zap that integrates Microsoft Outlook with ChatGPT, you'll need to create a Zapier account if you don't have one already. Don't worry, creating an account is easy and free. You'll also need an Microsoft Outlook account and a ChatGPT account.

Once you're signed in, you can create new Zaps by clicking the Create Zap button or by going to zap.new.

Step 1: Connect your trigger app

A Zap always consists of two parts:

  • The trigger: an event that starts a Zap.

  • The action: an event a Zap performs after it's triggered. A single Zap can perform more than one action.

In this instance, our workflow will have three parts (one trigger step and two action steps), as we want ChatGPT's output to be stored in our CRM.  

Search for and select your trigger app. In our example, we'll select Microsoft Outlook for our trigger app.

Screenshot of Outlook trigger in Zap editor

Then select your trigger event. If your trigger app is Microsoft Outlook, your Zap can trigger when you receive a new email, a contact is added to your account, a calendar event starts, and more.

Screenshot of Microsoft Outlook action in Zap editor

Select your trigger event and click Continue. We're going to select New Email for our example.

Screenshot of Microsoft Outlook trigger in Zap editor

Next, connect your trigger app account to Zapier by clicking on the dropdown menu and selecting +Connect a new account. We'll connect Microsoft Outlook in our example. You'll need to give Zapier permission to access your account. Once you've connected your account, select it from the dropdown menu and click Continue. 

Screenshot of Outlook authentication

Next, set up your trigger step by filling in the trigger step fields. Depending on your trigger app and event, you'll have different fields to customize. In our example, the only field we need to select is which Microsoft Outlook inbox we're going to be using. (If you have access to a shared inbox, you can add that here, otherwise it will trigger off your own inbox.)

Screenshot of trigger inbox

When you're done customizing your trigger step, click Continue.

Next, click Test Trigger so Zapier will create a test event to make sure the trigger is working properly. Once the test runs successfully, click Continue with selected record.

Screenshot of test data

Step 2: Connect your action app

In this next step, you'll set up the action—the event your Zap will perform once it's triggered. Start by searching for and selecting your action app. We'll use ChatGPT in our example. 

Screenshot of action step

Next, choose your action event. If your action app is ChatGPT, your Zap can create a conversation or extract structured data. 

Screenshot of ChatGPT conversation

Select your action event and click Continue. We're going to select Conversation for our example.

Screenshot of ChatGPT conversation action

Next, connect your action app account to Zapier by clicking on the dropdown menu and selecting +Connect a new account. In our example, we'll connect ChatGPT. You'll need to give Zapier permission to access your app account. Once you've connected your account, click Continue.

Screenshot of ChatGPT integration

Next, set up your action by filling in the action step fields. Depending on your action app and event, you'll have different fields to customize. In our example, the fields that show up in your Zap are those related to ChatGPT. 

You can also customize your action step with data from your trigger step. For example, to add data from your Microsoft Outlook step—like the email body—click in a field and select the data you'd like to use from the dropdown.

Screenshot of email fields

The most important part of setting up your ChatGPT action is providing a clear prompt under Assistant Instructions. Because I want ChatGPT to analyze the intent and information in the email, my instructions are: 

You are a helpful email assistant. You will look at this email content and determine the tone and intent of the email. It will either be positive (interested), neutral (might be interested), or negative (not at all interested). You will then create a quick summary of the email (one sentence or two) along with your determination of intent. 

Remember to also pull in the email body from your trigger step. 

Screenshot of assistant instructions

You can also adjust other settings, like the model, number of tokens, temperature, and memory key. Because I want ChatGPT to remember future interactions with this lead, I'll include the sender's email address as the memory key. 

Screenshot of memory key

Once you've customized your action step how you'd like, click Continue.

Now it's time to test your action. When you click Test & Review or Test & Continue, Zapier will send test data to your action app. In our example, ChatGPT will create an analysis of the new email according to how we set up the action step. We always recommend testing your Zap to check if your step looks good. But if you'd rather skip the test, just click Skip Test in the bottom-right corner.

Screenshot of test results

Step 3: Connect your second action app

In this next step, you'll set up the second action—this is the app where ChatGPT will send its output. Click on the + icon to add another action step. Start by searching for and selecting your action app (the CRM). We'll use Pipedrive in our example. 

Screenshot of CRM action

Next, choose your action event. If your action app is Pipedrive, your Zap can create leads, notes, organizations, deals, and more.

Screenshot of Pipedrive action

Select your action event and click Continue. We're going to select Create Lead for our example.

Screenshot of Pipedrive action set up

Once you've connected your Pipedrive account, click Continue.

Screenshot of Pipedrive account authenticated

Next, set up your action by filling in the action step fields. In our example, the fields that show up in your Zap are those related to your Pipedrive lead inside your database. 

You can also customize your action step with data from your trigger step. For example, to add data from your Microsoft Outlook step—like your lead's name and email address—click in a field and select the data you'd like to use from the dropdown.

Screenshot of action fields

In my example, I'll also need to pull in data from ChatGPT's step under Note. This means that ChatGPT's analysis of John Doe's email will be added as a note to the lead it creates within Pipedrive—so anyone from your sales team can review it before reaching out. You can also select True under Pin Note to Lead, so it's more noticeable. 

Screenshot of ChatGPT response

You can also customize other aspects of how your lead is set up, like adding a label, the lead's value, and who the lead is visible to within Pipedrive. 

Once you're happy with the way you've set this up, click Continue. 

Now it's time to test your action. When you click Test & Review or Test & Continue, Zapier will send test data to your action app. 

Screenshot of ChatGPT response

In our example, Zapier will create a new lead in Pipedrive according to how we set up the action step. This is what it looks like in Pipedrive: 

Screenshot of Pipedrive lead card

If your test looks right, you're ready to publish and start using your Zap!

And remember: you can now use the memory key you added in your ChatGPT step in other Zaps so that it remembers all of John Doe's context. 

Connect Outlook with ChatGPT

Whether you struggle to keep up with your email inbox or you just want a better way to streamline your lead management, connecting Microsoft Outlook and ChatGPT is a great way to combine the power of AI with automation. 

As you've seen, there are plenty of ways to automate the two apps, but the best way to find your ideal use cases is to start experimenting.

Get productivity tips delivered straight to your inbox

We’ll email you 1-3 times per week—and never share your information.

tags

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.

Sign up
A Zap with the trigger 'When I get a new lead from Facebook,' and the action 'Notify my team in Slack'