GMail2SQL Sync Utility

GMail2SQL Sync Utility is a standalone command-line tool that synchronises your GMail mailbox into Microsoft SQL Server, giving you fast, structured access to your email data for reporting, integration, and analysis.

It connects securely to your GMail account and automatically exports:

Messages
To recipients
CC recipients
Attachments

Key Features

Automatic incremental sync
Only new messages since the last successful synchronisation are imported, ensuring your SQL Server database stays current without unnecessary processing.
Automatic table creation
The utility creates four SQL Server tables for you:
- GMailMessages
- GMailTos
- GMailCCs
- GMailAttachments
This allows you to begin working with the data immediately without manual database preparation.
Advanced table mapping (optional)
For organisations with established database structures, the tool can map GMail data into your existing tables. This requires advanced configuration but allows seamless alignment with your preferred schema.
Command-line operation
Designed as a command-line utility, it can be scheduled using Windows Task Scheduler or your preferred automation tools.

Security and Deployment

Runs entirely in your infrastructure
The utility is installed and executed within your own environment, giving you full control over connectivity, privacy, and security.
No data stored in transit
The tool does not store your data in transit. It reads directly from GMail and writes straight to your SQL Server tables.
Gmail API integration
Requires Gmail API access configured through your Google Cloud project. Once authorised, the utility uses the official GMail API to retrieve your mailbox data.

Licensing and Support

Licensing
One licence is required per installation of the GMail2SQL Sync Utility.
Support
The product includes limited email support. Immediate or priority responses are not guaranteed under the standard licence.
Enhanced support packages can be purchased separately if you require guaranteed response times or extended assistance.
Free 30-day trial
A fully functional 30-day trial is available so you can evaluate the utility in your own environment before purchasing.

GMail2SQL Sync Utility is ideal for organisations that need reliable, secure, and controlled access to their GMail data in SQL Server, without relying on external hosted services.

Configuration

All configuration settings for the GMail2SQL Sync Utility are stored in the appconfig.json file in the installation folder. This file can be edited with any text editor. All entries must follow valid JSON syntax. Configuration options allow you to define database connections, GMail authentication settings, and optional mapping rules tailored to your environment.

GMail To SQL Synchronisation

GMail2SQL Sync Utility

GMail2SQL Sync Utility – 30 day evaluation