Hello @Anonymous
First of all, you already have a way to use Python to output content as key-value pairs from extracted text of the email body, right?
You can do "import json" to refer the JSON library in your Python code, then you can use "json.dumps()" method to format the output text as JSON. So far, it's done on the Python side.
After that, you can use action "Convert JSON to custom object" to convert your Python output from JSON format to a custom object. From now on, it is done on the PAD side.
You can retrieve the value of element in custom object as below format:
%JsonAsCustomObject['name']%
%JsonAsCustomObject['salary']%
%JsonAsCustomObject['skills']%
All that remains is to write those values you get to the Excel cells as usual. 🙂
I hope above is make sense for you.
Thank you.
