XML Email Body

[shawnryder]

Just a quick question - if I have an email body like this - can I take it and parse it to push in to Google Sheets or similar application:

<?xml version="1.0" encoding="UTF-8"?>
<?ADF version="1.0"?>
<adf>
<prospect>
<id source="language">English</id>
<requestdate>2023-03-18T19:39:07-04:00</requestdate>
<vehicle interest="buy" status="Used">
<id sequence="1" source="Stock#">A54488</id>
<year>2021</year>
<make>Volkswagen</make>
<model>Atlas</model>
<trim></trim>
<vin>1V2LR2CAXMC554488</vin>
<stock>A54488</stock>
<price>43988</price>
<condition>Used</condition>
</vehicle>
<customer>
<contact>

Etc....

 

[Pabblymember11]

Hey @shawnryder

Please refer to the following screenshot once on how you can parse the data from your email body.