Drive Images to Sheet Sync

I am looking for a small, well-documented script that will scan a chosen folder in my Google Drive, collect the image URLs it finds, and push each URL into the right row and column of an existing data table. The table might live in Google Sheets, a CSV, or an Excel workbook—so the script should let me point to whichever file I need at run time. Matching will be done based on a Keyfield that will be specified

Core flow
• Read every file name (or other key that I specify) inside the target Drive folder.
• Open the data table, locate the correct tab if it is a multi-sheet workbook, and search a chosen key column.
• When the key matches, write the image URL into a column for matched row
• Provide simple settings—folder name, sheet or file name, tab, key column, and destination column—right at the top of the script so I can change them without touching the logic.

Must-haves
• Google Drive API or Apps Script familiarity for reliable file discovery.
• Clean, readable code with inline comments explaining each step.
• A quick test log or sample run that proves:
– existing rows are updated,
– non-matching rows remain untouched,
– the script exits gracefully if no image is found.
• Delivery as a single script file plus a short read-me on how to authorize and execute.

I am happy with Python, Apps Script, or another lightweight approach—choose the tool you are fastest with, just make sure it works cross-platform. Better if script can be excuted from within google drive

We are looking at quotes from INR 300/- to INR 600/=