Create Flow To Manage Email With Remainders

Introduction

This article will help you create a Flow to manage the email from Office 365 with remainders and save all the schedules on an online excel sheet at Google Drive.

Note:

  • Make sure that you have worked on my previous article of creating a Flow from template before getting on to this.
  • Click here to learn about what is Microsoft Flow, how it could help you, and how to create a flow from template. 
  • Make sure that you have the following things before you work on this demo,

Prerequisites:

  • An account in www.flow.microsoft.com
  • A Google Drive account.
  • An Office 365 account.

Follow the below steps now,

Step 1: Go to www.flow.microsoft.com and click on Sign in at the top right corner. If you don’t have an account, click on Sign Up free at the right corner.

account

Step 2: Sign in with your credentials here. 

account

Step 3: Scroll down and click on Make a flow button.

flow

Step 4: Here, you can filter the templates under Showing option. We have various streams that can be filtered with featured, approval, collect data, email, events and calendar, mobile, notifications, productivity, social media and Sync. You can filter the templates as you need from these options.

Let’s select “All Flow” over here.

All Flow

Step 5: Click on “Get daily remainders in Email” followed by Use this template option.

Get daily remainders in Email

Step 6: Click on Sign in button of Office 365 Users and sign in with your Office 365 account credentials over here.

Sign in

Step 7: Click on Continue button.

Continue

Step 8: Enter a name for your Microsoft Flow that you have created. Here, let's enter the flow name “Get daily remainders in Email”. Click on New Step and select Google Sheets.

Continue

Note: You should have created a Google online excel sheet before you create this.

Step 9: Click on Sign in and log in with the google account credentials in which you have created your online excel sheet.

Sign in

Enter your google account credentials for which you have created an online excel sheet over here.

google account credentials

Click on Allow button to provide authentication for the Microsoft PowerApps.

Allow

Step 11: Select the File name and select the Worksheet that you have created.

Select the File

Here, I will be selecting “Sheet 1” which is the Online Excel Sheet that I have created in my Google Drive.

Sheet 1

Sheet 1

Click on Create Flow one after your Flow process is done.

This will make your flow to be saved. You can find the process of “Saving Flow and Your Flow is running” followed by this.

process

process

X

Build smarter apps with Machine Learning, Bots, Cognitive Services - Start free.

Start Learning Now