cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rudes
New Member

Where to find a good tutorial on setting up a gmail send email flow...

Hi-

 

I'm looking for the most efficient way to set up an emailing flow.

 

I want to email from a gmail account but it's on a custom domain from google domains and i am using google workspace.

 

I think I'm going to use a spreadsheet to pull data from to email to my list.

 

But I could enter the data in PA. then run manually.

 

I'm not sure if it would be better to use excel or sheets (google) for the spreadsheet.

 

Anyone set this up already and have any advice?

 

Seems like there are many ways to do this. Looking for the way that PA will play nice with google.

 

Thanks for any help.

 

Tony

2 ACCEPTED SOLUTIONS

Accepted Solutions

Thanks for the reply but I'm looking for something a little easier as I'm new to all of this.

 

I think I may have found my solution.

 

Can I mark my own reply comment as the solution to my own question I wonder?

 

Anyways for those who read this looking for the solution I will explain what I found.

 

I was using power automate desktop.

 

Desktop does not seem to have any connectors.

 

When I logged into office.com then clicked on the top 9 dots in the top left corner.

clicked all apps

 

clicked power automate.

 

then created a flow as a cloudflow not a desktop flow I found all the connectors I needed.

 

Important notes:

 

I was using the free office.com account with my outlook email account.

 

To get data from the excel spreadsheet i created using a free account i had to seach for excel then excel one drive was shown as a connector. otherwise you only see excel business which you need a business account for.

 

then i searched for gmail and had to connect my gmail account i wanted to use to send the emails.

this was easily done.

 

It worked!

 

When I tested it a second time sending to a different email address (an gmail address with promotions tab)

it also worked (as a test) but I got an error that it failed because it didn't have a To: email address which it obviously did because it worked and you will see in the screenshot I  took for you.

 

The screenshot also shows the flow.

 

I am looking for help on how to add a wait between emails so if I send many emails they do not all go out at once and get marked as spam.

 

This test not only worked but it worked getting the  email into the INBOX not spam or the promotions tab.

 

This was a gmail account. When i run the actual flow I will be setting up a google workspace account to send emails from.

 

If anyone knows how and where I should add the wait to this flow please let me know.

 

Tony

 

PS- I figured out how to  create this flow from a youtube video 

 

"how to send multiple emails with dynamic content in microsoft power automate"

by
anders jensen

 

He's got a lot of good tut's follow and like him if this was helpful for you.

View solution in original post

rudes
New Member

how to send multiple emails with dynamic content in microsoft power automate
anders jensen

 

on youtube is where i learned how to set up this flow.

 

the image is a screenshot of the flow with an error i got but its funny because it did work

 

shows error but this cloudflow workedshows error but this cloudflow worked

View solution in original post

3 REPLIES 3
mahoneypat
Solution Sage
Solution Sage

I haven't done either personally, but two approaches you could consider would be

 

1. Use the Google REST API - Gmail API  |  Google Developers

 

2. Do it with the Web Recorder in Power Automate Desktop (with Gmail in your web browser)

 

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about the Power Platform, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Thanks for the reply but I'm looking for something a little easier as I'm new to all of this.

 

I think I may have found my solution.

 

Can I mark my own reply comment as the solution to my own question I wonder?

 

Anyways for those who read this looking for the solution I will explain what I found.

 

I was using power automate desktop.

 

Desktop does not seem to have any connectors.

 

When I logged into office.com then clicked on the top 9 dots in the top left corner.

clicked all apps

 

clicked power automate.

 

then created a flow as a cloudflow not a desktop flow I found all the connectors I needed.

 

Important notes:

 

I was using the free office.com account with my outlook email account.

 

To get data from the excel spreadsheet i created using a free account i had to seach for excel then excel one drive was shown as a connector. otherwise you only see excel business which you need a business account for.

 

then i searched for gmail and had to connect my gmail account i wanted to use to send the emails.

this was easily done.

 

It worked!

 

When I tested it a second time sending to a different email address (an gmail address with promotions tab)

it also worked (as a test) but I got an error that it failed because it didn't have a To: email address which it obviously did because it worked and you will see in the screenshot I  took for you.

 

The screenshot also shows the flow.

 

I am looking for help on how to add a wait between emails so if I send many emails they do not all go out at once and get marked as spam.

 

This test not only worked but it worked getting the  email into the INBOX not spam or the promotions tab.

 

This was a gmail account. When i run the actual flow I will be setting up a google workspace account to send emails from.

 

If anyone knows how and where I should add the wait to this flow please let me know.

 

Tony

 

PS- I figured out how to  create this flow from a youtube video 

 

"how to send multiple emails with dynamic content in microsoft power automate"

by
anders jensen

 

He's got a lot of good tut's follow and like him if this was helpful for you.

rudes
New Member

how to send multiple emails with dynamic content in microsoft power automate
anders jensen

 

on youtube is where i learned how to set up this flow.

 

the image is a screenshot of the flow with an error i got but its funny because it did work

 

shows error but this cloudflow workedshows error but this cloudflow worked

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,155)