"Retrieve the number of Outlook emails in a Google Sheet"

Getting Started
1

What are you trying to achieve?

"Hello, I am new to Make, and to start, I would like to create a simple automation. I would like to retrieve the number of unread emails (the number displayed on the ‘inbox’) and send it to a Google Sheet.

The Google Sheet would have a ‘date’ column and an ‘unread emails count’ column.
The automation would add a new row with each execution.

I would like this automation to run once a day.

Do you think this automation is easily achievable for a new user?
I did a similar exercise with the built-in script tool in Google Sheets for a Gmail account, and it was very simple.

Thank you in advance for your help!"

Steps taken so far

“I tried integrating an Outlook module, but the planned scenario would have counted the number of unread emails one by one, which is tedious. Ideally, I would like it to simply retrieve the already established number in Outlook.”

2

Hi @Jeremy
If you want to add more informations into the sheet you can use “Make an API call” module with the follwing end point to retrive latest 100 unread messages. You can adjust the limit in endpoint:
/v1.0/me/mailFolders/Inbox/messages?$filter=isRead eq false&$top=100

image
image698×900 54.9 KB

3

You will have to list the unread emails and then use an aggregator to turn it into an array. From there use the lenght() function on the array to count the number of emails.

Hope this helps!