Read and Process CSV Files to Google Sheets
detail.loadingPreview
Reads multiple CSV files from a directory, processes them, and uploads the data to a Google Sheet.
🚀Ready to Deploy This Workflow?
About This Workflow
Overview
This workflow is designed to automate the process of ingesting data from multiple CSV files. It reads binary CSV files from a specified directory, parses their content, removes duplicate entries based on a specific field, filters for subscribed users, sorts the data by a date field, and finally appends or updates the processed data into a Google Sheet.
Key Features
- Reads multiple CSV files from a specified directory.
- Parses CSV content with options for header row and raw data.
- Removes duplicate entries based on a selected field (e.g.,
user_name). - Filters records to keep only those marked as subscribed.
- Sorts the filtered data by a date field (e.g.,
date_subscribed). - Appends or updates data into a Google Sheet with automatic column mapping.
- Includes basic error handling.
How To Use
- Configure
Read Binary Filesnode: Set thefileSelectorparameter to the path of your CSV files (e.g.,./.n8n/*.csv). - Configure
Read CSVnode: EnsurerawData,headerRow, andreadAsStringare set appropriately based on your CSV structure. - Configure
Remove duplicatesnode: Select the field (user_namein the example) to use for identifying and removing duplicates. - Configure
Keep only subscribersnode: Set the condition to filter for subscribed users (e.g.,={{ $json.subscribed }}equalsTRUE). - Configure
Sort by datenode: Specify the field (date_subscribedin the example) to sort the data by. - Configure
Upload to spreadsheetnode:- Authenticate with your Google Sheets account.
- Set the
sheetNameanddocumentIdfor your target Google Sheet. - Review and adjust the
columnsmapping if needed, especially if the incoming data fields differ from the target sheet.
- Execute the workflow manually or via a trigger.
Apps Used
Workflow JSON
{
"id": "b7c6c05e-3587-4b3e-9c10-7e8ac72da55d",
"name": "Read and Process CSV Files to Google Sheets",
"nodes": 0,
"category": "Readbinaryfiles",
"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: b7c6c05e-3587...
About the Author
SaaS_Connector
Integration Guru
Connecting CRM, Notion, and Slack to automate your life.
Statistics
Verification Info
Related Integrations
- Google Sheets + Schedule Trigger(394 workflows)
- Google Sheets + Split Out(277 workflows)
- Google Sheets + Slack(268 workflows)
- Gmail + Google Sheets(245 workflows)
- Google Drive + Google Sheets(203 workflows)
- Form Trigger + Google Sheets(163 workflows)
- Google Drive + Google Drive Trigger(135 workflows)
- Google Drive + Split Out(134 workflows)
- Google Sheets + Telegram(118 workflows)
- Execute Workflow Trigger + Google Sheets(101 workflows)
Related Workflows
Discover more workflows you might like
Automate Competitor Tracking with Crunchbase & ClickUp
Streamline competitor analysis by automatically fetching data from Crunchbase and creating review tasks in ClickUp. Stay informed about market changes without manual effort.
Telegram Profanity & Toxicity Filter
This n8n workflow automatically monitors incoming Telegram messages for profanity and toxic language. It leverages Google's Perspective API to analyze message content, and if a message is deemed inappropriate, the workflow sends an automated warning response back to the sender.
Automate Shipment Tracking with Telegram and n8n
Streamline your logistics operations by automating shipment tracking with Telegram and n8n. This workflow allows drivers to easily share updates, and ensures timely notifications to your team.
Automated Multi-Platform Social Media Publisher
Streamline your social media content creation and publishing with this n8n workflow. Simply fill out a web form with your caption, media (image or video), and target platforms, and let n8n automate the posting process across multiple social networks.
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.
Automate DOCX to PDF Conversion and Save Locally
This workflow automates the process of converting a Microsoft Word DOCX file to a PDF document. It downloads a source DOCX file, uses ConvertAPI to perform the conversion, and then saves the resulting PDF file directly to your local disk.