AI / Automation Engineer for Architecture Firm Data Enrichment (Google Sheets + Web Scraping + APIs)
Job Description: We are looking for an experienced developer or AI automation specialist to help us build a scalable solution for enriching and verifying data of architecture firms worldwide. We already have a large dataset (stored in Google Sheets) and partial infrastructure set up, including: Google Sheets (data source) JavaScript-based scripts Google Cloud API Programmable Search Engine (Google CSE) However, our current implementation has not yet achieved reliable results. We are seeking someone who can either help us fix and complete the existing system or propose a more effective AI-driven approach. Scope of Work: Your task will be to design and/or implement an automated workflow that can: Find and fill in missing official websites for architecture firms Verify and correct existing website URLs Identify and fill in company location (country/city) Count the number of architectural projects listed on the official website Technical Requirements: Strong experience with web scraping and automation Experience with Google Sheets API / Apps Script Familiarity with Google Cloud services Experience using search APIs (e.g., Google Programmable Search Engine or alternatives) Knowledge of AI tools (LLMs, agents, or scraping + parsing pipelines) Ability to handle large-scale datasets efficiently Nice to Have: Experience with tools like Puppeteer, Playwright, or Selenium Experience with AI-based extraction (e.g., using GPT or similar models for parsing websites) Prior experience working with business directory or enrichment data Ability to suggest improved architecture (e.g., hybrid scraping + AI validation pipeline) Deliverables: A working automated system (or improved version of our current one) Clean and structured output written back into Google Sheets Documentation of the workflow and setup What We’re Looking For: Someone who can not only implement but also propose better solutions Strong problem-solving skills Clear communication and ability to iterate quickly To Apply: Please include: A brief explanation of how you would approach this problem Relevant past projects (especially involving scraping, AI, or data pipelines) Your suggested tech stack (if different from ours) We are open to both short-term consulting and longer-term collaboration depending on results. Looking forward to working with you!