Developer & DevOps
Extract Keywords and Search Volumes from X Posts
11 nodes
192
99
Automatic trigger
Workflow Description
Automation that captures keywords from X posts and retrieves their monthly search volumes, then logs them automatically in a Google Sheets spreadsheet for tracking trending keywords and search opportunities across your niche.
How it works
- 1.Receive new X post as workflow trigger
- 2.Extract relevant keywords from post text
- 3.Call API endpoint to fetch monthly search volume data
- 4.Format data with timestamps and categorization tags
- 5.Append keywords and volumes to Google Sheets table
Use cases
- Monitor keyword trends in your industry or niche
- Build a searchable library for content strategy and SEO planning
Requirements
- Active X account with API access enabled
- Pre-configured Google Sheets with columns for keyword, volume, and date
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Google Sheets
Twitter/X
Details
Trigger
Automatic trigger
Nodes
11
Apps
2
Views
192
Downloads
99
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 (11)
/
Split Out
Split Out
Sticky Note
Sticky Note
Generate new keywords
HTTP Request
Edit Fields
Set
Set Keywords
Set
Upsert
Google Sheets
Trigger
Execute Workflow Trigger
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note
Sticky Note4
Sticky Note