Automate login to google and download a spreadsheet

Question

My C# application reads and processes Excel file. Recently I moved my spreadsheets to google documents. Now I need to sign in to google and access a particular link(equivalent to export) to get the exported form of the spreadsheet (xls) that my application reads.

I was wondering if there is any way to automate logging to google and getting the xls file to a particular location so that I can avoid the trouble of logging in and downloading the excel file. Any thoughts on this?

(I'm thinking of saving the google credentials and link for the xls file in an xml)

Answer 1

This link has everything you need for logging in.

Answer 2

The Google Docs API has an option to export a spreadsheet in any supported format.

GET /feeds/download/spreadsheets/Export?key=example_spreadsheet_id&fmcmd=4

fmcmd "4" exports to Microsoft Excel format (xls).

Answer 3

I think this is a duplicate of this SO question: http://stackoverflow.com/questions/725627/accessing-google-spreadsheets-with-c-using-google-data-api