I have been working on a tool to connect Google Spreadsheets to OpenERP's XMLRPC port. For standard jobs (like creating databases, installing modules, loading data, etc.) you only need to define what you want to do in a Google Spreadsheet. No Python or XMLRPC knowledge required.

The project is available for download from here (alpha stage still, mind you) : Google to OpenERP Data Pump

I'd be most grateful to anyone who would like to fool around with it and complain about all the stuff that's missing or poorly tested.

I have designed it so that it should be very, very easy to extend with any special functionality you might need; pull requests delightedly reviewed, of course. The downside is -- not much in the way of protections -- the code is probably way more open than a true "plugin" architecture should be. The upside is : it's only a few hundred lines of pretty obvious code. I've tried to document well too.

I hope to add a tutorial video about the pump to this channel sometime next week

There is already module, that will import csv data using detailed configuration: ea_import. Hope it helps.

Yes you could call the importer from code, but it is going to be easier to write a Python script that imports the data into the different objects. You might consider using a library like OERPLib

https://pypi.python.org/pypi/OERPLib/

it will make your job of importing data into multiple classes much easier