Google Sheets FireDAC Components

Easily connect Delphi & C++Builder Apps with real-time data from spreadsheets stored in Google Docs. Use Google Sheets to manage the data that powers your applications.

  • Connect to Google Sheets from Rad Studio Data Explorer.
  • Comprehensive support for CRUD (Create, Read, Update, and Delete) operations.
  • Use Google Spreadsheets as a simple real-time database to power Delphi & C++Builder Apps.

  download   buy now

CData FireDAC Components for Google Spreadsheets
 Included in FireDAC Subscriptions: 125+ Components for real-time data access.

Extend Delphi & C++Builder Apps with unrivaled data connectivity!

Google Sheets FireDAC Components Included in Enterprise & Enterprise PLUS Subscriptions

Get the Google Sheets FireDAC Components together with 125+ additional components for SaaS, NoSQL, and Big Data integration! Our components offer the fastest & easiest way to build data driven Apps.

Learn More  

FireDAC Components in Action

Connecting to Any Data Source is as Easy as Connecting to a Database

Standard FireDAC Components

Just like connecting with a typical RDBMS like MySQL. or SQL Server. Use standard FireDAC components like TDFManager, TDFConnection, TDFQuery, etc.

FDConnection1.Name := 'GoogleSheetsConnection';
FDConnection1.DriverName := 'CData.Fire.GoogleSheets';
with FDConnection1.Params as     
    TFDPhysCDataGoogleSheetsConnectionDefParams do begin


FDConnection1.Connected := true;
FDQuery1.Active := true;
FDQuery1.Open('select * from GoogleSpreadsheet');


Type SQL, Get Google Sheets

The easiest way to build data-centric applications. Write standard SQL queries to interact with Google Sheets, just like working with any RDBMS. Supports joins, updates, aggregation, and more.


SELECT GoogleSpreadsheet.Id, GoogleSpreadsheet.Name, GoogleSpreadsheet.Fax,     
  Opportunity.AccountId, Opportunity.CloseDate
FROM GoogleSpreadsheet
INNER JOIN Opportunity
  ON GoogleSpreadsheet.Id = Opportunity.AccountId


SELECT Name, AVG(AnnualRevenue) FROM GoogleSpreadsheet GROUP BY Name


UPDATE GoogleSpreadsheet SET Name='John' WHERE Id = @myId

Powerful Enterprise features