Google Sheets Helper export error

Comments

9 comments

  • Sree Vani Amara Principal Product Manager
    Engaged
    Answer Pro
    Celigo University Level 4: Legendary

    Hi Elmir Bilalic

    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!

     

    0
  • Elmir Bilalic

    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. 

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

    Additionally my inputs

    0
  • Sree Vani Amara Principal Product Manager
    Engaged
    Answer Pro
    Celigo University Level 4: Legendary

    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.

     

    0
  • Sree Vani Amara Principal Product Manager
    Engaged
    Answer Pro
    Celigo University Level 4: Legendary

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

    0
  • Elmir Bilalic

    I get the following error now 

    Failed to locate headers in the configured sheet.

     

    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.

    0
  • Sree Vani Amara Principal Product Manager
    Engaged
    Answer Pro
    Celigo University Level 4: Legendary

    Hi Elmir Bilalic

    Please submit a support ticket , so that we can analyse the issue further and provide a solution. Thanks!

    0
  • Scott Henderson CTO
    Celigo University Level 1: Skilled
    Answer Pro
    Top Contributor

    [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.

    0
  • Elmir Bilalic

    Scott Henderson

    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. 

    0
  • Scott Henderson CTO
    Celigo University Level 1: Skilled
    Answer Pro
    Top Contributor

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

    0

Please sign in to leave a comment.