Google Sheets integration Banner

Google Sheets data can be integrated and synchronized codeless with various other data sources using the Layer2 Cloud Connector via 3rd party data providers. Please take a look here for supported target systems and applications like SQL, Office 365, SharePoint, Exchange, Dynamics and others.​

Google Sheets Integration with Office 365, SharePoint and 100+

​To connect to a Google sheet the source entity must be configured as follows in the Layer2 Cloud Connector Connection Manager:

Fig.: Sample connection configuration to connect to a Google sheet with the Layer2 Cloud Connector for synchronization.

Google Sheets Specific Integration Settings

​Please note the following Google Sheet specific settings.

  • Install the RSSBus ADO.NET Provider for Google AppsSheets. This provider is not part of the Layer2 Cloud Connector ADO.NET provider package and should be installed separately from the vendor's product page. It requires extra licensing.
  • Choose “RSSBus ADO.NET Provider for Google Spreadsheets” (exact name might vary) as “Data Provider” for your data entity (source and / or destination).
  • Follow the vendor instructions for setting up the connection string and select statement (see below for samples).
  • Set the connection string as required, e.g. OAuthClientId=myClientId; OAuthClientSecret=myClientSecret; InitiateOAuth=true; SpreadSheet=myTable
  • A Google client ID looks like
  • A client secret looks like one encoded string of numbers and characters.
  • myTable referrs to any specific table in the spreadsheet.
  • Note: The first time new credentials are used, your default browser will open a web page where you are asked to authorize access to your Google account. Thats not the case for any further manual or automatic scheduled syncs.
  • Set the data query as required, e.g. SELECT * mySheet.
  • Choosing a primary key is not required as the provider sets one automatically.
  • You can map your Google spreadesheet data fields to specific external fields in the Layer2 Cloud Connector. Please take care about data types (simple type conversions are supported).
  • No installation or changes are required at the Google spreadsheet data source or the data destination.
  • Data synchronization can be started manually in the Connection Manager, per command line or scheduled in background by the Layer2 Cloud Connector Windows Service. Only data changes are processed (no delete / bulk import).
  • No programming required for setup a connection and sync.
  • No need to open your local network for access from outside.
  • Insert to Google Sheet requires knowledge of the primary key value (e.g. customer number). Delete / Update works as usual, also two-way. If you are using this provider as target or in a bi-directional connection, choosing your own primary key (usual PK restrictions of ‘unique, non-NULL’ apply) is required. Choosing the automatically provided primary key is not recommended as this might lead to inconsistent
    synchronization. Using the replication key feature (see technical documentation for explanation) might help you with this.

Step-by-Step Intros For Codeless Google Sheet Data Integration And Synchronization

Just some ideas what to connect next:

  • Sync with Microsoft SharePoint (on-premises) or Office 365 for better collaboration (for example with customers or partners) or for intranet publishing. Change notifications and workflows on item level fully supported.
  • Sync with Microsoft Exchange (on-premises or online) for calendar events and appointments, contacts etc. mobile access and offline availability on any device. Public folders also supported.
  • Sync with 3rd party tools like ERP/CRM/CMS based on SQL databases like Oracle, mySQL or Microsoft SQL Server.
  • Integrate with Microsoft Dynamics CRM/ERP/NAV etc.
  • Connect to SAP via NetWeaver and OData or SAP Hana.

Next Steps For Evaluation

​​​​You can register to download and evaluate the Layer2 Cloud Connector here.
Share this site on Xing
Share this site on Google+
Share this site on LinkedIn

The software works perfect and does just what we need.

Frank Daske

Frank Daske

Business Development Manager
+49 (0) 40 28 41 12 - 30
[email protected]

Please note that the 011 exit code must be dialed first for all international calls made from the USA, Canada and Australia.

Related Downloads
PDF Image

Office 365: How to sync with MS SQL Server

You can sync any Microsoft SQL Server data codeless with SharePoint or Office 365 to make it available for collaboration, search and workflows.
PDF Image

Solution Flyer: Google Data Integration and Synchronization

Google data from Google Drive, Google Calendar, Google Contacts, Google Spreadsheet, Google BigQuery or Google Analytics can be integrated and synchronized with other apps via Layer2 Cloud Connector.
PDF Image

Solution Flyer: Microsoft Dynamics CRM Data Integration

Microsoft Dynamics CRM Codeless Data Integration and Synchronization via Layer2 Cloud Connector.
PDF Image

Solution Flyer: Microsoft Exchange Data Integration

Microsoft Exchange Codeless Data Integration and Synchronization via Layer2 Cloud Connector.
PDF Image

Solution Flyer: SOAP Web Services Data Integration

SOAP Web Services data can be integrated and synchronized codeless with various other data sources, on-premise or in the cloud, using the Layer2 Cloud Connector.
PDF Image

Solution Flyer: XML & XPath Data Integration

XML & XPath Data Integration and Codeless Synchronization via Layer2 Cloud Connector.