Google Sheet to Netsuite

[maricardelarosa]

Hi! I'm new in this community and I'm currently exploring migrating our Customer data from Google Sheet to Netsuite.

But I always encounter this error - "failed to save record because Please enter value(s) for: First Name, Last Name". I tried changing the parameter, from Row To Columns and unspecified dimension just to check but it doesn't seems to resolve this error.

I hope anyone can share their experience on this :)

[coryanderson215 (Cory Anderson)]

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.

[maricardelarosa]

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!

[lucianhymer]

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

[maricardelarosa]

Hi Lucian!

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

Thank you for your help!

[maricardelarosa]

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 :)

[lucianhymer]

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.

[maricardelarosa]

Thanks, Lucian! Will look into it :)

[maricardelarosa]

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!

[lucianhymer]

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!

[maricardelarosa]

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!