I am not able to use authorization key to access private spreadsheet

bassarisse / google-spreadsheet-to-json

Simple tool to export Google Spreadsheets to JSON files, though Node API or CLI

The Unlicense

134 stars 33 forks source link

I am not able to use authorization key to access private spreadsheet #26

Open abhinavjain1607 opened 5 years ago

abhinavjain1607 commented 5 years ago


 await gsjson({
            spreadsheetId: spreadsheetId,
            allWorksheets: true,
            token: 'Bearer ya29.---------------------------------7yg',
            tokentype: 'Bearer'
        });```

This is throwing this error:
{
    "message": "Invalid authorization key.",
    "error_code": "",
    "data": {}
}

Can someone help me understand why this is failing. I generated a new token using Postman Auth2.0.

bassarisse commented 5 years ago

Have you tried informing the token without the "Bearer " prefix?