Developer & DevOps

Clean and publish Google Sheets data across social platforms

26 nodes 303 151 Automatic trigger
Download

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. 1.Receive data through manual trigger or external workflow execution
  2. 2.Remove duplicate rows from the incoming dataset
  3. 3.Split the cleaned data into manageable batches for processing
  4. 4.Apply custom code logic, filtering, and conditional operations on each batch
  5. 5.Aggregate results and upload final data to Google Sheets automatically
  6. 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

Remove Duplicates Split In Batches Google Sheets Twitter/X

Details

Trigger Automatic trigger
Nodes 26
Apps 4
Views 303
Downloads 151

How to Use

  1. 1.Click "Download Template"
  2. 2.Open your n8n dashboard
  3. 3.Go to Workflows > Import from File
  4. 4.Select downloaded file and configure credentials

Nodes Used (26)

/

Remove Duplicate URLs

Remove Duplicates

#1

Loop over queries

Split In Batches

#2

Search Google Maps with query

HTTP Request

#3

Scrape URLs from results

Code

#4

Filter irrelevant URLs

Filter

#5

Request web page for URL

HTTP Request

#6

Loop over URLs

Split In Batches

#7

Loop over pages

Split In Batches

#8

Scrape emails from page

Code

#9

Aggregate arrays of emails

Aggregate

#10

Split out into default data structure

Split Out

#11

Remove duplicate emails

Remove Duplicates

#12

Filter irrelevant emails

Filter

#13

Save emails to Google Sheet

Google Sheets

#14

Starts scraper workflow

Execute Workflow Trigger

#15

Run workflow

Manual Trigger

#16

Wait between executions

Wait

#17

Execute scraper for query

Execute Workflow

#18

Sticky Note

Sticky Note

#19

Sticky Note2

Sticky Note

#20

Sticky Note3

Sticky Note

#21

Sticky Note4

Sticky Note

#22

Sticky Note5

Sticky Note

#23

Sticky Note6

Sticky Note

#24

Sticky Note7

Sticky Note

#25

Sticky Note8

Sticky Note

#26