⚠️ WARNING - This article is intended for NetSuite Admins to help understand how to bulk import Google Drive files and associate them with NetSuite records. It is not meant to replace the everyday interaction users have within the NetSuite and ExtendSync UI.
See this video and the instructions below to get started.
Background
New ExtendSync users may desire to integrate files that already exist in their Google Drive. In order to add Drive files to NetSuite Admins whose organizations license, ExtendSync Google (with Google Drive) will need to add data to two custom ExtendSync records (the records themselves are pre-installed as part of the CloudExtend bundle).
Celigo Google Doc
This record is populated with data specific to the files you will be uploading. Once this data is entered into NetSuite you will 'associate' these files with NetSuite records.Celigo Google Doc Associations
This record is used to associate the files uploaded into the Celigo Google Doc custom record with the desired NetSuite records.
Celigo Google Doc
Field Names
Resource ID | The unique name of the file as it exists in Google Drive. This is typically an element of the URL. (See italics below) https://docs.google.com/spreadsheets/d/1fXA6FqQtfjdYwIjcgvHYz7q8lqCMF_vHqCFTWA__spc/edit#gid=30036372
Title | This is the name of the document that will be displayed once uploaded to NetSuite. While not required, most users will want to use the name of the Google Doc.
Size(Bytes) | Can be left empty for initial upsert.
Type | Type is used only to display the logo (sheet, doc, etc.) and is not a required field. A list of valid MIME types from Google can be found here.
Popular examples include:
- application/vnd.google-apps.document (Google Docs)
- application/vnd.google-apps.spreadsheet (Google Sheets)
- application/vnd.google-apps.presentation (Google Slides)
- application/pdf (PDF file)Owner | The email address of the document owner.
Kind | This will always be set to 'file' or 'folder' (no quotes).
Owner Name | A combination of fields above built by a formula in your upload document. See the sample formula below but you may need to be modify based on the columns your data is in.
=K2&"###https://drive.google.com/"&J2&"/d/"&B2where
K2 =The name of the document owner (ie "Joe Smith" without quotes)
J2 = Kind (file or folder)
B2 =The Google File ID (Resource ID)Is Deleted | not applicable for uploads
Celigo Google Doc Association
Field Names
Google Doc | The NetSuite internal ID of the document that was uploaded to the Celigo Google Doc custom record.
NS Record Type | The name of the NetSuite Record type, ie customer, vendor, contact, etc.
NS Record Id | The internal ID of the NetSuite record to associate the document with. For example, if the record type was customer enter the internalID of the customer record to associate it with.
Please watch the video above to see a more detailed example.
How to export your data from Google
As with any third-party site use caution when reviewing the contents as data may have changed since we last pointed to it.
This article in Stack Overflow includes a sample script that takes a folder ID as input and returns all the file names and file IDs into a Google Sheet. This can be used to begin creating the Celigo Google Doc record.
Prerequisites for Google Drive Integration:
The email addresses for NetSuite and Gmail must match for Google Drive integration to work.
User must have Google Drive license