D4E Google Sheets Add-on (D4ESQL)

Full Description

D4ESQL is a powerful Google Sheets add-on that enables users to create and send SQL-based data requests directly from Google Sheets to a secure back-end D4E Server running in Excel for Windows. This setup empowers business users to work with live or offline data sources—including ODBC, CSV, and Excel—using a familiar spreadsheet interface, while IT teams or analysts maintain control over data logic, access, and execution from the centralized server.

The solution provides a 2-tier architecture:

• Frontend: A simple Google Sheets interface for selecting reports and entering parameters.

• Backend: A Windows-based D4E Server (Excel + Add-in) that runs scheduled tasks and processes SQL templates created in Google Sheets.

Use cases include:

• Budget planning and forecasting

• Automated report generation

• Collaboration between business users and SQL developers

• Secure parameterized access to enterprise data without giving direct SQL access to end users

Key Features:

• Simple “Get Data” and “Create Budget App” buttons embedded in Google Sheets

• SQL versions defined in columns; users just click and send

• D4E Server polls email inbox for incoming requests and sends back results

• No user-side scripting or macros required in Google Sheets

• Supports ODBC, Excel, CSV, and Python-based drivers

• Fully customizable and compatible with enterprise security models

Why list as SaaS?
The D4ESQL Add-on is free to install from the Google Workspace Marketplace, but requires a hosted D4E Server instance to process requests. Organizations can deploy their own D4E Server or request a hosted instance from Caratrel Consultants Pty Ltd.

Documentation and Support
Visit https://www.datamart4excel.com for installation steps, documentation, videos, and a test Access DB.