Automatically create sales invoices

Hi all,

Is there a way in Sage50Cloud to automatically create sales invoices based on a spreadsheet/csv file?

I want to be able to use import/macros/python etc to produce a physical invoice via Customers->Invoices and Credits (not simply importing the data to create a record on the customers account). 

Is this technically possible?  Does Sage allow macros?  Or can python link into Sage?    Or a third party app?

Any help greatly appreciated!

Many thanks

Paul