Log Gmail emails to a Google Sheet using Power Automate

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.

Log Gmail Emails to a Google Sheet

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.

Log Gmail Emails to a Google Sheet power automate

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.

Log Gmail Emails to a Google Sheet microsoft flow

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.

power automate example Log Gmail Emails to a Google Sheet

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.

how to log gmail emails to a google sheet

Step 6: Next I selected Sheet1 and I Configure the column which I have created I that sheet. Both columns should be the same otherwise it will encounter an error.

how to log gmail emails to a google sheet using flo

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.

how to log gmail emails to a google sheet using power automate

This is all about Log Gmail emails to a Google Sheet using Power Automate.

You may like following Microsoft flow tutorials:

In this tutorial, we learned another example of Microsoft flow, how to Log Gmail emails to a Google sheet using power automate.

Donwload Hub site pdf

Download SharePoint Online Tutorial PDF FREE!

Get update on Webinars, video tutorials, training courses etc.

  • >