Technical guide

Google Drive technical guide

Everything an engineer needs to connect Google Drive to Salesforce: architecture, the exact build steps with real code, field mapping, the data model, security, monitoring, and the pitfalls we design out.

Platform: Google DriveType: File / docsDirection: OutboundObjects: Any record

Google Docs, Drive, and Sheets automation, our most widely used document integration. We have shipped it across 32 client projects and 117 build tasks.

The value is that the action happens automatically from the record your team already works in, with the result tracked back in Salesforce.

We build it the Salesforce-native way: a Connected App and Named Credentials so no secrets ever live in code, field mappings that respect your data model, and record-triggered automation that does the work.

Every Google Drive / Docs build is delivered by a senior Salesforce architect on a fixed price, tested end to end in a sandbox, deployed to your org, and backed by 30 days of hypercare. You own the result: documented, source-controlled, and free of black-box middleware lock-in.

the connection at a glancesync active
01Salesforce flow / Apex
02Named Credential
03Google Drive API
04Records
Integration facts

How Google Drive connects to Salesforce

The real connection surface: how it authenticates, what it is built on, the endpoints and events in play, and where the reference docs live.

Connects via
No first-party Google managed package: custom Apex HTTP callouts to Google REST APIs (Drive/Docs/Sheets)Salesforce Named Credential + External Credential (or Auth Provider) backed by an OAuth 2.0 client in Google CloudOptional AppExchange middleware for declarative setup
Package
Custom build (no managed package)
Authentication
OAuth 2.0 (Google): Auth Provider + Named/External Credential in Salesforce; server-to-server can use a Google service account with a JWT bearer. Scopes for drive, documents, spreadsheets
API type
REST
Drive: https://www.googleapis.com/drive/v3 ; Docs: https://docs.googleapis.com/v1 ; Sheets: https://sheets.googleapis.com/v4

Key endpoints

POST /drive/v3/files (create file/folder; native Doc via mimeType application/vnd.google-apps.document)POST /upload/drive/v3/files (upload content)Docs /documents and /{id}:batchUpdateSheets /spreadsheets and /values/{range}:appendPOST /drive/v3/files/{fileId}/permissions (share)
Free download

Build this with AI agents

Copy the full playbook as a prompt for any coding agent, or install it as a Claude Code skill. Either way your agent builds with our exact approach: the architecture, the Apex code, the field mapping, the rate limits, and the pitfalls to design out. Free, no signup.

Loading the Google Drive playbook...
Paste into Claude Code, Cursor, or any coding agent
From our builds

What we build for a Google Drive integration

Google Docs, Drive and Sheets integrated with Salesforce: a Google Doc auto-created per project on record creation, and renewal and report data exported to Google Sheets.

30client projects
117delivery tasks shipped

Doc-per-record automation

A Google Doc is created automatically for each project when the record is created, so the working document lives alongside the Salesforce data.

Data export to Sheets

Exported renewal and report data from Salesforce into Google Sheets for downstream review and sharing.

Real components we ship

Google Drive / Docs / SheetsAuto-create a Doc per projectExport to Google SheetsOAuth 2.0 to Google APIs
Step 0

What you will need

What we confirm on both sides before writing a line of code.

A Salesforce edition with API access (Enterprise, Unlimited, or Developer)
A dedicated sandbox to build and test in
A Google Drive / Docs account on a plan with API access
System Administrator access on both systems
A dedicated integration user with a minimum-access permission set
Agreement on the objects, fields, and sync direction for the Google Drive / Docs data
How it works

From trigger to record, end to end

The production runtime flow, with what happens in each system.

runtime sequence4 steps
  1. 01

    Trigger in Salesforce

    In Salesforce

    A record change or a button starts the Google Drive / Docs action.

    $A record-triggered flow or a Quick Action fires the process.
  2. 02

    Payload is built

    In Salesforce

    A flow or Apex assembles the request and maps the Salesforce fields.

    $Serialized with JSON.serialize; the callout is queued to run asynchronously.
  3. 03

    Call Google Drive / Docs

    In transit

    The request is sent to Google Drive / Docs.

    $HTTPS callout via callout:NamedCredential over API, Automation, with no secrets in code.
  4. 04

    Result written back

    In Salesforce

    Google Drive / Docs performs the action and the status is written back.

    $Response parsed; status and external ids stored on the record for audit.
Architecture

How the data actually flows

Left to right: sources, the integration layer, Salesforce, and the outcomes it drives.

