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!

[JakeSkinner]

@ChallagundlaSindhuraITS no, not without an Admin account.

[ChallagundlaSindhuraITS]

Thank You @JakeSkinner  , I dont have a ArcgisPro lisence to go explore that route, but someone from the other team suggested that Email's are usually handled using web hooks via Microsoft Power Automate.  I am not the person who created the Survey123 Spill form, but can i create webhook or attach a .py script to assign a spill and send email notifications?