Automate Excel Square Footage Lookup

In my workbook I type U.S. property addresses by hand—one per row—and I’d like the square-footage field to populate automatically in the next column. The data can come from Gemini (Google’s AI) pulling whatever public source it trusts; I just need the entire process wrapped in a single click inside Excel.

Here’s the flow I picture: I enter or paste an address, trigger the macro/add-in, Gemini or any free service fetches the living-area figure from the internet, the script parses the answer down to a clean number, and that number lands in the neighboring cell. If a property can’t be found, the cell should return a clear “Not available” message rather than an error.

Deliverables
• A working VBA, Python-xlwings, or Power Query solution embedded in the file (your choice, as long as it runs locally in Excel for Windows).
• Any supporting API keys or prompts for Gemini, stored so I can swap credentials without touching the code.
• A brief read-me sheet in the workbook explaining setup, buttons, and trouble-shooting.

Acceptance criteria
• Address in A2 → square footage appears in B2 within a few seconds.
• Empty or malformed addresses are skipped gracefully.
• I can point the code at a different worksheet and it still functions after I adjust the range constants.

I’m flexible on the exact technical stack as long as it keeps everything inside Excel, works with manually entered addresses, and lets me reformat the address cell structure if needed.