system architecture
Sources
Salesforce record
Flow / Apex trigger
Integration layer
Payload build
Google Drive / Docs API call
Status write-back
Salesforce
document
Related records
Reports
Outcomes
Action done automatically
Status on the record
No app-switching

// sources feed the integration layer, Salesforce persists, outcomes ship

Data model

The objects behind the integration

The Salesforce objects we read and write, what each one is for, and the fields that carry the load.

ObjectPurposeKey fields
documentThe primary Salesforce record Google Drive / Docs data maps onto.External_Id__c, Name, Status
AccountMatched or created for the customer or company behind the record.Name, External_Id__c
Error_Log__c (custom)Captures every request, response, and failure so anything can be replayed.Payload__c, Status__c, Related_Id__c

Salesforce objects typically in play for Google Drive

Any record object as the trigger sourceContentVersion/ContentDocumentLink if mirroring links backCustom fields to store Google file IDs and URLs
Step by step

Build the Google Drive integration

Every step we follow to ship a production-grade build, with the code that matters.

1

Plan the integration and prerequisites

Before any code, we lock down access and design how Google Drive / Docs and Salesforce will talk.

  • A Salesforce edition with API access (Enterprise, Unlimited, or Developer) and a dedicated sandbox track
  • A Google Drive / Docs account on a plan with API access, plus admin rights on both systems
  • A dedicated Salesforce integration user with a minimum-access permission set, never a personal admin login
  • Decide direction (inbound, outbound, or bidirectional) and cadence (real-time callouts vs scheduled batch)
  • Budget the daily API request allocation and per-transaction callout limits up front
2

Register the app and scope OAuth in Google Drive / Docs

We create the connection on the Google Drive / Docs side and collect exactly the access Salesforce needs.

  • Create an OAuth app or scoped API token in Google Drive / Docs to get the Client ID and Client Secret
  • Grant the minimum OAuth scopes required, and note the API base URL and version
  • Whitelist the Salesforce callback URL if the tool uses the authorization-code flow
3

Store secrets with External and Named Credentials

We use the modern Salesforce auth stack, so no secret ever lives in code or metadata.

  • Create an External Credential (OAuth 2.0 or custom) with a named principal
  • Create a Named Credential pointing at the Google Drive / Docs base URL and enable the generated authorization header
  • Grant the External Credential through a permission set, so only the integration user can call out
  • This replaces legacy Remote Site Settings and hard-coded tokens entirely

Pro tip: Named Credentials, not code

Named Credentials keep the secret and endpoint out of your Apex and metadata, so nothing sensitive ships in a deployment or lands in version control.

4

Design the data model and external IDs

We make Google Drive / Docs records land cleanly on the right Salesforce object with no duplicates.

  • Map every Google Drive / Docs field to the document and related objects, documenting type, picklist values, and record types
  • Add a unique, external-id, case-insensitive field on each object as the match key
  • Define owner assignment, required-field defaults, and relationship lookups
5

Build inbound ingestion

If Google Drive / Docs data flows in, we ingest it safely and idempotently.

  • Expose an Apex REST resource (@RestResource) or subscribe to Google Drive / Docs's push or Platform Events
  • Authenticate and parse the payload, then Database.upsert on the external id in bulk
  • Make it idempotent, so a retried or duplicate payload never creates a second record
InboundRecordApi.clsapex
@RestResource(urlMapping='/inbound/records/*')
global with sharing class InboundRecordApi {
  @HttpPost
  global static void upsertRecords() {
    List<Row> items = (List<Row>) JSON.deserialize(
      RestContext.request.requestBody.toString(), List<Row>.class);

    List<MyObject__c> rows = new List<MyObject__c>();
    for (Row r : items) {
      rows.add(new MyObject__c(External_Id__c = r.id, Name = r.name, Amount__c = r.amount));
    }
    upsert rows External_Id__c;         // bulk + idempotent on the external id
    RestContext.response.statusCode = 200;
  }
  global class Row { global String id; global String name; global Decimal amount; }
}
6

Build outbound sync

If Salesforce drives Google Drive / Docs, we call out the right way.

  • A record-triggered flow to invocable Apex, or an Apex trigger handing off to a Queueable
  • Triggers cannot call out synchronously, so the HTTP callout runs asynchronously
  • Serialize with JSON.serialize and call Google Drive / Docs via callout:NamedCredential, handling every status code
SyncToServiceQueueable.clsapex
public class SyncToServiceQueueable implements Queueable, Database.AllowsCallouts {
  private List<Id> ids;
  public SyncToServiceQueueable(List<Id> ids) { this.ids = ids; }

