How to fetch Google Spreadsheets from AppEngine

how_to_fetch_google_spreadsheets_from_appengine.py

    def fetch_csv(self, options):
        """
        Retrieves a single Google spreadsheet as CSV using ClientLogin
        authentication.

        TODO: handle retries and timeouts on auth calls
        TOOD: handle retries and timeouts on content fetching
        """
        client = gdata.docs.client.DocsClient()
        client.ClientLogin(config.USER_EMAIL, config.USER_PASSWORD, config.APP_DOMAIN)

        spreadsheets_client = gdata.spreadsheet.service.SpreadsheetsService()
        spreadsheets_client.ClientLogin(config.USER_EMAIL, config.USER_PASSWORD, config.APP_DOMAIN)

        docs_token = client.auth_token
        client.auth_token = gdata.gauth.ClientLoginToken(spreadsheets_client.GetClientLoginToken())

        return client.get_file_content(CSV_URL % options)