Google Sheets Import & Export
Pricing
Pay per usage
Google Sheets Import & Export
Import data from datasets or JSON files to Google Sheets. Programmatically process data in Sheets. Easier and faster than the official Google Sheets API and perfect for importing data from scraping.
5.0 (1)
Pricing
Pay per usage
37
Monthly users
123
Runs succeeded
83%
Response time
1.6 days
Last modified
15 days ago
Error invalid_grant after few days
Closed
The export works fine for a few days after authorizing, but after some time I get invalid_grant. Is there something I'm missing in the configuration?
2022-10-08T04:30:16.170Z INFO System info {"apifyVersion":"2.0.7","apifyClientVersion":"1.4.2","osType":"Linux","nodeVersion":"v16.8.0"} 2022-10-08T04:30:16.173Z WARN You are using an outdated version (2.0.7) of Apify SDK. We recommend you to update to the latest version (2.2.2). 2022-10-08T04:30:16.176Z Read more about Apify SDK versioning at: https://help.apify.com/en/articles/3184510-updates-and-versioning-of-apify-sdk 2022-10-08T04:30:16.876Z Input: 2022-10-08T04:30:16.889Z {} 2022-10-08T04:30:17.090Z We found tokens saved in our store. No need to authenticate again. 2022-10-08T04:30:17.092Z using stored tokens 2022-10-08T04:30:17.774Z ERROR 2022-10-08T04:30:17.777Z Error: invalid_grant 2022-10-08T04:30:17.779Z at Gaxios._request (/usr/src/app/node_modules/gaxios/build/src/gaxios.js:129:23) 2022-10-08T04:30:17.780Z at processTicksAndRejections (node:internal/process/task_queues:96:5) 2022-10-08T04:30:17.783Z at async OAuth2Client.refreshTokenNoCache (/usr/src/app/node_modules/google-auth-library/build/src/auth/oauth2client.js:172:21) 2022-10-08T04:30:17.785Z at async OAuth2Client.getRequestMetadataAsync (/usr/src/app/node_modules/google-auth-library/build/src/auth/oauth2client.js:259:17) 2022-10-08T04:30:17.787Z at async OAuth2Client.requestAsync (/usr/src/app/node_mo... [trimmed]
Hello, I was reworking the authorization process because Google changed the rules. It should not impact old users but it will impact any new authorizations.
invalid_grant usually means that you are using wrong account for that sheet. If you cannot get rid of it, probably just delete the google-auth-tokens kv store and go through the authorization again.
exclusive_plants
Hi, thanks for quick reply. Just to clarify the everything works fine for a few days, then I receive the invalid_grant and have to delete the tokens and authorize again manually.
Thanks. I never encountered this issue before, it is possible that Google now decided to allow the tokens to live only for several days. Unfortunately, there isn't probably much I can do with it.
Pricing
Pricing model
Pay per usageThis Actor is paid per platform usage. The Actor is free to use, and you only pay for the Apify platform usage.
