topic Smart Mapping with Google Sheets in ArcGIS JavaScript Maps SDK Questions https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/smart-mapping-with-google-sheets/m-p/449894#M41548 <HTML><HEAD></HEAD><BODY><P>I am tasked with a very interesting project. I have a google sheets document that contains non spatial data. I have a custom ArcGIS Javascript API map that has a states shapefile from AGOL. I want this google sheets doc to be "live" in the map. I have read ESRI documents about uploading a CSV into AGOL but it needs a spatial which this does not have. I have looked at several different scenerios. One would be a python script using Pygsheets or using another cloud based storage system to reference the spreadsheet. Sorry if that was confusing but some advice would be greatly appreciated!</P></BODY></HTML> Fri, 04 Oct 2019 14:27:00 GMT JohnnyHarley2 2019-10-04T14:27:00Z Smart Mapping with Google Sheets https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/smart-mapping-with-google-sheets/m-p/449894#M41548 <HTML><HEAD></HEAD><BODY><P>I am tasked with a very interesting project. I have a google sheets document that contains non spatial data. I have a custom ArcGIS Javascript API map that has a states shapefile from AGOL. I want this google sheets doc to be "live" in the map. I have read ESRI documents about uploading a CSV into AGOL but it needs a spatial which this does not have. I have looked at several different scenerios. One would be a python script using Pygsheets or using another cloud based storage system to reference the spreadsheet. Sorry if that was confusing but some advice would be greatly appreciated!</P></BODY></HTML> Fri, 04 Oct 2019 14:27:00 GMT https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/smart-mapping-with-google-sheets/m-p/449894#M41548 JohnnyHarley2 2019-10-04T14:27:00Z Re: Smart Mapping with Google Sheets https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/smart-mapping-with-google-sheets/m-p/449895#M41549 <HTML><HEAD></HEAD><BODY><P>If the&nbsp;<SPAN style="background-color: #ffffff;">google sheets document contains non-spatial data, does it contain any fields in common with the&nbsp;<SPAN>states shapefile from AGOL? If so, you could try to join the date together.</SPAN></SPAN></P><P><SPAN style="background-color: #ffffff;"></SPAN></P><P><SPAN style="background-color: #ffffff;"><SPAN><A class="link-titled" href="https://doc.arcgis.com/en/arcgis-online/analyze/join-features.htm" title="https://doc.arcgis.com/en/arcgis-online/analyze/join-features.htm">Join Features—ArcGIS Online Help | Documentation</A>&nbsp;</SPAN></SPAN></P></BODY></HTML> Fri, 04 Oct 2019 22:28:24 GMT https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/smart-mapping-with-google-sheets/m-p/449895#M41549 Noah-Sager 2019-10-04T22:28:24Z