Automation has revolutionised the way businesses operate, offering new avenues for growth and enhancing performance marketing strategies. By automating repetitive tasks, companies can focus on more strategic activities that drive success.
Recently, a client approached us with a unique challenge, they needed detailed information on hospitals in Delhi, specifically starting from the third page of Google search results. This data was crucial for their performance marketing efforts. To address this challenge efficiently, we turned to ZeroWork, a platform designed to streamline such tasks through automation.
The Challenge: Efficiently Collecting Hospital Information
Our goal was to gather detailed information about the best hospitals in Delhi, a task that would typically require hours of manual browsing and data entry.
Traditionally, this process would involve searching for hospitals online, visiting individual websites, and manually copying relevant information into a database. Not only is this method time-consuming, but it’s also prone to human error.
Building the First Taskbot: Scraping Hospital Links
To kick off the project, we built our first taskbot in ZeroWork. The bot was designed to search for “best hospitals in Delhi” on Google and then directly navigate to the third page of search results. From there, the bot automatically extracted the hospital website links listed on this page and the subsequent four pages, making a total of five pages of links.
This process, known as web scraping, allowed us to quickly gather a comprehensive list of hospital websites without any manual intervention. The collected links were then stored in an inbuilt table within ZeroWork, ready for further use.
First Taskbot scraping hospital website links from Google and storing those links in the data table. The taskbot goes through 5 pages and extracts links present on google search results. The small blocks are called building blocks
Building the Second Taskbot: Extracting Contact Emails
With the hospital links securely stored in our ZeroWork table, the next step was to extract contact emails from each website. To accomplish this, we created a second taskbot.
This bot was programmed to open each stored link, navigate through the website, and search for an email address using specific keywords. Once the bot identified an email address, it automatically added it to the table under a newly created column labelled “Email.”
Second Taskbot extracting hospital emails by opening each hospital link stored in the data table column “Hospital Links”. The taskbot opens each link, and then extracts emails, and finally saves those emails in another column named “Email” in the data table.
The Power of Automation
The use of these two taskbot demonstrated the power of automation in handling tasks that would otherwise require significant manual effort.
By leveraging ZeroWork, we were able to streamline the process of gathering hospital data and extracting contact information. What would have taken several hours—or even days—was completed in a fraction of the time, with minimal oversight required.
Conclusion: ZeroWork’s Potential in Business Automation
Through the use of ZeroWork, we were able to efficiently gather and organise the hospital data our client needed, ultimately resolving their problem and empowering their marketing efforts. Automation not only saved time but also provided accurate and comprehensive data that played a key role in supporting the client’s growth strategy.
The ability to build task bots that can perform complex tasks like web scraping and data extraction has proven to be invaluable. Not only did we save time and resources, but we also minimised the risk of errors associated with manual data entry.
Data Table: Scraped Information stored in the columns Hospital Links and Emails in the data table
Live running report of our task bots seen through this “Running Task Bots” window. The above window shows the error messages and warnings as well.