Florida Sunbiz Daily FTP Automation

I need a small, reliable script that logs in to the public Florida Sunbiz FTP each morning, grabs the latest “Daily Datab” file, converts or stores it as-is in CSV format, and then pushes that file straight into a specific Google Drive folder. Every file has to be renamed with the date of the download so, for example, today’s run would appear as 2024-06-21.csv.

Once the upload is complete I want a brief email confirming success (or flagging any issue) sent to an address I’ll provide. No SMS or other alerts are necessary.

I’m open to Python, a lightweight bash script with cron, Google Apps Script, or another language you’re comfortable with as long as it can:
• Handle the FTP connection securely to this public endpoint
• Run automatically every 24 hours without manual intervention
• Drop the CSV into Google Drive via the Drive API with the correct filename
• Trigger the email notification

Deliverables: the fully working script, any dependency list, and concise instructions for deploying it on a Linux server (or inside Apps Script if you go that route) so I can keep it running long-term.