Google Drive to Google Sheets Automation

Project overview

We are looking for a freelancer with experience in Google Sheets and Google Apps Script to help automate a data matching process.

We currently manage a large real estate dataset (5,000+ entries), where each entry must be linked to a corresponding PDF file stored in Google Drive.

The PDFs are already downloaded and named using a structured convention (based on property lot numbers).

The goal of this project is to automate the linking process between the dataset and the PDF files.

3. Scope of work

The freelancer will be required to:

Access a Google Drive folder containing thousands of PDF files
Extract:
file names
corresponding file URLs
Generate a structured mapping table:
Lot number → Google Drive link
Integrate this mapping with an existing Google Sheets dataset
Implement a solution to automatically match:
dataset lot numbers
PDF file links
Ensure the solution is:
scalable
reusable for future datasets

Optional (bonus):

Directly inject links into the main dataset (without manual formulas)
4. Deliverables
A working Google Apps Script solution
A clean mapping table (Lot → Link)
Automated or semi-automated matching system
Clear instructions on how to reuse the solution
5. Tools / sources
Google Sheets
Google Drive
Google Apps Script
6. Quality requirements
Clean and efficient code
No duplicate or incorrect mappings
Accurate matching (lot number = file name)
Solution must handle large datasets (5,000+ files)
Easy to reuse for future cities/projects

7. Timeline
Start: immediately
Estimated duration: 1–2 days
Fast delivery preferred
8. Budget
Fixed price (to be proposed)
Open to proposals based on experience
9. How to apply

Please include:

Your experience with Google Apps Script or similar automation
Examples of similar work (if available)
A brief explanation of how you would approach this task
Estimated delivery time