
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
34
Monthly users
109
Runs succeeded
69%
Response time
18 days
Last modified
24 days ago
Google is blocking access to apify when trying to authorize
slothster
I am getting the same thing. "This app is blocked - This app tried to access sensitive info in your Google Account. To keep your account safe, Google blocked this access."

Unfortunately, nothing we can do at the moment. The access is blocked for your specific account, it depends on your security settings, country, etc... We hope to have better Google integration later this year.
slothster
If its based on my account settings, what settings do I need to change to make it work or whitelist your app?

You can try to reduce the security settings but I cannot promise it will work.
patient_candlestand
THanks for having a look - i decreased the settings but the same result. I also saw this message that starting may it'll be deprecated anyways. Thanks for giving it a try though.
Allow less secure apps: ON On May 30, 2022, this setting will no longer be available.
elad_geek
Still getting this block even after setting the security settings to be more permissive. Any ideas how to resolve this?

Unfortunately not, they seem to hard block some types of emails or countries. For some people, it works, for some not. Google is really unfriendly to app developers, even their docs are terrible. But an official integration is coming soon!
enviable_photocopier
Still facing this issue. Any way to set up an export?

There will be an official integration in the relatively new feature. Unfortunately, this actor simply works for some and doesn't for others.
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.