Is it possible to have a live data connection from Smartsheet into ArcGIS online? I would like to have a table in Smartsheet that has latitude and longitude display directly in a ArcGIS online map.
I've been able to do a rough connection by grabbing Smartsheet data with their Python API then pushing that to an AGOL feature service with the ArcGIS API for Python. We set it up in Task Scheduler so it's an automatic update a few times a day. Not ideal but it works. With increased support for webhooks in AGOL that might be another option to explore.