Read and write Google Drive data in SSIS with API Source + API Destination .

Use Google Drive connector workflows to configure OAuth or Service Account authentication, work with files, folders, and shared drives, and execute mapped source/destination operations directly inside SSIS.
Part of ZappySys SSIS PowerPack (100+ connectors & tasks).

Recommended starting point

View Setup Guide & Get Started →

See features, UI & examples →

Pro Tip: The landing guide includes export and import flows, so you can design two-way file automation in one package.

Compatibility: SQL Server 2012-2025+ (32/64-bit) | Azure Data Factory / Azure-SSIS IR Ready

⚡ Key Benefits

Two-Way Drive Automation — Extract with API Source and write back with API Destination
Flexible Authentication — Supports OAuth User Account and Service Account setup patterns
File + Folder Operations — Work with files, folders, and shared drive resources through connector endpoints
Resilient API Runtime — Configure retry mode and retry status settings for robust execution
No-Code Mapping Workflow — Preview endpoint results and configure mappings in SSIS UI

📸 Visual Overview & Setup

1. Drag API Source to Data Flow 🔍 View Full Size	2. Drag API Destination to Data Flow 🔍 View Full Size	3. Pick or Search Google Drive Connector 🔍 View Full Size
4. Map the Columns 🔍 View Full Size	5. Select Endpoint and Preview data 🔍 View Full Size	6. Destination Mapping & Execute 🔍 View Full Size

🔧 Key Features

Google Drive Connector Workflow

Read Drive data with API Source and write changes with API Destination in one package
Select endpoints and configure required parameters through connector UI
Preview data before finalizing downstream mappings

Authentication & Reliability

OAuth User Account flow for interactive account-based access
Service Account flow for automated machine-to-machine execution
Retry options for throttling and transient API failures

💡 Common Use Cases

Common integration scenarios from the landing guide:

File and Folder Export: Pull Drive metadata and content pointers into staging systems.
Automated Content Sync: Upsert or update files/folders from upstream sources via API Destination.
Shared Drive Governance: Enumerate and manage shared drive entities in scheduled workflows.
Low-Code API ETL: Replace script-heavy integrations with connector-driven SSIS components.

🎯 Summary

SSIS Google Drive Connector provides a landing-page-documented, two-way connector workflow for files, folders, and shared drives.
Configure auth, preview endpoints, map columns, and run resilient API integrations without custom API coding.

Trusted by Developers & IT Teams Worldwide

Built for SSIS Workflows: Purpose-built for high-performance ETL and API integration scenarios.
Expert Technical Support: Direct access to engineers via email and remote screen-share sessions.
Proven Enterprise Scale: Trusted by 3000+ teams across 90+ countries.

SSIS PowerPack

Includes SSIS Google Drive Connector