Find Top Keywords

• 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.

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.

1. 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.