Hi, I have a google sheet which is updated periodically and I want to add that layer into my Operations Dashboard.
I have tried these steps:
In Google Sheets:
Use Publish to the Web as a CSV.
I then copied that link and inside my AGOL Web Map I used "Add Layer from Web" and used that link.
It adds the layer fine and I am able to set the refresh on that layer.
Everything refreshes fine in the Web Map.
However, when I try to add that layer to my Operations Dashboard, the Layer is Not Found.
I understand it has to be a hosted Feature Layer, but how do I make it a Hosted Feature Layer that is still updated periodically from the Google sheets?
Any help is appreciated!
Thank you!