# From ChatGPT response to Google Sheets in one row, seperated by commas

**URL:** <https://community.make.com/t/from-chatgpt-response-to-google-sheets-in-one-row-seperated-by-commas/28410>\
**Category:** Questions\
**Tags:** iterator, chatgpt, google-sheets\
**Created:** [February 23, 2024, 10:12am UTC](https://community.make.com/t/from-chatgpt-response-to-google-sheets-in-one-row-seperated-by-commas/28410 "2024-02-23T10:12:06Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Andraz\_Radovan](https://avatars.discourse-cdn.com/v4/letter/a/5fc32e/32.png) [@Andraz\_Radovan](https://community.make.com/u/Andraz_Radovan)\
**Post date:** [February 23, 2024, 10:12am UTC](https://community.make.com/t/from-chatgpt-response-to-google-sheets-in-one-row-seperated-by-commas/28410/1 "2024-02-23T10:12:06Z")

</div>

I have one issue because I don’t know how to separate one string I get from ChatGPT which is separated by commas and then use those separated values and put them all in one line in Google Sheets like this:  
 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/e/3/e39e31ce779fe3e10d5aa3a4fb52cf295ebeaa18.png)

Thid is part of scenario that is giving me issue:

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/c/0/c098c57d7602ec9fec77de644eb4e3acbcc45eff.png)

---

<div class="post-metadata">

**Author:** ![ManishMandot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/manishmandot/32/25887_2.png) [@ManishMandot](https://community.make.com/u/ManishMandot)\
**Post date:** [February 23, 2024, 11:09am UTC](https://community.make.com/t/from-chatgpt-response-to-google-sheets-in-one-row-seperated-by-commas/28410/2 "2024-02-23T11:09:39Z")

</div>

Hey @Andraz_Radovan  
welcome to the make community

You should use split function here like this

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/9/b/9b1addd52784e4726cc4baf396fa0c0ea473b8aa.png)

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/9/692667ec23caf5afb0d1d8ff0f3af2c30fd86961.png)

You can also try this direct function into your google sheet

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/5/c/5c0be65abaaf45f392cbc4538ffe0600a5f92e34.png)

---

<div class="post-metadata">

**Author:** ![Andraz\_Radovan](https://avatars.discourse-cdn.com/v4/letter/a/5fc32e/32.png) [@Andraz\_Radovan](https://community.make.com/u/Andraz_Radovan)\
**Post date:** [February 23, 2024, 11:34am UTC](https://community.make.com/t/from-chatgpt-response-to-google-sheets-in-one-row-seperated-by-commas/28410/3 "2024-02-23T11:34:35Z")

</div>

It works. Thanks for the prompt solution @ManishMandot ! BR

---

<div class="post-metadata">

**Author:** ![ManishMandot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/manishmandot/32/25887_2.png) [@ManishMandot](https://community.make.com/u/ManishMandot)\
**Post date:** [February 23, 2024, 11:39am UTC](https://community.make.com/t/from-chatgpt-response-to-google-sheets-in-one-row-seperated-by-commas/28410/4 "2024-02-23T11:39:13Z")

</div>

@Andraz_Radovan

We are glad to hear that your problem has been solved.

Visit us : [https://www.growwstacks.com/](https://www.growwstacks.com/case-studies)

Feel Free to connect at [admin@growwstacks.com](mailto:admin@growwstacks.com)

**Thanks and Regards**  
**GrowwStacks Automation**

---

<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:** [March 8, 2024, 12:33pm UTC](https://community.make.com/t/from-chatgpt-response-to-google-sheets-in-one-row-seperated-by-commas/28410/5 "2024-03-08T12:33:10Z")

</div>