# Extract multiple lines from an email html table to MOnday.com

**URL:** <https://community.make.com/t/extract-multiple-lines-from-an-email-html-table-to-monday-com/17910>\
**Category:** Questions\
**Tags:** text-parser\
**Created:** [October 20, 2023, 8:14am UTC](https://community.make.com/t/extract-multiple-lines-from-an-email-html-table-to-monday-com/17910 "2023-10-20T08:14:32Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![OmriNyx](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/omrinyx/32/55914_2.png) [@OmriNyx](https://community.make.com/u/OmriNyx)\
**Post date:** [October 20, 2023, 8:14am UTC](https://community.make.com/t/extract-multiple-lines-from-an-email-html-table-to-monday-com/17910/1 "2023-10-20T08:14:32Z")

</div>

Hi guys,

I have a scenario that does the following:

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/1/4/146eec6c750d4d8d11b5bd55d6a5aebeccdc781c.png)

1. Watching emails with a certain criteria
2. Using a Text Parser - Get Content from HTML Table
3. HTML to text - Here im taking the info from **Column 1 Row 2** since I used have only a header row and 1 content row  
 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/3/7/37967c33f83ebd2b22ed654f8bd71f6f07df1a8e.png)
4. Im taking the text extract above and searching it in a certain Monday board  
 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/3/0/30f26bd1f13302670332658e3589260360a8b843.png)
5. Once Step 4 return the Item ID, I use the Monday function to update the values of other Monday Columns with the values I received in the initial HTML table  
 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/5/65e18b21c83fdf04e5dcd6ee9e3db04b6c3cf985.png) ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/b/8/b83397b7b9240e64e888ed55dfffa8c67a794985.png)

Since all my mapping is based on looking for an item in Line 2 column 1 and then getting values from other columns in line 2, how can I do this more generic if I have several rows on the html table?

I assume I need to use an Iterator, but how do I say in step 3: "get the value of Column 1 and row N, starting from row 2 onwards), and the same question goes for step 5, mapping value from specific columns (this I know) and rows according to order starting row 2.

Man thanks in advance! 😊 🤖 👾

---

<div class="post-metadata">

**Author:** ![IOA\_Harman](https://avatars.discourse-cdn.com/v4/letter/i/ce7236/32.png) [@IOA\_Harman](https://community.make.com/u/IOA_Harman)\
**Post date:** [October 20, 2023, 9:42pm UTC](https://community.make.com/t/extract-multiple-lines-from-an-email-html-table-to-monday-com/17910/2 "2023-10-20T21:42:03Z")

</div>

Hi Omri,

You are correct, you need to iterate the rows:

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/4/9/496aeeab0230c2914ac36efd1dbbe07b0db0f362.png)

Then in your search step you would use Columns[1]

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/c/e/ce41fd96f2ac21dfd15da8ad29a7d7972f98a815.png)

Then in your Step 5 mappings you would do a similar thing as above, except change the ‘1’ to whichever column you want to map (in this case 4, and 5)

Let me know if this helps

---

<div class="post-metadata">

**Author:** ![OmriNyx](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/omrinyx/32/55914_2.png) [@OmriNyx](https://community.make.com/u/OmriNyx)\
**Post date:** [October 22, 2023, 1:59pm UTC](https://community.make.com/t/extract-multiple-lines-from-an-email-html-table-to-monday-com/17910/3 "2023-10-22T13:59:07Z")

</div>

Thank you @IOA_Harman It is working. I added a “Set Variables” after the iterator, its probably redundant, will try without it at some point 😊

Much appreciated !!! 🏆

---

<div class="post-metadata">

**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\
**Post date:** [November 15, 2023, 4:07am UTC](https://community.make.com/t/extract-multiple-lines-from-an-email-html-table-to-monday-com/17910/4 "2023-11-15T04:07:16Z")

</div>


