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

Configure OAuth User Account or Service Account authentication, query and update spreadsheets/ranges/cells, and map source/destination operations directly in SSIS.
Part of ZappySys SSIS PowerPack (100+ connectors & tasks).

Recommended starting point

View Setup Guide & Get Started →

See features, UI & examples →

Pro Tip: Service Account setup works well for unattended jobs; ensure the spreadsheet is shared with the service account.

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

⚡ Key Benefits

Two-Way Sheets Automation — Extract with API Source and write back with API Destination
Dual Authentication Paths — Supports User Account OAuth and Service Account key authentication
Spreadsheet-Centric Operations — Query, update, and manage sheets, ranges, and cells
Retry-Aware Runtime — Configure retry status handling to improve package reliability
Low-Code SSIS UX — Choose endpoints, preview responses, and map columns in the designer

📸 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 Sheets Connector 🔍 View Full Size
4. Map Source and Destination Columns 🔍 View Full Size	5. Select Endpoint and Preview Data 🔍 View Full Size	6. Execute and Load to Target 🔍 View Full Size

🔧 Key Features

Google Sheets Connector Workflow

Use preinstalled or Search Online connector loading in API Source and API Destination
Configure SpreadsheetId-aware connections and select endpoints for read/write calls
Map source data to destination payload fields in SSIS designer

Authentication & Reliability

OAuth User Account flow for interactive account access
Service Account flow using JSON/P12 key file for automation
Retry options (RetryMode, RetryStatusCodeList, RetryCountMax) for resilient execution

💡 Common Use Cases

Common integration scenarios from the landing guide:

Spreadsheet Export Pipelines: Extract worksheet data and load into SQL or analytics targets.
Automated Sheet Updates: Push transformed data back to sheets and ranges via API Destination.
Operational Reporting Flows: Synchronize SQL source data with Google Sheets for business reporting.
Low-Code API ETL: Build API-driven jobs in SSIS without custom Google API coding.

🎯 Summary

SSIS Google Sheets Connector provides a two-way, UI-driven integration workflow for spreadsheets in SSIS.
Teams can authenticate securely, preview endpoints, map payloads, and run reliable ETL pipelines for Google Sheets data.

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 Sheets Connector