# Extracting data from google spreadsheet to send it by email **URL:** \ **Category:** Questions\ **Tags:** mapping\ **Created:** [November 20, 2024, 8:15pm UTC](https://community.make.com/t/extracting-data-from-google-spreadsheet-to-send-it-by-email/61969 "2024-11-20T20:15:18Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![kvnz](https://avatars.discourse-cdn.com/v4/letter/k/b38774/32.png) [@kvnz](https://community.make.com/u/kvnz)\ **Post date:** [November 20, 2024, 8:15pm UTC](https://community.make.com/t/extracting-data-from-google-spreadsheet-to-send-it-by-email/61969/1 "2024-11-20T20:15:18Z")
Hi I have being trying for hours to extract some info from a couple of columns in excel paste them in gmail module (content field) but it was impossible. Each column has a word that user inputs in google sheets and i just received in the email a couple of characters not a word. I choose Google Sheets - Watch New Rows and Gmail Module. What i was expecting for example that column Name with content John extracted to the gmail module and send an email saying “Hi John” But i just get “Hi J” Appreciate any help. Thank you ---
**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:** [November 21, 2024, 7:02am UTC](https://community.make.com/t/extracting-data-from-google-spreadsheet-to-send-it-by-email/61969/2 "2024-11-21T07:02:56Z")
Hi @kvnz Could you please share the snapshot of the mapping in Gmail module? **Regards,** _Msquare Automation - Platinum Partner of Make_ @Msquare_Automation ---
**Author:** ![kvnz](https://avatars.discourse-cdn.com/v4/letter/k/b38774/32.png) [@kvnz](https://community.make.com/u/kvnz)\ **Post date:** [December 18, 2024, 2:14pm UTC](https://community.make.com/t/extracting-data-from-google-spreadsheet-to-send-it-by-email/61969/3 "2024-12-18T14:14:31Z")
i recently changed the scenario because i read it was better with a webhook So scenario is webhook + gmail Webhook receives an array with 6 items but i cant access the array from the “content field” in the Gmail Module. At the Gmail module it just appear one item, the first. ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/d/a/dae57b7b230dc47c8f7d0699492d6f07beaa87f4.png) ![Captura desde 2024-12-18 11-13-09](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/b/7/b7477854f7912f9d4b1235cd74776539ae19b767.png) ![Captura desde 2024-12-18 11-13-46](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/a/4/a455689ae906110e730f760127960401f57fdd43.png) ---
**Author:** ![kvnz](https://avatars.discourse-cdn.com/v4/letter/k/b38774/32.png) [@kvnz](https://community.make.com/u/kvnz)\ **Post date:** [December 21, 2024, 12:50am UTC](https://community.make.com/t/extracting-data-from-google-spreadsheet-to-send-it-by-email/61969/4 "2024-12-21T00:50:07Z")
I have changed the json format and added an iterator but the module does not iterates. I feel a bit down about it. Thanks in advanced ---
**Author:** ![kvnz](https://avatars.discourse-cdn.com/v4/letter/k/b38774/32.png) [@kvnz](https://community.make.com/u/kvnz)\ **Post date:** [December 24, 2024, 2:41am UTC](https://community.make.com/t/extracting-data-from-google-spreadsheet-to-send-it-by-email/61969/5 "2024-12-24T02:41:49Z")
I finally solved it! The issue wasn’t with how I was doing it but with how I was running it. I had been executing each module separately, but when I ran them all together, everything worked perfectly. ---
**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 16, 2025, 9:28am UTC](https://community.make.com/t/extracting-data-from-google-spreadsheet-to-send-it-by-email/61969/6 "2025-01-16T09:28:47Z")
This topic was automatically closed because it's resolved or inactive. Please, start a new topic.