View Categories

Database Automation: Schedule SQL Reports to Excel, Sheets and Airtable

17 min read

DATABASE AUTOMATION SCHEDULED REPORTS

Set It Once.
Fresh Data Forever.

Schedule SQL reports that deliver themselves to Excel, Google Sheets, Airtable, Smartsheet, and more — no cron jobs, no ETL pipelines, no manual exports.

Scheduled Sync Multi-Destination Zero-Code Setup Parallel Execution
Start Free Learn More
See everything Query Streams can do beyond this guide Get Started Free
Supports
SQL Server PostgreSQL MySQL MariaDB SQLite MS Access Oracle BigQuery DuckDB
+more
Excel Sheets
Live Data

Replace exports with on-demand SQL

Excel Sheets
Nova
BI & AI Analytics

Ask Nova, get SQL + charts

Meet Nova
REST API
Database REST API

One key per partner. No credentials shared.

Build an API
Airtable Smartsheet Baserow SeaTable +more
Automation

Scheduled sync to 6+ platforms

Explore
Stripe HubSpot Shopify GA +more
API to SQL

Query APIs with SQL, no code

Explore
MCP Claude Cursor ChatGPT Grok +more
AI Database MCP

Claude, Cursor, ChatGPT & Grok talk to your data

Connect AI

Query Streams is a secure, real-time database integration platform that automates the delivery of SQL query results to Excel, Google Sheets, Airtable, Smartsheet, and other destinations on a schedule you define. Learn more at QueryStreams.com and sign up for free to start automating your database reports today.

What Is Database Automation?

Database automation is the practice of using software to perform recurring database tasks without manual intervention. Instead of a person writing a query, running it, exporting the results, and emailing a spreadsheet every Monday morning, database automation tools handle the entire chain — from query execution to data delivery — on a defined schedule. The goal is to remove humans from repetitive data workflows so they can focus on analysis, decision-making, and building systems rather than acting as a manual relay between a database and the people who need its data.

In practice, database automation covers a wide spectrum of tasks: scheduled report generation, data synchronization between platforms, automated dashboard refresh, recurring data exports, cross-system data pipelines, and alert-driven query execution. For most teams, the most impactful form of database automation is scheduled data delivery — running a SQL query on a recurring basis and pushing the results directly into the tools people already work in, such as Microsoft Excel, Google Sheets, or project management platforms like Airtable and Smartsheet.

Scheduled Reports

Run SQL queries automatically on a daily, weekly, or custom schedule and deliver results without manual intervention.

Data Refresh

Keep dashboards, spreadsheets, and reporting tools up to date with the latest data from production databases.

Cross-Platform Sync

Push database results into Airtable, Smartsheet, Baserow, or SeaTable so teams work from a single source of truth.

Event-Driven Queries

Trigger data pulls on demand from spreadsheets or the web portal alongside your automated schedules.

Common Database Automation Tasks

Most organizations run into the same recurring data workflows that consume disproportionate amounts of time when handled manually. A finance team needs last month’s revenue breakdown every first Monday. Operations wants a daily inventory snapshot. Sales leadership expects a weekly pipeline report in their shared Airtable base. Each of these tasks involves the same cycle: someone remembers (or forgets) to run a query, exports the results, formats them, and distributes the file. According to McKinsey, knowledge workers spend roughly 20% of their time searching for and gathering data before they can begin actual analysis.

Database automation software eliminates this cycle by handling the query-to-delivery chain end to end. The three most common automation tasks are:

  • Recurring report generation: Financial summaries, KPI dashboards, sales performance reports, and compliance exports that need to run on a fixed schedule — daily, weekly, monthly, or at custom intervals.
  • Live data refresh for spreadsheets: Keeping Excel workbooks and Google Sheets up to date with current database values so teams always see fresh numbers without running manual queries.
  • Cross-platform data synchronization: Pushing SQL results into project management tools (Airtable, Smartsheet), open-source platforms (Baserow, SeaTable), or external SaaS systems so that every team works from the same dataset.
