If the update needs to be instantaneous I would recommend looking into webhooks, which can be configured to run every time a feature is submitted. You would need access to a tool like Microsoft Power Automate or Integromat to do so though. Documentation on webhooks here: https://developers.arcgis.com/rest/services-reference/online/web-hooks-feature-service-.htm
Alternatively if it could be on an hourly or daily update, I would recommend using ArcGIS Notebooks in AGOL to accomplish this, as you can set them to run on a schedule. This page https://developers.arcgis.com/python/guide/editing-features/ has examples on how to query and add data to feature services using the API for Python, it can take a little bit of getting used to but it works pretty effectively.
Hope that helps!