Skip to main content
Don’t miss what’s next at Microsoft Ignite
Don’t miss what’s next at Microsoft IgniteGet direct access to the people, products, and expertise behind Microsoft technology, with opportunities to ask questions, build skills, and learn alongside the community.
Register now
Microsoft
separator
https://store-images.s-microsoft.com/image/apps.54051.f12e70a6-01c3-4e20-b660-9d85ce5c3883.9cde5377-49cd-483e-b3ab-31a98cd7ee39.07ef9074-8661-490e-af64-f577adff41e2

D4E Google Sheets Add-on (D4ESQL)

by Caratrel Consultants Pty Ltd

Enable SQL-powered automation in Google Sheets with D4E Server (Excel-based backend).

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.

At a glance

https://store-images.s-microsoft.com/image/apps.46013.f12e70a6-01c3-4e20-b660-9d85ce5c3883.9cde5377-49cd-483e-b3ab-31a98cd7ee39.742f9efb-4412-4fea-b01b-7888867d2715
/staticstorage/20261108.1/assets/videoOverlay_62a424ca921ff733.png
https://store-images.s-microsoft.com/image/apps.46013.f12e70a6-01c3-4e20-b660-9d85ce5c3883.9cde5377-49cd-483e-b3ab-31a98cd7ee39.742f9efb-4412-4fea-b01b-7888867d2715
/staticstorage/20261108.1/assets/videoOverlay_62a424ca921ff733.png
https://store-images.s-microsoft.com/image/apps.28719.f12e70a6-01c3-4e20-b660-9d85ce5c3883.9cde5377-49cd-483e-b3ab-31a98cd7ee39.66461a6b-061c-4b22-bee8-8b94ca9f1fb3
https://store-images.s-microsoft.com/image/apps.42508.f12e70a6-01c3-4e20-b660-9d85ce5c3883.9cde5377-49cd-483e-b3ab-31a98cd7ee39.f8a7c33b-3dff-4366-b531-d7b24756db6e
English (Philippines)
Your Privacy Choices Opt-Out Icon Your Privacy Choices
Consumer Health Privacy Sitemap Contact Us Privacy & Cookies Terms of Use About our ads Manage cookies