Developer & DevOps
Automate Google Sheets
6 nodes
199
102
Automatic trigger
Workflow Description
Automation template that monitors Google Sheets for new entries and automatically removes duplicate rows from incoming data, with conditional logic and HTTP request capabilities for external service integration.
How it works
- 1.Monitor Google Sheets for new or updated rows
- 2.Identify and remove duplicate entries from the dataset
- 3.Apply conditional logic to filter and control data flow
- 4.Send cleaned data to external APIs via HTTP requests
Use cases
- Clean customer or email lists by removing duplicates automatically
- Sync deduplicated data with external CRM platforms or databases in real-time
Requirements
- Active Google account with Google Sheets access permissions
- Endpoint URLs for external systems that will receive the processed data
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Google Sheets
Remove Duplicates
Details
Trigger
Automatic trigger
Nodes
6
Apps
2
Views
199
Downloads
102
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (6)
Google Sheets Trigger
Google Sheets Trigger
Remove Duplicates
Remove Duplicates
Verify your emails
HTTP Request
Sticky Note
Sticky Note
Update data to google sheets
Google Sheets
If Email Exists
If