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 CloudExtend UI.

See this video and instructions below to get started.

Background

New CloudExtend 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 CloudExtend G Suite (with Google Drive) will need to add data to two custom CloudExtend records (the records themselves are pre installed as part of the CloudExtend bundle).

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

  2. 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. A sample formula is provided below but will need to be modified based on the columns your data is in.
    =K2&"###https://drive.google.com/"&J2&"/d/"&B2 where
    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 internalID 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 internalID 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 ID's into a Google Sheet. This can be used to begin creating the Celigo Google Doc record.

Did this answer your question?