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.



Step 2: Sign in with your credentials here. 



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



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.



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



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



Step 7: Click on Continue button.



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.



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.



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



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



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



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





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.