Answered

connect to google sheets for read and write

(0) Share

Report

Posted on by douglasabreu

120

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.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (10)

Answers (1)

Sort by

fraenK 2,125 on at

Like (0)

Report
Copy link

Link copied!

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#invokewebservicebase

Was this reply helpful? Yes No
douglasabreu 120 on at

Like (0)

Report
Copy link

Link copied!

thank you so far

Was this reply helpful? Yes No
douglasabreu 120 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
fraenK 2,125 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
PAG 154 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
douglasabreu 120 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

PAG 154 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
douglasabreu 120 on at

Like (1)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
douglasabreu 120 on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
feliperubio 3 on at

Like (0)

Report
Copy link

Link copied!

HYello @PAG
I don't know if I turned off the flow, it didn't work for me

Was this reply helpful? Yes No