Automation

Your Excel KPI Dashboards, updated automatically

Connect your MCP to external sources, set a schedule, and let Viete generate or update your Excel models automatically. No manual work required.

Connects to your systems via MCP

Microsoft 365SalesforceGoogle SheetsStripeSAPOracle NetSuiteSnowflakeHubSpotPostgreSQLNotionMicrosoft 365SalesforceGoogle SheetsStripeSAPOracle NetSuiteSnowflakeHubSpotPostgreSQLNotion

Step 1

Choose your automation type

Create a brand-new Excel workbook on every run, or update an existing one with fresh data. Two fundamentally different approaches — pick the one that fits your process.

Choose Automation Type

Automate Excel Model Creation

Creates a completely new workbook each time the automation runs.

Automate Excel Model Update

Updates an existing workbook with new or refreshed data.

How should data be updated?

Replace existing data

Overwrites data in the model each time the automation runs.

Example: Monthly reports where current data replaces previous month.

Add updated data

Adds new data to the model, building on previous data.

Example: Budget model that appends new actuals at regular intervals.

Step 2

Replace or append

When updating an existing workbook, choose whether to overwrite the data entirely or add new rows on top of what's already there. Build growing datasets or keep dashboards current.

Step 3

Configure and schedule

Give it a title, write a prompt, optionally attach a template and style, connect your data sources, and set the schedule. That's the entire setup.

Create New Automation

Model Creation — New session each run

Weekly Sales Report
Fetch this week's sales data from Salesforce. Create a summary with total revenue, top 10 deals, and a breakdown by region. Include a chart comparing this week to last week.

Click to upload Excel file (.xlsx)

Select template
Select style
Select connectors

Schedule

Weekly
08:00
2026-02-17
CancelCreate Automation

Then it just runs

On schedule

Hourly, daily, weekly, or monthly. Your automation fetches live data and generates or updates the Excel model exactly when you need it.

Every run is saved

Each run creates a session you can go back to. Preview the output, download it, or continue editing in Viete.

Full control

Pause, resume, or edit your automation anytime. Monitor everything from the automation dashboard.

Or save any session as an automation

Already built something great in Viete? Turn it into an automation with one click. The prompt, template, and style carry over — just add a schedule.

Save as Automation

Automate Excel Model Creation

Creates a completely new workbook each time the automation runs.

Example: Automatically fetch new data from a data source every morning to generate fresh analysis reports.

Automate Excel Model Update

Updates this workbook with new or refreshed data.

Example: Refresh KPI dashboard regularly with updated metrics from connected data sources.

What teams automate

Any recurring Excel task where the data source is predictable.

Financial reporting

Pull actuals vs budget from your ERP and generate a board-ready financial pack. Updated automatically before every deadline.

CRM dashboards

Pipeline data from Salesforce or HubSpot, transformed into KPI dashboards in Excel. Refreshed daily.

Operational tracking

Inventory levels, order status, logistics data — appended to a growing workbook with each run.

Database reports

Query PostgreSQL, Snowflake, or any SQL database and transform results into formatted Excel. Scheduled exactly when you need them.

Automation vs Workflows

Both use the same AI agent. The difference is how you trigger them.

AutomationWorkflows
TriggerRuns on a scheduleYou click run
InputData from connected systemsFiles you upload
Best forRecurring reports, live dataVariable inputs, file processing
Manual effortNone after setupUpload + click per run

See it in action

Book a demo to see how automation can eliminate your team's manual Excel work.