Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Google Sheets APIs in a Organization

Go to answer
GabrielMendonça
Level 3

‎08-03-21 08:22 PM

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 ?
1 BEST ANSWER

Best Answers

Go to answer
ewilson
Staff
Staff

‎09-03-21 04:25 PM

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,

View answer in original post

0 Likes
2 REPLIES 2

Go to answer
ewilson
Staff
Staff

‎09-03-21 04:25 PM

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,
0 Likes

Go to answer
GabrielMendonça
Level 3

‎09-03-21 06:47 PM

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!
0 Likes