I have a research spreadsheet in Google Sheets that must stay current with key property information pulled from real-estate websites and government databases. Each day the sheet should automatically retrieve fresh data, place it in the correct columns, and overwrite or append intelligently so I never have to touch the raw numbers again. The script needs to capture many fields—property address, price, property type etc—then tidy and standardize that information before it lands in the workbook. If an API is available you can tap into it; otherwise, scraping routines that respect site policies will work. Google Apps Script is the natural home for this, though a lightweight external service that writes back to the sheet over the API is fine if you prefer. Clean code, clear comments, and graceful error handling are essential so I can maintain or extend the workflow later. Deliverables • A working automation (Apps Script or API integration) that runs daily on a time-based trigger • A neatly organised sheet with address, price, property-type and others columns populated from multiple sources • Inline documentation plus a short read-me explaining setup, triggers, and how to add new sources in the future I’ll test the solution on my own spreadsheet; payment releases once the daily run completes successfully and the data appears exactly where expected.