topic Google Sheets APIs in a Organization in Product Forum

Google Sheets APIs in a Organization

GabrielMendonça — Mon, 08 Mar 2021 20:22:52 GMT

hello!!

This is my first question in this community, I'm happy to be part of it !

I need some help, how can I use a Google APIs with blue prism in a Organization ? There's a way to do it without the need of share the service account with the sheets ? Has anyone ever experienced this ?

Re: Google Sheets APIs in a Organization

ewilson — Tue, 09 Mar 2021 16:25:00 GMT

Hi @Gabriel Mendonça,

Are you using the Google Sheets VBO or the actual Web API service? Ultimately both make use of an OAuth client ID and client secret. You could always create DW-specific credentials within your GCP environment and then store those credentials in the Blue Prism Credential Manager. Then, when you launch your process, you tell it which credential to use from Credential Manager. Does that make sense?

Cheers,

Re: Google Sheets APIs in a Organization

GabrielMendonça — Tue, 09 Mar 2021 18:47:11 GMT

It does make sense! The problem is that I was using the wrong credential type (Was using Service Account) the right method is to use the OAuth credential type. Thanks! You are amazing!