In this Power Platform tutorial, we will discuss how to Log Gmail emails to a Google Sheet using Power Automate.
Here I have an Office 365 E3 subscription to use this service. So here I am explaining, how to achieve this using Power Automate or Microsoft Flow.
You can have an Office 365 E5 subscription also.
Log Gmail emails to a Google Sheet using Power Automate
In Power Automate, Microsoft provides many templates which we can use for various functionalities.
If you want to modify then you can do it easily. So here I am using one of the existing templates called Log Gmail emails to a Google Sheet.
Configure Power Automate Action
Step-1: Login to your Office 365 account -> Go to the Apps gallery and click on Power Automation.
Step-2: Next go to the Templates section and search weather. Next, there are many templates that are available to use. So here you can select one which you want.
Step-3: Next I click on Log Gmail emails to Google Sheet. So when you click on this template, it will appear a new page where you can see the flow and click on continue to modify this template.
Step 4: Before you click on Continue, verify your connectivity of Gmail and Google Sheets. Then only SharePoint will allow continuing this service. Here everything got successfully connected so I clicked on the Continue button to configure my flow.
So here I choose Inbox and you can also choose any option which came in the below screenshot.
Step 5: Next log in to your Google account and create a new google sheet where you keep your information.
After creation, you have to create a column in the first row of the sheet. Here I selected my newly created google sheet.
Step 6: Next I selected Sheet1 and I Configured the column which I have created I that sheet. Both columns should be the same otherwise it will encounter an error.
Step 7: Once you run this flow, it will take some time to execute. And refresh your sheet after some time. If any new email came to your inbox, it will track in this sheet as per the below screenshot.
This is all about Log Gmail emails to a Google Sheet using Power Automate.
You may like the following Microsoft flow tutorials:
- Add my latest Twitter post to Yammer using Power Automate or Microsoft Flow
- Save tweets to a Google Sheet using Power Automate (Flow)
- Get daily weather reports delivered to your email and phone using Power Automate
- Microsoft Flow Example Save tweets that include specific hashtag to a SharePoint list
- Save Twitter Tweets in SharePoint Online list using Microsoft Flow (Power Automate)
- Microsoft Flow or PowerAutomate Example: Save my email attachments to a SharePoint document library
In this tutorial, we learned another example of Microsoft flow, how to Log Gmail emails to a Google sheet using power automate.
Rajkiran is currently working as a SharePoint Consultant in India . Rajkiran having 7+ years of experience in Microsoft Technologies such as SharePoint 2019/2016/2013/2010, MOSS 2007,WSS 3.0, Migration, Asp.Net, C#.Net, Sql Server, Ajax, jQuery etc.He is C#Corner MVP (2 Times).