I need to replace manual key-strokes with a reliable workflow that pulls data straight from my vendors’ APIs and drops it into my existing Google Sheet exactly where it belongs. I will give you the API keys, sample payloads, and a clean template sheet; your job is to build a script that authenticates, fetches the data, maps every field to the right column, and writes the records without creating duplicates. You may use Google Apps Script, Python, or any language that I can run easily on a Windows laptop or a small cloud VM. The code must be commented, handle rate-limits and retries gracefully, and keep a simple log so I can trace errors later. Deliverables • Working, well-documented source code that runs end-to-end on my sample data • A concise README covering setup, scheduling, and how to add new endpoints • One successful live test populating at least 1,000 rows with zero mismatches If this sounds like your specialty, let me know how you plan to structure the calls and safeguard data accuracy.