How to Integrate Google Dialogflow with Microsoft Outlook

Prerequisites

• Ensure you have a Google Cloud account and have created a Dialogflow agent.

 

• Ensure you have access to Microsoft Outlook and the ability to set up an Office 365 account.

 

• Basic understanding of APIs and familiarity with tools like Postman.

Create a Dialogflow Agent

• Go to the Dialogflow console and create a new agent if you haven't already.

 

• Enable the required APIs from the Google Cloud Console: Dialogflow API and any other necessary for your functionality.

Enable Webhooks in Dialogflow

• Navigate to your Dialogflow agent's console, click on the gear icon next to the agent's name.

 

• Under the "Fulfillment" tab, enable "Webhook" fulfillment and provide the URL where you'd like Dialogflow to send requests.

Create an API Endpoint for Outlook in Azure

• Go to Azure portal and create an Azure Function App which will handle the requests from Dialogflow and interact with Outlook.

 

• Create a new function within your Function App. Choose HTTP trigger template which will serve as your endpoint.

Connect Dialogflow to Outlook via Azure Function

• In your Azure Function, write code that can communicate with Outlook using the Microsoft Graph API.

 

• Use the following Python sample to authenticate and send requests to Outlook for sending emails or retrieving calendar events.

import azure.functions as func
import requests
import json

def handle_dialogflow_request(req: func.HttpRequest) -> str:
    dialogflow_action = req.params.get('queryResult')['action']
    
    if dialogflow_action == 'send_email':
        return send_email()
    
    elif dialogflow_action == 'get_events':
        return get_calendar_events()

def send_email():
    url = "https://graph.microsoft.com/v1.0/me/sendMail"
    headers = {'Authorization': 'Bearer ACCESS_TOKEN'}
    payload = {
        "message": {
            "subject": "subject",
            "body": {
                "contentType": "Text",
                "content": "Hello! This is a test email."
            },
            "toRecipients": [
                {
                    "emailAddress": {
                        "address": "example@domain.com"
                    }
                }
            ]
        }
    }
    response = requests.post(url, headers=headers, json=payload)
    return response.json()

def get_calendar_events():
    url = "https://graph.microsoft.com/v1.0/me/calendar/events"
    headers = {'Authorization': 'Bearer ACCESS_TOKEN'}
    response = requests.get(url, headers=headers)
    return response.json()

Configure Permissions in Microsoft Graph

• In the Azure portal, navigate to Azure Active Directory and register your app to gain necessary permissions.

 

• Assign your app permission to access Graph API for sending email and reading calendar events, like Mail.Send and Calendars.ReadWrite.

Test the Integration

• Ensure your Azure function endpoint is connected to the Dialogflow webhook URL.

 

• Test your Dialogflow agent using the simulator present in the Dialogflow console. Validate actions like email sending and calendar retrieval by checking logs and ensuring expected behavior.

Deploy and Monitor

• Deploy your Azure function to production. Ensure you secure your endpoint and handle any necessary token refreshing operations for Microsoft Graph API.

 

• Monitor Dialogflow interactions and Azure function to ensure communication flow remains uninterrupted and performs as expected.