This AI prompt can be used for reading an html table from an email body & convert it to JSON array. The array can further be used to store date in different data source like in online excel file, SharePoint, Dataverse etc.
Create Prompt:
Select "AI hub" from left navigation & click "AI prompts" tile:
Next, click "Create text with GPT using a prompt" tile to create a new prompt:
Enter the name as 'Convert HTML Table to JSON array' in "Prompt details" section.
Expand 'Input' section and create 3 input parameters.
- HTML Table - This parameter will store the value of HTML table
- ExcludeColumns - This parameter will store the comma separated list of columns that needs to be excluded from the output JSON array.
- OutputStructure - This parameter defines the output properties of the output JSON array.
Select 'JSON (preview)' in "Output" section:
Choose 'GPT (preview)' from the "Model" dropdown:
Enter the below text in the "Prompt" (left side):
Create a valid JSON array of objects to list columns from given HTML table:
Exclude property in each JSON object.
Provide valid JSON response that strictly comply with below structure:
Click 'Insert' button and add the parameter in the correct location:
Similarly, add other parameters in the prompt text:
Test Prompt
Enter the sample values in the input parameters to test the custom prompt:
HTML Table:
<table> <tr> <th>Company</th> <th>Contact</th> <th>Country</th> </tr> <tr> <td>Alfreds Futterkiste</td> <td>Maria Anders</td> <td>Germany</td> </tr> <tr> <td>Centro comercial Moctezuma</td> <td>Francisco Chang</td> <td>Mexico</td> </tr> </table>
ExcludeColumns:
Contact
OutputStructure:
Sample data: [{"Company":"String","Contact":"String","Country":"String"}]
Click 'Test prompt' button to get the response:
Output Response:
[
{
"Company": "Alfreds Futterkiste",
"Country": "Germany"
},
{
"Company": "Centro comercial Moctezuma",
"Country": "Mexico"
}
]
Check out my blog to see it in action for extracting html table in email body to JSON array:
Custom AI Prompt to convert html table to JSON array (manish-solanki.com)
