Skip to main content

Google Sheet to Netsuite

Featured

Comments

10 comments

  • Cory Anderson
    Great Answer
    Awesome Follow-up
    Engaged
    Celigo University Level 4: Legendary

    This usually means that the First Name and Last Name fields are required on the customer record, but NetSuite is not getting the data. You should check the mapping on the Import to NetSuite to make sure that those fields are mapped correctly. You can also look at the retry data on the error to make sure that there are values in those fields. 

    0
  • maricar dela rosa
    Engaged

    Hi Cory!

    Thank you for replying on this, very much appreciated!

    Actually when i setted up Netsuite as the destination application and select IMPORT to destination application, there was NO option to map out the fields which I do when i import in Netsuite via CSV. So i guess this is the possible source of error? The error I received before was Permission in Customer's List and Documents and Files' List which i addressed but managing the role in Netsuite.

    But since i'm very new with Celigo, I am not sure if connecting Google Sheet to Netsuite is possible, without application in between. But since I'm getting this error, the connection was established but there's an error in the mapping process.

    Looking forward to learn from your experience w Celigo!

    0
  • Lucian Hymer Senior Solutions Consultant

    Hey Maricar,

    It sounds like you still need to define your field mapping. To do this, you click the '+' icon on the import and then choose the "mapping" button (it looks sort of like a sideways trident).

     

    On this screen, you define your field mappings from the source to the destination, including the First and Last Name fields.

    Thanks,
    -Lucian

    0
  • maricar dela rosa
    Engaged

    Hi Lucian!

    I think this is the one I skipped! We'll look into it and give feedback :)

    Thank you for your help!

    0
  • maricar dela rosa
    Engaged

    Hi Lucian!

    Good news! I was able to do the mapping and was able to upload in Netsuite! So, the connection is working!

    Bad news is that, i can't get the value in the Google Sheet huhu. it just call the range I setted up when i connected the Google Sheet, here's the screenshot:

     

    Then mapped it NetSuite:

    But the output is this:

    I'm almost there! If i can just get the value from Google Sheet, wow! I hope you can guide me on this :)

    0
  • Lucian Hymer Senior Solutions Consultant

    Maricar,

    So in that mapping, you'll want to reference the individual fields. Right now, you're referencing the "range" field which just stores the sheet name and the cells that you're looking at.

    This article explains how you can transform and map data from a google sheet. 

    0
  • maricar dela rosa
    Engaged

    Thanks, Lucian! Will look into it :)

    0
  • maricar dela rosa
    Engaged

    Hi Lucian! I was able to mapped it out correctly, thank you for sending the article as my guide! But there's a downside, it only uploaded one entry (Mercedez Tomo) was not uploaded in Netsuite. Am i missing something here? Like number of records to upload? 

    See screenshot below, for reference.

    Netsuite mapping:

    And the output is here :) 

     

    Grateful for this community!

     

    0
  • Lucian Hymer Senior Solutions Consultant

    Hey Maricar,

    You're right, this actually requires one extra step compared to the FTP file creation showed in the example I provided.

    This is one of the more complicated things that you can do in integrator.io, but you'll be able to do it! We need to add a preSavePage hook to the Export from Google Sheets.

    First you'll need to enable Developer Mode if you haven't yet. Go to My Profile (in the top right) and check the checkbox for Developer Mode. You might have to set a Time Zone as well to save the page.

    Then, you'll want to click the little "+" icon on the Google Sheets export, and click the icon that looks like a fish hook. Click the "+" to the right of the Scripts field, name the script "Rows to Records", and enter the following text under Edit content:

    function preSavePage (options) {
    return {
    data: options.data[0],
    errors: options.errors,
    abort: false
    }
    }

    It should look like this:

    And when you click save, enter preSavePage for the function and click save on this page, like this:

    Now, your flow should work as expected!

    0
  • maricar dela rosa
    Engaged

    Hey Lucian!

    It worked! Amazing!! This is actually what our company needed as of this moment! Thank you so much!!!

    Can't wait to explore more such as adding more data fields, update customer record and a lot more!

    I'm not a developer but with amazing community, we were able to do this! Wow!

    Again thank you, Lucian and Cory!

    0

Please sign in to leave a comment.