1

I am trying to create a ArcGIS Online Dashboard that is linked to Google Sheets. I have done this successfully in a regular ArcGIS Online map by published the Google Sheet as a CSV and uploading accordingly; however, this type of layer cannot be read by the Dashboard since it is not a "Hosted Feature Layer".

Therefore, I tried to upload the Google Sheet using the following steps:

  1. Navigated to "Add Item from Cloud Drive"
  2. Selected the correct Google Sheet
  3. Reviewed the data (coordinates, etc.)
  4. Uploaded the Google Sheet

Despite following these steps, I constantly get a "An Error Occurred" message and the new hosted feature layer is blank. I have tried changing the "Share Settings" on the Google Drive, but to no avail.

0

I just had this issue.

Go through and make sure none of the cells in your Google Sheet are exceeding the 255 character limit. This was the source of my error.

If this doesn't resolve the issue, remove any additional sheets that you might be using. Make sure there are no special characters in your field names. Remove any hyperlinks. And go into your browser settings and delete any stored cookies, and try again.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.