# Google Sheet generates a new row for each data instead of filling a single row

**URL:** <https://community.make.com/t/google-sheet-generates-a-new-row-for-each-data-instead-of-filling-a-single-row/7760>\
**Category:** Questions\
**Tags:** google-sheets\
**Created:** [February 6, 2023, 4:45pm UTC](https://community.make.com/t/google-sheet-generates-a-new-row-for-each-data-instead-of-filling-a-single-row/7760 "2023-02-06T16:45:29Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vianney](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/vianney/32/5097_2.png) [@Vianney](https://community.make.com/u/Vianney)\
**Post date:** [February 6, 2023, 4:45pm UTC](https://community.make.com/t/google-sheet-generates-a-new-row-for-each-data-instead-of-filling-a-single-row/7760/1 "2023-02-06T16:45:29Z")

</div>

Hi Makers!  
I have a scenario whose goal is to retrieve information from a form (to which I do not have access) to insert them in a Google Sheet. I have access to the content of the information entered in the form thanks to the mail generated by it. With a Text Parser module, I can extract the necessary information from the mail thanks to the regular expression below. My problem is the following: the Google Sheet module “Add a row” generates a new row for each data instead of filling a single row with all the data.

Thanks for your help.

```auto
Nom :\s*(?<Nom>.*)|Prénom :\s*(?<Prenom>.*)|Activité professionnelle :\s*(?<Activiteprofessionnelle>.*)|N° ADELI :\s*(?<ADELI>.*)|Email :\s*(?<Email>.*)|Téléphone :\s*(?<Telephone>.*)|Adresse :\s*(?<Adresse>.*)|Code Postal :\s*(?<CodePostal>.*)|Ville :\s*(?<Ville>.*)|Mode de paiement :\s*(?<ModeDePaiement>.*)

```

 ![Capture d’écran 2023-02-06 à 17.32.12](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/2/22b634dce5fae17ae59752b92cbd936b88972cb6.png)  
 ![Capture d’écran 2023-02-06 à 17.32.21](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/7/7fec6be939c13f5a5e68f8121327bb6a0f1b146a.png)  
 ![Capture d’écran 2023-02-06 à 17.33.06](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/2/254f333b37456dc45d3f3587f935c2e2bca1393c.jpeg)  
 ![Capture d’écran 2023-02-06 à 17.33.25](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/3/38dc0719b78e543a4f8efd5005c8e09a712de3e8.jpeg)  
 ![Capture d’écran 2023-02-06 à 17.33.47](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/e/e6f733d068294a9f5a70539c8a2d30ce945e79d7.jpeg)  
 ![Capture d’écran 2023-02-06 à 17.32.35](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/b/b96b5d27ffbde62221a61535906bda9328cc9992.png)

---

<div class="post-metadata">

**Author:** ![loic.wiseflow](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/loic.wiseflow/32/132_2.png) [@loic.wiseflow](https://community.make.com/u/loic.wiseflow)\
**Post date:** [February 6, 2023, 5:21pm UTC](https://community.make.com/t/google-sheet-generates-a-new-row-for-each-data-instead-of-filling-a-single-row/7760/2 "2023-02-06T17:21:03Z")

</div>

Hi,

Your parser module generates bundles so you need to use an aggregator after it to create an array. Then you can map your “add row” module with the values from your array.

---

<div class="post-metadata">

**Author:** ![Vianney](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/vianney/32/5097_2.png) [@Vianney](https://community.make.com/u/Vianney)\
**Post date:** [February 6, 2023, 10:06pm UTC](https://community.make.com/t/google-sheet-generates-a-new-row-for-each-data-instead-of-filling-a-single-row/7760/3 "2023-02-06T22:06:14Z")

</div>

@loic.wiseflow I have added an iterator but I don’t know how to map the “G Sheet Add Row Module” with the values of the array created.

 ![Capture d’écran 2023-02-06 à 23.11.11](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/2/28f64e9f411d343706cffb9ab6e3451a94301ea5.png)

 ![Capture d’écran 2023-02-06 à 22.23.06](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/a/a514033a33a055765dea7382176a050befa89c8d.jpeg)  
 ![Capture d’écran 2023-02-06 à 23.02.48](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/2/27a9211b417431c6282780860a1a1817a3b105e0.jpeg)

---

<div class="post-metadata">

**Author:** ![loic.wiseflow](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/loic.wiseflow/32/132_2.png) [@loic.wiseflow](https://community.make.com/u/loic.wiseflow)\
**Post date:** [February 6, 2023, 11:50pm UTC](https://community.make.com/t/google-sheet-generates-a-new-row-for-each-data-instead-of-filling-a-single-row/7760/4 "2023-02-06T23:50:24Z")

</div>

@Vianney,

Sorry, I meant aggregator, not iterator 🤦

---

<div class="post-metadata">

**Author:** ![Vianney](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/vianney/32/5097_2.png) [@Vianney](https://community.make.com/u/Vianney)\
**Post date:** [February 7, 2023, 1:56pm UTC](https://community.make.com/t/google-sheet-generates-a-new-row-for-each-data-instead-of-filling-a-single-row/7760/5 "2023-02-07T13:56:45Z")

</div>

After several tests, I have understood that the problem was in fact due to the regular expression. I have modified it so that the text parser only outputs one bundle and so the mapping with the Google sheet fields works without the need of an aggregator module.

```auto
(?<=Nom\s:\s)(.*)\n.*(?<=Prénom\s:\s)(.*)\n.*(?<=Activité\sprofessionnelle\s:\s)(.*)\n.*(?<=N°\sADELI\s:\s)(.*)\n.*(?<=Email\s:\s)(.*)\n.*(?<=Téléphone\s:\s)(.*)\n.*(?<=Adresse\s:\s)(.*)\n.*(?<=Code\sPostal\s:\s)(.*)\n.*(?<=Ville\s:\s)(.*)\n.*(?<=Mode\sde\spaiement\s:\s)(.*)

```

 ![Capture d’écran 2023-02-07 à 14.52.35](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/0/03ea06332b15d9ec1a68c9ce1210015eb9d660e9.png)

Thanks for helping

---

<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:** [September 7, 2023, 3:32pm UTC](https://community.make.com/t/google-sheet-generates-a-new-row-for-each-data-instead-of-filling-a-single-row/7760/6 "2023-09-07T15:32:54Z")

</div>