Link Arcpro to Google Sheet with out the sheet being publicly accessible.

[FlightDeck]

Hey All,

I have a Google Sheet that I brought in to Arcpro by exporting it to Excel, Importing the excel file to Arcpro, then used Create Points from Table, and applied symbology. I now need to update this data. I'm thinking there has to be a better way especially since this gets published to our portal/experience builder and completely remaking this layer will require a bunch more work to the portal/experience builder side of things. 

Is there anyway to create a feature based on a Non-public, Internal only, Google Sheet where I don't have to essentially rebuild the entire project each time I need to update the data? 

I have seen some tutorials out there, but they seem to only involve publicly accessible data or ArcGOL, neither of which are an option for me. Any help is appreciated. TIA.

[BobBooth1]

You can set up a script to update (append to or overwrite) the feature layer, instead of recreating it.

Here is an example (not google sheets, but illustrates the principle).

https://learn.arcgis.com/en/projects/schedule-automated-near-real-time-data-updates/

[FlightDeck]

Thanks, but Unless I am missing something this tutorial, like the others, Is for ArcGOL not ArcPro. Anyway around this?

[BobBooth1]

The tutorial does show updating an ArcGIS Online hosted feature service. The OverwriteFS.py script featured in the tutorial supports overwriting Enterprise hosted feature services as well. See the PDF documentation in the zipfile here.

https://www.arcgis.com/home/item.html?id=d45f80eb53c748e7aa3d938a46b48836

There is also a code snippet in this post that may help you:

https://community.esri.com/t5/arcgis-enterprise-portal-questions/append-data-to-hosted-feature-layer...

[BobBooth1]

For the ArcGIS Pro side of things, I would suggest using geoprocessing tools manually to make the data that you want to update your local feature class with and overwrite your current geodatabase feature class with it, and then go to the Geoprocessing History and copy the steps from the history as Python snippets.

https://pro.arcgis.com/en/pro-app/latest/help/analysis/geoprocessing/basics/geoprocessing-history.ht...

That code is a good starting place for a local notebook in ArcGIS Pro, or a Python script, that you can use to automate the process.