# Help Needed Mapping Array to Google Sheets **URL:** \ **Category:** Questions\ **Tags:** arrays, google-sheets, mapping\ **Created:** [October 22, 2024, 5:24pm UTC](https://community.make.com/t/help-needed-mapping-array-to-google-sheets/58555 "2024-10-22T17:24:47Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![NEON\_Global](https://avatars.discourse-cdn.com/v4/letter/n/74df32/32.png) [@NEON\_Global](https://community.make.com/u/NEON_Global)\ **Post date:** [October 22, 2024, 5:24pm UTC](https://community.make.com/t/help-needed-mapping-array-to-google-sheets/58555/1 "2024-10-22T17:24:47Z")
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. ![Screen Shot 2024-10-22 at 1.13.43 PM](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/1/e/1e8c93fe0ef05fcf104a5e57880bdff396076398.png) 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. ![bing html table blur](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/3/b/3b7761c5f5bafa9b026f600deaef4e315f475b52.png) [inputbundle.txt](https://community.make.com/uploads/short-url/meGMj3nSjXtgKW4cTEAq4mKSKS5.txt) (5.3 KB) [inputbundle.txt](https://community.make.com/uploads/short-url/meGMj3nSjXtgKW4cTEAq4mKSKS5.txt) (5.3 KB) Thanks to all for reading and extra thanks to anyone who has the knowledge/time to help. ---
**Author:** ![Msquare\_Automation](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/msquare_automation/32/6634_2.png) [@Msquare\_Automation](https://community.make.com/u/Msquare_Automation)\ **Post date:** [October 23, 2024, 5:16am UTC](https://community.make.com/t/help-needed-mapping-array-to-google-sheets/58555/2 "2024-10-23T05:16:27Z")
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 ---
**Author:** ![NEON\_Global](https://avatars.discourse-cdn.com/v4/letter/n/74df32/32.png) [@NEON\_Global](https://community.make.com/u/NEON_Global)\ **Post date:** [October 25, 2024, 5:48pm UTC](https://community.make.com/t/help-needed-mapping-array-to-google-sheets/58555/4 "2024-10-25T17:48:52Z")
Woops. Here you go. Thanks. [inputbundle.txt](https://community.make.com/uploads/short-url/jnAnu0TIj7GeM4v0rKMPBWpMmlC.txt) (13.4 KB) [outputbundle.txt](https://community.make.com/uploads/short-url/meGMj3nSjXtgKW4cTEAq4mKSKS5.txt) (5.3 KB) ---
**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 26, 2024, 10:55pm UTC](https://community.make.com/t/help-needed-mapping-array-to-google-sheets/58555/5 "2024-10-26T22:55:00Z")
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 ---
**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:** [January 25, 2025, 12:00am UTC](https://community.make.com/t/help-needed-mapping-array-to-google-sheets/58555/6 "2025-01-25T00:00:35Z")
This topic was automatically closed because it's resolved or inactive. Please, start a new topic.