I used to link Google Sheets to a webmap just by publishing the Sheet, then adding it as CSV to my webmap. Two weeks ago, this worked fine. Today I get errors, with the same Sheets, which are still shared in the same way. When I try to add the Google Sheet as CSV I get an error that the Sheet 'is not accessible':
When I open a webmap that used to have Google Sheets linked as CSV I also get an error that the Sheet 'is not accessible':
Can anyone offer a work-around or tell me how I can get these sheets linked in to my webmaps again? We are using these to coordinate among a bunch of project partners, and not being able to see our data on the map is frustrating.
Thanks for your help.
Solved! Go to Solution.
Hi s degroot,
It looks like you're running into an issue that was logged as a bug in our system about a week ago - Development has taken a look and is hoping to get a fix out as soon as possible. I'll make sure to update the thread once the fix is out.
Here is the BUG that you can subscribe to from MyEsri: BUG-000128074: A public CSV file published using Google Sheets and .. You can also Contact Support and attach your customer number as well. Feel free to send me a DM or email firstname.lastname@example.org and I can help with this process.
In the meantime does the Alternate Solution listed in the BUG suffice as a workaround?
Share documents as Excel files using either Microsoft OneDrive or Dropbox using the second workflow in How To: Add and update Google Sheets data in ArcGIS Online. This method requires manual update to reflect any changes.
Hope this helps and let me know if there are any other questions ~
Thank you for the reply.
I tried adding a file from the cloud drive, and received this error: "Cloud
drive file is invalid or not found." However I can open it in Google Sheets
and edit it just fine.
If I can get the workaround to work, it could suffice temporarily, but the
real benefit from linking a Google Sheet is that the map is automatically
updated when any changes are made to the Sheet. I just don't have time to
do manual updates whenever there's a change (there will be a lot).
I'm not sure if this is an ArcGIS Online problem, or a Google Sheets
problem. I just know that on Jan. 16 all my sheets were linking to
webmaps just fine, and as of today (Jan. 30) they are not, and I changed
nothing in between there.
Unfortunately, the problem is not fixed yet. Data from GoogleSheets can be loaded and shown on the map BUT popups don't show the attribute data. Instead, 'No information available' is indicated. In the attribute table the data is visible.
Can you please let development know about this issue?!
Thanks a lot!
Popups from Google Sheets seem to be working on my map, with all the
attribute data showing.
A few years ago I had the problem of popups from a Google Sheet listing the
field names but not the data (just blank), and the problem was that the
field names contained double colons :: Replacing those with _ solved the