Spreadsheet import not working, throws generic exception

I try to set up a SpreadSheet import, but this ends in an exception thrown by google_spreadsheet.py:

2023-08-17 10:58:59,604 ERROR A general exception was thrown when executing the import
Traceback (most recent call last):
  File "/opt/splunk/etc/apps/google_drive/bin/google_spreadsheet.py", line 213, in import_file
    google_lookup_sync = GoogleLookupSync.from_service_key_file(key_file, logger=self.logger)
  File "/opt/splunk/etc/apps/google_drive/bin/google_drive_app/__init__.py", line 91, in from_service_key_file
    return GoogleLookupSync(key_file=key_file, logger=logger)
  File "/opt/splunk/etc/apps/google_drive/bin/google_drive_app/__init__.py", line 79, in __init__
    raise ValueError("Gspread client was not constructed")
ValueError: Gspread client was not constructed

Unfortunately no more details are available.

I've configured the input and the service account key file manually.

Key file:

inputs.conf:

[google_spreadsheet]
disabled = 0
service_account_key_file = XXXXXX-splunkimporter-prod-XXXXXXXXXXX.json

[google_spreadsheet://SplunkAzureCloud_Thresholds]
interval = 1m
lookup_name = thresholds_google.csv
operation = import
spreadsheet = SplunkAzureCloud_Thresholds
worksheet = Thresholds
disabled = 0

I also tried to set the service account key file in stanza [google_spreadsheet://SplunkAzureCloud_Thresholds]

LukeMurphey / splunk-google-drive

Spreadsheet import not working, throws generic exception #4