Apify and Crawlee Official Forum

Updated 3 months ago

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.

Attachment

12 comments

AAlexey Udovydchenko

Confirmed, exactly the same error

HHonzaS

thanks, I guess already knows about this

PPepa J

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?

HHonzaS

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?

LLukas Krivka

There is a plan to enable proper OAuth login on Apify but no deadline yet

HHonzaS

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.

HHarrry

how to resolve this issue i am facing the same problem, tried different google account all have the same block error.

HHonzaS

Everything is there in my post. Run it under the service account.

HHarrry

I have created the service account, how to link it with apify? There is not much data i found under the run.

HHonzaS

It is not no code solution. You cannot just link it. You need to code it. Use gsheets api.

HHarrry

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?

HHonzaS

it's all there for example https://medium.com/@shkim04/beginner-guide-on-google-sheet-api-for-node-js-4c0b533b071a

Add a reply