Effortlessly Import and Manage Multiple CSVs to Google Sheets
detail.loadingPreview
Automate the process of importing multiple CSV files into a single Google Sheet. This workflow cleans, filters, and organizes your data for seamless integration and analysis.
About This Workflow
Streamline your data ingestion with this powerful n8n workflow designed to handle multiple CSV files. It begins by triggering the workflow and reading all CSV files from a specified directory. Each file is then processed individually, ensuring data integrity through duplicate removal based on user names and filtering for only subscribed users. The data is then sorted chronologically by subscription date before being efficiently appended or updated into your designated Google Sheet. This automated solution saves valuable time and reduces manual data entry errors, allowing you to focus on deriving insights from your clean, organized data.
Key Features
- Multi-File CSV Import: Automatically processes an entire directory of CSV files.
- Data Cleaning & Deduplication: Removes duplicate entries based on specified fields (e.g., 'user_name').
- Smart Filtering: Isolates relevant data by keeping only subscribed users.
- Chronological Sorting: Organizes your data by date for better trend analysis.
- Seamless Google Sheets Integration: Appends or updates data directly into your Google Sheet.
How To Use
- Trigger: Manually execute the workflow by clicking "Execute Workflow."
- File Discovery: The "Read Binary Files" node will automatically locate all CSV files in the specified directory (defaulting to
./.n8n/*.csv). - Batch Processing: The "Split In Batches" node processes each CSV file individually.
- CSV Parsing: The "Read CSV" node converts the binary file content into structured data.
- Source File Identification: The "Assign source file name" node captures the name of the original CSV file for context.
- Deduplication: The "Remove duplicates" node eliminates redundant entries based on the 'user_name' field.
- Subscriber Filtering: The "Keep only subscribers" node filters the data to include only users marked as subscribed.
- Data Sorting: The "Sort by date" node arranges the filtered data chronologically by 'date_subscribed'.
- Google Sheets Upload: The "Upload to spreadsheet" node appends or updates the processed data into your specified Google Sheet, using 'user_name' for matching.
Apps Used
Workflow JSON
{
"id": "97a479f5-097e-403f-b1d6-f4c5a45d3e4b",
"name": "Effortlessly Import and Manage Multiple CSVs to Google Sheets",
"nodes": 13,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 97a479f5-097e...
About the Author
SaaS_Connector
Integration Guru
Connecting CRM, Notion, and Slack to automate your life.
Statistics
Related Workflows
Discover more workflows you might like
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.