# Parse JSON to Google Sheets **URL:** \ **Category:** Questions\ **Tags:** error\ **Created:** [July 28, 2024, 12:24am UTC](https://community.make.com/t/parse-json-to-google-sheets/48177 "2024-07-28T00:24:05Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Sam\_Van\_Leeuwen](https://avatars.discourse-cdn.com/v4/letter/s/f08c70/32.png) [@Sam\_Van\_Leeuwen](https://community.make.com/u/Sam_Van_Leeuwen)\ **Post date:** [July 28, 2024, 12:24am UTC](https://community.make.com/t/parse-json-to-google-sheets/48177/1 "2024-07-28T00:24:05Z")
I have OpenAI gather data from images and then want to put this data into google sheets however. For some reason it does not work because of 2 parameters, but I dont understand what is wrong with the parameters/ ![Screenshot 2024-07-28 at 10.20.58](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/3/0/307dbae23ef89a3466d6b133e0d59ac413689403.png) ![Screenshot 2024-07-28 at 10.20.48](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/8/9/89c26870bdc49e0bbbf7652fbd3787e087c429ca.png) ![Screenshot 2024-07-28 at 10.20.42](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/a/b/ab247bf5be99ea17d6194bf46226eb3122ece9ab.jpeg) ![Screenshot 2024-07-28 at 10.20.17](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/1/7/174d0b30bfcf042db1e15484fd0f996711b4279e.png) ---
**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:** [July 28, 2024, 1:04am UTC](https://community.make.com/t/parse-json-to-google-sheets/48177/2 "2024-07-28T01:04:39Z")
Hi @Sam_Van_Leeuwen Please find solution [here](https://www.loom.com/share/1813645072c14a36bb672114bef39ea7?sid=bb57ab0f-60fc-441e-9586-14540c911171). **Regards,** _Msquare Automation - Gold Partner of Make_ > [Book a Free Consultation](https://calendly.com/msquarepro/meeting) | [Connect Live](https://calendly.com/msquarepro/msquareautomation-live) Explore our [**YouTube Channel**](https://www.youtube.com/@msquareautomation) for valuable insights and updates! ---
**Author:** ![holymoly](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/holymoly/32/50414_2.png) [@holymoly](https://community.make.com/u/holymoly)\ **Post date:** [October 6, 2024, 1:40pm UTC](https://community.make.com/t/parse-json-to-google-sheets/48177/4 "2024-10-06T13:40:57Z")
Video is not available. ---
**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:** [October 6, 2024, 2:13pm UTC](https://community.make.com/t/parse-json-to-google-sheets/48177/5 "2024-10-06T14:13:11Z")
Yes, the video link is broken. In future, please provide answers in text and image format so that we can all read and follow the discussion. — @samliew P.S.: Investing some effort into the [Make Academy](https://academy.make.com) will save you lots of time and frustration using Make. ---
**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:** [October 7, 2024, 4:04am UTC](https://community.make.com/t/parse-json-to-google-sheets/48177/6 "2024-10-07T04:04:49Z")
Hi @holymoly Google Sheets expects a text value rather than a collection, which is causing the issue. Some of the variables mapped here are collections. To resolve this, we recommend expanding the collection and mapping the specific value inside it. You can do this by clicking the plus sign next to the collection and selecting the appropriate value. ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/1/b/1b47c323e3422e6fd254120e3cd6940fd8fc3229.jpeg) For example, variables like “Pricing” and “Free Trial” are collections, so you’ll need to carefully map the correct data type based on what’s required. **Best regards,** **Msquare Automation** _Gold Partner of Make_ @Msquare_Automation ---
**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:** [January 5, 2025, 5:10am UTC](https://community.make.com/t/parse-json-to-google-sheets/48177/7 "2025-01-05T05:10:33Z")