An integrated automation suite built with n8n that streamlines marketing intelligence workflows through API-driven data gathering, processing, and analysis. The system connects SEO, social, and web search data sources with real-time analytics pipelines to power content and keyword strategy
SEO Keyword Research Automation
Developed a dynamic SEO research workflow leveraging DataForSEO API to extract and analyze keyword data by location.
- Fetches keyword lists, related searches, and topic clusters by region
- Performs SERP analysis and retrieves average search volumes and CPC data
- Automates data storage and reporting via synchronized Google Sheets integration
Reddit Forum Insights Scraper
Built a Reddit monitoring tool using Apify APIs to collect trending or “hot” posts from targeted subreddits.
- Stores forum insights in Google Sheets for content ideation and sentiment tracking
- Automates periodic data extraction by subreddit
Google Search Results Analyzer
Implemented an automated Google Search scraper via RapidAPI, enhanced with LLM-powered content analysis.
- Fetches top-ranking pages for user queries
- Uses language models to categorize and rank content relevance
- Consolidates findings into Google Sheets for further review
