CSV Subscriber Data Processor and Google Sheets Updater

This n8n workflow automates the processing of CSV files containing subscriber data, filters for active subscribers, removes duplicates, sorts by subscription date, and updates a Google Sheets document with the cleaned data. Triggered manually for flexible execution, this workflow is useful for maintaining accurate, up-to-date subscriber lists without manual intervention.

The workflow begins when the user clicks the ‘Execute Workflow’ button, initiating the process. It reads CSV files from the local directory, splits the files into individual records for efficient processing, and reads each CSV’s content with proper headers. It then removes duplicate entries based on the ‘user_name’ field to ensure data integrity.

Next, the workflow filters the data to keep only subscribers who are marked as ‘TRUE’ under the ‘subscribed’ field. It sorts these subscribers by their subscription date to maintain chronological order. Before updating the Google Sheet, it assigns the file name for tracking purposes. Finally, it appends or updates the subscriber data in a specified Google Sheets document, ensuring your subscriber list remains current and organized.

This workflow is ideal for newsletter management, membership sites, or any scenario where periodical updates of subscription data are needed efficiently and accurately.