Hi Kris, when I first tried to use it, it failed as the script is set up to update layers and I needed to update a table in a feature service. If you publish your csv as a table then you can do the same. I had to change line 40 of Jake's script from arcpy.conversion.FeatureClassToFeatureClass to arcpy.conversion.TableToTable and lines 64 and 86 refer to fLyr = premiseLayer.layers[0] so I changed this to fLyr = premiseLayer.tables[0], which seemed to do the trick.
Also I changed the GIS object on line 18 to gis = GIS("Pro") as I didn't want to store my user credentials in the script so I found out that by using this your credentials can be read from ArcGIS Pro. You just need to make sure your login is saved automatically in Pro.
Once you've tested your script and it works you can save it as a python file and then add it to an ArcGIS tool box. Open the script in the geoprocessing window of Pro and the drop down next to run will allow you to schedule the tool to run regularly. My issue is I'm not sure how to run it when I'm not working and my pc is off. I may need to look into a virtual machine.
Like I said I'm a beginner when it comes to the python API but with a little tinkering was able to get mine to work. Hope you manage to get something working at your end too. Cheers