Import multiple CSV to GoogleSheet

This workflow is ideal for:

• Marketing Teams: Looking to consolidate subscriber data from multiple CSV files into a single Google Sheet for analysis and campaign management.
• Data Analysts: Who need to clean, filter, and organize data efficiently to derive insights.
• Small Business Owners: Seeking an automated solution to manage customer subscriptions without manual data entry.
• Developers: Interested in automating data processing tasks via n8n and integrating with Google Sheets.

This workflow addresses the following issues:

• Data Duplication: It removes duplicate entries based on user names to ensure unique subscriber records.
• Data Filtering: It filters out only those users who are subscribed, allowing for targeted marketing efforts.
• Data Organization: It sorts subscribers by their subscription date, making it easier to analyze trends over time.
• Manual Data Entry: Automates the process of importing multiple CSV files into Google Sheets, reducing human error and saving time.

Workflow Process Overview:

1. Manual Trigger: The workflow starts when the user clicks "Execute Workflow."
2. Read Binary Files: It reads all CSV files located in the .n8n directory.
3. Split In Batches: The workflow processes each file one at a time, allowing for controlled handling of data.
4. Read CSV: Each CSV file is read into the workflow for further processing.
5. Assign Source File Name: The name of the source file is assigned to the data for reference.
6. Remove Duplicates: Duplicate entries based on the user_name field are removed to maintain data integrity.
7. Keep Only Subscribers: Filters the data to retain only those entries where the subscription status is TRUE.
8. Sort by Date: The remaining records are sorted by the date_subscribed field for better organization.
9. Upload to Spreadsheet: Finally, the cleaned and sorted data is appended to a designated Google Sheet.