Script to Upload Customers, Addresses, Sales Items and Sales Invoices

Hello Gurus…
I am new to ERPNext and want to explore more on uploading customers, saleable items, and sales invoices. I understand we have a template that can be used for uploading but I want to use automatic uploading using java/python script from another database and schedule this as an automated Job to run daily. How can I achieve this ?

One way would be to export data in the correct format as a CSV, use rsync or scp to upload it to your server, use bench import to import to erpnext.

All of this can be scripted