n8n
operations

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

Manualtrigger
Httprequest
Spreadsheetfile
Set
Snowflake
Stickynote
Microsoftsql
Mysql

Related Packs