Automation Specialist for Apollo.io Data Scraping and Google Sheets Integration

Job Description:
We are looking for an experienced Automation Specialist skilled in either Browser Automation Studio (BAS), Microsoft Power Automate, Selenium, or other similar automation tools to help streamline our data extraction process from Apollo.io. The ideal candidate will have experience with web scraping, API integration, and automating tasks.
The project involves automating the process of logging into Apollo.io, navigating to user-provided search URLs, scraping contact data (such as names, job titles, emails), and exporting this data into Google Sheets using the Google Sheets API or another preferred method. We are open to pure coding approaches (Python, Node.js, etc.) if they offer more flexibility or performance.
Key Responsibilities:
Develop and automate a script using Browser Automation Studio (BAS), Microsoft Power Automate, or custom coding solutions.
Automate the login process to Apollo.io and navigate to specific user-provided URLs.
Scrape contact data (names, job titles, emails, companies) and handle dynamic web elements.
Ensure the automation handles pagination to scrape all available contact data from multiple pages if necessary.
Integrate scraped data with Google Sheets using the Google Sheets API or another method, ensuring the data is appended in a structured manner.
Build the automation in a way that it can be easily updated to handle changes in Apollo’s interface.
Ensure the solution can handle different lists and search URLs reliably.
Skills & Experience:
Proven experience with one or more of the following:
Browser Automation Studio (BAS)
Microsoft Power Automate
Selenium (or other browser automation frameworks)
Custom automation solutions using Python, Node.js, or other programming languages.
Experience with web scraping and handling dynamic HTML content using CSS selectors or XPath.
API integration experience, particularly with Google Sheets API (or other similar platforms).
Familiarity with OAuth2 and handling secure logins.
Ability to create robust and efficient scripts that can handle dynamic changes to websites.
Solid knowledge of JSON, HTTP requests, and API communication.
Attention to detail and ability to test, debug, and document the solution effectively.
Project Scope:
Automate the entire process of scraping contact data from user-provided Apollo.io URLs.
Export the scraped data directly into Google Sheets in a structured format.
Ensure the solution works for different list sizes and multiple pages of results.
Provide documentation or training on how to operate the automation.
Preferred Technologies:
Browser Automation Studio (BAS)
Microsoft Power Automate
Selenium or other browser automation tools
Python or Node.js for custom scripting solutions
Google Sheets API or any suitable integration solution
How to Apply:
Please share examples of similar automation projects you've completed, particularly those involving data scraping, API integrations, and the tools mentioned above. Highlight any experience with Apollo.io or similar CRM systems.
Contact: You can reach me at Upgrade to see actual info for any questions or to submit your application.