Welcome to the GSheetBridge world!
The only limit is your imagination. If you've made it this far, you're well on your way to becoming a Business Intelligence (BI) expert.
As a token of our appreciation, we've built your first Web App. This application is bidirectionally connected to the GSB-FireWall.
We created an Input 10×10 matrix and an Output 10×10 matrix in the GSB-FireWall. The Output_Data sheet links both sides — so whatever goes into Input_Data automatically transfers to Output_Data. These are already connected to your App.
Download it, open in your browser, and enter data in the left blue matrix. The data automatically syncs to your spreadsheet, then returns to the right red matrix when you click "Refresh Data".
Advanced Settings Webhook, SDK, API reference ▸
Current webhook URL: Not set
Copy the SDK snippet below into your website. It contains your personal key and connection endpoint.
Full SDK file:
Download sample pages:
A GSB_Client_SDK class public methods:
| Method | Description | Example |
|---|---|---|
new GSB_Client_SDK(config) | Initializes the SDK with the given routerUrl, userKey and optional settings. | const db = new GSB_Client_SDK({...}); |
.connect() | Checks the connection to the Router. On success, emits a 'ready' event. | db.connect(); |
.fetchData(sheetName?) | Fetches data from the specified sheet. Uses cache if enabled. | db.fetchData('Output_Data'); |
.writeCell(cell, value, sheet?) | Writes a value to the specified cell. Performs deduplication and limit checking. | db.writeCell('A1', 'Hello'); |
.updateCell(row, col, value, sheet?) | Similar to writeCell, but using row/column indices (starting from 1). | db.updateCell(2, 3, 'Adat'); |
.on(event, callback) | Event listener: 'ready', 'data', 'error', 'write', 'disconnect'. | db.on('data', mtx => {...}); |
.clearCache() | Clears the internal cache; the next fetchData will download fresh data. | db.clearCache(); |
💡 Tip: The SDK never sends the secret from the frontend — the secret key is used only by the Sheet Agent.