Exctract html email via n8n

I am recieving below email
i want to extract E-Gift Card Code , Face Value ,PIN,Expiry Date as json so i can upload to google sheets can anyone help how can i use n8n html extract ??

<html xmlns="http://www.w3.org/1999/xhtml" xmlns:th="http://www.thymeleaf.org">\n<head>\n    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />\n    <title>Axis Bank AR</title>\n</head>\n<body>\n<table width="600" border="0" cellspacing="0" cellpadding="0" align="center" style="border:1px solid #e1e1e1;">\n    <tr>\n        <td align="center" height="15">\n            <spacer dataset="block" height="15" />\n        </td>\n    </tr>\n    <tr>\n        <td align="center" valign="top">\n            <table width="570" border="0" cellspacing="0" cellpadding="0" align="center">\n                <tr>\n                    <td height="20" align="left" valign="middle"><img src="https://cdn.gyftr.com/comm_engine/prod/images/img_vars/content/1602306224222_iqxzenjkg37r78e.png" width="570" height="71" alt="Masthead" /></td>\n                </tr>\n                <tr>\n                    <td align="center" valign="top" height="15">\n                        <spacer dataset="block" height="15" />\n                    </td>\n                </tr>\n                <tr>\n                    <td align="left" valign="top" style="font-family:Arial, Helvetica, sans-serif; font-size:12px; color:#333333;line-height:18px; padding-right:20px;">Dear ABHAY,<br />\n                        <br /> Thank you for buying Pantaloons Instant Gift Voucher. The details of your Instant Gift Voucher are as follows:\n                    </td>\n                </tr>\n                <tr>\n                    <td align="left" valign="top" height="15">\n                        <spacer dataset="block" height="15" />\n                    </td>\n                </tr>\n                <tr>\n                    <td align="left" valign="top" style="padding-bottom: 7px;">\n                        <table width="100%" border="0" cellpadding="4" cellspacing="1" style="border-collapse: collapse; font-family:Arial, Helvetica, sans-serif; font-size:12px; color:#000000;    text-align: center;  width:100%;">\n                            <tr><th style='font-family:Arial, Helvetica, sans-serif; font-size:12px;border: 1px solid #000000; padding: 5px;'>QR Code</th><th  style='font-family:Arial, Helvetica, sans-serif; font-size:12px;border: 1px solid #000000; padding: 5px;'>E-Gift Card Code</th><th  style='font-family:Arial, Helvetica, sans-serif; font-size:12px;border: 1px solid #000000; padding: 5px;'>Face Value</th><th  style='font-family:Arial, Helvetica, sans-serif; font-size:12px;border: 1px solid #000000; padding: 5px;'>PIN</th><th  style='font-family:Arial, Helvetica, sans-serif; font-size:12px;border: 1px solid #000000; padding: 5px;'>Expiry Date</th></tr>\n                            <TR>\n<TD height='100' style='font-family:Arial, Helvetica, sans-serif; font-size:12px;border: 1px solid #000000; padding: 5px;'><img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAHQAAAB0CAYAAABUmhYnAAAAAklEQVR4AewaftIAAAKdSURBVO3BQW7kQAwEwSxC//9yro88NSBIM7C5jIg/WGMUa5RijVKsUYo1SrFGKdYoxRqlWKMUa5RijVKsUYo1SrFGKdYoxRrl4qEkfJNKl4RO5SQJncpJEr5J5YlijVKsUYo1ysXLVN6UhDepPKHypiS8qVijFGuUYo1y8WFJuEPliSQ8oXJHEu5Q+aRijVKsUYo1ysUfp9Il4X9WrFGKNUqxRrn445LQqXRJ6FS6JExSrFGKNUqxRrn4MJVPUumS0Kl0SXiTym9SrFGKNUqxRrl4WRK+KQmdSpeETqVLwh1J+M2KNUqxRinWKPEH/5EknKj8ZcUapVijFGuU+IMHktCpnCThk1TuSMKJykkSOpUuCXeoPFGsUYo1SrFGuXhZEu5Q6ZLQqXRJ6FS6JHQqTyShU3lC5ZOKNUqxRinWKBdfptIl4SQJJ0l4QuWOJLwpCZ3KE8UapVijFGuUi5epnCThDpUuCZ3KHUnoVLokdConKl0S7lB5U7FGKdYoxRol/uCBJDyhcpKEE5UuCZ3KE0n4JJU3FWuUYo1SrFHiD/6wJHyTSpeETqVLwh0qTxRrlGKNUqxRLh5KwjepnKjckYQTlROVLgmdyjcVa5RijVKsUS5epvKmJLwpCScqdyShUzlJwonKE8UapVijFGuUiw9Lwh0qb0rCE0noVDqVLgmdSqfSJeFNxRqlWKMUa5SL4VS6JNyh8kQSOpVO5U3FGqVYoxRrlIs/TqVLwonKSRJOVE5UTpJwovJEsUYp1ijFGuXiw1S+SeWbknCicqLypmKNUqxRijXKxcuS8E1JeELlRKVLQqfymxRrlGKNUqxR4g/WGMUapVijFGuUYo1SrFGKNUqxRinWKMUapVijFGuUYo1SrFGKNUqxRvkHSjIC4XPnrEwAAAAASUVORK5CYII=" width='80' height='50' alt="PT1234567895654654"></TD>\n<TD style='font-family:Arial, Helvetica, sans-serif; font-size:12px;border: 1px solid #000000; padding: 5px;'>PT1234567895654654</TD>\n<TD style='font-family:Arial, Helvetica, sans-serif; font-size:12px;border: 1px solid #000000; padding: 5px;'>500.00</TD>\n<TD style='font-family:Arial, Helvetica, sans-serif; font-size:12px;border: 1px solid #000000; padding: 5px;'>5927</TD>\n<TD style='font-family:Arial, Helvetica, sans-serif; font-size:12px;border: 1px solid #000000; padding: 5px;'>07 Apr 2024</TD>\n</TR>\n                        </table>\n                    </td>\n                </tr>  \n                <tr>\n                    <td align="left" valign="top" height="7">\n                        <spacer dataset="block" height="7" />\n                    </td>\n                </tr>\n                <tr>\n                    <td align="left" valign="middle" style="font-family:Arial, Helvetica, sans-serif; font-size:12px; color:#333333;line-height:18px;"><strong></strong></td>\n                </tr>\n                <tr>\n                    <td align="left" valign="top" height="7">\n                        <spacer dataset="block" height="7" />\n                    </td>\n                </tr>\n                <tr>\n                    <td align="left" valign="top" style="font-family:Arial, Helvetica, sans-serif; font-size:12px; color:#000000;line-height:16px; padding:5px 0px 5px 0px;"><strong>Voucher Helpline:</strong> For any queries related to your Instant Gift Voucher <a href="bit.ly/3iVGFg0" target="_blank" style="color:#000">Click Here</a> or call us at 18001033314 (09:30 am to 11 pm).<br><br>\n\n                    <strong>* Note:</strong> Your Bonus <strong><em>EDGE REWARD</em><strong> Points (10X / 5X / 3X) will be credited into your account within 120 days of your purchase. For any queries related to point’s credit, please contact the bank helpline.\n                     </td>\n                </tr>\n                <tr>\n                    <td align="left" valign="top" height="5"> </td>\n                </tr>\n                <tr>\n                    <td align="left" valign="top">\n                        <table width="550" border="0" cellspacing="0" cellpadding="0">\n                            <tr>\n                                <td align="center" valign="top" height="5"> </td>\n                            </tr>\n                            <tr>\n                                <td align="left" valign="middle" style="font-family:Arial, Helvetica, sans-serif; font-size:12px; color:#333333;line-height:18px;"><strong>How to Redeem:</strong> <a href="bit.ly/33Wu4VF" target="_blank">Click here</a></td>\n                            </tr>\n                            <tr>\n                                <td align="center" valign="top" height="20"> </td>\n                            </tr>\n                            <tr>\n                                <td align="left" valign="middle" style="font-family:Arial, Helvetica, sans-serif; font-size:12px; color:#333333;line-height:18px;"><strong>Important Instructions</strong></td>\n                            </tr>\n                            <tr>\n                                <td align="center" valign="top" height="5">\n                                </td>\n                            </tr>\n                            <tr>\n                                <td width="526" align="left" valign="middle" style="font-family:Arial, Helvetica, sans-serif; font-size:12px; color:#000000;line-height:16px; padding:0px 0px 5px 0px;">    <ul>\n<li>This is a Pantaloons Insta Gift Voucher (GV) / Gift Card (GC) and can be redeemed for any product at participating pantaloons stores across India.</li>\n<li>More than one GV / GC can be used in one bill.</li>\n<li>Pantaloons GV / GC can be used during sale.</li>\n<li>Pantaloons E-Gift voucher is not valid at shop-in-shops & on jewellery.</li>\n</ul>\n\n                                </td>\n                            </tr>\n                        </table>\n                    </td>\n                </tr>\n                <tr>\n                    <td align="left" valign="top" style="font-family:Arial, Helvetica, sans-serif; font-size:12px; color:#000000;line-height:16px; padding:5px 0px 5px 0px;font-weight: bold;">Warm regards,<br />Gift Edge Team</td>\n                </tr>\n                <tr>\n                    <td align="center" valign="top" height="5" style="border-top:1px solid #D2D2D2;">\n                        <spacer dataset="block" height="5" />\n                    </td>\n                </tr>\n                <tr>\n                    <td align="left" valign="top" height="15">\n                        <spacer dataset="block" height="15" />\n                    </td>\n                </tr>\n                <tr>\n                    <td align="left" valign="top">\n                        <table width="550" border="0" cellspacing="0" cellpadding="0">\n                            <tr>\n                                <td align="left" valign="middle" style="font-family:Arial, Helvetica, sans-serif; font-size:11px; color:#333333;line-height:18px;">            <strong>Terms and Conditions</strong>           </td>\n                            </tr>\n                            <tr>\n                                <td align="left" valign="middle" height="5">\n                                    <spacer dataset="block" height="5" />\n                                </td>\n                            </tr>\n                            <tr>\n                                <td align="left" valign="middle" style="font-family:Arial, Helvetica, sans-serif; font-size:11px; color:#666666;line-height:14px; padding:0px 0px 5px 0px;white-space:pre;">1.This is a Pantaloons Insta Gift Voucher (GV) / Gift Card (GC) and can be redeemed for any product at participating pantaloons stores across India. For list of Stores, click here https://www.pantaloons.com/content/store-locators-9.<br/>2.Pantaloons Insta Gift Voucher (GV) / Gift Card (GC) and is valid for one year from the date of issuance.<br/>3.The person who has the Pantaloons GV / GC is deemed to be the beneficiary.<br/>4.Do inform the cashier that you plan to use the GV / GC for making payments before billing.<br/>5.Validity period of the E-Gift voucher will not be extended under any circumstances.<br/>6.Pantaloons Insta Gift Voucher (GV) / Gift Card (GC) is redeemable only once and only by the bearer.<br/>7.Pantaloons Insta Gift Voucher (GV) / Gift Card (GC) is not valid at shop-in-shops & on jewellery.<br/>8.Pantaloons Insta Gift Voucher (GV) / Gift Card (GC) must be redeemed in full and partial redemption is not allowed.<br/>9.Pantaloons Insta Gift Voucher (GV) / Gift Card (GC) is not redeemable for cash or credit nor can be exchanged for a gift voucher/gift card.<br/>10.More than one GV / GC can be used in one bill.<br/>11.Pantaloons GV / GC can be used during sale.<br/>12.No duplicate will be issued if Pantaloons E-Gift voucher is lost or misplaced.<br/>13.Providing the correct Mobile no & E-mail Id will be customer's responsibility for generation of E-GV Redemption Code<br/>14.The bearer of the E-Gift Voucher shall protect the E-Gift Voucher number and PIN to avoid misuse. Pantaloons shall not assume any liability in case the E-Gift Voucher PIN gets stolen/compromised, Pantaloons shall neither replace the e-GC nor refund cash.<br/>15.Any dispute should be referred to any company and decision of the company shall be final.<br/>16.Pantaloons Insta Gift Voucher (GV) / Gift Card (GC) has been issued subject to the terms of the company.<br/>17.Dispute arising in respect of the E-Gift Voucher, shall be subject to the exclusive jurisdiction of the Mumbai Court.<br/>18.Pantaloons makes full efforts to accept Insta Gift Vouchers (GV) / Gift Card (GC) but on account of any technical / administrative reasons an outlet may refuse to accept the same.<br/>19.Redemption Process for the Insta GV / GC-<br/>a)Customer receives an email & sms confirmation having the GV/GC Code and PIN<br/>b)Cashier will put GV/GC no. & pin to redeem the voucher in the bill & reduce payable amount.<br/>c)If bill value is greater than GV/GC value, customer to pay balance amount in other payment modes.<br/>20.For any concern, write to [email protected] and for any queries / issues related to GV / GC, raise a request at www.gvhelpdesk.com\n                                </td>\n                            </tr>\n                        </table>\n                    </td>\n                </tr>\n            </table>\n        </td>\n    </tr>\n    <tr>\n        <td align="center" valign="top" height="15">\n        </td>\n    </tr>\n    <tr>\n        <td align="center" valign="top">\n            <table width="600" border="0" cellspacing="0" cellpadding="0">\n                <tr>\n                    <td align="center" valign="top"><img src="https://cdn.gyftr.com/comm_engine/prod/images/img_vars/content/1602306257847_iqxzenjkg37rx6f.png" width="570" height="18" alt="Band" />     </td>\n                </tr>\n                <tr>\n                    <td align="left" valign="top" style="background-color:#e1e1e1;">\n                        <table class="full-w" style="text-align:left; border:0; padding:0; margin:0 auto; width:100%; border-spacing:0; background:#ffffff;border-top:2px solid #e9e9e9; ">\n                            <tbody>\n                                <tr>\n                                    <td style="text-align:center; padding:5px; padding-bottom:15px;">\n                                        <img src="http://images.gyftr.com/HDFCMoneyBack/gyftr.jpg" alt="GyFTR Logo">\n                                    </td>\n                                </tr>\n                                <tr>\n                                    <td style="text-align:center; padding:5px 0 20px;font-size:11px;font-family:Arial,sans-serif;color:#333333; font-weight:bold;">\n                                        For any help <a href="bit.ly/3iVGFg0" target="_blank">Click Here</a>\n                                      <span style="display:inline-block; padding:0 10px; outline:none;">|</span>  <span style="display:inline-block; outline:none;">18001033314</span> \n                                    </td>\n                                </tr>\n                            </tbody>\n                        </table>\n                    </td>\n                </tr>\n            </table>\n        </td>\n    </tr>\n</table>\n\nClick <a href="http://delivery.gyftr.com/KJHVAN?id=77635=MB1UAVQGBgUASBVBQ0MRRBYRQ0VGGBFGFEMQQhASQURFQUQRQxEQFhUUFUFDQxFEFgEfBglWRQdXF3AGQlYAAwRPB14OTQEADQQNUVVUBlUCBVBRUgwHGlwXRBIKHU4AAA0NRwZDSRhSTVMVEU1SC1seKC8ubnAoCwpUHkYB">here</a> to unsubscribe\n<img id='SBBBB' src='http://delivery.gyftr.com/KJHVAN?id=77635=Kh1UAVQGBgUASBVBQ0MRRBYRQ0VGGBFGFEMQQhASQURFQUQRQxEQFhUUFUFDQxFEFgEfBglWRQdXF3AGQlYAAwRPB14OTQEADQQNUVVUBlUCBVBRUgwHGlwXRBIKHU4AAA0NRwZDSRhSTVMVEU1SC1seKC8ubnAoCwpUHkYB' /></body>\n</html>\n\n	```

Hi @Spinefit,

If the structure of the email remains constant, with the following workflow you can do it easily.

:wink:

1 Like

works perfectly jst 1 question can we use chatgpt so even if structure changes we can have final data :stuck_out_tongue:

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.