How to Integrate Google Apps With NetSuite

cloud computing
Google Apps are increasingly becoming a bigger part of the way companies and individuals do business. Anyone who has worked in business knows that Microsoft has been the main platform, particularly Microsoft Outlook, Microsoft Exchange and Microsoft Office. But we’re now seeing a shift away from these more expensive and difficult-to-manage business platforms into the more user friendly and economical Google Apps.

There are four main areas of Google Apps:

  1. Google GMail
  2. Google Contacts
  3. Google Calendar
  4. Google Docs

In essence, these are the 4 big productivity apps that all businesses work with to compete in the global economy.  Not every business is leveraging the power of an integrated CRM & ERP business management suite, like that offered by NetSuite.  Those organizations that are leveraging an integrated business suite, like NetSuite, have a much greater capacity for producing competitive advantages over those that do not.   Still, basic productivity applications are needed for the unstructured, irregular demand for collaboration, presentations, and electronic communications.  Fortunately, there are solutions available to integrate NetSuite to Google Apps to minimize the classic issue of import, export and the resulting inevitable data problems when you try to store information in your CRM & ERP system as well as your productivity suite.

While the NetSuite partner community has built an integration between Google Mail and NetSuite, Prolecto Resources has created Google Contacts to NetSuite Sync.   If you want to have a central repository of contacts in NetSuite because you’re going to use it to produce marketing, send email blasts, and leverage lead nurturing campaigns, but you are also using Gmail for your day-to-day email and calendaring, you’re going to want to connect these systems.  The goal here is to keep all of your contacts synchronized with NetSuite.  As you continue to add people to Google groups, you can synchronize those groups with the equivalent of “NetSuite Categories” for each of the contacts.  These category attributes can then be used as targeting mechanisms.  You can then have your employees use their Android phones connected to Google Apps while they capture information of the people they’re interacting with day-to-day — essentially creating new NetSuite target groups without having to lift a finger or import/export data.

Copyright © Marty Zigman 2011

Be Sociable, Share!

Marty Zigman

Holding all three official certifications, Marty is regarded as the top NetSuite expert and leads a team of senior professionals at Prolecto Resources, Inc. He is a former Deloitte & Touche CPA and has held CTO roles. For over 30 years, Marty has produced leadership in ERP, CRM and eCommerce business systems. Contact Marty to set up a conversation.

More Posts - Website - Twitter - Facebook - LinkedIn - YouTube

| Tags: , , , , , , , , , , , , , , , , , , , , , | Category: CRM, Marketing, NetSuite | 5 Comments

5 thoughts on “How to Integrate Google Apps With NetSuite

  1. Kevin says:

    Any solutions for getting Netsuite data into google sheets in an automatic way – every day at midnight download the latest data into a google sheet?

  2. Marty Zigman says:

    I haven’t tried this. But I can see a few options:

    1. Google sheet supports an Import from CSV file via URL. What if you could get that pointer to something in the cabinet?
    2. Creating a REST endpoint that will accept data fed from NetSuite via SuiteScript. For example, have a look at this: https://developers.google.com/sheets/reference/rest/v4/spreadsheets/batchUpdate

    Marty

  3. Rajitha K S says:

    could you please advise me how we can integrate google drive in netsuite for attach files from netsuite?

  4. Joe Levatino says:

    You can create a script (I found one online) that has a scheduled script that copes a saved search into a csv file in the file cabinet. I made the folder public for the file cabinet. I then have a script in google sheets that replaces a sheet in my google workbook on a schedule. A little complicated to setup but free and easy to update and I don’t know how to write suitescript.

Leave a Reply

Your email address will not be published. Required fields are marked *