# Text Parse in to multiple bundle outputs into Google Sheets rows

**URL:** <https://community.make.com/t/text-parse-in-to-multiple-bundle-outputs-into-google-sheets-rows/37225>\
**Category:** Beginner Questions\
**Tags:** arrays\
**Created:** [May 13, 2024, 3:20pm UTC](https://community.make.com/t/text-parse-in-to-multiple-bundle-outputs-into-google-sheets-rows/37225 "2024-05-13T15:20:25Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Brian\_Corish](https://avatars.discourse-cdn.com/v4/letter/b/e95f7d/32.png) [@Brian\_Corish](https://community.make.com/u/Brian_Corish)\
**Post date:** [May 13, 2024, 3:20pm UTC](https://community.make.com/t/text-parse-in-to-multiple-bundle-outputs-into-google-sheets-rows/37225/1 "2024-05-13T15:20:25Z")

</div>

Hello everyone

I`m relatively new to Make and I'm stuck with a particular scenario where I I am trying to extract specific text fields from a set of txt documents and create a spreadsheet for each txt file with the extracted values as columns. I have extracted the text values I want to populate and the array aggregator is outputting the bundles correctly but I can`t get the individual bundle values into the Google Sheet.

 ![Screenshot 2024-05-13 at 16.54.42](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/a/b/ab9e95cbddbd5b52f660c4405a8ef7f549597c3b.png)  
 ![Screenshot 2024-05-13 at 16.55.01](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/e/2ea0a18ab9d3a7b3eca7e89b7ef8723f5af072fd.jpeg)  
Here are the output bundles and here`s what I`m doing in the Google Sheets create new doc from template setting but instead of the bundle output values I`m getting blank fields in the created Google Sheets doc. Could some one tell me what I`m doing wrong? Thanks!

---

<div class="post-metadata">

**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\
**Post date:** [May 13, 2024, 9:13pm UTC](https://community.make.com/t/text-parse-in-to-multiple-bundle-outputs-into-google-sheets-rows/37225/2 "2024-05-13T21:13:05Z")

</div>

Welcome to the Make community!

Looks like the array sub property key is `$1` and your map function is using something different (missing the dollar sign).

[samliew](https://samliew.com/services) – [request private consultation](https://samliew.com/request-quote?ServiceType=Automation%20Consultation&Referrer=Make)

> Join the unofficial [Make Discord server](https://samliew.com/make-discord-invite) to chat with us!

---

<div class="post-metadata">

**Author:** ![Brian\_Corish](https://avatars.discourse-cdn.com/v4/letter/b/e95f7d/32.png) [@Brian\_Corish](https://community.make.com/u/Brian_Corish)\
**Post date:** [May 15, 2024, 7:30am UTC](https://community.make.com/t/text-parse-in-to-multiple-bundle-outputs-into-google-sheets-rows/37225/3 "2024-05-15T07:30:35Z")

</div>

Hello  
Thank you, that helped me figure it out!

B

---

<div class="post-metadata">

**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\
**Post date:** [May 15, 2024, 9:21am UTC](https://community.make.com/t/text-parse-in-to-multiple-bundle-outputs-into-google-sheets-rows/37225/4 "2024-05-15T09:21:10Z")

</div>

No problem, glad I could help!

1. If you have a new question in the future, please start a new thread. This makes it easier for others with the same problem to search for the answers to specific questions, and you are more likely to receive help since newer questions are monitored closely.

2. The [Make Community guidelines](https://community.make.com/t/make-community-the-ultimate-topic/11682) encourages users to try to **mark helpful replies as solutions** to help keep the Community organized.

This marks the topic as solved, so that:

others can _save time_ when catching up with the latest activity here, and

- allows others to _quickly jump to the solution_ if they come across the same problem

To do this, simply click the checkbox at the bottom of the post that answers your question:  
 ![Screenshot_2023-10-04_161049](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/5/d/5d9b26fbef0fd7385a34084f61cd5b9165786f42.png)

3. Don’t forget to like and bookmark this topic so you can get back to it easily in future!

[samliew](https://samliew.com/services) – [request private consultation](https://samliew.com/request-quote?ServiceType=Automation%20Consultation&Referrer=Make)

> Join the unofficial [Make Discord server](https://samliew.com/make-discord-invite) to chat with us!

---

<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:** [May 30, 2024, 5:34am UTC](https://community.make.com/t/text-parse-in-to-multiple-bundle-outputs-into-google-sheets-rows/37225/5 "2024-05-30T05:34:02Z")

</div>


