I need a lightweight script that scans one master folder (and all of its sub-folders) each week, opens every Excel file it finds, reads the sales ID stored in the same cell of every workbook, and—based on that ID—pushes specific rows and columns from the file into the matching Google Sheet column. The ID-to-Sheet URL mapping can live directly in the code; no interface is necessary at this stage. Key points • Sales data only; the files all share one consistent layout. • New files arrive weekly, so the solution should let me trigger a fresh run on demand (a simple command-line call, task-scheduler job, or Apps Script time trigger is fine). • File names vary, so discovery must rely purely on folder crawling rather than naming patterns. • Only the designated rows/columns get appended; nothing else should be touched in the Google Sheet. Deliverables 1. A brief kickoff call to confirm cell addresses, target columns, and runtime environment. 2. A concise, well-commented script (Python, Google Apps Script, or a comparable tool you recommend) that: – Recursively scans the folder – Extracts the ID and maps it to the correct Google Sheet – Appends the required data without overwriting existing content 3. Basic README covering setup, authentication with the Google Sheets API, and how to run or schedule the job. Once the pilot script is proven on a handful of files, I’ll validate the results in the live Sheet and settle any final tweaks.