# How to take bundles given by chatgpt and populate it a table in sheets **URL:** \ **Category:** Questions\ **Tags:** chatgpt, google-sheets\ **Created:** [November 15, 2024, 5:51pm UTC](https://community.make.com/t/how-to-take-bundles-given-by-chatgpt-and-populate-it-a-table-in-sheets/61114 "2024-11-15T17:51:33Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Sudhansh\_Perkari](https://avatars.discourse-cdn.com/v4/letter/s/d07c76/32.png) [@Sudhansh\_Perkari](https://community.make.com/u/Sudhansh_Perkari)\ **Post date:** [November 15, 2024, 5:51pm UTC](https://community.make.com/t/how-to-take-bundles-given-by-chatgpt-and-populate-it-a-table-in-sheets/61114/1 "2024-11-15T17:51:33Z")
Chat gpt has given me the following: 0/Las Cimas II/Suite 115/Available Now/1,579| 0/Las Cimas II/Suite 200/Available Now/11,866| 0/Las Cimas II/Suite 245/Available Now/1,738| i need each section(seperated by /) to be in different cells and each row needs to be in a seperate rows in sheets. Please help ---
**Author:** ![Jennifer\_AI](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/jennifer_ai/32/55136_2.png) [@Jennifer\_AI](https://community.make.com/u/Jennifer_AI)\ **Post date:** [November 16, 2024, 12:05pm UTC](https://community.make.com/t/how-to-take-bundles-given-by-chatgpt-and-populate-it-a-table-in-sheets/61114/2 "2024-11-16T12:05:14Z")
I need something similar, so I’m watching any responses here. I’d like to put 20 rows of data at the bottom of a google sheet. If I find the answer, I’ll come back and post here. ---
**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 18, 2024, 5:11am UTC](https://community.make.com/t/how-to-take-bundles-given-by-chatgpt-and-populate-it-a-table-in-sheets/61114/3 "2024-11-18T05:11:39Z")
Hi @Jennifer_AI , @Sudhansh_Perkari You can split the text using split function. Here is a sample workflow we created: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/f/c/fcf34dbf2ebd9e3c00d0334f0354f3b84d1c5264.png) Sample text you shared: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/f/9/f99464aecf4bb23b6ec33b0b82f3a10e70735860.png) Iterate through each row: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/1/1/11c59f9b72a6b1ed070ab48916b37c45ddec3a2c.png) iterator output: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/3/8/38cf269f979565b88749ad3efd6a3eed97260ff3.png) Adding each value to sheet this way: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/9/d/9dcdd87f97ecdfb1aa94e89085f6d3ebf9ce6973.png) Output: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/5/f/5f07156ffe68430a87abafca74b9f7577bd6fc46.png) **Best regards,** **Msquare Automation** _Platinum Partner of Make_ @Msquare_Automation ---
**Author:** ![Jennifer\_AI](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/jennifer_ai/32/55136_2.png) [@Jennifer\_AI](https://community.make.com/u/Jennifer_AI)\ **Post date:** [November 20, 2024, 11:41am UTC](https://community.make.com/t/how-to-take-bundles-given-by-chatgpt-and-populate-it-a-table-in-sheets/61114/4 "2024-11-20T11:41:03Z")
Thank you!! That’s awesome. ---
**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:** [February 18, 2025, 11:46am UTC](https://community.make.com/t/how-to-take-bundles-given-by-chatgpt-and-populate-it-a-table-in-sheets/61114/5 "2025-02-18T11:46:45Z")