Trouble with Google Sheets - Looking for alternative solution?

[KateSweet]

Hi, 

I have a Google sheet that a team of people contributes to that I want to update on a field map throughout a field season. I tried uploading the Google sheet in AGOL and saw this message. I tried adjusting security settings as well as using a non-work email address to host the file and transfer it over, but still no success. Does this feature still work for you? Is there a specific email/security setting that I've missed?

Is there another workaround to do something similar (update a layer throughout a season with a linked Google sheet)?

Thanks!

[ScottBall · Accepted solution]

Hi - this is something the ArcGIS Online team is aware of. If you log a support case you will be attached to the issue and will be notified when the team finds / implements a solution. 

Also, in lieu of using Google Sheets you could potentially set up a Survey123 survey connected to a hosted feature layer to ingest information from contributors directly into ArcGIS. 

[rachelg_esri]

To add some additional information to Scott's recommendation, when you call in to Support, to expedite your case being attached to the correct bug, please include the following bug number in your case description:

BUG-000173427: Unable to add content from Google Drive and “This app is blocked. This app tried to access sensitive info in your Google Account. To keep your account safe, Google blocked this access” error is returned.

I won't have be able to provide any future information on the status of this bug - just providing it so your Support analyst can find it quicker.

Please be sure to call in so we can add you to the list of those affected.

Thank you!