connect to google sheets for read and write

[douglasabreu]

I would like to know how I can make a connection with google sheets. Back in the days when it was still WinAutomation I was also looking for that, but I couldn't, maybe now there is a way. UiPath has a plugin that facilitates integration. Power Automate Desktop could have plugins as in its web version, which has many connectors.

So I want to connect my PAD (power automate desktop) to Google Sheets, using api or another way. I appreciate if you can help me.

[fraenK]

Cloud flows has a Google Sheets connector, better use this: https://emea.flow.microsoft.com/en-us/connectors/shared_googlesheet/google-sheets/

With PAD would need to go through the details of invoke web service:

https://docs.microsoft.com/en-us/power-automate/desktop-flows/actions-reference/web#invokewebservice...

[douglasabreu]

thank you so far

[douglasabreu]

I haven't been able to implement this yet, if anyone knows how to invoke, please share.

I'm waiting for the PAD to include in the desktop version the connections from the cloud version.

uiPath has had this for a long time.

[fraenK]

Should be pretty straight forward:

1. Get an API key to authorize your requests: https://developers.google.com/sheets/api/guides/authorizing

2. Try the samples for working with sheets: https://developers.google.com/sheets/api/samples

[PAG]

I've created a flow example that authenticates with Google API and returns spreadsheet values, visit:

https://power.automate.gallery/read-google-sheets-api-with-power-automate-for-desktop 

[douglasabreu]

Very good, it's really simple, I tried it here and it worked.
I have a desire to write on the spreadsheet, I'll go ahead and see if I can, thank you very much.

The Power Automate Gallery is quite interesting I didn't know it.

[PAG · Accepted solution]

Hello @douglasabreu,

I've published a flow actions template that shows how to write to Google Sheets API using OAuth 2.0 Power Automate for Desktop, see link:

https://power.automate.gallery/write-to-google-sheets-api-using-oauth-2-0-power-automate-for-desktop 

[douglasabreu]

Mister PAG, that was awesome, I'm going to try this out right now, thanks for helping the community so kindly.

In the future I'm sure we'll have cloud connectors in the desktop version, which will make all this work much easier, but in the meantime, we can enjoy it thanks to your help.

May your days be full of energy!

[douglasabreu]

Mister PAG, that was awesome, I'm going to try this out right now, thanks for helping the community so kindly.

In the future I'm sure we'll have cloud connectors in the desktop version, which will make all this work much easier, but in the meantime, we can enjoy it thanks to your help.

May your days be full of energy!