Extract Data from google sheet

[yja]

Hello,

How can i extract data from a google sheet using power automate desktop. I have used extarct data from a web page but it doesn't work because apparently a google sheet isn't a web page ! 

some help please !

[VJR]

Hi @yja 

There is no direct action in the Power Automate Desktop for Google sheets. 

You can check a solution given in this post which uses Google API.

https://powerusers.microsoft.com/t5/Power-Automate-Desktop/connect-to-google-sheets-for-read-and-wri...

[yja]

What about downoalding as an Excel file ?

[JezAuditore]

Hi @yja, if you can export to excel then there are built in PAD functions for extracting data from excel 🙂