Hi Colin,

I had set aside today to have a look at that module for my own needs, so I have dug into your problem quite a bit...

To answer your question, Has anyone managed to get the Google Docs Templates and setup got the integration working between OpenERP 7.0 and Google drive?

Yes, I have had it working both with a private Spreadsheet I created myself, and a "Public on the Web" spreadsheet that I created from another account. After playing around with it, I'd have to say I trust the module about as far as I can spit during a root canal job.

Some things I noticed in my own experiments:

• if I have no Google Document specified at all in Google Docs Configuration -> Model configuration it'd generate a new blank word-processing document. That's valid, I suppose.

• I couldn't get it to work on a person Partner -- it threw a hysterical alert

  Integrity Error
  The operation cannot be completed, probably due to the following:
   - deletion: you may be trying to delete a record while other records still reference it
   - creation/update: a mandatory field is not correctly set
  

• it did work with a company Partner, but it tried to open a new browser tab with the URL http://erp.not4publication.com:8069/undefined which of course threw an HTTP error "404 Not Found".

I see from your bug report last January 17, that this has been a problem for you for a long time. My configuration is somewhat similar to yours, except the last item:

OpenERP Server Ubuntu 12.04.
OpenERP version Version 7.0-20130305-002149
Browser: Chrome running on *Ubuntu 12.04*
Using google apps ***NOT*** as a business account

It seems possible that the module expects to use a different URL than those of Google business accounts. May I suggest you try again with a simple personal Google account like mine (as specified in Settings -> Users -> Users -> 'Your user' -> Synchronization of course.) Also, probably, you should do it on an entirely fresh database -- yours may simply have gone nuts from too many compounded previous errors.

The fact that it works differently with Persons and Companies, suggests to me that you should test it on several different models: Partner, CRM Leads/Opps, etc.