Find Top Keywords - N8N Workflow Directory

Target Audience

Digital Marketers: Professionals looking to optimize keyword strategies for Google and YouTube searches.
- Content Creators: Individuals seeking to enhance their visibility on search engines and video platforms.
- SEO Specialists: Experts aiming to analyze search volume and competition for targeted keywords.
- Businesses: Companies wanting to leverage keyword data to improve online presence and drive traffic to their websites.

Problem Solved

This workflow automates the process of gathering, analyzing, and updating keyword data from various sources, including Google and YouTube. It effectively addresses the challenges of:
- Time Consumption: Reduces the manual effort involved in keyword research and data entry.
- Data Accuracy: Ensures that the keyword data is up-to-date and relevant by regularly querying APIs.
- Market Insights: Provides insights into search volume and competition, enabling informed decision-making for marketing strategies.

Workflow Steps

Trigger: The workflow is initiated either on a schedule (every 4 hours) or manually through a test trigger.
2. Date Generation: It calculates the previous day's date for time-sensitive queries.
3. Keyword Retrieval: Fetches base keywords from NocoDB, a database service.
4. Autocomplete Queries: Sends requests to specific APIs to retrieve second-order keywords for both Google and YouTube based on the base keywords.
5. Search Volume Analysis: Queries APIs to obtain search volume data for the retrieved keywords.
6. Data Filtering: Filters out keywords based on certain criteria (e.g., existence of search volume, CPC values).
7. Data Storage: Adds or updates keyword data in NocoDB, ensuring all information is organized and accessible for future use.
8. Bulk Import: Imports monthly search volume data in batches to optimize database performance and avoid API limits.

Customization Guide

To customize this workflow:
- Adjust Scheduling: Modify the cron expression in the Schedule Trigger node to change how often the workflow runs.
- Change Data Sources: Update the NocoDB table IDs and API endpoints if you want to pull data from different sources or tables.
- Modify Filters: Edit the filter conditions based on your specific requirements for keyword performance metrics.
- Add Additional Nodes: Incorporate more nodes for extra functionality, such as additional data analysis or reporting features, depending on your needs.