Every source your data lives in

Google Sheets

All plansAuto-refresh

The fastest way to start

Paste a sheet URL, pick a tab, and your dashboard is live. DataRich reads your data via the Google Sheets API and refreshes it automatically on Starter and above plans.

• Auto-detect all tabs in a spreadsheet
• Automatic data refresh (Starter+)
• No sheet upload or export required
• Supports multiple sources per dashboard (Pro+)

CSV / Excel

Pro+Manual only

Upload any spreadsheet file

Drag and drop a .csv, .xlsx, or .xls file from your computer. Your data is parsed client-side, stored securely, and instantly available as a dashboard without any external accounts.

• Supports CSV, XLSX, and XLS formats
• No external account or API key needed
• Data stored securely in DataRich
• Instant parse preview before publishing

PostgreSQL

Pro+Auto-refresh

Live SQL queries, always fresh

Connect any PostgreSQL 10+ database with a read-only user. Write any SELECT query and DataRich will cache the result, display it as widgets, and re-run the query on your refresh schedule.

• Any SELECT or WITH query supported
• Schema browser — see all tables at a glance
• Credentials encrypted with AES-256-GCM
• Auto-refresh on Pro/Team plan schedule

MySQL

Pro+Auto-refresh

The world's most popular open-source DB

Connect MySQL 5.7+ or MySQL 8 over TCP. DataRich handles connection pooling, timeouts, and SSL automatically. Use a read-only user for best security.

• MySQL 5.7+ and MySQL 8 supported
• SSL/TLS encryption for connections
• Schema browser with table/view listing
• Parameterised SELECT queries

MariaDB

Pro+Auto-refresh

MySQL-compatible, community-driven

Connect MariaDB 10.3+ using the same MySQL-compatible protocol. Fully supported with identical connection fields and introspection. A drop-in alternative to MySQL.

• MariaDB 10.3+ supported
• Uses MySQL-compatible wire protocol
• SSL/TLS support
• Schema browser and query builder

Microsoft SQL Server

Pro+Auto-refresh

Enterprise SQL Server & Azure SQL

Connect SQL Server 2017+ and Azure SQL Database over the TDS protocol. Supports SQL Server Authentication, Windows domain accounts, and Azure AD credentials.

• SQL Server 2017+ and Azure SQL Database
• Encrypt connection and trust server certificate options
• Works with SQL Server Auth and Windows Auth
• No ODBC driver or native client needed

Oracle SQL

Pro+Auto-refresh

Enterprise Oracle Database support

Connect Oracle 12c and above using the thin-mode oracledb driver — no Oracle Client libraries required. Supports service names, SIDs, and EZConnect strings.

• Oracle 12c and above
• Thin-mode driver — no client install needed
• Service Name, SID, and EZConnect string support
• OUT_FORMAT_OBJECT result rows

SQLite

Pro+Manual only

Upload a local database file

Upload a .sqlite or .db file (up to 50 MB). The file is stored in private cloud storage and queried server-side in read-only mode — perfect for sharing a snapshot of a local database.

• .sqlite and .db files supported
• Stored securely in private cloud storage
• Opened read-only — no writes possible
• Full SQL query builder and schema browser

Snowflake

Pro+Auto-refresh

Cloud data warehouse at scale

Connect your Snowflake account using account identifier, warehouse, and role. DataRich runs your SELECT queries via the Snowflake Node.js SDK and caches results for dashboard display.

• Account identifier and warehouse selection
• Role-based access control support
• Schema and database browser
• Auto-refresh on scheduled warehouse queries

Amazon Redshift

Pro+Auto-refresh

Petabyte-scale analytics warehouse

Connect Amazon Redshift clusters or Redshift Serverless using standard PostgreSQL-compatible credentials. DataRich queries your warehouse over port 5439 with a read-only user.

• Redshift Provisioned and Serverless supported
• PostgreSQL-compatible SQL dialect
• SSL enforced for all connections
• Schema and table browser included

Amazon S3

