n8n Operations Pack (MySQL) — 8 Workflows
Automate SQL data exports and Snowflake CSV loads with 8 n8n workflows
What This Pack Does
This pack of 8 n8n workflows automates data extraction, transformation, and loading between SQL databases (MySQL, PostgreSQL, Snowflake) and spreadsheet formats (CSV, Excel, Google Sheets). Workflows 1 and 6 load CSV data into Snowflake from web sources. Workflows 2, 3, 4, 5, and 7 export SQL table data to CSV or Excel files, with manual triggers for on-demand execution. Workflow 8 collects user data from an external API and stores it in Google Sheets. Together, these workflows streamline routine data operations by connecting databases, HTTP endpoints, and spreadsheet tools, reducing manual data handling and enabling repeatable, scheduled or triggered data transfers.
Who It's For
Operations analysts, database administrators, and data engineers who regularly move data between SQL databases and spreadsheet tools. Also suitable for teams that need to generate periodic reports from MySQL or PostgreSQL tables, or load external CSV data into Snowflake without writing custom scripts.
Highlights
- Export SQL tables to CSV or Excel with manual triggers
- Load CSV data into Snowflake from web sources
- Convert PostgreSQL tables to CSV files
- Automate API data collection into Google Sheets
- Map database columns before data insertion
- 8 workflows covering SQL, Snowflake, and spreadsheets
Included Workflows(8)
Example Use Case
Imagine a data analyst needs to generate a weekly sales report from a MySQL database. They use Workflow 2 to export the sales table to CSV, then Workflow 3 to convert the same data into an Excel spreadsheet for stakeholders. Meanwhile, the team receives a daily CSV file from a partner; Workflow 1 automatically downloads and inserts it into Snowflake. Later, they use Workflow 8 to pull updated user profiles from an API into Google Sheets for CRM updates. All workflows run on manual triggers, giving the analyst full control over timing.
Primary Integrations
Related Packs
n8n Operations Pack — 22 Workflows
22 n8n workflows to automate operations, data, and document tasks.
n8n Operations Pack — 11 Workflows
11 n8n workflows to connect AI agents with operations tools via MCP servers.
Make Operations Pack (Slack + ClickUp) — 6 Workflows
Automate operations across ClickUp, Slack, and Microsoft Teams with 6 workflows.