Google sheets connector for workflow

[AJheron]

I am setting up a workflow in Flow Builder to import serial numbers from a Google sheet so we can edit assets state based on those values. 

What level of oauth access to we need to provide Lansweeper in our Google workspace as a trusted app. A different team manages those settings and does not necessarily want to give Lansweeper full trusted access if it does not need it.

I am assuming it just needs access to Google Sign in and the Google sheets API via https://www.googleapis.com/auth/spreadsheets.

 

[KrisK · Accepted solution]

While we are not Google API experts, we believe the following measures will restrict access to the minimum:

• When using OAuth 2.0, you can specify the scope to limit access. For example, use the scope https://www.googleapis.com/auth/spreadsheets to restrict access to Google Sheets only.
• Create a service account in your Google Cloud project and share the specific spreadsheet with the service account email. This way, the service account will only have access to the shared spreadsheet.