Assigning Survey123 Spills to Workforce Responders - Need Guidance

[ChallagundlaSindhuraITS]

Hi,
I need help with a Python script requirement.

The setup:

• A Survey123 form collects spill data in one feature layer.
• A Workforce app stores responder details (phone, email, region) in another feature layer.

  The task:
  I need to write a script to:

  1. Assign spills from the Survey123 form to responders based on their region.
  2. Send email or text notifications to the assigned responders as soon as a spill is created.

     What I’ve tried:

     • Created a script to access and join the feature layers on the county field.
     • Attempted to send emails using smtplib, but I ran into connection issues on my local machine.

       Questions:

       • How can I reliably send the notifications (email/text)?
       • Where should I host the script to make it run automatically when new spills are added?

         Any advice or ideas are appreciated!

[Andrew_Hare_NZ]

Very very new to ArcGIS (2 days in) although been on the GIS scene since 1996.  So, what my suggestion is, and could totally be incorrect, is to use ArcGIS connectors for Microsoft Power Automate and whether Survey123 has the functionality to use that connector to generate an email