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 ```