Extract different dynamic Data from Email and use for different purposes

How To
, , ,
1

Hello all

I have an email that comes that has a static format (for the most part) but dynamic variable data for each entry

The email is structured like this

Network:(can be long string of text variable in size)
Area: (can be long string of text variable in size)
Impact: (can be long string of text variable in size)
Severity: (can be 1 to 4)

This is the first part, I want to extract this section and do 2 things

  1. Capture just that part and send off in an email
  2. Link the Key (static name) to the associated Variable so that i can call it later which i can with parsing and such but this is where I’m stuck, not matter what fandangle i do aggregator, iterator, you name it there is no way i can get these selectable, The closes i can get is to be able to select key or variable attribute but the values in there are only the 1st ones despite they being all there in the input. I have a google sheet with the header containing all these Key values and I’m trying to add a row and essentially populate that row with the varibales aligned with there keys. but because i can’t select the actual variable i can’t input into the add a row node.

The other half of the email is a stable with 4 columns

Element Locations Start Time End time
TOB123 123 main street Jan 4th 2025 16:45:27 Jan5th 2025 18:52:21
TOB123.567 123 main street Jan 4th 2025 16:45:27 Jan5th 2025 18:52:21
TOB123.421 123 main street Jan 4th 2025 16:45:27 Jan5th 2025 18:52:21
TOB123.223 123 main street Jan 4th 2025 16:45:27 Jan5th 2025 18:52:21
NAK474 190 main street Jan 4th 2025 16:45:27 Jan5th 2025 18:52:21
NAK474.345 190 main street Jan 4th 2025 16:45:27 Jan5th 2025 18:52:21
NAK474.193 190 main street Jan 4th 2025 16:45:27 Jan5th 2025 18:52:21
NAK474.534 190 main street Jan 4th 2025 16:45:27 Jan5th 2025 18:52:21

For this one similar as before but slightly different, I want to extract the
Element
Location
Start Time
End Time

but only for the short form sites so in the end it would be like

Element Locations Start Time End time
TOB123 123 main street Jan 4th 2025 16:45:27 Jan5th 2025 18:52:21
NAK474 190 main street Jan 4th 2025 16:45:27 Jan5th 2025 18:52:21

my intention is again to have these populate a google sheet or something which i can the later pull the values individually for various other formats like as example
Pulling the TOB123 or location variable to use in another system or google sheets where we can reference what customers are on it and then later use that match to email clients

I tried everything even Chat GTP and i’m willing to start over if there is better ideas but this gap of having the data all groom but unable to isolate specific variables that match keys is caused me a few weeks of stall. I must be missing something