In this post, I’ll walk you through how I built a powerful keyword research tool for Bing using Make.com and BuildShip. This tool generates comprehensive keyword reports efficiently, allowing you to analyze multiple URLs without writing any code.
Introduction to the Tool
I created an automation that streamlines the process of generating keyword reports for Bing. This tool is designed to be efficient and user-friendly, enabling anyone to obtain comprehensive keyword data without needing technical skills. The automation leverages Make.com and BuildShip to create an effective solution that can handle a large number of URLs at once.
Bulk Functionality Overview
The bulk functionality of this tool allows it to process multiple entries simultaneously. Instead of making separate requests for each URL, it utilizes a single operation to gather data for up to a thousand rows. This capability significantly reduces the time required to generate keyword reports, making it ideal for users who need to analyze a large set of data quickly.
Adapting the Tool for Bing
Adapting the tool for Bing requires only minor adjustments. I’ve taken the foundational structure used for Google and modified it to pull data specifically from Bing’s search engine. This flexibility makes it easy to switch between different platforms without starting from scratch. The core logic remains the same, ensuring that users can generate keyword reports efficiently regardless of the search engine.
Accessing the Bing Template
To access the Bing template, navigate to the keyword research automation section in the system templates. This updated section includes the Bing-specific template, allowing users to generate reports tailored for Bing with just a few clicks. Setting it up is straightforward, requiring no coding experience at all.
Understanding the Automation Process
The automation process begins by monitoring new entries in a Google Sheet. When a new URL is added, the tool triggers a series of actions to extract relevant keywords. Users specify the number of desired results and the maximum position for those keywords, focusing on those ranked in the top ten. This ensures that the data collected is both relevant and high-quality.
Using BuildShip for Automation
BuildShip plays a crucial role in this automation. It acts as a low-code platform that receives calls from Make.com and processes the keyword data efficiently. I’ve created a scenario in BuildShip that pulls information from the Data for SEO API, specifically targeting the ranked keywords endpoint. This integration allows users to access rich SEO data seamlessly.
Integrating with Data for SEO
Data for SEO is a powerful tool that provides a wealth of information about keyword rankings. When setting up the automation, I configured it to call the ranked keywords API endpoint. Users can select the specific data they need, ensuring that the output is tailored to their requirements. This integration is vital for obtaining accurate and actionable keyword insights.
Constructing API Requests
I created a system that makes API requests to gather keyword data efficiently. The process starts by defining the parameters for the request, which include the root URL and various filters. I use hard-coded values for specific fields, simplifying the setup and ensuring consistency in the requests.
Once the parameters are established, I utilize a low-code platform to handle the API call. This allows for seamless integration with other tools, making it easy to pull in the data I need without excessive manual input. The API endpoint I focus on is the ranked keywords endpoint from Data for SEO, a reliable source for keyword data.
Creating Google Sheets Reports
After fetching the keyword data, I automate the creation of Google Sheets reports. I set up a module that generates a new spreadsheet for each URL processed. The title of the sheet is derived from the URL itself, providing clarity and easy identification of reports.
Once the sheet is created, it’s moved to a designated folder in Google Drive for better organization. This step ensures that all reports are stored in one place, making it easier to access and manage them later.
Making Bulk API Calls
The real power of this automation comes from making bulk API calls. Instead of sending individual requests for each row in the spreadsheet, I consolidate the data into a single API call. This drastically reduces the time it takes to gather information from multiple URLs.
By using the append method with the spreadsheet ID, I can update a large number of rows in one go. This approach not only improves efficiency but also minimizes the risk of errors that can occur with multiple separate requests.
Duplicating Scenarios for Flexibility
To enhance flexibility, I’ve duplicated scenarios within the automation workflow. This allows me to target different data sources without creating entirely new projects. For instance, I can switch between Google and Bing data sources simply by adjusting the parameters in the duplicated scenario.
This method streamlines the process, enabling me to handle various types of keyword data while maintaining a consistent structure. It’s a practical way to adapt to different needs without starting from scratch each time.
Processing URLs Quickly
Processing URLs is a swift endeavor with this automation. I can select multiple URLs from Google Sheets and run the automation with just a few clicks. The system efficiently retrieves data from BuildShip, generating keyword reports in a matter of seconds.
This speed is critical for users who need timely insights. Whether it’s a single URL or a batch of a thousand, the process remains quick and efficient, ensuring that I can analyze data without unnecessary delays.
Finalizing Reports and Merging Data
Once the data is gathered and populated in the Google Sheets, I can finalize the reports. The system allows me to include various fields, such as search volume and keyword difficulty, maintaining a consistent format across all reports.
The ability to merge reports together enhances the analysis capabilities. Users can compile data from different sources and obtain a comprehensive view of their keyword landscape, facilitating informed decision-making.
Accessing Automation Blueprints
For those interested in replicating this setup, accessing automation blueprints is straightforward. I’ve made these templates available, which can guide you through the process of creating similar automations tailored to your specific needs.
These blueprints serve as a foundation, allowing users to customize them further based on their requirements. With the right tools and guidance, anyone can harness the power of automation to streamline their keyword research efforts.
