The CData Excel Add-In for Gmail models Gmail entities in relational Tables and Stored Procedures. API limitations and requirements are documented in this section; you can use the SupportEnhancedSQL feature, set by default, to circumvent most of these limitations.

Gmail REST Data Model

Gmail REST Data Model describes the schemas available to connect to Gmail REST accounts. You can use tables to work with live Gmail data. You can use stored procedures provided by CData Excel Add-In for Gmail to automate working with Gmail data.

Gmail IMAP Data Model

Gmail IMAP Data Model describes the schemas available to connect to Gmail IMAP accounts. You can use tables to work with live Gmail data. You can use stored procedures provided by CData Excel Add-In for Gmail to automate working with Gmail data.

Stored Procedures

Stored Procedures are function-like interfaces to the data source. They can be used to search, update, and modify information in the data source.