Create User from Email on Custom Table

[KMNichols]

I have a request from our Security GRC team to create a ticket from an email sent to our company's privacy email.  The privacy email comes from a form that is filled out on our company's external website.

We would like to create a user on a custom table let's call it u_external_users from the email that is received.  The email contains, first, last name, email, state of residence, address, phone number.  We don't want these requests classified as guest user due to the need to follow them closely to ensure we are within the state alotted time to complete the request.

[Kalyani Jangam1]

Hi @KMNichols 

Please check below link once

https://docs.servicenow.com/bundle/vancouver-platform-administration/page/administer/notification/ta...

[Amit Verma]

Hi @KMNichols 

You can easily do it using Flow. Please follow below steps :

1. Ensure that the system property "glide.pop3readerjob.create_caller" is set to false.

2. Create a flow in Flow Designer with Inbound Email as the trigger and trigger conditions as Receive Type as New and User ID is empty so that the Flow will only trigger for Incoming new emails where the sender email does not match the email address in the Users [sys_user] table.

3. Make use of Create Record Action on your table "u_external_users " and update the fields like first name, last name etc. from the data pills of the email received. Refer below snip as a reference :

4. Activate the Flow and test.

Thanks & Regards

Amit Verma

[Dr Atul G- LNG]

Hi @KMNichols 

This property might be helpful