Google Sheets Import & Export Actor

At a glance

The community member is having trouble with the OAuth process when using the Apify actor for Google Sheets. They are getting an "App is blocked" message and are unsure if the issue is with the app or their Google account settings. Other community members suggest trying a different Google account, such as a company account instead of a personal one, or using the Google Drive integration directly. One community member mentions that Google is making it harder to authenticate and it may not work at all. The solution provided is to create a Google service account and share the spreadsheet with that account, which allows running the actor without the need for authorization during the run.

Useful resources

HHonzaS

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

Apify Discord Mirror

Google Sheets Import & Export Actor