batchGet запрос google spreadsheets api c#

Можно так (весь код приводить не буду, он стандартный):

// Define request parameters.
const string spreadsheetId = "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms";
const string range1 = "Class Data!B2:B7";
const string range2 = "Class Data!D2:E7";
SpreadsheetsResource.ValuesResource.BatchGetRequest request
  = service.Spreadsheets.Values.BatchGet(spreadsheetId);
request.Ranges = new Repeatable<string>(new[] { range1, range2 });
BatchGetValuesResponse response = request.Execute();
IList<IList<object>> values = response.ValueRanges.SelectMany(x => x.Values).ToList();

if (values != null && values.Count > 0)
{
  Console.WriteLine("Name, Major");
  foreach (var row in values)
  {
    if (row.Count > 1)
      Console.WriteLine("{0} {1}", row[0], row[1]);
    else
      Console.WriteLine("{0}", row[0]);
  }
}
else
{
  Console.WriteLine("No data found.");
}

Результат для таблицы

Будет:

Name, Major
Female
Male
Female
Female
Male
Male
CA English
SD Math
NC English
SD Art
WI English
MD Art