Clean and publish Google Sheets data across social platforms
Workflow Description
An advanced workflow that receives data, removes duplicates, splits into batches, processes them programmatically, and automatically publishes to social media. Includes manual control options and error handling throughout.
How it works
- 1.Receive data through manual trigger or external workflow execution
- 2.Remove duplicate rows from the incoming dataset
- 3.Split the cleaned data into manageable batches for processing
- 4.Apply custom code logic, filtering, and conditional operations on each batch
- 5.Aggregate results and upload final data to Google Sheets automatically
- 6.Publish processed content to Twitter/X accounts in scheduled intervals
Use cases
- Dedup email lists and sync clean data to Google Sheets before sending campaigns
- Import and normalize sales data from multiple sources then update tracking sheets
- Auto-publish promotional announcements to social media based on updated sheet values
- Process customer feedback forms and categorize responses into organized spreadsheets
Requirements
- Google Workspace account with write permissions to Google Sheets
- Twitter/X API credentials configured for automated posting
- Basic understanding of data formats, JSON structure, and API responses
- Regular monitoring of execution logs to ensure data integrity and delivery
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Details
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 (26)
Remove Duplicate URLs
Remove Duplicates
Loop over queries
Split In Batches
Search Google Maps with query
HTTP Request
Scrape URLs from results
Code
Filter irrelevant URLs
Filter
Request web page for URL
HTTP Request
Loop over URLs
Split In Batches
Loop over pages
Split In Batches
Scrape emails from page
Code
Aggregate arrays of emails
Aggregate
Split out into default data structure
Split Out
Remove duplicate emails
Remove Duplicates
Filter irrelevant emails
Filter
Save emails to Google Sheet
Google Sheets
Starts scraper workflow
Execute Workflow Trigger
Run workflow
Manual Trigger
Wait between executions
Wait
Execute scraper for query
Execute Workflow
Sticky Note
Sticky Note
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note
Sticky Note4
Sticky Note
Sticky Note5
Sticky Note
Sticky Note6
Sticky Note
Sticky Note7
Sticky Note
Sticky Note8
Sticky Note