  public void execute(QueueableContext ctx) {
    for (MyObject__c rec : [SELECT Id, Name, External_Id__c FROM MyObject__c WHERE Id IN :ids]) {
      HttpRequest req = new HttpRequest();
      req.setEndpoint('callout:Service_NC/v1/records'); // secret lives in the Named Credential
      req.setMethod('POST');
      req.setHeader('Content-Type', 'application/json');
      req.setBody(JSON.serialize(new Map<String,Object>{
        'externalId' => rec.External_Id__c, 'name' => rec.Name }));
      HttpResponse res = new Http().send(req);
      if (res.getStatusCode() != 200) ErrorLog.capture(rec.Id, res);
    }
  }
}
7

Engineer for scale and governor limits

We build it to survive real volume, not just a demo.

  • Bulkify everything: no SOQL, DML, or callouts inside loops (100 SOQL and 150 DML per transaction)
  • Use Queueable, Batchable, or Scheduled Apex for volume, and chain jobs for large syncs
  • Add retry with backoff and a dead-letter Error_Log__c record for anything that fails
NightlySyncBatch.clsapex
global class NightlySyncBatch implements Database.Batchable<SObject>, Database.AllowsCallouts {
  global Database.QueryLocator start(Database.BatchableContext bc) {
    return Database.getQueryLocator([SELECT Id, External_Id__c FROM MyObject__c WHERE Needs_Sync__c = true]);
  }
  global void execute(Database.BatchableContext bc, List<MyObject__c> scope) {
    ServiceClient.sync(scope);       // one callout per 200-record chunk stays under limits
  }
  global void finish(Database.BatchableContext bc) { /* chain the next job or log the run */ }
}

Watch out: governor limits

Salesforce caps SOQL, DML, and callouts per transaction. Bulkify everything and move volume to Queueable or Batch Apex, or the integration will fail at scale.

8

Lock down security and compliance

We give the integration exactly the access it needs and nothing more.

  • A least-privilege permission set, field-level security, and sharing for the integration user
  • Rotate secrets on a schedule, and add Shield Platform Encryption for sensitive fields where required
9

Test like production

We prove it works before it ships.

  • Apex tests with Test.setMock(HttpCalloutMock) covering success, failure, and a 200-record bulk case
  • At least 75 percent coverage, plus sandbox UAT and a parallel run against the live system
SyncToServiceTest.clsapex
@IsTest
private class SyncToServiceTest {
  private class Mock implements HttpCalloutMock {
    public HttpResponse respond(HttpRequest req) {
      HttpResponse res = new HttpResponse();
      res.setStatusCode(200); res.setBody('{"ok":true}');
      return res;
    }
  }
  @IsTest static void syncsInBulk() {
    Test.setMock(HttpCalloutMock.class, new Mock());
    List<MyObject__c> recs = new List<MyObject__c>();
    for (Integer i = 0; i < 200; i++)
      recs.add(new MyObject__c(Name = 'Row ' + i, External_Id__c = 'EXT-' + i));
    insert recs;

    Test.startTest();     // proves the callout is bulk-safe under governor limits
    System.enqueueJob(new SyncToServiceQueueable(new List<Id>(new Map<Id,MyObject__c>(recs).keySet())));
    Test.stopTest();
  }
}
10

Deploy, monitor, and hand over

We ship it safely and keep it healthy.

  • Deploy via change sets or an SFDX and CI pipeline, and assign the permission sets
  • Turn on monitoring and alerting on the Error Log, and optionally Event Monitoring
  • Hand over with 30 days of hypercare and failure alerting
Field mapping

Example field mapping

How Google Drive data lands on your Salesforce records. We tailor the full mapping to your org.

Google DriveSalesforceNotes
Salesforce documentGoogle Drive / Docs recordDirection: Salesforce to Google Drive / Docs
Record idGoogle Drive / Docs external referenceStored back on the record
Key fieldsGoogle Drive / Docs fieldsMapped per template
StatusGoogle Drive / Docs statusWritten back on completion
Created / updated atLastModifiedDateEnables delta sync and audit
Owner or repdocument.OwnerIdAssignment rules or a default owner
API & limits

Rate limits and governor limits

The platform constraints we design around, so the integration stays fast and never falls over at scale.

Specific to Google Drive

Salesforce: 100 callouts/transaction, 120s, ~6 MB (sync)/12 MB (async) heap; large bodies must be chunked
Drive API default ~12,000 queries/min per project
Sheets API default ~300 read + 300 write/min per project
Docs API default ~3,000 requests/min per project