The hidden cost of manual data delivery: Beyond the time spent running queries and exporting results, manual data workflows introduce version control problems — multiple copies of the same report floating through email, each slightly different. Automated delivery ensures everyone works from the same, most-recent dataset at all times.

How Query Streams Automates Data Delivery

Query Streams replaces manual data workflows with a secure, agent-based automation pipeline. A lightweight Query Streams Agent runs on any machine with database access — Windows, Linux, or macOS — and connects outbound to the cloud relay. You write your SQL once in the web portal, configure a schedule, choose your delivery destinations, and let the system handle every subsequent execution and delivery cycle automatically. No inbound firewall rules are needed because the Agent only makes outbound connections on standard HTTPS and WSS ports.

1

Deploy the Agent

Install the Query Streams Agent on a server with database access. Supports Windows, Ubuntu/Debian, generic Linux, and macOS (Intel and Apple Silicon).

2

Write Your SQL

Build queries in the web portal with optional interactive filters. Auto-detect filterable values or use explicit SQL variables like @region or @start_date.

3

Set a Schedule

Define when the query runs: daily, weekly, monthly, or custom intervals. Pair schedules with specific delivery destinations.

4

Choose Destinations

Route results to Airtable, Smartsheet, Baserow, SeaTable, or let users pull on demand from the Excel add-in or Sheets add-on.

5

Automatic Delivery

The Agent executes the query on schedule and pushes results to every configured destination. No manual intervention required.

This automation pipeline works across your entire infrastructure. You can deploy multiple agents — one in your on-premises data center, one on an AWS EC2 instance, another on an Azure VM — and all their data sources appear as a unified dropdown list in the query builder. Users simply select from available data sources without needing to know which agent or physical location hosts the database. For optimal performance, deploy agents in the same network or region as their databases.

Combine scheduled and on-demand: Scheduled sync handles your recurring reports automatically, but users can still pull fresh data on demand at any time from the Excel add-in or Google Sheets add-on. The two modes complement each other — automation handles the routine while on-demand covers ad-hoc requests.

Scheduling SQL Reports to Excel and Google Sheets

For many teams, the primary destination for database reports is a spreadsheet. Finance teams build models in Microsoft Excel. Marketing tracks campaign metrics in Google Sheets. Operations runs pivot tables across inventory data. Query Streams delivers fresh data directly into these tools through a native Excel add-in and Google Sheets add-on.

Users open the add-in, select a saved query from their list, adjust any available filters (date ranges, regions, departments), and click refresh. The Agent executes the query against the live database and streams the results directly into the worksheet. No CSV exports. No copy-paste. No stale data. The spreadsheet formulas, charts, and pivot tables built on top of the data update instantly because the underlying source rows are always current.

Query Streams also supports parallel query execution — users can launch multiple saved queries simultaneously into different worksheet tabs, and the Agent streams each result concurrently regardless of result size. A finance team can refresh five different reports at the same time (revenue, expenses, headcount, pipeline, and forecast) rather than waiting for each to complete sequentially. This turns a 15-minute manual batch refresh into a one-click operation that finishes in seconds.

Query sharing for teams: You can share saved queries with specific users or teams. A shared user can independently select a query from their list, adjust any available filters, and run it to get live data on demand — without any action needed from the original query creator. The SQL code remains hidden; end users only see the query name and filters.

Automating Database-to-Airtable, Smartsheet, and More

Spreadsheets handle analysis, but many teams track projects, manage workflows, and collaborate in platforms like Airtable, Smartsheet, Baserow, and SeaTable. Query Streams’ Automation and Integration feature bridges the gap between your database and these collaboration platforms by syncing SQL query results directly into their tables on a schedule.

