https://linen.dev logo
#plugins-general
Title
# plugins-general
j

josh_lloyd

03/08/2022, 7:12 PM
Does anyone know how to setup the
tap-google-sheets
properly? I’ve gotten a client_id, client_secret, and refresh_token all taken care of but when I run
meltano --log-level=debug invoke tap-google-sheets
I get the following error:
Copy code
{'code': 403, 'message': 'Request had insufficient authentication scopes.', 'status': 'PERMISSION_DENIED', 'details': [{'@type': '<http://type.googleapis.com/google.rpc.ErrorInfo|type.googleapis.com/google.rpc.ErrorInfo>', 'reason': 'ACCESS_TOKEN_SCOPE_INSUFFICIENT', 'domain': '<http://googleapis.com|googleapis.com>', 'metadata': {'method': 'google.apps.sheets.v4.SpreadsheetsService.GetSpreadsheet', 'service': '<http://sheets.googleapis.com|sheets.googleapis.com>'}}]}
even though we’ve theoretically added the following scopes to this particular client: •
<https://www.googleapis.com/auth/drive.metadata.readonly>
<https://www.googleapis.com/auth/spreadsheets.readonly>
<https://www.googleapis.com/auth/webmasters.readonly>