I have a spreadsheet to table operation that will need to be done daily. Is there a way to create an automation? I am hoping that the joins will still remain intact. It is a weather update that will affect how settings will be set for sensitivity.
I would need ArcPRO, to retrieve the Spreadsheet from a shared folder online, replace the current sheet.. then if possible, export a Layout(s) to the same shared folder.
The Spreadsheet will have the same name each day...
The layout will show geographically how each area is expected to be affected. Because it is weather, those setting will change from the predicted forecast based on variation in actual weather.
If you're able to turn your process into a model or script tool, you can look at the Scheduled Tools documentation to get it running whenever you want. Pay attention to all the notes about licensing and keep an eye on your logs, it's easy for Pro to lose a license and grind your tasks to a halt.
This tutorial may get you part way there:
https://learn.arcgis.com/en/projects/schedule-automated-near-real-time-data-updates/
This one may help too:
https://learn.arcgis.com/en/projects/automate-a-geoprocessing-workflow-with-python/
You can use the arcpy module to interact with an ArcGIS Pro project, export layers.
https://pro.arcgis.com/en/pro-app/3.4/arcpy/mapping/introduction-to-arcpy-mp.htm
You may also refer:
Automation with ArcGIS Pro
This can also be achieved through Model Builder