Pro+Manual only

Query files directly from your bucket

Connect an S3 bucket with an IAM access key. DataRich fetches CSV, JSON, or Parquet files at the path you specify and presents them as a queryable dataset for your dashboard.

• CSV, JSON, and Parquet file formats
• IAM access key and secret authentication
• Path-based file selection per dashboard
• Works with private and public buckets

Google Cloud Storage

Pro+Manual only

Files from GCS buckets

Authenticate with a Google service account JSON key to read CSV or JSON files from any GCS bucket. Ideal for data pipelines that export results to Cloud Storage.

• Service account JSON key authentication
• CSV and JSON file formats supported
• Path-based file selection per dashboard
• Works across all GCS storage classes

OneDrive / SharePoint

Pro+Manual only

Excel and CSV files from Microsoft 365

Connect with Azure AD app credentials to read Excel and CSV files stored in OneDrive or SharePoint document libraries. Perfect for teams whose data lives in Microsoft 365.

• OneDrive personal and business supported
• SharePoint document library access
• XLSX and CSV file formats
• Azure AD app (client credentials) auth

Airtable

Pro+Auto-refresh

Bases and tables as live datasets

Connect an Airtable base using a Personal Access Token. DataRich syncs records from any table or view and maps fields to your dashboard widgets automatically.

• Personal Access Token authentication
• Any base, table, or view supported
• Field type mapping (text, number, date, etc.)
• Auto-refresh pulls latest Airtable records

HubSpot

Pro+Auto-refresh

CRM contacts, deals, and pipelines

Connect with a HubSpot Private App access token. Pull contacts, companies, deals, pipelines, and activity data into dashboards to visualise your CRM performance.

• Contacts, companies, deals, and pipelines
• Deal stage funnel visualisation
• Private App token — no OAuth redirects
• Auto-refresh syncs latest CRM data

Salesforce

Pro+Auto-refresh

CRM objects via SOQL

Connect to any Salesforce org using OAuth 2.0 connected app credentials. Write SOQL queries to pull data from any standard or custom object and build live sales dashboards.

• Any standard or custom Salesforce object
• SOQL query editor with field hints
• OAuth 2.0 — tokens refreshed automatically
• Works with Salesforce Classic and Lightning

Pipedrive

Pro+Auto-refresh

Sales pipeline and deal analytics

Connect Pipedrive with your API token and company domain. DataRich surfaces deals, contacts, activities, and pipeline stages so you can share real-time sales metrics.

• Deals, contacts, and activity data
• Pipeline stage breakdown
• API token — simple one-field setup
• Auto-refresh on schedule

Shopify

Pro+Auto-refresh

Orders, products, and revenue

Connect your Shopify store using an Admin API access token. DataRich pulls orders, products, customers, and inventory data so you can share live e-commerce dashboards.

• Orders, products, customers, and inventory
• Revenue and conversion metrics
• Admin API token — no app install required
• Auto-refresh keeps store data current

Stripe

Pro+Auto-refresh

Payments, revenue, and subscriptions

Connect Stripe with a restricted secret key. DataRich pulls charges, subscriptions, customers, payouts, and refunds so you can build real-time revenue dashboards.

• Charges, subscriptions, and customer data
• MRR, churn, and payout analytics
• Restricted key — grant only read permissions
• Auto-refresh on schedule

QuickBooks

Pro+Auto-refresh

Accounting and financial data

Connect QuickBooks Online using OAuth 2.0. Pull profit & loss, balance sheet, invoices, expenses, and customer data to build financial dashboards for your business.

• P&L, balance sheet, and cash flow reports
• Invoices, expenses, and customer data
• OAuth 2.0 — tokens refreshed automatically
• Auto-refresh keeps financials current

Google Analytics GA4

Pro+Auto-refresh

Website traffic and user behaviour

Connect a GA4 property using a Google service account. DataRich runs Data API queries to pull sessions, users, events, conversions, and acquisition data into your dashboards.

