# Error Importing to Google Sheet

**URL:** <https://connective.celigo.com/t/error-importing-to-google-sheet/296>\
**Category:** Integrator.io\
**Tags:** google-sheets, hubspot, error-handling, export, import\
**Created:** [November 17, 2023, 3:42pm UTC](https://connective.celigo.com/t/error-importing-to-google-sheet/296 "2023-11-17T15:42:59Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![daveguderian](https://avatars.discourse-cdn.com/v4/letter/d/ce7236/32.png) [@daveguderian](https://connective.celigo.com/u/daveguderian)\
**Post date:** [November 17, 2023, 3:42pm UTC](https://connective.celigo.com/t/error-importing-to-google-sheet/296/1 "2023-11-17T15:42:59Z")

</div>

Im trying to import data into a google sheet using the marketplace connector and believe I am close. I am receiving an error and not sure if its something with my mapping or something else in my setup. I am exporting from HubSpot, but I dont believe that makes a difference in this scenario. As always any help is appreciated.

 ![5301043caa20740200000001-10dd87889e0545869bffb0172b8e59aa.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/4/4a4503ac29b8c40753f58b46ae613da5d11e610d.png)

 ![5301043caa20740200000001-2b10f0c969f14644a922fbb71325255e.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/8/8ab0599ca302a0d9d0621b75e55c9a88a296988a.png)

 ![5301043caa20740200000001-e1507a6980474dba8535bb5c9620814c.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/b/b4d7cf2e7002b1d9dd4f8a2e753f6c0444e99e30.png)

 ![5301043caa20740200000001-d62bc43fd5ea4013b609b6c2218a7d80.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/f/f444acbfd741cf24c3c4b41773af22a0e06ad69f.png)

---

<div class="post-metadata">

**Author:** ![scotthenderson](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/scotthenderson/32/6780_2.png) [@scotthenderson](https://connective.celigo.com/u/scotthenderson)\
**Post date:** [November 17, 2023, 6:09pm UTC](https://connective.celigo.com/t/error-importing-to-google-sheet/296/2 "2023-11-17T18:09:16Z")

</div>

The error you are seeing is due to an embarrassing bug in our UI. The root problem is when you save the import flow step from the 'Simple' toggle at the top, then it wipes out the pre-configured 'HTTP request body' field. The work around is to paste the following value back into the 'HTTP request body' field, and then always save from the 'HTTP' toggle view on the top. We are hoping to patch this UI bug asap, and we are really sorry about this!

```
{ "values": [[{{#each record}}{{#if @first}}{{{jsonSerialize this}}}{{else}},{{{jsonSerialize this}}}{{/if}}{{/each}}] ]}
```

 ![5301043caa20740200000001-d8b9921337134155b6b72f8a3822dd9f.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/1/1cc909f7c137f7a33fe1e0b485b3ef1ce8f8b1fd.png)

---

<div class="post-metadata">

**Author:** ![daveguderian](https://avatars.discourse-cdn.com/v4/letter/d/ce7236/32.png) [@daveguderian](https://connective.celigo.com/u/daveguderian)\
**Post date:** [November 17, 2023, 6:35pm UTC](https://connective.celigo.com/t/error-importing-to-google-sheet/296/3 "2023-11-17T18:35:09Z")

</div>

Scott- Thanks for the help. I just tested and that did the trick! Thanks so much!