Connect Database – QuantumLayers

If you haven’t done so already, you need to authenticate with your Google account to access your spreadsheets.

Dataset Name *

A friendly name for this dataset

Spreadsheet ID or URL *

You can paste the full URL or just the spreadsheet ID.
Example URL: https://docs.google.com/spreadsheets/d/SPREADSHEET_ID/edit

Sheet Name

The name of the specific sheet/tab to import (default: Sheet1)

Range

Specify a range to import (e.g., A1:Z1000). Leave empty to import entire sheet.

Privacy Setting

Private – Only you can accessPublic – Anyone with link can view

How to find your Spreadsheet ID:

Open your Google Sheet in a web browser
Look at the URL in the address bar
Copy the long string of letters and numbers between /d/ and /edit

Example:
URL: https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit
Spreadsheet ID: 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms

Dataset Name *

Give this connection a memorable name

Database Type *

Host *

Port

Default: 3306 (MySQL), 5432 (PostgreSQL)

Database Name *

Username

Password

SQL Query *
This query will be executed to fetch data for analysis

⚠️ Security Note:

Use a read-only database user with minimal privileges. Never use admin credentials.

Privacy Setting

Private – Only you can accessPublic – Anyone with link can view

Dataset Name *

API Endpoint URL *

The API must return JSON data

API Key (Optional)

If your API requires authentication

Example response format:
{
  “data”: [
    {“id”: 1, “name”: “John”, “value”: 100},
    {“id”: 2, “name”: “Jane”, “value”: 200}
  ]
}

Privacy Setting

Private – Only you can accessPublic – Anyone with link can view

Security & Privacy

Credentials are encrypted – All database credentials are encrypted at rest
Read-only access recommended – Use database users with SELECT-only permissions
Data stays external – We don’t import your data, only query results for analysis
Secure connections – All connections use encrypted protocols when available