Marty Zigman

Conversations with Marty Zigman

Certified Administrator • ERP • SuiteCloud

Drive Gmail Account Provisioning from NetSuite: Secure, Automated Google Workspace Integration

ERP Infrastructure NetSuite Technical



This article is relevant if you need to manage a mobile or distributed workforce that relies on Gmail and Google Workspace, and want to automate onboarding/offboarding processes through your existing NetSuite employee management infrastructure, without manually touching the Google Admin Console.

TL;DR Summary

Building on prior success integrating Google Drive with NetSuite, this approach automates Google Workspace user provisioning (including Gmail setup) by extending the NetSuite employee record and using OAuth 2.0 protocols. Administrators can create, link, and manage Google users—without leaving NetSuite—while benefiting from banner-based feedback, field-level controls, and robust application settings.

NetSuite as the Control Tower for Google Workspace User Management

In previous work described here, we explored how NetSuite could programmatically create Google Drive folders and assign user-level permissions without resorting to middleware platforms. That architecture was well-received by clients, especially those with large, dynamic workforces.

One such client, operating a sizable field service organization, saw immediate value. Their staff relies heavily on Gmail and other Google Workspace tools to stay connected, but maintaining user accounts manually through the Google Admin Console was cumbersome, error-prone, and disconnected from their core business system.

They asked a smart question:

“Can we take what you did with Drive and go one step further—can we control Gmail account creation from NetSuite too?”

Because NetSuite already drives their business operations, using it as the central source of truth for user provisioning made complete sense. This allowed the client to manage hiring, onboarding, and terminations directly from the employee record—without switching systems or relying on additional personnel trained in Google Workspace administration.

NetSuite-Driven Google Workspace Account Provisioning

The challenge of creating Google user accounts from within NetSuite isn’t trivial, but it’s addressable with the right architecture. The solution builds on several proven design elements:

  1. Leverage OAuth 2.0 server-to-server credentials to interface securely with Google APIs.
  2. Extend the NetSuite employee record with minimal, intentional fields to control sync behavior.
  3. Provide visual feedback via NetSuite’s native UI to reduce confusion or misconfiguration.
  4. Use NetSuite application settings to maintain sensitive credentials and constants securely.

The result is a seamless admin experience: business teams can activate and deactivate Google accounts with simple checkboxes and field updates, while all underlying calls to Google’s infrastructure occur in the background via secure, tokenized requests.

Key Elements of the Approach

  1. Extended Employee Record Fields: To manage the Google user lifecycle, we added four fields to the native Employee record:
    • Email Address: Serves as the primary identifier in both systems.
    • Integration Flag (Checkbox): Indicates whether the employee should be provisioned in Google Workspace.
    • Google User ID (Text): Stores the linked Google account’s unique ID to support reconciliation and audits.
    • Temporary Password (Text) & “Require Change on Next Login” Checkbox: Used for new account setup and initial security posture.
  2. OAuth 2.0 Authorization for Google API Access: Using secure service accounts with domain-wide delegation, NetSuite connects to Google Workspace APIs. The one-time configuration process ensures NetSuite can perform account operations without repeated user prompts by obtaining and refreshing access tokens as needed.
  3. Application Settings Management: OAuth credentials, scopes, and admin-related settings are stored in a protected NetSuite application settings structure, making the deployment portable and secure across environments.
  4. Administrator Feedback via Banner Messages: Banner messages within NetSuite communicate provisioning status, failures, or necessary follow-ups. This reduces the need to inspect logs or troubleshoot via Google as admins get immediate clarity during the employee update flow.
  5. No NetSuite License Required for Provisioned Users: Since the employee record is the control point, and that employee does not need NetSuite access, we avoid needing to license every field worker in NetSuite, while still automating their digital workspace provisioning.

Video Demonstration: See It in Action

In this video, we walk through how a NetSuite administrator can create or deactivate a Google Workspace account simply by updating fields on the Employee record. The process includes visual feedback, syncing logic, and background server-to-server API interactions.

Special thanks to Jeff D. in our Technology Practice for his contributions to the OAuth integration and practical modeling design.

Work with NetSuite Professionals with a Rich License-Free Library

This integration demonstrates how NetSuite can drive enterprise-grade automation across system boundaries without relying on middleware or licensing bloat. Our Prolecto Labs initiative provides our clients with significant value, as the software is open and offered without a license fee.

By aligning provisioning logic with business context, stored naturally on the Employee record, we give administrators power and precision.

As with many of our projects, this solution is built on a thoughtful model, clean logic, and respect for security protocols. We offer all algorithms and intellectual property used here without a license fee; our value lies in execution, insight, and integrity. Clients appreciate our ability to listen carefully, model deeply, and deliver practically.

If you found this article relevant, feel free to sign up for notifications to new articles as I post them. If you are ready to eliminate manual provisioning work and centralize user lifecycle management in NetSuite, let’s have a conversation.

Marty Zigman LinkedIn

Marty Zigman

Holding three official certifications, Marty is widely recognized as a top NetSuite expert and leads a team of senior professionals at Prolecto Resources, Inc. A former Deloitte & Touche CPA and technology executive with CTO roles, he brings over 35 years of leadership in ERP, CRM, and eCommerce business systems. Contact Marty to engage directly.

BiographyYouTubeLinkedInX (Twitter)

Leave a Reply

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