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 publishing the Google Sheet as a CSV file 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:
- Navigated to "Add Item from Cloud Drive"
- Selected the correct Google Sheet
- Reviewed the data (coordinates, etc.)
- 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.