Instead of building a custom ETL pipeline, writing API integration scripts, or using intermediary tools like Zapier, you configure a sync destination in the Query Streams portal. Define which query feeds which table, set the schedule, and the Agent handles the rest. The destination table stays in sync with your database automatically — fresh data appears on the schedule you set without any manual intervention or middleware.

Microsoft Excel icon
Microsoft Excel

Add-in with on-demand and batch refresh

Google Sheets icon
Google Sheets

Add-on with parallel query execution

Airtable icon
Airtable

Scheduled sync to bases and tables

Smartsheet icon
Smartsheet

Automated delivery to sheets

Baserow icon
Baserow

Open-source database platform sync

SeaTable icon
SeaTable

Self-hosted or cloud table sync

API Bridge: Automate SaaS Data Too

Database automation is not limited to traditional databases. Query Streams’ API Bridge lets you query SaaS platforms — Stripe, HubSpot, Shopify, Google Analytics 4, and more — using standard SQL syntax. The API Bridge caches API data locally (using DuckDB) and exposes it as queryable tables. You write SQL against your Stripe transactions the same way you query a PostgreSQL table, and the results flow through the same scheduling and delivery pipeline. This means a single Query Streams Agent can automate reports that combine data from your internal databases and your SaaS tools simultaneously.

Unified data pipeline: With the API Bridge, a single scheduled report can join your internal PostgreSQL sales data with Stripe payment records and HubSpot CRM contacts — all using standard SQL. No separate ETL tool, no middleware, no custom scripts. The Agent handles the API calls, caching, and query execution behind the scenes.

Query Streams vs Traditional Database Automation

Teams have been automating database tasks for decades using cron jobs, SSIS packages, Apache Airflow DAGs, and custom Python scripts. These tools are powerful, but they require significant engineering effort to build, maintain, and monitor. A cron job that emails a CSV is simple to set up once — but multiply that across 50 reports, 12 databases, and 8 destinations, and you are maintaining a fragile web of shell scripts and credentials scattered across servers. Query Streams provides a managed, visual, and security-first alternative.

Traditional Automation
  • Script-based scheduling

    Cron jobs, SSIS packages, or Airflow DAGs require scripting, version control, and server maintenance for every report.

  • Single-destination outputs

    Each script typically targets one destination. Sending to Excel, Sheets, and Airtable means three separate scripts to maintain.

  • Credential management overhead

    Database passwords are stored in config files, environment variables, or secrets managers across multiple servers.

  • Custom monitoring required

    You need to build your own alerting for failed jobs, stale data, and broken pipelines — or rely on log file inspection.

Query Streams
  • Visual schedule builder

    Configure schedules and destinations from the web portal. No crontab syntax, no deployment pipelines, no server access needed.

  • Multi-destination delivery

    One query, many destinations. Route the same SQL results to Excel, Sheets, Airtable, Smartsheet, and more simultaneously.

  • Zero credential sharing

    Database credentials stay on your server with the Agent. No passwords in config files, no secrets to rotate across scripts.

  • Built-in execution monitoring

    Every query run is logged with timestamps, user identity, and delivery status. View history and troubleshoot from the portal.

Capability Query Streams Cron + Scripts SSIS Airflow
Setup complexity Web portal, no code Shell/Python scripting Visual Studio packages Python DAGs
Schedule configuration Visual UI Crontab syntax SQL Server Agent Cron expressions in code
Excel/Sheets delivery Native add-in/add-on Email CSV attachment File export only Custom operator required
Airtable/Smartsheet sync Built-in integration Custom API scripts Not supported Custom operator required
SaaS data (Stripe, HubSpot) API Bridge, SQL syntax Separate ETL scripts Not supported Custom operator per API
Credential management On-agent only, never shared Config files or env vars Connection managers Connections or Vault
Cross-platform agents Windows, Linux, macOS Linux only (typically) Windows only Docker/Linux
End-user self-service Yes, from spreadsheets No No No
When traditional tools make sense: If your automation needs involve complex data transformations, multi-step ETL workflows with conditional branching, or orchestration of non-database tasks (file processing, API orchestration, ML pipelines), tools like Airflow or custom scripts offer more flexibility. Query Streams is purpose-built for the query-to-delivery pipeline — running SQL and delivering results to the tools your team already uses, with security and simplicity as priorities.

