{"id":7007,"date":"2016-05-20T12:57:13","date_gmt":"2016-05-20T03:57:13","guid":{"rendered":"http:\/\/www.ka-net.org\/blog\/?p=7007"},"modified":"2016-05-20T12:57:13","modified_gmt":"2016-05-20T03:57:13","slug":"google-sheets-api-v4%e3%81%8c%e7%99%bb%e5%a0%b4%e3%81%97%e3%81%be%e3%81%97%e3%81%9f%e3%80%82","status":"publish","type":"post","link":"https:\/\/www.ka-net.org\/blog\/?p=7007","title":{"rendered":"Google Sheets API v4\u304c\u767b\u5834\u3057\u307e\u3057\u305f\u3002"},"content":{"rendered":"<p>\u300c<a href=\"http:\/\/googleappsdeveloper.blogspot.jp\/2016\/05\/apps-dev-sheets-api.html\" title=\"Google Apps Developer Blog: New ways to keep data flowing between your apps and ours\" target=\"_blank\">Google Apps Developer Blog: New ways to keep data flowing between your apps and ours<\/a>\u300d\u306b\u3042\u308b\u901a\u308a\u3001\u65b0\u3057\u3044Google Sheets API\u300c<a href=\"https:\/\/developers.google.com\/sheets\/reference\/rest\/\" title=\"Google Sheets API  |  Sheets API  |  Google Developers\" target=\"_blank\">v4<\/a>\u300d\u304c\u767b\u5834\u3057\u307e\u3057\u305f\u3002<\/p>\n<p><iframe loading=\"lazy\" width=\"100%\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/0rpgVE_nrIk\" frameborder=\"0\" allowfullscreen><\/iframe><\/p>\n<blockquote><p>The new Sheets API gives developers programmatic access to powerful features in the Sheets web and mobile interfaces, including charts and pivot tables. For example, developers can use Sheets as part of a rich workflow that pushes data from their app into Sheets and allows users to collaborate on that data before the updated data is pulled back into the original app, removing altogether the need to copy and paste.<\/p><\/blockquote>\n<p><a href=\"http:\/\/googleappsdeveloper.blogspot.jp\/2016\/05\/apps-dev-sheets-api.html\" title=\"Google Apps Developer Blog: New ways to keep data flowing between your apps and ours\" target=\"_blank\">Google Apps Developer Blog: New ways to keep data flowing between your apps and ours<\/a> \u3088\u308a<\/p>\n<p>\u3068\u3044\u3046\u306e\u304c\u65b0\u3057\u3044API\u306e\u30dd\u30a4\u30f3\u30c8\u306e\u3088\u3046\u3067\u3059\u3002<\/p>\n<h4 class=\"style4a\">Google.Apis.Sheets.v4 Client Library<\/h4>\n<p>\u767a\u8868\u3055\u308c\u3066\u9593\u304c\u7121\u3044Sheets API v4\u3067\u3059\u304c\u3001\u3082\u3046Nuget\u3067.NET\u7528\u306e\u30e9\u30a4\u30d6\u30e9\u30ea\u304c\u516c\u958b\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n<p><strong>\u30fbNuGet Gallery | Google.Apis.Sheets.v4 Client Library<\/strong><br \/>\n<a href=\"https:\/\/www.nuget.org\/packages\/Google.Apis.Sheets.v4\/\" title=\"NuGet Gallery | Google.Apis.Sheets.v4 Client Library 1.13.0.496\" target=\"_blank\">https:\/\/www.nuget.org\/packages\/Google.Apis.Sheets.v4\/<\/a><\/p>\n<p>\u4eca\u56de\u306f\u3053\u306e\u30e9\u30a4\u30d6\u30e9\u30ea\u3092\u8a66\u3057\u3066\u307f\u3088\u3046\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">nuget install Google.Apis.Sheets.v4<\/pre>\n<h4 class=\"style4a\">\u4e0b\u6e96\u5099<\/h4>\n<p>API\u3092\u547c\u3073\u51fa\u3059\u306b\u3042\u305f\u308a\u3001\u30af\u30e9\u30a4\u30a2\u30f3\u30c8 ID\u3068\u30af\u30e9\u30a4\u30a2\u30f3\u30c8 \u30b7\u30fc\u30af\u30ec\u30c3\u30c8\u304c\u5fc5\u8981\u306b\u306a\u308b\u306e\u3067\u3001\u307e\u305a\u306f\u305d\u308c\u3089\u3092\u6e96\u5099\u3057\u307e\u3059\u3002<\/p>\n<ol>\n<li><a href=\"https:\/\/console.developers.google.com\/start\/api?id=sheets.googleapis.com\" title=\"Google API Console\" target=\"_blank\">Google API Console<\/a>\u3092\u958b\u304d\u3001Google \u30a2\u30ab\u30a6\u30f3\u30c8\u3067\u30ed\u30b0\u30a4\u30f3\u3057\u307e\u3059\u3002<\/li>\n<li>\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u767b\u9332\u753b\u9762\u304c\u8868\u793a\u3055\u308c\u305f\u3089\u300c<span style=\"color: #ff0000; font-weight: bold;\">\u65b0\u3057\u3044\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u4f5c\u6210<\/span>\u300d\u3092\u9078\u629e\u3057\u3001\u300c<span style=\"color: #ff0000; font-weight: bold;\">\u7d9a\u884c<\/span>\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/li>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Google_Sheets_API_v4_01.jpg\" alt=\"Google_Sheets_API_v4_01\" width=\"457\" height=\"363\" class=\"alignnone size-full wp-image-7008\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Google_Sheets_API_v4_01.jpg 457w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Google_Sheets_API_v4_01-300x238.jpg 300w\" sizes=\"auto, (max-width: 457px) 100vw, 457px\" \/><\/p>\n<li>API\u304c\u6709\u52b9\u5316\u3055\u308c\u307e\u3057\u305f\u753b\u9762\u304c\u8868\u793a\u3055\u308c\u305f\u3089\u300c<span style=\"color: #ff0000; font-weight: bold;\">\u8a8d\u8a3c\u60c5\u5831\u306b\u9032\u3080<\/span>\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/li>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Google_Sheets_API_v4_02.jpg\" alt=\"Google_Sheets_API_v4_02\" width=\"370\" height=\"247\" class=\"alignnone size-full wp-image-7009\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Google_Sheets_API_v4_02.jpg 370w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Google_Sheets_API_v4_02-300x200.jpg 300w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Google_Sheets_API_v4_02-220x146.jpg 220w\" sizes=\"auto, (max-width: 370px) 100vw, 370px\" \/><\/p>\n<li>\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3078\u306e\u8a8d\u8a3c\u60c5\u5831\u306e\u8ffd\u52a0\u753b\u9762\u304c\u8868\u793a\u3055\u308c\u305f\u3089\u300c<span style=\"color: #ff0000; font-weight: bold;\">\u30af\u30e9\u30a4\u30a2\u30f3\u30c8 ID<\/span>\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/li>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Google_Sheets_API_v4_03.jpg\" alt=\"Google_Sheets_API_v4_03\" width=\"742\" height=\"308\" class=\"alignnone size-full wp-image-7010\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Google_Sheets_API_v4_03.jpg 742w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Google_Sheets_API_v4_03-300x125.jpg 300w\" sizes=\"auto, (max-width: 742px) 100vw, 742px\" \/><\/p>\n<li>\u30af\u30e9\u30a4\u30a2\u30f3\u30c8 ID\u306e\u4f5c\u6210\u753b\u9762\u304c\u8868\u793a\u3055\u308c\u305f\u3089\u300c<span style=\"color: #ff0000; font-weight: bold;\">\u540c\u610f\u753b\u9762\u3092\u8a2d\u5b9a<\/span>\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/li>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Google_Sheets_API_v4_04.jpg\" alt=\"Google_Sheets_API_v4_04\" width=\"827\" height=\"278\" class=\"alignnone size-full wp-image-7011\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Google_Sheets_API_v4_04.jpg 827w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Google_Sheets_API_v4_04-300x101.jpg 300w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Google_Sheets_API_v4_04-768x258.jpg 768w\" sizes=\"auto, (max-width: 827px) 100vw, 827px\" \/><\/p>\n<li>\u8a8d\u8a3c\u60c5\u5831\u753b\u9762\u304c\u8868\u793a\u3055\u308c\u305f\u3089\u300c<span style=\"color: #ff0000; font-weight: bold;\">\u30e6\u30fc\u30b6\u30fc\u306b\u8868\u793a\u3059\u308b\u30b5\u30fc\u30d3\u30b9\u540d<\/span>\u300d\u7b49\u306e\u9805\u76ee\u3092\u5165\u529b\u3057\u3001\u300c<span style=\"color: #ff0000; font-weight: bold;\">\u4fdd\u5b58<\/span>\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/li>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Google_Sheets_API_v4_05.jpg\" alt=\"Google_Sheets_API_v4_05\" width=\"630\" height=\"510\" class=\"alignnone size-full wp-image-7012\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Google_Sheets_API_v4_05.jpg 630w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Google_Sheets_API_v4_05-300x243.jpg 300w\" sizes=\"auto, (max-width: 630px) 100vw, 630px\" \/><\/p>\n<li>\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u7a2e\u985e\u3092\u300c<span style=\"color: #ff0000; font-weight: bold;\">\u305d\u306e\u4ed6<\/span>\u300d\u306b\u3057\u3001\u540d\u524d\u3092\u5165\u529b\u3057\u305f\u5f8c\u3001\u300c<span style=\"color: #ff0000; font-weight: bold;\">\u4f5c\u6210<\/span>\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/li>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Google_Sheets_API_v4_06.jpg\" alt=\"Google_Sheets_API_v4_06\" width=\"528\" height=\"470\" class=\"alignnone size-full wp-image-7013\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Google_Sheets_API_v4_06.jpg 528w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Google_Sheets_API_v4_06-300x267.jpg 300w\" sizes=\"auto, (max-width: 528px) 100vw, 528px\" \/><\/p>\n<li>\u30af\u30e9\u30a4\u30a2\u30f3\u30c8 ID\u3068\u30af\u30e9\u30a4\u30a2\u30f3\u30c8 \u30b7\u30fc\u30af\u30ec\u30c3\u30c8\u304c\u8868\u793a\u3055\u308c\u308b\u306e\u3067\u3001\u3053\u308c\u3092\u30e1\u30e2\u5e33\u306b\u3067\u3082\u30b3\u30d4\u30fc\u3057\u3066\u304a\u304d\u307e\u3059\u3002<\/li>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Google_Sheets_API_v4_07.jpg\" alt=\"Google_Sheets_API_v4_07\" width=\"542\" height=\"214\" class=\"alignnone size-full wp-image-7014\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Google_Sheets_API_v4_07.jpg 542w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Google_Sheets_API_v4_07-300x118.jpg 300w\" sizes=\"auto, (max-width: 542px) 100vw, 542px\" \/>\n<\/ol>\n<h4 class=\"style4a\">C#\u304b\u3089\u306eAPI\u547c\u3073\u51fa\u3057<\/h4>\n<p>\u30af\u30e9\u30a4\u30a2\u30f3\u30c8 ID\u3068\u30af\u30e9\u30a4\u30a2\u30f3\u30c8 \u30b7\u30fc\u30af\u30ec\u30c3\u30c8\u3092\u53d6\u5f97\u51fa\u6765\u305f\u3089\u6e96\u5099\u5b8c\u4e86\u3001\u3055\u3063\u305d\u304f.NET\u304b\u3089Sheets API\u3092\u547c\u3073\u51fa\u3057\u3066\u307f\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n<p><span style=\"color: #ff0000; font-weight: bold;\">\u203b \u30af\u30e9\u30a4\u30a2\u30f3\u30c8 ID\u3068\u30af\u30e9\u30a4\u30a2\u30f3\u30c8 \u30b7\u30fc\u30af\u30ec\u30c3\u30c8\u3001\u30b7\u30fc\u30c8ID\u306f\u81ea\u5206\u304c\u53d6\u5f97\u3057\u305f\u3082\u306e\u306b\u7f6e\u304d\u63db\u3048\u3066\u304f\u3060\u3055\u3044\u3002<\/span><br \/>\n<span style=\"color: #ff0000; font-weight: bold;\">\u203b \u30b7\u30fc\u30c8\u306eID\u306fURL\u304b\u3089\u53d6\u5f97\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Google_Sheets_API_v4_08.jpg\" alt=\"Google_Sheets_API_v4_08\" width=\"628\" height=\"66\" class=\"alignnone size-full wp-image-7015\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Google_Sheets_API_v4_08.jpg 628w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Google_Sheets_API_v4_08-300x32.jpg 300w\" sizes=\"auto, (max-width: 628px) 100vw, 628px\" \/><\/p>\n<pre class=\"brush: csharp; title: ; notranslate\" title=\"\">\/*\r\n * \u4ee5\u4e0b\u53c2\u7167\r\n *   Google.Apis,Google.Apis.Auth,Google.Apis.Auth.PlatformServices,\r\n *   Google.Apis.Core,Google.Apis.PlatformServices,Google.Apis.Sheets.v4\r\n *\/\r\nusing System;\r\nusing System.IO;\r\nusing System.Collections.Generic;\r\nusing System.Threading;\r\nusing Google.Apis.Auth.OAuth2;\r\nusing Google.Apis.Sheets.v4;\r\nusing Google.Apis.Sheets.v4.Data;\r\nusing Google.Apis.Services;\r\nusing Google.Apis.Util.Store;\r\n\r\nnamespace SheetsApiv4Sample\r\n{\r\n  class Program\r\n  {\r\n    static string&#x5B;] Scopes = {SheetsService.Scope.SpreadsheetsReadonly};\r\n    static string ApplicationName = &quot;Google Sheets API .NET Quickstart&quot;;\r\n    static string AppClientId = &quot;(\u30af\u30e9\u30a4\u30a2\u30f3\u30c8 ID)&quot;;\r\n    static string AppClientSecret = &quot;(\u30af\u30e9\u30a4\u30a2\u30f3\u30c8 \u30b7\u30fc\u30af\u30ec\u30c3\u30c8)&quot;;\r\n    static string SpreadSheetId = &quot;(\u64cd\u4f5c\u5bfe\u8c61\u3068\u306a\u308b\u30b7\u30fc\u30c8\u306eID)&quot;;\r\n    \r\n    public static void Main(string&#x5B;] args)\r\n    {\r\n      UserCredential credential;\r\n      string credPath = System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal);\r\n      credPath = Path.Combine(credPath, &quot;.credentials\/sheets.googleapis.com-dotnet-quickstart.json&quot;);\r\n      credential = GoogleWebAuthorizationBroker.AuthorizeAsync(\r\n        new ClientSecrets\r\n        {\r\n          ClientId = AppClientId,\r\n          ClientSecret = AppClientSecret\r\n        },\r\n        Scopes,\r\n        &quot;user&quot;,\r\n        CancellationToken.None,\r\n        new FileDataStore(credPath, true)\r\n      ).Result;\r\n      \/\/Console.WriteLine(&quot;Credential file saved to: &quot; + credPath);\r\n      \r\n      var service = new SheetsService(new BaseClientService.Initializer()\r\n      {\r\n         HttpClientInitializer = credential,\r\n         ApplicationName = ApplicationName,\r\n      });\r\n      \r\n      \/\/Sheet1\u306e\u30bb\u30ebA1\u306e\u5024\u53d6\u5f97\r\n      SpreadsheetsResource.ValuesResource.GetRequest req1 = service.Spreadsheets.Values.Get(SpreadSheetId, &quot;Sheet1!A1&quot;);\r\n      IList&lt;IList&lt;Object&gt;&gt; values = req1.Execute().Values;\r\n      Console.WriteLine(values&#x5B;0]&#x5B;0]);\r\n      Console.ReadKey(true);\r\n    }\r\n  }\r\n}<\/pre>\n<p>\u4e0a\u8a18\u30b3\u30fc\u30c9\u3092\u5b9f\u884c\u3059\u308b\u3068\u8a8d\u8a3c\u753b\u9762\u304c\u8868\u793a\u3055\u308c\u308b\u306e\u3067\u3001\u30ea\u30af\u30a8\u30b9\u30c8\u306e\u8a31\u53ef\u3092\u884c\u3044\u307e\u3059\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Google_Sheets_API_v4_09.jpg\" alt=\"Google_Sheets_API_v4_09\" width=\"346\" height=\"417\" class=\"alignnone size-full wp-image-7016\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Google_Sheets_API_v4_09.jpg 346w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Google_Sheets_API_v4_09-249x300.jpg 249w\" sizes=\"auto, (max-width: 346px) 100vw, 346px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Google_Sheets_API_v4_10.jpg\" alt=\"Google_Sheets_API_v4_10\" width=\"574\" height=\"410\" class=\"alignnone size-full wp-image-7017\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Google_Sheets_API_v4_10.jpg 574w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Google_Sheets_API_v4_10-300x214.jpg 300w\" sizes=\"auto, (max-width: 574px) 100vw, 574px\" \/><\/p>\n<p>\u7121\u4e8b\u306b\u8a8d\u8a3c\u304c\u884c\u308f\u308c\u308b\u3068\u3001API\u3067\u53d6\u5f97\u3057\u305f\u30bb\u30eb\u306e\u5024\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Google_Sheets_API_v4_12.jpg\" alt=\"Google_Sheets_API_v4_12\" width=\"307\" height=\"383\" class=\"alignnone size-full wp-image-7019\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Google_Sheets_API_v4_12.jpg 307w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Google_Sheets_API_v4_12-240x300.jpg 240w\" sizes=\"auto, (max-width: 307px) 100vw, 307px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Google_Sheets_API_v4_11.jpg\" alt=\"Google_Sheets_API_v4_11\" width=\"398\" height=\"280\" class=\"alignnone size-full wp-image-7018\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Google_Sheets_API_v4_11.jpg 398w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Google_Sheets_API_v4_11-300x211.jpg 300w\" sizes=\"auto, (max-width: 398px) 100vw, 398px\" \/><\/p>\n<h4 class=\"style4a\">\u304a\u308f\u308a\u306b<\/h4>\n<p>\u305d\u3046\u3044\u3063\u305f\u308f\u3051\u3067\u3001\u4eca\u56de\u306fC#\u304b\u3089Google Sheets API v4\u3092\u547c\u3073\u51fa\u3057\u3066\u307f\u307e\u3057\u305f\u3002<br \/>\nAPI\u306e\u516c\u958b\u5f8c\u3059\u3050\u306bClient Library\u3092\u7528\u610f\u3057\u3066\u304f\u308c\u308b\u3001\u3053\u306e\u30b9\u30d4\u30fc\u30c9\u611f\u306f\u3055\u3059\u304cGoogle\u3002<br \/>\n\u30b5\u30f3\u30d7\u30eb\u30b3\u30fc\u30c9\u306f\u307e\u3060\u307e\u3060\u5c11\u306a\u3044\u3067\u3059\u304c\u3001\u305d\u306e\u3046\u3061\u60c5\u5831\u3082\u5145\u5b9f\u3057\u3066\u304f\u308b\u3060\u308d\u3046\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n<p>\u306a\u304b\u306a\u304b\u4f7f\u3044\u52dd\u624b\u304c\u826f\u3055\u305d\u3046\u306aAPI\u3067\u3059\u306e\u3067\u3001\u8208\u5473\u304c\u3042\u308b\u65b9\u306f\u4e00\u5ea6\u304a\u8a66\u3057\u304f\u3060\u3055\u3044\u3002<\/p>\n<h4 class=\"style4a\">\u95a2\u9023Web\u30da\u30fc\u30b8<\/h4>\n<ul>\n<li>.NET Quickstart<\/li>\n<li style=\"list-style-type:none;\"><a href=\"https:\/\/developers.google.com\/sheets\/quickstart\/dotnet\" target=\"_blank\" title=\".NET Quickstart\">https:\/\/developers.google.com\/sheets\/quickstart\/dotnet<\/a><\/li>\n<li>Google\u304c\u300cI\/O 2016\u300d\u3067\u767a\u8868\u3057\u305f\u3053\u3068\u5168\u3066\u3010\u307e\u3068\u3081\u3011<\/li>\n<li style=\"list-style-type:none;\"><a href=\"http:\/\/thebridge.jp\/2016\/05\/everything-google-announced-at-io-2016\" target=\"_blank\" title=\"Google\u304c\u300cI\/O 2016\u300d\u3067\u767a\u8868\u3057\u305f\u3053\u3068\u5168\u3066\u3010\u307e\u3068\u3081\u3011\">http:\/\/thebridge.jp\/2016\/05\/everything-google-announced-at-io-2016<\/a><\/li>\n<li>\u30b0\u30fc\u30b0\u30eb\u3001\u751f\u7523\u6027\u30a2\u30d7\u30ea\u306e\u65b0API\u3092\u767a\u8868&#8211;\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u3092\u52b9\u7387\u5316<\/li>\n<li style=\"list-style-type:none;\"><a href=\"http:\/\/japan.zdnet.com\/article\/35082889\/\" target=\"_blank\" title=\"\u30b0\u30fc\u30b0\u30eb\u3001\u751f\u7523\u6027\u30a2\u30d7\u30ea\u306e\u65b0API\u3092\u767a\u8868--\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u3092\u52b9\u7387\u5316\">http:\/\/japan.zdnet.com\/article\/35082889\/<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"\u300cGoogle Apps Developer Blog: New ways to keep data flowing between your apps and ours\u300d\u306b\u3042\u308b\u901a\u308a\u3001\u65b0\u3057\u3044Google Sheets A [&hellip;]","protected":false},"author":1,"featured_media":7113,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"[Google Sheets API v4\u304c\u767b\u5834\u3057\u307e\u3057\u305f]","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[126],"tags":[],"class_list":["post-7007","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.0.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u300cGoogle Apps Developer Blog: New ways to keep data flow\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"\u304d\u306c\u3042\u3055\"\/>\n\t<meta name=\"google-site-verification\" content=\"xy7uchdGM1SE5sADlVsdekXridA1vSaVWceffSwnE48\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/www.ka-net.org\/blog\/?p=7007\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.0.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"ja_JP\" \/>\n\t\t<meta property=\"og:site_name\" content=\"\u521d\u5fc3\u8005\u5099\u5fd8\u9332 | Power Automate for desktop\u3084Microsoft Office\u958b\u767a\u306e\u60c5\u5831\u304c\u6e80\u8f09\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Google Sheets API v4\u304c\u767b\u5834\u3057\u307e\u3057\u305f\u3002 | \u521d\u5fc3\u8005\u5099\u5fd8\u9332\" \/>\n\t\t<meta property=\"og:description\" content=\"\u300cGoogle Apps Developer Blog: New ways to keep data flow\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/www.ka-net.org\/blog\/?p=7007\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2016-05-20T03:57:13+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2016-05-20T03:57:13+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Google Sheets API v4\u304c\u767b\u5834\u3057\u307e\u3057\u305f\u3002 | \u521d\u5fc3\u8005\u5099\u5fd8\u9332\" \/>\n\t\t<meta name=\"twitter:description\" content=\"\u300cGoogle Apps Developer Blog: New ways to keep data flow\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.ka-net.org\\\/blog\\\/?p=7007#article\",\"name\":\"Google Sheets API v4\\u304c\\u767b\\u5834\\u3057\\u307e\\u3057\\u305f\\u3002 | \\u521d\\u5fc3\\u8005\\u5099\\u5fd8\\u9332\",\"headline\":\"Google Sheets API v4\\u304c\\u767b\\u5834\\u3057\\u307e\\u3057\\u305f\\u3002\",\"author\":{\"@id\":\"https:\\\/\\\/www.ka-net.org\\\/blog\\\/?author=1#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/www.ka-net.org\\\/blog\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.ka-net.org\\\/blog\\\/wp-content\\\/uploads\\\/eyecatch-Google.png\",\"width\":790,\"height\":480},\"datePublished\":\"2016-05-20T12:57:13+09:00\",\"dateModified\":\"2016-05-20T12:57:13+09:00\",\"inLanguage\":\"ja\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.ka-net.org\\\/blog\\\/?p=7007#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.ka-net.org\\\/blog\\\/?p=7007#webpage\"},\"articleSection\":\"Google\\u95a2\\u9023\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.ka-net.org\\\/blog\\\/?p=7007#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.ka-net.org\\\/blog#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.ka-net.org\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.ka-net.org\\\/blog\\\/?cat=126#listItem\",\"name\":\"Google\\u95a2\\u9023\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.ka-net.org\\\/blog\\\/?cat=126#listItem\",\"position\":2,\"name\":\"Google\\u95a2\\u9023\",\"item\":\"https:\\\/\\\/www.ka-net.org\\\/blog\\\/?cat=126\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.ka-net.org\\\/blog\\\/?p=7007#listItem\",\"name\":\"Google Sheets API v4\\u304c\\u767b\\u5834\\u3057\\u307e\\u3057\\u305f\\u3002\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.ka-net.org\\\/blog#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.ka-net.org\\\/blog\\\/?p=7007#listItem\",\"position\":3,\"name\":\"Google Sheets API v4\\u304c\\u767b\\u5834\\u3057\\u307e\\u3057\\u305f\\u3002\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.ka-net.org\\\/blog\\\/?cat=126#listItem\",\"name\":\"Google\\u95a2\\u9023\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.ka-net.org\\\/blog\\\/#organization\",\"name\":\"\\u521d\\u5fc3\\u8005\\u5099\\u5fd8\\u9332\",\"description\":\"Power Automate for desktop\\u3084Microsoft Office\\u958b\\u767a\\u306e\\u60c5\\u5831\\u304c\\u6e80\\u8f09\",\"url\":\"https:\\\/\\\/www.ka-net.org\\\/blog\\\/\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.ka-net.org\\\/blog\\\/?author=1#author\",\"url\":\"https:\\\/\\\/www.ka-net.org\\\/blog\\\/?author=1\",\"name\":\"\\u304d\\u306c\\u3042\\u3055\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/www.ka-net.org\\\/blog\\\/?p=7007#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1c6237fc3012b3da1f36fa6435b2ccea656e2ff69a51f709c7d8352c69356dc3?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"\\u304d\\u306c\\u3042\\u3055\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.ka-net.org\\\/blog\\\/?p=7007#webpage\",\"url\":\"https:\\\/\\\/www.ka-net.org\\\/blog\\\/?p=7007\",\"name\":\"Google Sheets API v4\\u304c\\u767b\\u5834\\u3057\\u307e\\u3057\\u305f\\u3002 | \\u521d\\u5fc3\\u8005\\u5099\\u5fd8\\u9332\",\"description\":\"\\u300cGoogle Apps Developer Blog: New ways to keep data flow\",\"inLanguage\":\"ja\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.ka-net.org\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.ka-net.org\\\/blog\\\/?p=7007#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/www.ka-net.org\\\/blog\\\/?author=1#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/www.ka-net.org\\\/blog\\\/?author=1#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.ka-net.org\\\/blog\\\/wp-content\\\/uploads\\\/eyecatch-Google.png\",\"@id\":\"https:\\\/\\\/www.ka-net.org\\\/blog\\\/?p=7007\\\/#mainImage\",\"width\":790,\"height\":480},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.ka-net.org\\\/blog\\\/?p=7007#mainImage\"},\"datePublished\":\"2016-05-20T12:57:13+09:00\",\"dateModified\":\"2016-05-20T12:57:13+09:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.ka-net.org\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.ka-net.org\\\/blog\\\/\",\"name\":\"\\u521d\\u5fc3\\u8005\\u5099\\u5fd8\\u9332\",\"description\":\"Power Automate for desktop\\u3084Microsoft Office\\u958b\\u767a\\u306e\\u60c5\\u5831\\u304c\\u6e80\\u8f09\",\"inLanguage\":\"ja\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.ka-net.org\\\/blog\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Google Sheets API v4\u304c\u767b\u5834\u3057\u307e\u3057\u305f\u3002 | \u521d\u5fc3\u8005\u5099\u5fd8\u9332","description":"\u300cGoogle Apps Developer Blog: New ways to keep data flow","canonical_url":"https:\/\/www.ka-net.org\/blog\/?p=7007","robots":"max-image-preview:large","keywords":"","webmasterTools":{"google-site-verification":"xy7uchdGM1SE5sADlVsdekXridA1vSaVWceffSwnE48","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.ka-net.org\/blog\/?p=7007#article","name":"Google Sheets API v4\u304c\u767b\u5834\u3057\u307e\u3057\u305f\u3002 | \u521d\u5fc3\u8005\u5099\u5fd8\u9332","headline":"Google Sheets API v4\u304c\u767b\u5834\u3057\u307e\u3057\u305f\u3002","author":{"@id":"https:\/\/www.ka-net.org\/blog\/?author=1#author"},"publisher":{"@id":"https:\/\/www.ka-net.org\/blog\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/eyecatch-Google.png","width":790,"height":480},"datePublished":"2016-05-20T12:57:13+09:00","dateModified":"2016-05-20T12:57:13+09:00","inLanguage":"ja","mainEntityOfPage":{"@id":"https:\/\/www.ka-net.org\/blog\/?p=7007#webpage"},"isPartOf":{"@id":"https:\/\/www.ka-net.org\/blog\/?p=7007#webpage"},"articleSection":"Google\u95a2\u9023"},{"@type":"BreadcrumbList","@id":"https:\/\/www.ka-net.org\/blog\/?p=7007#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/www.ka-net.org\/blog#listItem","position":1,"name":"Home","item":"https:\/\/www.ka-net.org\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/www.ka-net.org\/blog\/?cat=126#listItem","name":"Google\u95a2\u9023"}},{"@type":"ListItem","@id":"https:\/\/www.ka-net.org\/blog\/?cat=126#listItem","position":2,"name":"Google\u95a2\u9023","item":"https:\/\/www.ka-net.org\/blog\/?cat=126","nextItem":{"@type":"ListItem","@id":"https:\/\/www.ka-net.org\/blog\/?p=7007#listItem","name":"Google Sheets API v4\u304c\u767b\u5834\u3057\u307e\u3057\u305f\u3002"},"previousItem":{"@type":"ListItem","@id":"https:\/\/www.ka-net.org\/blog#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/www.ka-net.org\/blog\/?p=7007#listItem","position":3,"name":"Google Sheets API v4\u304c\u767b\u5834\u3057\u307e\u3057\u305f\u3002","previousItem":{"@type":"ListItem","@id":"https:\/\/www.ka-net.org\/blog\/?cat=126#listItem","name":"Google\u95a2\u9023"}}]},{"@type":"Organization","@id":"https:\/\/www.ka-net.org\/blog\/#organization","name":"\u521d\u5fc3\u8005\u5099\u5fd8\u9332","description":"Power Automate for desktop\u3084Microsoft Office\u958b\u767a\u306e\u60c5\u5831\u304c\u6e80\u8f09","url":"https:\/\/www.ka-net.org\/blog\/"},{"@type":"Person","@id":"https:\/\/www.ka-net.org\/blog\/?author=1#author","url":"https:\/\/www.ka-net.org\/blog\/?author=1","name":"\u304d\u306c\u3042\u3055","image":{"@type":"ImageObject","@id":"https:\/\/www.ka-net.org\/blog\/?p=7007#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/1c6237fc3012b3da1f36fa6435b2ccea656e2ff69a51f709c7d8352c69356dc3?s=96&d=mm&r=g","width":96,"height":96,"caption":"\u304d\u306c\u3042\u3055"}},{"@type":"WebPage","@id":"https:\/\/www.ka-net.org\/blog\/?p=7007#webpage","url":"https:\/\/www.ka-net.org\/blog\/?p=7007","name":"Google Sheets API v4\u304c\u767b\u5834\u3057\u307e\u3057\u305f\u3002 | \u521d\u5fc3\u8005\u5099\u5fd8\u9332","description":"\u300cGoogle Apps Developer Blog: New ways to keep data flow","inLanguage":"ja","isPartOf":{"@id":"https:\/\/www.ka-net.org\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/www.ka-net.org\/blog\/?p=7007#breadcrumblist"},"author":{"@id":"https:\/\/www.ka-net.org\/blog\/?author=1#author"},"creator":{"@id":"https:\/\/www.ka-net.org\/blog\/?author=1#author"},"image":{"@type":"ImageObject","url":"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/eyecatch-Google.png","@id":"https:\/\/www.ka-net.org\/blog\/?p=7007\/#mainImage","width":790,"height":480},"primaryImageOfPage":{"@id":"https:\/\/www.ka-net.org\/blog\/?p=7007#mainImage"},"datePublished":"2016-05-20T12:57:13+09:00","dateModified":"2016-05-20T12:57:13+09:00"},{"@type":"WebSite","@id":"https:\/\/www.ka-net.org\/blog\/#website","url":"https:\/\/www.ka-net.org\/blog\/","name":"\u521d\u5fc3\u8005\u5099\u5fd8\u9332","description":"Power Automate for desktop\u3084Microsoft Office\u958b\u767a\u306e\u60c5\u5831\u304c\u6e80\u8f09","inLanguage":"ja","publisher":{"@id":"https:\/\/www.ka-net.org\/blog\/#organization"}}]},"og:locale":"ja_JP","og:site_name":"\u521d\u5fc3\u8005\u5099\u5fd8\u9332 | Power Automate for desktop\u3084Microsoft Office\u958b\u767a\u306e\u60c5\u5831\u304c\u6e80\u8f09","og:type":"article","og:title":"Google Sheets API v4\u304c\u767b\u5834\u3057\u307e\u3057\u305f\u3002 | \u521d\u5fc3\u8005\u5099\u5fd8\u9332","og:description":"\u300cGoogle Apps Developer Blog: New ways to keep data flow","og:url":"https:\/\/www.ka-net.org\/blog\/?p=7007","article:published_time":"2016-05-20T03:57:13+00:00","article:modified_time":"2016-05-20T03:57:13+00:00","twitter:card":"summary","twitter:title":"Google Sheets API v4\u304c\u767b\u5834\u3057\u307e\u3057\u305f\u3002 | \u521d\u5fc3\u8005\u5099\u5fd8\u9332","twitter:description":"\u300cGoogle Apps Developer Blog: New ways to keep data flow"},"aioseo_meta_data":{"post_id":"7007","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[],"defaultGraph":"","defaultPostTypeGraph":""},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2020-12-24 07:15:26","updated":"2022-09-14 04:30:27","seo_analyzer_scan_date":null,"focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/eyecatch-Google.png","jetpack_shortlink":"https:\/\/wp.me\/p4UZZr-1P1","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/7007","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7007"}],"version-history":[{"count":1,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/7007\/revisions"}],"predecessor-version":[{"id":7020,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/7007\/revisions\/7020"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/media\/7113"}],"wp:attachment":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7007"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7007"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7007"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}