To make the application fully configurable, a section handler is written. In short, just share the spreadsheet with this email id. Each Google service account has a unique email id and make sure you allow this email to access the spreadsheet you want to access. You need to create a service account and get a JSON key file/Certificate to allow authentication. Below is a link to configure service account:
There are several ways to achieve that, I have used service account(s) for authentication.
The first thing is authentication to Google Docs. This utility connects to Google Docs based on configured settings, fetches data from spreadsheet cells and converts it to CSV file. So I created a configurable console application to accomplish the same. I got a request from my marketing department that they are collecting Google Analytics data in Google Docs (Spreadsheet) and they want it to convert this data to CSV format.
0 kommentar(er)