Nova AI: Ad-Hoc Analytics Between Scheduled Deliveries

Scheduled reports cover the recurring data needs, but questions that arise between delivery cycles still require immediate answers. Query Streams includes Nova AI — a natural-language-to-SQL engine that generates schema-aware, dialect-correct SQL from plain English questions. When a manager asks “what were our top 10 products by revenue last quarter?” at 2 PM on a Wednesday, they can ask Nova directly instead of waiting for the next scheduled report or filing a request with the data team.

Nova reads your actual database schema and generates SQL that references real tables, columns, and relationships — not hallucinated structures. It supports every SQL dialect that Query Streams connects to, including Microsoft SQL Server, PostgreSQL, MySQL, Oracle, Snowflake, and BigQuery. Nova also auto-generates charts and visualizations alongside query results, providing immediate business intelligence without requiring a separate BI tool. All Nova queries operate within the same read-only, per-user access controls that govern saved queries and scheduled deliveries.

Supported Databases and Platforms

Query Streams connects to the databases your organization already runs. A single Agent installation supports simultaneous connections to multiple database engines: Microsoft SQL Server (including Azure SQL Database), PostgreSQL (including AWS RDS and Google Cloud SQL), MySQL, MariaDB, SQLite, Microsoft Access, Oracle, Snowflake, Google BigQuery, and DuckDB — with more integrations coming soon. The Agent installs on Windows (exe installer), Ubuntu/Debian Linux (deb package), any Linux distribution (tar.gz), and macOS for both Intel and Apple Silicon architectures.

Multiple agents can be deployed per account based on your subscription tier — across different networks, regions, and cloud providers. Whether your databases run on bare-metal servers in a data center, EC2 instances on AWS, Azure VMs, Google Cloud Compute Engine, or development machines, all agents register under your single Query Streams account and present their data sources as a unified dropdown in the query builder. All agents self-maintain with automatic updates, downloading and applying new versions without manual intervention.

Frequently Asked Questions

