Web Automation
Extract SQL database records to spreadsheet automatically
5 nodes
125
83
Automatic trigger
Workflow Description
A workflow that retrieves data from Microsoft SQL Server and automatically saves it to a spreadsheet file. Eliminates manual data entry, ensures consistency, and keeps records synchronized without requiring constant oversight or repetitive transfers.
How it works
- 1.Activate the workflow manually when data extraction is needed
- 2.Query the specified SQL Server database for required records
- 3.Process and organize the retrieved data into intermediate variables
- 4.Write the final results to a spreadsheet file for storage and review
Use cases
- Export monthly sales reports from SQL databases into Excel for analysis and distribution
- Back up employee records or customer information regularly in spreadsheet format
- Generate automated billing statements or inventory lists from centralized databases
Requirements
- Valid connection credentials for the SQL Server instance
- Read access permissions to the target database tables
- Spreadsheet application (Excel or Google Sheets) configured and accessible
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Microsoft Sql
Spreadsheet File
Details
Trigger
Automatic trigger
Nodes
5
Apps
2
Views
125
Downloads
83
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (5)
When clicking "Execute Workflow"
Manual Trigger
Sticky Note1
Sticky Note
TableName
Set
LoadMSSQLData
Microsoft Sql
SaveCSV
Spreadsheet File