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:

{'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>