# Connections

Connections link your Squirrel365 project to an external data source. You can pull data in from spreadsheets, databases, and cloud paltforms, write data back when users interact with your app, or trigger actions in other tools. Each connection runs in the background and keeps your app's spreadsheet in sync with your data.

### Adding a connection

To access the Connections library, select the <img src="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2FepKCSgsHyfYBcg7dp4Ew%2FAdd%20Connetion%20Icon.svg?alt=media&#x26;token=2d2928b0-4d02-4f90-b89a-edd870ce673a" alt="" data-size="line"> icon in the Sidebar.&#x20;

To add a new connection click the add <img src="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2FUd6a7bfWPXQ51VczSkia%2FAdd%20Connection%20to%20tree%20Icon.svg?alt=media&#x26;token=fac58036-8b4c-4969-bc6c-08d5c7e85c95" alt="" data-size="line"> icon to open the Connection Library where you can browse the available connections and select the one you need.

<figure><img src="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2FK7tvBllOdKal5PR9OS8F%2FConnection%20Library.svg?alt=media&#x26;token=11cfffbc-0661-401c-ba9f-b885d6e82af8" alt="" width="425"><figcaption><p>The Connections Library (v1.19), after selecting the 'Add a Connection' button</p></figcaption></figure>

Connections added to your project will appear as a list in the connections panel.

<figure><img src="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2FJmQ3b9ymY7aAYpd76QUW%2FConnections%20-%20with%20connections%20added.svg?alt=media&#x26;token=91276e34-6989-4550-807c-4cbfc9d86a11" alt=""><figcaption><p>A connection added to the connections panel.</p></figcaption></figure>

## Looking for something in particular?

<table data-view="cards"><thead><tr><th></th><th></th><th></th><th data-hidden data-card-cover data-type="files"></th><th data-hidden data-card-target data-type="content-ref"></th></tr></thead><tbody><tr><td><strong>Excel One Drive</strong></td><td>Import and writeback to an Excel Online sheet from a linked One Drive account.</td><td></td><td><a href="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2FLdFidz1tiKsahqGtW7pc%2FExcel%20OneDrive.svg?alt=media&#x26;token=577560e9-1b0b-42b6-a40a-1036337c5607">Excel OneDrive.svg</a></td><td><a href="overview-2/spreadsheets/excel-one-drive">excel-one-drive</a></td></tr><tr><td><strong>Google Sheets</strong></td><td>Connect to, import and writeback to a Google Sheet from a linked Google account.</td><td></td><td><a href="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2F5fAlqmxZuQLWzJnUcubg%2FGoogle%20Sheets.svg?alt=media&#x26;token=a75fede8-0ab3-47f2-8832-f6803b9cb2a8">Google Sheets.svg</a></td><td><a href="overview-2/spreadsheets/google-sheets">google-sheets</a></td></tr><tr><td><strong>Ninox Connections</strong></td><td>Read, update and insert new data into a database stored in the Ninox cloud.</td><td></td><td><a href="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2Fp34B4od9NgGwnU6Rs9qd%2FNinox%20Connections.svg?alt=media&#x26;token=1be2f214-12b4-420d-aeb5-4a270a40c6ac">Ninox Connections.svg</a></td><td><a href="overview-2/cloud/ninox-connections">ninox-connections</a></td></tr><tr><td><strong>Smartsheets</strong></td><td>Connect to Smartsheets to power projects, allowing for read, insert and update capabilities.</td><td></td><td><a href="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2F1cVvaglO7D0qRxGzNqdH%2FSmartsheets.svg?alt=media&#x26;token=74ec1cbe-6247-4710-b851-5e42f616d2f7">Smartsheets.svg</a></td><td><a href="broken-reference">Broken link</a></td></tr><tr><td><strong>CSV Connector</strong></td><td>Draw in and populate data in the spreadsheet from a .csv file.</td><td></td><td><a href="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2FnTTfrurhAkqKbvMIGmk5%2FCSV.svg?alt=media&#x26;token=4ed22c51-7a7d-4f57-8b7b-46a1ded37722">CSV.svg</a></td><td><a href="overview-2/file/csv-connector">csv-connector</a></td></tr><tr><td><strong>SAP Webi Connector</strong></td><td>Pull data from an external BO Webi database.</td><td></td><td><a href="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2FP8zjBHJZPXkNdAT1h7js%2FSAP.svg?alt=media&#x26;token=25336d53-9492-4238-bc7d-502c60918646">SAP.svg</a></td><td><a href="overview-2/other-1/sap-webi-connector">sap-webi-connector</a></td></tr><tr><td><strong>XDC Connections</strong></td><td>Bring in a whole or query specific data from an XDC cache from Infoburst.</td><td></td><td><a href="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2F5pqtnpYtYKrBfXXn9lEd%2FXDC.svg?alt=media&#x26;token=53751437-1959-472b-b6e9-2ebee766291a">XDC.svg</a></td><td><a href="overview-2/infoburst/xdc-connections">xdc-connections</a></td></tr><tr><td><strong>Database Connections</strong></td><td>Query and writeback to a database stored in an Infoburst encironment.</td><td></td><td><a href="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2F9bjlaGToBPLBdNNECg8V%2FDatabase.svg?alt=media&#x26;token=ac662bf6-e2b0-4581-a4da-48bcfe121649">Database.svg</a></td><td><a href="overview-2/infoburst/database-connections">database-connections</a></td></tr><tr><td><strong>Zapier Trigger</strong></td><td>Wire up to Zapier and "zap" data from Squirrel to another environment and back again.</td><td></td><td><a href="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2FYcGEvmwjIPF8ImfhnHnt%2FZapier.svg?alt=media&#x26;token=393160e5-53de-4757-861a-9b0d7031d478">Zapier.svg</a></td><td><a href="overview-2/cloud/zapier-trigger">zapier-trigger</a></td></tr></tbody></table>
