# Google Sheets Helper export error

**URL:** <https://connective.celigo.com/t/google-sheets-helper-export-error/160>\
**Category:** Integrator.io\
**Tags:** google-sheets, export, flow-builder, netsuite\
**Created:** [April 23, 2024, 10:21pm UTC](https://connective.celigo.com/t/google-sheets-helper-export-error/160 "2024-04-23T22:21:22Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![elmirbilalic](https://avatars.discourse-cdn.com/v4/letter/e/f07891/32.png) [@elmirbilalic](https://connective.celigo.com/u/elmirbilalic)\
**Post date:** [April 23, 2024, 10:21pm UTC](https://connective.celigo.com/t/google-sheets-helper-export-error/160/1 "2024-04-23T22:21:22Z")

</div>

I am unable to save the helper export flow. I've modified the flow to import from Netsuite and successfully previewed the data but I get no feedback when I go to save

![5301043caa20740200000001-58c32524b2114356acecd1143fd7816f.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/0/0c8be1d5ac3759d7f317c8d909a8624b04800492.png)

---

<div class="post-metadata">

**Author:** ![sreevaniamara](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/sreevaniamara/32/6926_2.png) [@sreevaniamara](https://connective.celigo.com/u/sreevaniamara)\
**Post date:** [April 24, 2024, 5:51am UTC](https://connective.celigo.com/t/google-sheets-helper-export-error/160/2 "2024-04-24T05:51:06Z")

</div>

Hi @elmirbilalic

Thank you for reaching out. To better assist you, could you please provide a few more details about the issue you're encountering?  
  
When you mention being unable to save the helper export flow, are you experiencing issues saving the google sheets import bubble, or the export bubble? Please share screenshot of the bubble that you are not able to save and mask sensitive information.   
  
Thanks!

---

<div class="post-metadata">

**Author:** ![elmirbilalic](https://avatars.discourse-cdn.com/v4/letter/e/f07891/32.png) [@elmirbilalic](https://connective.celigo.com/u/elmirbilalic)\
**Post date:** [April 24, 2024, 2:22pm UTC](https://connective.celigo.com/t/google-sheets-helper-export-error/160/3 "2024-04-24T14:22:07Z")

</div>

Hi Sree, I have cloned the flow and updated the export to a netsuite saved search. Apologies for the confusion, the import is what is failing to save currently.

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

Here's is the preview and send windows for the Import data

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

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

Additionally my inputs

 ![5301043caa20740200000001-f7a27c502bca4c41bfd9210b171a32bd.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/3/3fdfb79a8f3d5e335d5cce84114f12797f808ffe.png)

---

<div class="post-metadata">

**Author:** ![sreevaniamara](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/sreevaniamara/32/6926_2.png) [@sreevaniamara](https://connective.celigo.com/u/sreevaniamara)\
**Post date:** [April 24, 2024, 2:51pm UTC](https://connective.celigo.com/t/google-sheets-helper-export-error/160/4 "2024-04-24T14:51:59Z")

</div>

Sorry for the inconvenience. We are working to fix this issue as soon as possible, aiming for a resolution by Thursday, which will enable you to save the import.

---

<div class="post-metadata">

**Author:** ![sreevaniamara](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/sreevaniamara/32/6926_2.png) [@sreevaniamara](https://connective.celigo.com/u/sreevaniamara)\
**Post date:** [April 25, 2024, 5:09pm UTC](https://connective.celigo.com/t/google-sheets-helper-export-error/160/5 "2024-04-25T17:09:43Z")

</div>

@elmirbilalic - We pushed the fix, you should be able to save the import bubble now. Thanks!

---

<div class="post-metadata">

**Author:** ![elmirbilalic](https://avatars.discourse-cdn.com/v4/letter/e/f07891/32.png) [@elmirbilalic](https://connective.celigo.com/u/elmirbilalic)\
**Post date:** [April 25, 2024, 6:06pm UTC](https://connective.celigo.com/t/google-sheets-helper-export-error/160/6 "2024-04-25T18:06:38Z")

</div>

I get the following error now

> Failed to locate headers in the configured sheet.

 ![5301043caa20740200000001-88bb27f2600b4aa796c2dcca6ae10f89.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/d/d68dc1a895f5ea63e7ed2929a8b870817322c305.png)

 ![5301043caa20740200000001-c09492444f604908bef734809beed9b1.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/e/e353293da331db1d8cdc52900b1dc7cfd54e51d3.png)

I can save when I uncheck "Does your sheet have column headers?" but I still get the "ValueRange.range is required but not specified" error from my previous message.

---

<div class="post-metadata">

**Author:** ![sreevaniamara](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/sreevaniamara/32/6926_2.png) [@sreevaniamara](https://connective.celigo.com/u/sreevaniamara)\
**Post date:** [April 26, 2024, 7:18am UTC](https://connective.celigo.com/t/google-sheets-helper-export-error/160/7 "2024-04-26T07:18:55Z")

</div>

Hi @elmirbilalic,   
  
Please [submit a support ticket](https://docs.celigo.com/hc/en-us/articles/4407535381147-Submit-a-support-ticket) , so that we can analyse the issue further and provide a solution. Thanks!

---

<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:** [April 29, 2024, 4:42pm UTC](https://connective.celigo.com/t/google-sheets-helper-export-error/160/8 "2024-04-29T16:42:34Z")

</div>

[updated] -- I know what the issue is. Stay tuned.

Ignore this.

_It would be good to get confirmation that the sheet name being configured matches what it in the spreadsheet. I see the name of the spreadsheet itself is 'sheet1', and this makes me wonder if spreadsheet vs sheet names are being mixed up; but we cannot see from the screenshots. Anyways, just a thought. Hopefully support has already helped you solve this._

---

<div class="post-metadata">

**Author:** ![elmirbilalic](https://avatars.discourse-cdn.com/v4/letter/e/f07891/32.png) [@elmirbilalic](https://connective.celigo.com/u/elmirbilalic)\
**Post date:** [April 29, 2024, 5:09pm UTC](https://connective.celigo.com/t/google-sheets-helper-export-error/160/9 "2024-04-29T17:09:11Z")

</div>

@scotthenderson

Good thought Scott but the sheet is named "Sheet1". I was doing some testing with the spreadsheet name to make sure I covered all basis.

---

<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:** [April 30, 2024, 8:19pm UTC](https://connective.celigo.com/t/google-sheets-helper-export-error/160/10 "2024-04-30T20:19:03Z")

</div>

The "_Failed to locate headers in the configured sheet._" issue should be fixed now. This was a bug on our side.
