Text Parse in to multiple bundle outputs into Google Sheets rows

Hello everyone

Im 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 cant get the individual bundle values into the Google Sheet.



Here are the output bundles and heres what Im doing in the Google Sheets create new doc from template setting but instead of the bundle output values Im getting blank fields in the created Google Sheets doc. Could some one tell me what Im doing wrong? Thanks!

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 – request private consultation

Join the unofficial Make Discord server to chat with us!

3 Likes

Hello
Thank you, that helped me figure it out!

B

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 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

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

samliew – request private consultation

Join the unofficial Make Discord server to chat with us!

2 Likes