Smartsheet link to ArcGIS Online

[KevinJHlava]

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.

[JasonJordan00]

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.

[CoryBowlin]

Jason I’m trying to do the same thing that you explained. Is there any chance you could share some examples of the Scripts you wrote? I’m struggling with api so far. 

[Darrin_Smith]

Jason, I would also be interested if you are having success with this.  My situation is the Smartsheets table has no coordinates.  I am moving points to their correct locations through WebApp Builder tools working with non-technical users, but would like to push those coordinates back to Smartsheets as well as keep the two in sync.  I'm trying to keep Excel out of the workflows!

[VanessaSimps]

There is a blog found here discussing how to do this... 

Haven't tried it out yet, but since there was never a resolution over here and I also found the link mentioned above, thought I would close the loop for anyone else looking for a tutorial... 

[WardHively]

It is! 

Skyway Consulting Co. excels in advanced integration, notably in achieving bidirectional synchronization between ArcGIS and Smartsheet. While our current focus lies in land acquisition projects, we’re keen on diversifying our portfolio. Our standout feature is our ability to establish a no-code integration tailored to your workflow in under 5 hours. With our integration, Smartsheet seamlessly transforms into the ArcGIS attribute table, allowing users to stay within their Smartsheet dashboards at all times.

We are currently offering free consultations prior to posting our solutions on Smartsheet and esri.

Our solutions are native to Smartsheet and esri and require no 3rd party applications. 

[NeilKY]

I'd be interested in a Smartsheet<>ESRI integration solution if anyone has it prebuilt. (Enterprise license needed)

[WardHively]

Neil, If you are still interested I am happy to help. You can reach out to me by email at ward@taketheskyway.com