# ChatGPT to JSON parse

**URL:** <https://community.make.com/t/chatgpt-to-json-parse/71421>\
**Category:** Beginner Questions\
**Tags:** parse, arrays, open-ai, json\
**Created:** [February 25, 2025, 1:09pm UTC](https://community.make.com/t/chatgpt-to-json-parse/71421 "2025-02-25T13:09:55Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ca\_Tung\_Ng](https://avatars.discourse-cdn.com/v4/letter/c/e79b87/32.png) [@Ca\_Tung\_Ng](https://community.make.com/u/Ca_Tung_Ng)\
**Post date:** [February 25, 2025, 1:09pm UTC](https://community.make.com/t/chatgpt-to-json-parse/71421/1 "2025-02-25T13:09:55Z")

</div>

![IMG_0073](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/a/a/aa6e51f5bc3dfd2f66b03cc81c9912d22fdf2c6a.jpeg)

Hi, I’m new with Make. At the moment, after my OpenAI module analyzed the text and provided me the output as shown in the image, I want to parse it into parse json. The data structure I’m using within parse json module has 4 different items: medicine, timestamp, dosage, pills\_left. The json string: medicine\_schedule

The output of the OpenAI should be able to parse successfully into the json module.  
However I keep encountering this error:

 ![IMG_0075](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/0/8/086e855c60cbead984f036d682446f1e6b4a41df.jpeg)

Please help

---

<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:** [February 25, 2025, 1:13pm UTC](https://community.make.com/t/chatgpt-to-json-parse/71421/2 "2025-02-25T13:13:12Z")

</div>

Welcome to the Make community!

I don’t see any JSON output in the screenshot of OpenAI.

You have no JSON to parse. Delete the Parse JSON module.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the [Make Academy](https://academy.make.com) will save you lots of time and frustration using Make.

---

<div class="post-metadata">

**Author:** ![Ca\_Tung\_Ng](https://avatars.discourse-cdn.com/v4/letter/c/e79b87/32.png) [@Ca\_Tung\_Ng](https://community.make.com/u/Ca_Tung_Ng)\
**Post date:** [February 25, 2025, 1:46pm UTC](https://community.make.com/t/chatgpt-to-json-parse/71421/3 "2025-02-25T13:46:50Z")

</div>

Hi Sam,

Thanks for replying. My aim is to have the output as seen in medicine\_schedule:

 ![IMG_0073](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/a/a/aa6e51f5bc3dfd2f66b03cc81c9912d22fdf2c6a.jpeg)

Be placed into different columns in google sheet. Or to put into json format where it can then be put into google sheet.

What module can I use ? What settings will I need ?

Thank you

---

<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:** [February 25, 2025, 1:57pm UTC](https://community.make.com/t/chatgpt-to-json-parse/71421/4 "2025-02-25T13:57:50Z")

</div>

When you see ARRAY, think ITERATOR.

 ![](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/3/23a694ffc3939712667b383fd1b497de5d8afecb.png)

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

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the [Make Academy](https://academy.make.com) will save you lots of time and frustration using Make.

---

<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 26, 2025, 1:12pm UTC](https://community.make.com/t/chatgpt-to-json-parse/71421/5 "2025-05-26T13:12:30Z")

</div>