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

Christian Berger
Christian Berger
  • Updated
Known Issue Id FMEENGINE-70066

Google Sheets Package [2.1.0]


Google Sheets Package [2.1.0]


Google Sheets Package [2.1.1]



You have a Google Sheets Web Connection under the 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. 



The Sheets web service definition provided by FME in the Sheets package v 2.1.0 currently has an unverified status. 



There are a couple of resolutions available. If you are using Google Sheets in a production environment we would recommend you turn to resolution 2 and manage your own web service definition. 

Resolution 1: Update Google Sheets Package

This issue has been fixed in Google Sheets Package v 2.1.1.  This package is available in b21261 or newer. To update the package in FME Workbench go to Tools > FME Options > FME Packages, select and update Google Sheets. If you are using an older version of FME you can manually fix the Google Sheets Web Service Definition. 
  1. In FME Workbench go to Tools > FME Options > Web Connections
  2. Select 'Manage Services...'
  3. Find 'Google Sheets (' and under Authorization Parameters > URL, replace the value with
  4. (re)authorize/create your connections


Resolution 2: Create your own Google Sheets App

The Google Sheets Web Service definition that is provided by Safe Software is recommended for demo purposes only. Therefore the preferred option may be to create your own Google App (client ID/secret) for use within FME. Since this is an app created by your account within Google there is no risk of access being denied in future. To do this you will need to:
  1. Visit Google API Console
  2. Create a new project


  1. 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. 

  1. 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

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


  1. Find your Google Sheets ( Web Service and update the Client ID/Secret under the Client Information Header with the ones you just created.


Was this article helpful?



Please sign in to leave a comment.