• Sessions, users, pageviews, and events
• Acquisition, engagement, and conversion data
• Service account JSON authentication
• Auto-refresh on schedule

Google Ads

Pro+Auto-refresh

Campaign and keyword performance

Connect Google Ads using a service account and developer token. Write GAQL queries to pull campaigns, ad groups, keywords, impressions, clicks, and spend data.

• Campaigns, ad groups, keywords, and ads
• Impressions, clicks, CTR, and spend metrics
• GAQL query editor for custom reports
• Auto-refresh on schedule

Facebook Ads

Pro+Auto-refresh

Ad account spend and performance

Connect a Facebook Ads account using a system user access token. Pull campaign performance, ad set reach, spend, ROAS, and audience data directly into dashboards.

• Campaigns, ad sets, and ad performance
• Spend, reach, impressions, and ROAS
• System user access token authentication
• Auto-refresh on schedule

Klaviyo

Pro+Auto-refresh

Email and SMS marketing analytics

Connect Klaviyo with a private API key to pull campaign performance, flow metrics, list growth, revenue attribution, and subscriber engagement data.

• Campaign and flow performance metrics
• List and segment growth data
• Revenue attribution per campaign
• Auto-refresh on schedule

Mailchimp

Pro+Auto-refresh

Audience and campaign metrics

Connect Mailchimp with an API key and server prefix. DataRich surfaces audience growth, campaign open and click rates, unsubscribes, and revenue data from your account.

• Audience list growth and churn
• Campaign open, click, and bounce rates
• E-commerce revenue attribution
• Auto-refresh on schedule

Zendesk

Pro+Auto-refresh

Support tickets and team metrics

Connect Zendesk using your subdomain, email, and API token. DataRich pulls tickets, agents, satisfaction scores, response times, and tag analytics for support dashboards.

• Tickets, agents, and groups
• CSAT and response time metrics
• Tag and priority breakdowns
• Auto-refresh on schedule

Intercom

Pro+Auto-refresh

Conversations and customer support

Connect Intercom with an access token to pull conversation volume, response times, team workload, contact data, and CSAT scores into live support dashboards.

• Conversation volume and response times
• Team and teammate workload metrics
• Contact and company data
• Auto-refresh on schedule

Jira

Pro+Auto-refresh

Issues, sprints, and project metrics

Connect Jira Cloud using your domain, email, and API token. Write JQL queries to pull issues, sprints, epics, and velocity data for engineering and project management dashboards.

• Issues, epics, sprints, and boards
• JQL query editor for custom reports
• Velocity, burndown, and cycle time data
• Auto-refresh on schedule

Linear

Pro+Auto-refresh

Engineering issues and cycles

Connect Linear with an API key to pull issues, cycles, projects, teams, and priority data. Build engineering velocity dashboards and share progress with stakeholders.

• Issues, cycles, and projects
• Team and priority breakdowns
• Velocity and completion rate metrics
• Auto-refresh on schedule

Monday.com

Pro+Auto-refresh

Boards, items, and project status

Connect Monday.com with an API token to pull boards, items, groups, subitems, and column values. Build project tracking dashboards to share status with your team.

• Boards, groups, and item data
• Column value and status tracking
• Multi-board aggregation
• Auto-refresh on schedule

GitHub

Pro+Auto-refresh

Repos, issues, and pull requests

Connect GitHub with a Personal Access Token to pull repository stats, issues, pull requests, commits, and release data. Perfect for engineering metrics dashboards.

• Repositories, issues, and pull requests
• Commit activity and release history
• Star, fork, and contributor counts
• Auto-refresh on schedule

RSS / Atom

Pro+Auto-refresh

Any feed URL as a data source

Paste any RSS 2.0 or Atom feed URL. DataRich parses the feed and exposes title, link, pubDate, and description fields as rows — great for content and news monitoring dashboards.

• RSS 2.0 and Atom formats supported
• Title, link, date, and description fields
• No authentication required for public feeds
• Auto-refresh fetches latest feed items