Import Multiple CSVs to Google Sheets with Dedup & Filter

This workflow streamlines the process of importing data from multiple CSV files into a single Google Sheets document. It begins by reading all CSV files from a specified directory, processes them in batches, parses the content, assigns source file names, removes duplicates based on 'user_name', filters for subscribed users (subscribed=TRUE), sorts by 'date_subscribed', and finally appends new data or updates existing rows in the sheet.

Key benefits include significant time savings on manual data consolidation, ensuring data integrity through deduplication and filtering, and maintaining an up-to-date spreadsheet without overwriting unrelated data. The upsert logic intelligently handles existing records, preventing redundancy while capturing new subscriptions.

Ideal use cases: Consolidating customer subscription lists from various sources (e.g., email campaigns, forms), syncing lead data into analytics sheets, or automating reporting for marketing teams tracking user engagement across multiple CSV exports from tools like Mailchimp or event platforms.