The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"nodes": [
{
"id": "4e670880-61cf-4870-8d29-525f4e677162",
"name": "When clicking \"Execute Workflow\"",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-40,
600
],
"parameters": {},
"typeVersion": 1
},
{
"id": "cd21e063-59fe-42a5-87c7-b4d63df2e2b7",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
500,
480
],
"parameters": {
"width": 682,
"height": 280,
"content": "## Save SQL table as a CSV file\n### You can send it via e-mail, upload to the file storage or download on your computer.\n### Just connect one or two extra n8n Nodes here!"
},
"typeVersion": 1
},
{
"id": "f960451e-d04e-4023-aed2-e039898b7cab",
"name": "TableName",
"type": "n8n-nodes-base.set",
"position": [
160,
600
],
"parameters": {
"values": {
"string": [
{
"name": "TableName",
"value": "SalesLT.ProductCategory"
}
]
},
"options": {}
},
"typeVersion": 1
},
{
"id": "e2b4f557-663e-4b1c-b90e-9fde44dcd63a",
"name": "LoadMSSQLData",
"type": "n8n-nodes-base.microsoftSql",
"position": [
340,
600
],
"parameters": {
"query": "=SELECT * FROM {{ $json[\"TableName\"] }}",
"operation": "executeQuery"
},
"credentials": {
"microsoftSql": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"id": "cec2452f-e3e9-47ad-bcc6-4d411b1cd532",
"name": "SaveCSV",
"type": "n8n-nodes-base.spreadsheetFile",
"position": [
760,
600
],
"parameters": {
"options": {
"fileName": "={{ $('TableName').first().json.TableName }}.{{ $parameter[\"fileFormat\"] }}"
},
"operation": "toFile",
"fileFormat": "csv"
},
"typeVersion": 1
}
],
"connections": {
"TableName": {
"main": [
[
{
"node": "LoadMSSQLData",
"type": "main",
"index": 0
}
]
]
},
"LoadMSSQLData": {
"main": [
[
{
"node": "SaveCSV",
"type": "main",
"index": 0
}
]
]
},
"When clicking \"Execute Workflow\"": {
"main": [
[
{
"node": "TableName",
"type": "main",
"index": 0
}
]
]
}
}
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
microsoftSql
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Export Sql Table Into Csv File. Uses manualTrigger, stickyNote, microsoftSql, spreadsheetFile. Event-driven trigger; 5 nodes.
Source: https://github.com/Zie619/n8n-workflows — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
This workflow demonstrates how easy it is to export SQL query to CSV automatically!
This workflow manually exports all records from a WordPress site, converts the returned JSON into a CSV file, and saves the CSV to disk on the n8n server. Starts when you manually click Execute in n8n
Push Json Data Into An App Or To Spreadsheet File. Uses httpRequest, spreadsheetFile, stickyNote, manualTrigger. Event-driven trigger; 8 nodes.
This workflow template shows how to load JSON data into a workflow and push that data into an App or convert it into a Spreadsheet file.
Typeform Spreadsheetfile. Uses typeformTrigger, nextCloud, spreadsheetFile. Event-driven trigger; 6 nodes.