Image Extraction from ftp server

I need 640 images searched and extracted from an ftp server, converted to jpg, stored into a dropbox public folder and have the link to the file recorded onto a product spreadsheet. Images are identified by their product code and stored on the ftp server under the corresponding folder. For example; Product code = 53AID28300D90. Therefore the image can be found in folder 53. The process will be as follows; 1. Identify product from spreadsheet 2. Find corresponding image in ftp folders 3. Download image from ftp 4. Convert to jpg 5. Post jpg to dropbox folder 6. Add file link to original spreadsheet I will supply; - product spreadsheet (attached) - ftp access - dropbox access I look forward to your proposals