Google Sheets Import & Export Actor
Hi, I have tried oauth process with this actor https://apify.com/lukaskrivka/google-sheets. I open liveview then I click on the authorize button as is instructed here https://help.apify.com/en/articles/2424053-google-integration but then I get this App is blocked mesage.
Anybody know what to do about this? Is it problem with the app or with some privacy setting on my google account? I know this definitely worked some time ago.
12 Replies
conscious-sapphire•3y ago
Confirmed, exactly the same error
stormy-goldOP•3y ago
thanks, I guess @Lukas Krivka already knows about this
@HonzaS I think this might be unfortunately related to the
Please note that Google gradually makes it harder to authenticate and it is possible it will not work for you at all. Try a different gmail, a company one rather then personal, or use directly our integration for Google drive.From Readme (https://apify.com/lukaskrivka/google-sheets#authentication-and-authorization) Have you tried with different account?
stormy-goldOP•3y ago
No, I did not, I do not have so many google accounts at my disposal. Can you elaborate how I can make this actor work with the Google drive integration?
other-emerald•2y ago
There is a plan to enable proper OAuth login on Apify but no deadline yet
stormy-goldOP•2y ago
I have created a service account and with that it work perfectly, no need for the authorization during run. All I needed to do is to share the spreadsheet with the account.
stormy-gold•16mo ago
@HonzaS how to resolve this issue i am facing the same problem, tried different google account all have the same block error.
stormy-goldOP•16mo ago
Everything is there in my post. Run it under the service account.
stormy-gold•16mo ago
I have created the service account, how to link it with apify? There is not much data i found under the run.
stormy-goldOP•16mo ago
It is not no code solution. You cannot just link it. You need to code it. Use gsheets api.
stormy-gold•16mo ago
@HonzaS can you please explain i have add the api and use the share the sheet with service account then how we can send the data using google sheet import and export?
stormy-goldOP•16mo ago
it's all there for example https://medium.com/@shkim04/beginner-guide-on-google-sheet-api-for-node-js-4c0b533b071a
Medium
How To Use Google Sheet API On Node.js
Google Sheet is very handy due to its incredible flexibility and easy access no matter where you are because it works on browsers. It is…