![]() The connection management to Google Docs is done by GoogleSpreadsheetConnection class. CSVFolderPath: Path where CSV files will be generated.UseFixedFileName: When set true, app will use name defined in section handler otherwise auto-naming will be used.ColumnSeparator: Column separator to be used in CSV file.NewLineCharacter - New line character to be used in CSV file.JsonKeyFilePath - Path of file you downloaded when creating a key under your Google service account.ApplicationName/AppClientName - Anything you want.It collects information about spreadsheet(s), sheet(s) and cell(s) to be read from Google docs.Ī short description of important settings is as follows: 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |