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>

Definitely looks like the error you get when the scope is wrong. We tend to test with tap-spreadsheets-anywhere, maybe that's an option for you? We've been meaning to release a google sheet data source for awhile - this is perhaps the motivation we need. I'll give it a closer look tomorrow and let you know if no one else replies in the meantime.

The only other part of the setup process I’m somewhat concerned may impact this is that when I went through the process of obtaining the refresh token, there’s a part where you have to signin into your google account in a browser. I used the gmail account associated with my organization. There aren’t additional permissions that need to be configured for my gsuite user are there? The instructions are not clear on this since they focus on authentication for the google search console.

Not that I recall, but OAuth it seems to be so painful every time!

@josh_lloyd , normally when you obtain the refresh token is when you provide scopes, I'd look at that step in more depth!

ah yes, you’re right, I forgot to use the spreadsheet.readonly scope in the scope parameter of the redirect uri provided in the instructions. Looks like I’m on to the next error. Thanks guys!!