Creating flow in Power Automate to extract contacts from Google

(0) Share

Report

Posted on by Amaya2013

103

Hi ,

I am new to Power Automate and have just started building simple flows. I was wondering if anyone can help me with my query.

I would like to know if it's possible to use Google APIs in Power Automate to extract contacts or count the emails in your Gmail account.

Thanks for your help in advance.

Categories:

General topics

I have the same question (0)

All responses (10)

Answers (2)

Deenuji_Loganathan_ 6,250 Super User 2025 Season 2 on at

Like (0)

Report

@Amaya2013

You can create your flow like below:

Thanks,
Deenuji Loganathan
🤖 Automation Evangelist
Deenuji - Follow me on LinkedIn

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🌟

Was this reply helpful? Yes No
Andrew_J 1,962 Moderator on at

Like (0)

Report

@Amaya2013

The following might help:

https://learn.microsoft.com/en-us/connectors/gmail/
https://learn.microsoft.com/en-us/connectors/googlecontacts/

I have not used these so cannot advise any further.

Regards,

Andrew

Was this reply helpful? Yes No
Amaya2013 103 on at

Like (0)

Report

Thanks @Deenuji - Do we need to use Google API to connect to Google from Power Automate?

Was this reply helpful? Yes No
Amaya2013 103 on at

Like (0)

Report

@Andrew_J - Thanks . Can you please help me in building the flow? I have managed to get the Client ID and Client Secret using Google API but got stuck now . Thanks

Was this reply helpful? Yes No
Verified answer

Deenuji_Loganathan_ 6,250 Super User 2025 Season 2 on at

Like (1)

Report

@Amaya2013
Yes correct. Please refer the below screenshot.

Thanks,
Deenuji Loganathan
🤖 Automation Evangelist
Deenuji - Follow me on LinkedIn

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🌟

Was this reply helpful? Yes No
Andrew_J 1,962 Moderator on at

Like (0)

Report

@Amaya2013

I am going to leave @Deenuji to assist it appears he is more sutied this question than I.

Regards,

Andrew

Was this reply helpful? Yes No
Amaya2013 103 on at

Like (0)

Report

Thanks @Deenuji - i've built the flow as you suggested as below. How can I see the result?

Do you know how this can be changed to send an email to someone with the list of contacts and the count of emails? Thanks

Was this reply helpful? Yes No
Amaya2013 103 on at

Like (0)

Report

@Deenuji - Thanks a lot for all your help, I have managed to send an email with list of contacts.

Just another question, Is it possible to link to Azure portal and get the file details from Data lake storage?

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,250 Super User 2025 Season 2 on at

Like (0)

Report

@Amaya2013
Please follow the below suggested actions.
and while add your variable into your email body, make sure the enable the below html flag.

Thanks,
Deenuji Loganathan
🤖 Automation Evangelist
Deenuji - Follow me on LinkedIn

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🌟

Thanks,
Deenuji Loganathan
🤖 Automation Evangelist
Deenuji - Follow me on LinkedIn

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🌟

Was this reply helpful? Yes No
Verified answer

Deenuji_Loganathan_ 6,250 Super User 2025 Season 2 on at

Like (0)

Report

@Amaya2013

I would recommend you to raise that as separate topic and close this thread.

Thanks,
Deenuji Loganathan
🤖 Automation Evangelist
Deenuji - Follow me on LinkedIn

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🌟

Was this reply helpful? Yes No