Known Issue: Google Sheets (v4) - Authorisation Error 401: disabled_client

Symptom 

You have a Google Sheets Web Connection under the safe.google-sheets.Google Sheets web service provided with the Sheets package. Upon approving your 2FA, the authentication will not pass the Google verification process, and a 401: disabled_client error will appear in the web service authentication dialog. 

Cause

The safe.google-sheets.Google Sheets web service definition provided by FME in the Sheets package v 2.1.0 currently has an unverified status. 

Resolution

Resolution 1: Update Google Sheets Package

1. In FME Workbench go to Tools > FME Options > Web Connections
2. Select 'Manage Services...'
3. Find 'Google Sheets (safe.google-sheets)' and under Authorization Parameters > URL, replace the value with

   https://accounts.google.com/o/oauth2/auth?response_type=code&access_type=offline&approval_prompt=force&scope=https://www.googleapis.com/auth/spreadsheets https://www.googleapis.com/auth/drive.metadata.readonly https://www.googleapis.com/auth/drive.file

4. (re)authorize/create your connections

Resolution 2: Create your own Google Sheets App

1. Visit Google API Console
2. Create a new project

3. Once in your project, configure the OAuth consent screen. You'll first need to choose if your app is for internal purposes only.

Then fill in some additional information about the application and publish the app. 

4. Create your Client ID and Secret

For the application type select 'Desktop App'

You'll now have a new Client ID and Secret that you can set your FME Google Sheets Service to use

 

5. Go to FME Desktop > FME Options and under Web Connections select 'Manage Services...'

6. Find your Google Sheets (safe.google-sheet) Web Service and update the Client ID/Secret under the Client Information Header with the ones you just created.