public IEnumerable <BlogPost> GetPosts(string range = "Planned!A2:T") { var rows = _clientSheet.GetCells(range).Select(r => new GoogleSheetRow(r)); return(rows.Select(r => BuildBlogPostFromRow(r))); }
//This should be useful once we move away from the master sheet and use to push from DB to client sheets public virtual IEnumerable <BlogPost> GetPosts(string range = "Current!A2:T") { var rows = _plannedPostsSheet.GetCells(range).Pad(20).Select(r => new GoogleSheetRow(r)); return(rows.Where(r => IsSheetRowValid(r)).Select(r => MakePostFromGoogleSheetRow(r))); }