Add Support for working with Google Sheets

[henryrizzi]

It would be really nice to be able to be able to import and export data Google Sheets directly from petl.
The only complication this would bring into grabbing and exporting data would be that you have to set up credentials through Google's API console.

This is described in the gspread docs within the oauth2 portion.

I implemented a version of this which is very similar to petl.io.xlsx, but I thought it would be good to check that this was a desired feature before putting in a pull request.

Does anyone have any thoughts?
Would this be better in petlx rather than petl even though it's less experimental?

[alimanfoo]

Hi Henry, This sounds like a very nice petl feature to me, happy to review a PR. Thanks, Alistair

…

On Wednesday, January 11, 2017, Henry Rizzi ***@***.***> wrote: It would be really nice to be able to be able to import and export data Google Sheets directly from petl. The only complication this would bring into grabbing and exporting data would be that you have to set up credentials through Google's API console. This is described in the gspread <https://github.com/burnash/gspread> docs within the oauth2 portion <http://gspread.readthedocs.io/en/latest/oauth2.html>. I implemented a version of this which is very similar to petl.io.xlsx, but I thought it would be good to check that this was a desired feature before putting in a pull request. Does anyone have any thoughts? Would this be better in petlx <https://github.com/alimanfoo/petlx> rather than petl even though it's less experimental? — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#404>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAq8QnbzFhx7PeyzBD4uytyEGcZHas6xks5rRWOrgaJpZM4LhMPk> .

-- Alistair Miles Head of Epidemiological Informatics Centre for Genomics and Global Health <http://cggh.org> The Wellcome Trust Centre for Human Genetics Roosevelt Drive Oxford OX3 7BN United Kingdom Email: alimanfoo@googlemail.com Web: http://purl.org/net/aliman Twitter: https://twitter.com/alimanfoo Tel: +44 (0)1865 287721