Custom Windows Automation Script Development
Budget: $250 – $750 USD
I’m seeking an experienced freelance developer to build a custom automation script for Windows that performs the following tasks:
• File Name Parsing:
Scan a designated folder for files with loosely defined naming conventions (e.g., "32_TexasRoadhouse_Ad_June24"). The script must extract the company name from each file name, handling various delimiters (underscores, spaces) and potential minor misspellings. Implement fuzzy matching to improve accuracy.
• Google Sheets Integration:
Connect to a specified Google Sheet using the Google Sheets API. The script should search for the extracted company name (found in Column B) and retrieve associated data (e.g., a geographical location) from the same row.
• File Operations:
Based on the retrieved geographical data, copy the original file into a designated folder corresponding to that location. After copying, search within that folder for similarly named files (for example, files starting with a numerical prefix) and display these results to the user so the user can confirm replacement of old file with new file but keeping the old file’s numerical pre-fix
• Error Handling & Logging:
Implement robust error handling (e.g., for cases when the company name cannot be confidently extracted or is not found in the Google Sheet) and logging to ensure smooth operation and easy troubleshooting.
• Platform & Delivery:
The solution should be developed in Python (or another suitable Windows scripting language), be easy to install and run on a Windows machine (command-line interface is acceptable, though a basic GUI is a plus), and include clear documentation on setup and usage.
Required Skills:
• Proficiency in Python or a similar scripting language for Windows.
• Experience with regular expressions, text parsing, and fuzzy matching (libraries such as RapidFuzz or fuzzywuzzy).
• Familiarity with Google Sheets API integration (using libraries like gspread and google-auth).
• Experience with Windows file operations (using modules like os and shutil).
• Strong error handling, logging, and documentation skills.
Budget & Timeline:
Please provide your cost estimate and an estimated timeline for developing this prototype. I’m open to quotes based on the scope described.
Additional Information:
This project is a prototype with the potential for additional features and enhancements later. For this reason I would prefer an English speaking programmer for future collaboration. If you have relevant experience in file processing automation and API integrations, please share examples of your past work.
• File Name Parsing:
Scan a designated folder for files with loosely defined naming conventions (e.g., "32_TexasRoadhouse_Ad_June24"). The script must extract the company name from each file name, handling various delimiters (underscores, spaces) and potential minor misspellings. Implement fuzzy matching to improve accuracy.
• Google Sheets Integration:
Connect to a specified Google Sheet using the Google Sheets API. The script should search for the extracted company name (found in Column B) and retrieve associated data (e.g., a geographical location) from the same row.
• File Operations:
Based on the retrieved geographical data, copy the original file into a designated folder corresponding to that location. After copying, search within that folder for similarly named files (for example, files starting with a numerical prefix) and display these results to the user so the user can confirm replacement of old file with new file but keeping the old file’s numerical pre-fix
• Error Handling & Logging:
Implement robust error handling (e.g., for cases when the company name cannot be confidently extracted or is not found in the Google Sheet) and logging to ensure smooth operation and easy troubleshooting.
• Platform & Delivery:
The solution should be developed in Python (or another suitable Windows scripting language), be easy to install and run on a Windows machine (command-line interface is acceptable, though a basic GUI is a plus), and include clear documentation on setup and usage.
Required Skills:
• Proficiency in Python or a similar scripting language for Windows.
• Experience with regular expressions, text parsing, and fuzzy matching (libraries such as RapidFuzz or fuzzywuzzy).
• Familiarity with Google Sheets API integration (using libraries like gspread and google-auth).
• Experience with Windows file operations (using modules like os and shutil).
• Strong error handling, logging, and documentation skills.
Budget & Timeline:
Please provide your cost estimate and an estimated timeline for developing this prototype. I’m open to quotes based on the scope described.
Additional Information:
This project is a prototype with the potential for additional features and enhancements later. For this reason I would prefer an English speaking programmer for future collaboration. If you have relevant experience in file processing automation and API integrations, please share examples of your past work.