Help Needed Mapping Array to Google Sheets

[NEON_Global]

Hi Makers. I’ve tried to figure this out for hours, with no luck, so figured I’d see if anyone has a few minutes to help me out. I’m looking to map data from an html table in an email into Sheets.

Here’s where my data is nested in the ouput section of the operation. The columns in collection 1/index 1 are the table headers—I’m looking to pull the info from collection2/index2, and collection3/index 3 (minimized for space). It could also be the case from time to time that an email table has a 3rd row, or just one row.

My specific issue is I’m having trouble formatting the correct mapping in the Google Sheets fields, to pull over the exact data that I want.

inputbundle.txt (5.3 KB)

inputbundle.txt (5.3 KB)

Thanks to all for reading and extra thanks to anyone who has the knowledge/time to help.

[Msquare_Automation]

Hi @NEON_Global

Could you share the output bundle of this module instead of input bundle.

Best regards,

Msquare Automation
Gold Partner of Make
@Msquare_Automation

[NEON_Global]

Woops. Here you go. Thanks.
inputbundle.txt (13.4 KB)

outputbundle.txt (5.3 KB)

[OmriNyx]

The question is how you want to map the 3rd row of the table onwards, will it be to another row on Google Sheets, if so, you can iterate on the collections so that each collection starting the 2nd will (data and not header) will add a row to Google Sheets…

If you want all the data from the input to be ONE row on google sheets, you may need to aggregate the results first