Salesforce platform limits

Salesforce caps API calls per 24 hours by edition and license count. We budget the daily allocation up front so the integration never starves other tools.
Per transaction, Apex allows 100 SOQL queries, 150 DML statements, and 100 callouts. We bulkify everything and move volume async to stay well under them.
Google Drive / Docs enforces its own rate limits. We honour them, and back off with jitter on HTTP 429 responses instead of hammering the API.
A synchronous callout can run for up to 120 seconds. Anything longer runs in Queueable or Batch Apex, never inline.
Security

Secure by design

How we keep the integration safe, least-privilege, and compliant.

Secrets stored in Named Credentials and permission sets, never in code or metadata
A least-privilege integration user, with field-level security and sharing scoped tight
All traffic over TLS, with signature verification on inbound events
Shield Platform Encryption available for sensitive fields
A full audit trail: every request and response logged for traceability
Every automation runs as a dedicated integration user, so actions are attributable and revocable
Sandbox-first delivery and change-set deployment keep production changes reviewed and controlled
Monitoring

Monitoring, retries, and reliability

What keeps the integration trustworthy in production, and how you know the moment something needs attention.

Every request and response is logged to a custom Error Log object, tagged with the related record id.
Failed calls retry with exponential backoff; anything still failing lands in a dead-letter queue for review.
Idempotency keys guarantee a retried or duplicate event never double-posts a record.
A dashboard surfaces failures, latency, and volume so problems are caught before users notice.
Optional email or Slack alerts fire on repeated failures or a stalled sync.
Testing & deployment

How we test, deploy, and hand it over

The quality gates every build clears before it touches your production org.

Apex unit tests with HttpCalloutMock cover the success path, failure handling, and a 200-record bulk case, at 75 percent or higher coverage.
The full flow is validated in a sandbox against real sample data and the edge cases that matter.
A parallel run reconciles the integration against your live system before cutover.
Everything deploys through change sets or an SFDX and CI pipeline, under version control.
Permission sets, sharing, and Named Credentials are configured in production, then we run 30 days of monitored hypercare.
Pitfalls

Common pitfalls we design out

The mistakes that quietly break integrations, and how we avoid each one.

Duplicate records on retry

Upsert on a unique external-id field so retried payloads are idempotent.

Hitting governor limits at volume

Bulkify and move work to Queueable or Batch Apex; never call out inside a loop.

Callouts failing when a token expires

Use Named Credentials so Salesforce refreshes the OAuth token automatically.

No visibility when it breaks

We log every call and surface failures on a dashboard with alerts, so an issue never goes unnoticed.

Reporting drifts from reality

External-id keys and a delta timestamp keep Salesforce and the source reconciled, so reports stay trustworthy.

Gotchas specific to Google Drive

No official Google managed package: you own OAuth/token refresh, Named Credential and error handling
Base64-encoded file bodies inflate ~33% and hit Apex heap/callout size limits; use resumable/async for anything sizable
Refresh-token expiry or scope changes silently break callouts; choose per-user vs service-account identity deliberately
FAQ

Google Drive integration: technical FAQs

How do you authenticate Google Drive / Docs with Salesforce?

We connect Google Drive / Docs using named credentials and API keys and store every secret in Salesforce Named Credentials with a permission set, so nothing is hard-coded or shipped in metadata.

Does the Google Drive / Docs integration handle bulk volume?

Yes. All Apex is bulkified, volume moves to Queueable or Batch Apex, and we respect the Salesforce governor limits (SOQL, DML, and callout caps per transaction).

How do you prevent duplicate records?

We upsert on a unique external-id field, so a retried or duplicate payload is idempotent and never creates a second document.

How is the integration tested and deployed?

Apex tests with HttpCalloutMock cover the success, failure, and a 200-record bulk case (75 percent plus coverage). We deploy via change sets or an SFDX and CI pipeline.

What happens if Google Drive / Docs or Salesforce is briefly down?

Failed calls retry with backoff and land in an Error Log object with alerting, so nothing is lost and any event can be replayed.

Inbound, outbound, or both?

We build whichever direction you need: an Apex REST endpoint for inbound, record-triggered flows or Queueable callouts for outbound, or both for a two-way sync.

Want us to build your Google Drive integration?

Skip the build. In a free 30-minute call we will map your Google Drive flow and hand you a clear, fixed-price plan.

Ask me anything