What is database automation and how does it differ from ETL? +
Database automation refers broadly to using software to perform recurring database tasks without manual intervention — including scheduled query execution, data delivery, and report distribution. ETL (Extract, Transform, Load) is a specific type of data pipeline that extracts data from source systems, transforms it (cleaning, aggregating, restructuring), and loads it into a destination like a data warehouse. Query Streams focuses on the query-to-delivery pipeline: executing SQL and delivering raw or filtered results directly to spreadsheets and collaboration platforms. If you need heavy transformations between source and destination, a traditional ETL tool may be more appropriate, but for delivering query results on a schedule, Query Streams eliminates the need to build and maintain ETL infrastructure.
How do I schedule a SQL report to run automatically? +
In the Query Streams web portal, create a saved query by writing your SQL and configuring any interactive filters. Then navigate to the Automation settings for that query, define a schedule (daily, weekly, monthly, or custom), and select one or more delivery destinations — such as an Airtable base, Smartsheet sheet, Baserow table, or SeaTable table. The Query Streams Agent executes the query on the defined schedule and pushes results to each configured destination automatically. Users can also pull data on demand from the Excel add-in or Google Sheets add-on at any time between scheduled runs.
Which databases does Query Streams support for scheduled automation? +
Query Streams supports Microsoft SQL Server (including Azure SQL Database), PostgreSQL (including AWS RDS, Google Cloud SQL), MySQL, MariaDB, SQLite, Microsoft Access, Oracle, Snowflake, Google BigQuery, and DuckDB. A single Agent installation can connect to multiple database engines simultaneously, and all data sources appear as a unified dropdown in the query builder. More database integrations are coming soon.
Can I sync SQL results to Airtable and Smartsheet automatically? +
Yes. Query Streams’ Automation and Integration feature supports scheduled sync to Airtable, Smartsheet, Baserow, and SeaTable. You configure the destination in the web portal — specifying which Airtable base/table or Smartsheet sheet receives the data — and set a sync schedule. The Agent executes the query and pushes results directly into the destination platform without any intermediary scripts, Zapier automations, or custom API integrations.
Does Query Streams require inbound firewall rules or VPN access? +
No. The Query Streams Agent makes outbound-only connections on standard HTTPS/WSS ports. No inbound firewall rules, no port forwarding, and no VPN tunnels are required. Your database never accepts connections from the internet. The Agent behaves like a web browser connecting to an external service — it works behind corporate firewalls, NATs, and proxy servers without any special network configuration. This makes it suitable for deployment in highly restricted enterprise environments.
Can I automate reports from SaaS platforms like Stripe and HubSpot? +
Yes, through the API Bridge. Query Streams can connect to SaaS platforms including Stripe, HubSpot, Shopify, and Google Analytics 4 and expose their data as queryable SQL tables. You write SQL against your SaaS data the same way you query a traditional database, and the results flow through the same scheduling and delivery pipeline. You can even join SaaS data with your internal database tables in a single query.
How is Query Streams different from using cron jobs or SSIS? +
Cron jobs and SSIS packages require scripting, server maintenance, and manual credential management for every automated report. Query Streams replaces the script-per-report pattern with a visual, web-based configuration: write a query, set a schedule, pick destinations. There is no crontab syntax, no Python scripts, no deployment pipelines, and no credentials stored in config files. Database passwords stay on the Agent and are never shared. Query Streams also adds built-in execution logging, multi-destination delivery from a single query, and end-user self-service from spreadsheets — capabilities that cron and SSIS do not provide out of the box.
Can multiple users refresh data at the same time? +
Yes. Query Streams supports parallel query execution. Individual users can launch multiple saved queries simultaneously into different worksheet tabs in Excel or Google Sheets, and the Agent streams each result concurrently regardless of data volume. Multiple users can also pull data from the same or different queries at the same time without queuing or blocking each other. This makes batch refresh operations fast even for large teams with many reports.
What operating systems does the Query Streams Agent support? +
The Agent is available for Windows (exe installer), Ubuntu/Debian Linux (deb package), any Linux distribution (tar.gz archive), and macOS for both Intel and Apple Silicon. You can deploy agents on-premises, in AWS EC2, Azure VMs, Google Cloud, or any other environment. Multiple agents per account are supported based on your subscription tier, and all agents self-maintain with automatic updates. Download the Agent to get started.
Is database automation with Query Streams free to try? +
Yes. Query Streams offers a free tier that lets you deploy an Agent, connect data sources, build saved queries, and use the Excel and Google Sheets integrations. You can sign up for free and start automating data delivery without entering a credit card. Paid plans unlock additional features including more agents, more users, advanced scheduling, and expanded sync destinations.

Get Started

Automate Your Database Reports in Minutes

Deploy a secure Agent, schedule your first SQL report, and let Query Streams deliver fresh data to Excel, Google Sheets, Airtable, and more — automatically, on the schedule you define.

Sign Up Free Download Agent

Related guides: Download the Query Streams Agent | Databases in Microsoft Excel | Databases in Google Sheets | Automation and Integration | API to SQL | AI Data Analytics with Nova

Category: Articles

Tags: database automation, database automation tools, database automation software, scheduled reports, sql automation, automated data delivery, Airtable sync, data pipeline, report scheduling, query streams

Meta Description: Automate SQL reports to Excel, Sheets, Airtable and more. Schedule database queries with no ETL pipeline.

Updated on June 26, 2026
automated-reporting database-automation database-integration excel google sheets live-data query-streams scheduled-reports sql-automation

What are your Feelings

  • Happy
  • Normal
  • Sad

Powered by BetterDocs