NO PLACEHOLDER BIDS ---------- READ THE PROJECT REQUIREMENT CAREFULLY. SEE THE MOCKUP OF THE FRONT END REQUIREMENT, IN THE FILES SECTION OF THIS PROJECT. You will need to demonstrate that your script is working on your server. Once approved, you will then upload to our server for final deployment -------- I’m looking to add a lightweight, server-hosted scraper that lets me type a keyword (e.g., “lawyers”) and a city, rely on Google Autocomplete for the final query, and then pull back the first-page business results. Core workflow • Front end: match the attached mock-up—two input fields (keyword + city) and a “Run” button. • Scraping: hit Google Search, respect reasonable delays, capture each result’s URL, business name, email address, phone number, mailing address, and any social-media link that appears on the page. • Storage: write everything to our MySQL database. • Data quality: run only basic validation—remove obvious duplicates, trim whitespace, keep field formats consistent. • Export: one-click download to XLS or CSV. • Deployment: install on our Linux server and document the steps so I can redeploy if needed. Preferred stack Python with BeautifulSoup, Scrapy, or Selenium is fine, as long as it’s cleanly modular. Use pandas or a similar library for the export. Deliverables 1. Source code and requirements.txt (or equivalent). 2. SQL script to create/update the necessary tables. 3. README covering setup, cron scheduling, and how to adjust throttling. 4. Working front-end files matching the mock-up. Keep it simple, reliable, and ready to run on our own hardware.