I am able to add a new sheet to an already exisiting Google Spreadsheet via the Sheets API using the code below. How do I import from a CSV to this new sheet ?
//Auth code to sheets API above this line
SheetsService sheetsService = new SheetsService(bc_init);
string spreadsheetID = "XXXXXX";
string sheetName = DateTime.Now.ToString();
var addSheetRequest = new AddSheetRequest();
addSheetRequest.Properties = new SheetProperties();
addSheetRequest.Properties.Title = sheetName;
BatchUpdateSpreadsheetRequest batchUpdateSpreadsheetRequest = new BatchUpdateSpreadsheetRequest();
batchUpdateSpreadsheetRequest.Requests = new List<Request>();
batchUpdateSpreadsheetRequest.Requests.Add(new Request
{
AddSheet = addSheetRequest
});
var batchUpdateRequest = sheetsService.Spreadsheets.BatchUpdate(batchUpdateSpreadsheetRequest, spreadsheetID);
batchUpdateRequest.Execute();