I feel this took me too much time to figure out, so I am posting a quick showcase to maybe save future makers some time.
Background: Our company gets email notifications from our bank whenever there are collections/payments received. The email always includes an HTML table, but it can be in a different order or contain extra fields.
Solution: Using a mailhook, we can setup a make scenario that instant triggers every time an email is sent to our inbox we can ingest it in make and send the relevant data to where it needs to get to.
Showcase: See the screenshots below, but what I wanted to share with the community is how I used the ‘Text parser’ to ‘get content from an HTML table’ and then iterate and aggregate that data to make it usable in our scenario.
The interesting finding was the Get Content from HTML Table worked really well, but the data was Array to Collection to Array. So I was struggling to get the Key/Value pairings with the get and map functions (maybe someone can share on this thread how to do that more easily).
So the solution was using the ‘text aggregator’ module, and specifically the group by with the text to aggregate, I could effectively create a Key:Value pairing that I was used to having.
Ultimately I end up with very easy to work with bundles, where each bundle has a key and a value. From here I ended up putting in a data store, then I can use ‘get a record’ calls to the data store to pull out the exact data I want to pass to a Google Sheet (and Slack).
I am always eager to learn and continue to grow my make skills, so if anyone else in the community has a more efficient or nice way to solve for this, I would be happy to hear about it. In the meantime, I hope someone else finds this helpful, as I couldn’t find much on the community regarding the ‘Get content from HTML table’ and how to actually transform that to a usable array or bundle of data.