Extract name from HTML table and lookup against a Google Sheet

How To
,
1

Hi there,

I receive an email from a vendor which contains an HTML table. I want to extract the name and amount from the table rows, then lookup those names against a Google Sheet. For each name match, I then want to do other stuff…

I managed to get the HTML table via the Text Parser object, but not sure how to go from there. Could someone help me out please?

Here’s the output from the text parser. I want to lookup each name e.g. Baker, Geier, King etc against a Google Sheet, then extract other info from the sheet row.

[
    {
        "caption": "",
        "headers": [],
        "rows": [
            {
                "index": 1,
                "columns": [
                    "\nAmount Paid\n",
                    "\nInvoice (Reference)#\n",
                    "\nDate\n"
                ]
            },
            {
                "index": 2,
                "columns": [
                    "\n$1,645.00\n",
                    "\nHALL Baker 10-24\n",
                    "\n10/1/2024\n"
                ]
            },
            {
                "index": 3,
                "columns": [
                    "\n$1,645.00\n",
                    "\nRRH Geier 10-24\n",
                    "\n10/1/2024\n"
                ]
            },
            {
                "index": 4,
                "columns": [
                    "\n$1,258.00\n",
                    "\nRRH King 10-24\n",
                    "\n10/1/2024\n"
                ]
            },
            {
                "index": 5,
                "columns": [
                    "\n$1,164.00\n",
                    "\nRRH Lopez 10-24\n",
                    "\n10/1/2024\n"
                ]
            },
            {
                "index": 6,
                "columns": [
                    "\n$1,164.00\n",
                    "\nRRH Davis 10-24\n",
                    "\n10/1/2024\n"
                ]
            },
            {
                "index": 7,
                "columns": [
                    "\n$1,258.00\n",
                    "\nRRH Schorgl 10-24\n",
                    "\n10/1/2024\n"
                ]
            }
        ]
    }
]