{"id":122722,"date":"2022-06-08T16:41:15","date_gmt":"2022-06-08T07:41:15","guid":{"rendered":"https:\/\/support.questetra.com\/?p=122722"},"modified":"2023-08-22T14:04:00","modified_gmt":"2023-08-22T05:04:00","slug":"google-sheets-row-range-delete-2022","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/ja\/addons\/google-sheets-row-range-delete-2022\/","title":{"rendered":"Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8 #\u884c\u7bc4\u56f2: \u524a\u9664"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><div class=\"su-box su-box-style-soft\" id=\"\" style=\"border-color:#cc66cc;border-radius:0px;max-width:none\"><div class=\"su-box-title\" style=\"background-color:#ff99ff;color:#000000;border-top-left-radius:0px;border-top-right-radius:0px\">Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: \u884c\u7bc4\u56f2, \u524a\u9664 (Google Sheets: Row Range, Delete)<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:0px;border-bottom-right-radius:0px\"> \u6307\u5b9a\u7bc4\u56f2\u306e\u884c\u3092\u5168\u3066\u524a\u9664\u3057\u307e\u3059\u3002\u5b58\u7d9a\u884c\u306f\u5168\u3066\u4e0a\u65b9\u5411\u306b\u30b7\u30d5\u30c8\u3055\u308c\u307e\u3059\u3002\u958b\u59cb\u884c\u3068\u7d42\u4e86\u884c\u306f\u30bc\u30ed\u59cb\u307e\u308a\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u5024\u3067\u6307\u5b9a\u3057\u307e\u3059\u3002\u306a\u304a\u300c\u958b\u59cb\u30a4\u30f3\u30c7\u30c3\u30af\u30b9:0\u3001\u7d42\u4e86\u30a4\u30f3\u30c7\u30c3\u30af\u30b9:1\u300d\u3068\u6307\u5b9a\u3057\u305f\u5834\u5408\u3001\u5148\u982d\u306e1\u884c\u3060\u3051\u304c\u524a\u9664\u3055\u308c\u307e\u3059\u3002\uff08\u7d42\u4e86\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306f\u6392\u4ed6\u7684\uff09<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1\" data-anchor=\"configs\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Configs<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<ul class=\"fa-ul\">\n<li><span class=\"fa-li\"><i class=\"fal fa-badge-check fa-lg\"><\/i><\/span> U: HTTP\u8a8d\u8a3c\u8a2d\u5b9a\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044<span style=\"color:#990000;\"> *<\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> A1: Drive\u5185\u3067\u306e\u30d5\u30a1\u30a4\u30ebID\uff08SPREADSHEET-ID\uff09\u3092\u30bb\u30c3\u30c8\u3057\u3066\u304f\u3060\u3055\u3044<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> A2: SPREADSHEET\u5185\u306eSHEET-ID\u3092\u30bb\u30c3\u30c8\u3057\u3066\u304f\u3060\u3055\u3044<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> A3: \u3082\u3057\u304f\u306f\u3001SPREADSHEET\u5185\u306eSHEET\u540d\u3092\u30bb\u30c3\u30c8\u3057\u3066\u304f\u3060\u3055\u3044<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> B1: \u524a\u9664\u7bc4\u56f2\uff08\u958b\u59cb\u884cIndex\uff09\u3092\u30bb\u30c3\u30c8\u3057\u3066\u304f\u3060\u3055\u3044<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> B2: \u524a\u9664\u7bc4\u56f2\uff08\u7d42\u4e86\u884cIndex\uff09\u3092\u30bb\u30c3\u30c8\u3057\u3066\u304f\u3060\u3055\u3044<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-caret-square-down fa-lg\"><\/i><\/span> C1: TSV\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3057\u305f\u3044\u5834\u5408\u3001TSV\u304c\u683c\u7d0d\u3055\u308c\u308b\u6587\u5b57\u5217\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 (\u66f4\u65b0)<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1 su-spoiler-closed\" data-anchor=\"script\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Script (click to open)<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-js\" data-lang=\"JavaScript\"><code>\/\/ GraalJS Script (engine type: 2)\n\n\/\/\/\/\/\/\/\/ START &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\nmain();\nfunction main(){ \n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst strAuthzSetting     = configs.get      ( &quot;AuthzConfU&quot; );   \/\/\/ REQUIRED\n  engine.log( &quot; AutomatedTask Config: Authz Setting: &quot; + strAuthzSetting );\nconst strFileId           = configs.get      ( &quot;StrConfA1&quot; );    \/\/\/ REQUIRED\n  if( strFileId         === &quot;&quot; ){\n    throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                     &quot; Config {A1: FileID} is empty \\n&quot; );\n  }\nlet   strSheetId          = configs.get      ( &quot;StrConfA2&quot; );    \/\/ NotRequired\nlet   strSheetName        = configs.get      ( &quot;StrConfA3&quot; );    \/\/ NotRequired\n  if( strSheetId === &quot;&quot; ){\n    engine.log( &quot; AutomatedTask ConfigWarning:&quot; +\n                &quot; Config {A2: SheetId} (recommended) is empty&quot; );\n    if( strSheetName === &quot;&quot; ){\n      throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                       &quot; Config {A2: Id} or {A3: Name} must be specified \\n&quot; );\n    }\n  }\nconst strRowRangeStart    = configs.get      ( &quot;StrConfB1&quot; );    \/\/\/ REQUIRED\n  let numRowRangeStart    = parseInt( strRowRangeStart, 10 );\nconst strRowRangeEnd      = configs.get      ( &quot;StrConfB2&quot; );    \/\/\/ REQUIRED\n  let numRowRangeEnd      = parseInt( strRowRangeEnd, 10 );\n  if( numRowRangeStart &gt;= numRowRangeEnd ){\n    throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                     &quot; {B1: StartRowIndex} must be smaller than {B2: EndRowIndex} \\n&quot; );\n  }\nconst strPocketTsv        = configs.getObject( &quot;SelectConfC1&quot; ); \/\/ NotRequired\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\n\/\/ (Nothing. Retrieved via Expression Language in Config Retrieving)\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\n\n\/\/\/ get Sheet Properties\n\n\/\/ request1, prepare\n\/\/ Sheets for Developers &gt; API v4\n\/\/ https:\/\/developers.google.com\/sheets\/api\/reference\/rest\/v4\/spreadsheets\/get\nlet request1Uri = &quot;https:\/\/sheets.googleapis.com\/v4\/spreadsheets\/&quot; + strFileId;\nlet request1    = httpClient.begin(); \/\/ HttpRequestWrapper\n    request1    = request1.authSetting( strAuthzSetting ); \/\/ with &quot;Authorization: Bearer XX&quot;\n    \/\/ https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024574471-R2300#HttpRequestWrapper\n\n\/\/ request1, try\nconst response1     = request1.get( request1Uri );       \/\/ HttpResponseWrapper\nengine.log( &quot; AutomatedTask ApiRequest1 Start: &quot; + request1Uri );\nconst response1Code = response1.getStatusCode() + &quot;&quot;; \/\/ (primitive string)\nconst response1Body = response1.getResponseAsString() + &quot;&quot;;\nengine.log( &quot; AutomatedTask ApiResponse Status: &quot; + response1Code );\nif( response1Code !== &quot;200&quot;){\n  throw new Error( &quot;\\n AutomatedTask UnexpectedResponseError: &quot; +\n                    response1Code + &quot;\\n&quot; + response1Body + &quot;\\n&quot; );\n}\n\n\/\/ parse response1\nconst response1Obj = JSON.parse( response1Body );\n\/* response sample\nengine.log( response1Body ); \/\/ debug\n{\n  &quot;spreadsheetId&quot;: &quot;17rwXXXXxS34yyyyYr-KzzzzX0_iWWWWOfHdxxxxRCLM&quot;,\n  &quot;properties&quot;: { \u2026 },\n  &quot;sheets&quot;: [\n    {\n      &quot;properties&quot;: {\n        &quot;sheetId&quot;: 0,\n        &quot;title&quot;: &quot;sheet1&quot;,\n        &quot;index&quot;: 0,\n        &quot;sheetType&quot;: &quot;GRID&quot;,\n        &quot;gridProperties&quot;: {\n          &quot;rowCount&quot;: 100,\n          &quot;columnCount&quot;: 20,\n          &quot;frozenRowCount&quot;: 1\n        }\n      }\n    }\n  ],\n  &quot;spreadsheetUrl&quot;: &quot;https:\/\/docs.google.com\/spreadsheets\/d\/17rwXXXXxS34yyyyYr-KzzzzX0_iWWWWOfHdxxxxRCLM\/edit&quot;\n}\n*\/\n\nif( strSheetId === &quot;&quot; ){\n  \/\/\/ get SheetId from SheetName\n  for( let i = 0; i &lt; response1Obj.sheets.length; i++ ){\n    engine.log( &quot; - &quot; + response1Obj.sheets[i].properties.title );\n    if( response1Obj.sheets[i].properties.title === strSheetName ){\n      strSheetId = response1Obj.sheets[i].properties.sheetId;\n      engine.log( &quot; AutomatedTask SheetName &#39;&quot; + strSheetName +\n                    &quot;&#39;: SheetId &quot; + strSheetId );\n      break;\n    }\n  }\n  if( strSheetId === &quot;&quot; ){\n    throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                     &quot; Config {A3 Sheet Name} does not exist \\n&quot; );\n  }\n}else{\n  const numSheetId = parseInt( strSheetId, 10 );\n  \/\/\/ get SheetName from SheetId\n  for( let i = 0; i &lt; response1Obj.sheets.length; i++ ){\n    engine.log( &quot; - &quot; + response1Obj.sheets[i].properties.sheetId );\n    if( response1Obj.sheets[i].properties.sheetId === numSheetId ){\n      strSheetName = response1Obj.sheets[i].properties.title;\n      engine.log( &quot; AutomatedTask SheetId &#39;&quot; + strSheetId +\n                    &quot;&#39;: SheetName &quot; + strSheetName );\n      break;\n    }\n  }\n}\n\n\n\/\/\/ backup RowRange\n\nlet strTsv = &quot;&quot;;\nif( strPocketTsv    !== null ){\n  const strA1Notation = strSheetName + &quot;!&quot; + (numRowRangeStart+1) + &quot;:&quot; + numRowRangeEnd;\n  engine.log( &quot; AutomatedTask Backup Range: &quot; + strA1Notation );\n\n  \/\/\/ Sheets for Developers &gt; API v4\n  \/\/\/ https:\/\/developers.google.com\/sheets\/api\/reference\/rest\/v4\/spreadsheets.values\/batchGet\n\n  \/\/ request2, prepare\n  let request2Uri = &quot;https:\/\/sheets.googleapis.com\/v4\/spreadsheets\/&quot; + strFileId + &quot;\/values:batchGet&quot;;\n  let request2    = httpClient.begin(); \/\/ HttpRequestWrapper\n      request2    = request2.authSetting( strAuthzSetting ); \/\/ with &quot;Authorization: Bearer XX&quot;\n      \/\/ https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024574471-R2300#HttpRequestWrapper\n      request2    = request2.queryParam( &quot;majorDimension&quot;, &quot;ROWS&quot; );\n      request2    = request2.queryParam( &quot;valueRenderOption&quot;, &quot;FORMATTED_VALUE&quot; ); \n                   \/\/ Even if formatted as currency, return &quot;$1.23&quot; not &quot;1.23&quot;.\n      request2    = request2.queryParam( &quot;dateTimeRenderOption&quot;, &quot;FORMATTED_STRING&quot; ); \n                   \/\/ Date as strings (the spreadsheet locale) not SERIAL_NUMBER\n      request2    = request2.queryParam( &quot;ranges&quot;, strA1Notation );\n\n  \/\/ request2, try\n  const response2     = request2.get( request2Uri ); \/\/ HttpResponseWrapper\n  engine.log( &quot; AutomatedTask ApiRequest2 Start: &quot; + request2Uri );\n  const response2Code = response2.getStatusCode() + &quot;&quot;;\n  const response2Body = response2.getResponseAsString() + &quot;&quot;;\n  engine.log( &quot; AutomatedTask ApiResponse Status: &quot; + response2Code );\n  if( response2Code !== &quot;200&quot;){\n    throw new Error( &quot;\\n AutomatedTask UnexpectedResponseError: &quot; +\n                      response2Code + &quot;\\n&quot; + response2Body + &quot;\\n&quot; );\n  }\n\n  \/\/ response2, parse\n  const response2Obj = JSON.parse( response2Body );\n  \/* response sample\n  engine.log( response2Body ); \/\/ debug\n  {\n    &quot;spreadsheetId&quot;: &quot;17rwXXXXxS34yyyyYr-KzzzzX0_iWWWWOfHdxxxxRCLM&quot;,\n    &quot;valueRanges&quot;: [\n      {\n        &quot;range&quot;: &quot;Sheet1!A1:Z3&quot;,\n        &quot;majorDimension&quot;: &quot;ROWS&quot;,\n        &quot;values&quot;: [\n          [\n            &quot;Date&quot;,\n            &quot;Account (\u79d1\u76ee)&quot;,\n            &quot;Description (\u6458\u8981)&quot;,\n            &quot;Debit (\u501f\u65b9)&quot;,\n            &quot;Credit (\u8cb8\u65b9)&quot;,\n            &quot;Balance (\u6b8b\u9ad8)&quot;\n          ],\n          [\n            &quot;2019-10-01&quot;,\n            &quot;\\u003cBUDGET\\u003e&quot;,\n            &quot;&quot;,\n            &quot;&quot;,\n            &quot;4,000,000.00&quot;,\n            &quot;4,000,000.00&quot;\n          ],\n          [\n            &quot;2019-10-17&quot;,\n            &quot;Design Fee&quot;,\n            &quot;Web Display: BPM &quot;,\n            &quot;2,000,000.00&quot;,\n            &quot;&quot;,\n            &quot;2,000,000.00&quot;\n          ]\n        ]\n      }\n    ]\n  }\n  *\/\n\n  engine.log( &quot; AutomatedTask ApiResponse: range: &quot; + response2Obj.valueRanges[0].range );\n  let numTsvWidth = 0;\n  for( let j = 0; j &lt; response2Obj.valueRanges[0].values.length; j++ ){\n    if( numTsvWidth &lt; response2Obj.valueRanges[0].values[j].length ){\n      numTsvWidth   = response2Obj.valueRanges[0].values[j].length;\n    }\n  }\n  engine.log( &quot; AutomatedTask ApiResponse: tmpTsv width: &quot; + numTsvWidth );\n  for( let j = 0; j &lt; response2Obj.valueRanges[0].values.length; j++ ){\n    for( let k = 0; k &lt; numTsvWidth; k++ ){\n      if( k &lt; response2Obj.valueRanges[0].values[j].length ){\n        strTsv += response2Obj.valueRanges[0].values[j][k];\n      }\n      if( k != response2Obj.valueRanges[0].values[j].length - 1 ){\n        strTsv += &quot;\\t&quot;;\n      }\n    }\n    if( j != response2Obj.valueRanges[0].values.length - 1 ){\n      strTsv += &quot;\\n&quot;;\n    }\n  }\n}\n\n\n\/\/\/ delete RowRange\n\/\/ Google Sheets for Developers &gt; Sheets API\n\/\/ https:\/\/developers.google.com\/sheets\/api\/reference\/rest\/v4\/spreadsheets\/request#DeleteRangeRequest\n\n\/\/ request3, prepare\nlet request3Obj = {};\n    request3Obj.requests = [];\n    request3Obj.requests[0] = {};\n    request3Obj.requests[0].deleteRange = {};\n    request3Obj.requests[0].deleteRange.shiftDimension = &quot;ROWS&quot;;\n    request3Obj.requests[0].deleteRange.range = {};\n    request3Obj.requests[0].deleteRange.range.sheetId = (strSheetId - 0);\n    request3Obj.requests[0].deleteRange.range.startRowIndex = numRowRangeStart;\n    request3Obj.requests[0].deleteRange.range.endRowIndex   = numRowRangeEnd; \nlet request3Uri = &quot;https:\/\/sheets.googleapis.com\/v4\/spreadsheets\/&quot; + strFileId + &quot;:batchUpdate&quot;;\nlet request3    = httpClient.begin(); \/\/ HttpRequestWrapper\n    request3    = request3.authSetting( strAuthzSetting ); \/\/ with &quot;Authorization: Bearer XX&quot;\n    \/\/ https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024574471-R2300#HttpRequestWrapper\n    request3 = request3.body( JSON.stringify( request3Obj ), &quot;application\/json&quot; );\nengine.log( &quot; AutomatedTask ApiRequest3 Prepared&quot; );\n\n\/\/ request3, try\nconst response3     = request3.post( request3Uri );       \/\/ HttpResponseWrapper\nengine.log( &quot; AutomatedTask ApiRequest3 Start: &quot; + request3Uri );\nconst response3Code = response3.getStatusCode() + &quot;&quot;; \/\/ (primitive string)\nconst response3Body = response3.getResponseAsString() + &quot;&quot;;\nengine.log( &quot; AutomatedTask ApiResponse3 Status: &quot; + response3Code );\nif( response3Code !== &quot;200&quot;){\n  throw new Error( &quot;\\n AutomatedTask UnexpectedResponseError: &quot; +\n                    response3Code + &quot;\\n&quot; + response3Body + &quot;\\n&quot; );\n}\n\/* response sample\nengine.log( response3Body ); \/\/ debug\n{\n  &quot;spreadsheetId&quot;: &quot;1Wfruxxxxxl6FmwyyyyyWzYLxzzzzzLQmiPxxxxxR_4I&quot;,\n  &quot;replies&quot;: [\n    {}\n  ]\n}\n*\/\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nif( strPocketTsv    !== null ){\n  engine.setData( strPocketTsv,    strTsv );\n}\n\n\n} \/\/\/\/\/\/\/\/ END &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\n\/*\nNotes:\n- When the process reaches this automated step, rows in Google Sheets will be deleted.\n    - Automates deletions by using the wider API Scope (strong privilege).\n- The range is specified by the zero-based indexes of start index and end index.\n    - If to delete all cell, specify &quot;0&quot; for the start index and &quot;1000&quot; for the end index.\n    - The index is evaluated by JavaScript `parseInt ()`.\n        - When specifying with numeric data, be careful not to mix digit delimiters.\n        - https:\/\/developer.mozilla.org\/docs\/Web\/JavaScript\/Reference\/Global_Objects\/parseInt\n    - Index values outside the range will be corrected.\n- Spreadsheets are specified by ID, such as by referencing a URL. (SPREADSHEETID)\n    - https:\/\/docs.google.com\/spreadsheets\/d\/SPREADSHEETID\/edit#gid=SHEETID\n- It is also possible to import (back up) deleted data as Workflow data.\n    - The TSV string has a uniform number of columns (rectangular data) in each row.\n    - There is no line feed code at the end of the TSV string.\n\nAPPENDIX-en\n- The backup lines and the deleted lines may be out of alignment if edited at the same time.\n- To restore the spreadsheet to a previous version, go to the &quot;Change History&quot; of the file.\n    - &quot;Find what&#39;s changed in a file&quot; (Google file)\n    - &quot;The revisions for your file may occasionally be merged to save storage space.&quot;\n    - https:\/\/support.google.com\/docs\/answer\/190843\n- Setting example of &quot;HTTP Authentication&quot; (OAuth2)\n    - Authorization Endpoint URL:\n        - https:\/\/accounts.google.com\/o\/oauth2\/v2\/auth?access_type=offline&prompt=consent\n    - Token Endpoint URL:\n        - https:\/\/oauth2.googleapis.com\/token\n    - Scope:\n        - https:\/\/www.googleapis.com\/auth\/spreadsheets.readonly\n    - Client ID, Consumer Secret:\n        - ( from https:\/\/console.developers.google.com\/ )\n        - Redirect URLs: https:\/\/s.questetra.net\/oauth2callback\n    - (OFFICIAL) https:\/\/developers.google.com\/identity\/protocols\/oauth2\/web-server#httprest\n\nNotes-ja:\n- \u6848\u4ef6\u304c\u81ea\u52d5\u5de5\u7a0b\u306b\u5230\u9054\u3057\u305f\u969b\u3001Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u4e00\u90e8\u306e\u884c\u304c\u81ea\u52d5\u524a\u9664\u3055\u308c\u307e\u3059\u3002\n    - \u5e83\u7bc4\u306a API Scope\uff08\u5f37\u3044\u6a29\u9650\uff09\u3092\u4f7f\u3063\u305f\u524a\u9664\u4f5c\u696d\u306e\u81ea\u52d5\u5316\u3002\n- \u524a\u9664\u7bc4\u56f2\u306f\u958b\u59cb\u884c\u3068\u7d42\u4e86\u884c\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u5024\u3067\u6307\u5b9a\u3057\u307e\u3059\u3002\uff08\u30bc\u30ed\u59cb\u307e\u308a\uff09\n    - \u5168\u30c7\u30fc\u30bf\u3092\u524a\u9664\u3057\u305f\u3044\u5834\u5408\u3001\u958b\u59cbIndex\u306b\u300c0\u300d\u3001\u7d42\u4e86Index\u306b\u300c1000\u300d\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002\n    - \u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306f JavaScript `parseInt()` \u306b\u3066\u8a55\u4fa1\u3055\u308c\u307e\u3059\u3002\n        - \u6570\u5024\u578b\u30c7\u30fc\u30bf\u3067\u6307\u5b9a\u3059\u308b\u5834\u5408\u3001\u6841\u533a\u5207\u308a\u6587\u5b57\u306e\u6df7\u5165\u30b1\u30fc\u30b9\u306b\u6ce8\u610f\u304c\u5fc5\u8981\u3067\u3059\n        - https:\/\/developer.mozilla.org\/docs\/Web\/JavaScript\/Reference\/Global_Objects\/parseInt\n    - \u7bc4\u56f2\u5916\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u5024\u306f\u88dc\u6b63\u3055\u308c\u307e\u3059\u3002\n- \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306f\u3001URL\u3092\u53c2\u7167\u3059\u308b\u306a\u3069\u3057\u3066 ID \u3067\u6307\u5b9a\u3057\u307e\u3059\u3002(SPREADSHEETID)\n    - https:\/\/docs.google.com\/spreadsheets\/d\/SPREADSHEETID\/edit#gid=SHEETID\n- \u524a\u9664\u3055\u308c\u305f\u30c7\u30fc\u30bf\u3092Workflow\u30c7\u30fc\u30bf\u3068\u3057\u3066\u53d6\u308a\u8fbc\u3080\uff08\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3059\u308b\uff09\u3053\u3068\u3082\u53ef\u80fd\u3067\u3059\u3002\n    - TSV\u6587\u5b57\u5217\u306f\u3001\u3044\u305a\u308c\u306e\u884c\u3082\u5747\u4e00\u306e\u5217\u6570\uff08\u77e9\u5f62\u30c7\u30fc\u30bf\uff09\u3068\u306a\u308a\u307e\u3059\u3002\n    - TSV\u6587\u5b57\u5217\u306e\u672b\u5c3e\u306b\u6539\u884c\u30b3\u30fc\u30c9\u306f\u3042\u308a\u307e\u305b\u3093\u3002\n\nAPPENDIX-ja\n- \u540c\u6642\u7de8\u96c6\u306b\u3088\u308a\u3001\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u884c\u3068\u524a\u9664\u884c\u304c\u30ba\u30ec\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002\n- \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3092\u904e\u53bb\u30d0\u30fc\u30b8\u30e7\u30f3\u306b\u5fa9\u5143\u3057\u305f\u3044\u5834\u5408\u3001\u30d5\u30a1\u30a4\u30eb\u306e &quot;\u5909\u66f4\u5c65\u6b74&quot; \u306b\u30a2\u30af\u30bb\u30b9\u3057\u307e\u3059\u3002\n    - (Google \u5f62\u5f0f\u306e) &quot;\u30d5\u30a1\u30a4\u30eb\u306e\u5909\u66f4\u5185\u5bb9\u3092\u78ba\u8a8d\u3059\u308b&quot;\n    - &quot;\u5bb9\u91cf\u7bc0\u7d04\u306e\u305f\u3081\u3001\u30d5\u30a1\u30a4\u30eb\u306e\u7248\u304c\u7d71\u5408\u3055\u308c\u308b\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002&quot;\n    - https:\/\/support.google.com\/docs\/answer\/190843\n- &quot;HTTP\u8a8d\u8a3c&quot;\uff08OAuth2\uff09\u306e\u8a2d\u5b9a\u4f8b\n    - Authorization Endpoint URL:\n        - https:\/\/accounts.google.com\/o\/oauth2\/v2\/auth?access_type=offline&prompt=consent\n    - Token Endpoint URL:\n        - https:\/\/oauth2.googleapis.com\/token\n    - Scope:\n        - https:\/\/www.googleapis.com\/auth\/spreadsheets\n    - Client ID, Consumer Secret:\n        - ( from https:\/\/console.developers.google.com\/ )\n        - Redirect URLs: https:\/\/s.questetra.net\/oauth2callback\n    - (OFFICIAL) https:\/\/developers.google.com\/identity\/protocols\/oauth2\/web-server#httprest\n*\/\n\n<\/code><\/pre><\/div>\n\n\n<\/div><\/div>\n\n\n\n<figure class=\"wp-block-image alignright\"><a href=\"#\"><img decoding=\"async\" src=\"data:image;base64,\niVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAC3ElEQVRYR8WXbUgTcRzHv\/85bZvF\nZmMwLKwXgkEUGFFKvSi6EoLe+M7IF3lGWtATQW9615uMKOlFaroFKc1XRvSiF14YPUBEtfKFpPlC\nI1TQ2q10Tr3dP3bzxm7e7e7m6u717+Fzv+c\/gcUfMeq\/vOuEa9EWq6dF5DAoqkGxHQRlkj5FBAQT\nIAiTBB1yiq6BqbPPYkZs6wL4Hh7yr4j2awRooYDDoNE4BTqLbULb7OmXM7l0cgKUBY62UNDbAEqN\nOFaRWSAgVyPsYKeWviaAO8jcJxSteTpWqFGCjmgTd07NliqAO8A8JkBDIZzLNigQirLcyWybawAK\n+efZztQioQBYzXlHtuK9g1fQUHkMdluRalCWRQH944O4+OaObtAISGtmTaQBVqt9XK3g3tX3oMqz\nTdP45J8ZiBDxevqLEYiFYptQKXdHGsATYO4CuKTmRQ9glJ\/E9fcPcKv2vFGIdp7lLid9SQDSkLEv\n\/tTqcyMANQPNYLbuMwRBgLhTcHqTw0oCKOs+coraSK9WjPUAYkIcr6Y+I7o8j43FTtT6d6F75Clu\nhh9ppo2ItDFy5kWfBOAJMgFQNOULoKbXO\/YcF3IVJUGQb+LYFECA+QSg+r8CAGGe5fakAHqYX+nF\nokKhl4K8IkAR4Zu5zXIEaK4GzgTgl+YxNPURy4kVhYrf5cUB\/+70rNBNAQCe5YhpgOnYHEb579jr\n24EPs1+xpdQHr8ONt9PDqKuoQYnNLoGZAzCRgiRA6Nug5Hj89w94N7ixqcSFuLCExqrjxgGyUmC4\nCAsGoChCE21YsBRktqGZQVSoIlQMovWOYrNtuGYUrw6jvJeRWQAAymWUNJBrHYeYG6ir2A+S2l26\nXzyxhLZwH9qH+9Vk1dextJRSR+iag6S81IfWnfXwOTy6zpMC4bkxdI08UZXVPEhkaUtPsjSElUfp\nv4iE6bNchrD0YSJDWPo0yyxjyx6nhvpuHUJ\/AerAujDWZMynAAAAAElFTkSuQmCC\n\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-cloud-download-alt\"><\/i> Download<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/drive.google.com\/file\/d\/1epascZwIS4UTcqI2mqZpHqP0qeLOaCZA\/view?usp=drivesdk\" target=\"_blank\">google-sheets-row-range-delete-2022.xml<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/drive.google.com\/file\/d\/1DkaB9XcUS_BG0pfC79XzoY0xRWG2jHAC\/view?usp=sharing\" data-type=\"link\" data-id=\"https:\/\/drive.google.com\/file\/d\/1DkaB9XcUS_BG0pfC79XzoY0xRWG2jHAC\/view?usp=sharing\">google-sheets-row-range-delete-2023.xml<\/a>\n<ul class=\"wp-block-list\">\n<li>2023-08-21 (C) Questetra, Inc. (MIT License)<\/li>\n\n\n\n<li>for &#8220;GraalJS standard (engine-type 3)&#8221; on v15.0 or above<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p class=\"has-text-align-right has-small-font-size wp-block-paragraph\">2021-06-02 (C) Questetra, Inc. (MIT License)<br><a href=\"https:\/\/support.questetra.com\/ja\/addons\/google-sheets-row-range-delete-2022\/\">https:\/\/support.questetra.com\/ja\/addons\/google-sheets-row-range-delete-2022\/<\/a><br><i class=\"fal fa-info-circle\"><\/i> Addon\u30d5\u30a1\u30a4\u30eb\u306e\u30a4\u30f3\u30dd\u30fc\u30c8\u306f <span style=\"color:#4a86e8\" class=\"has-inline-color\"><strong>Professional<\/strong><\/span> \u3067\u306e\u307f\u3054\u5229\u7528\u3044\u305f\u3060\u3051\u307e\u3059\u3002<br>\u81ea\u7531\u6539\u5909\u53ef\u80fd\u306a JavaScript (ECMAScript) \u30b3\u30fc\u30c9\u3067\u3059\u3002\u3044\u304b\u306a\u308b\u4fdd\u8a3c\u3082\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n\n\n<div class=\"su-divider su-divider-style-dashed\" style=\"margin:30px 0;border-width:8px;border-color:#009900\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-lightbulb-exclamation\"><\/i> Notes<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u6848\u4ef6\u304c\u81ea\u52d5\u5de5\u7a0b\u306b\u5230\u9054\u3057\u305f\u969b\u3001Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u4e00\u90e8\u306e\u884c\u304c\u81ea\u52d5\u524a\u9664\u3055\u308c\u307e\u3059\u3002\n<ul class=\"wp-block-list\">\n<li>\u5e83\u7bc4\u306a API Scope\uff08\u5f37\u3044\u6a29\u9650\uff09\u3092\u4f7f\u3063\u305f\u524a\u9664\u4f5c\u696d\u306e\u81ea\u52d5\u5316\u3002<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>\u524a\u9664\u7bc4\u56f2\u306f\u958b\u59cb\u884c\u3068\u7d42\u4e86\u884c\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u5024\u3067\u6307\u5b9a\u3057\u307e\u3059\u3002\uff08\u30bc\u30ed\u59cb\u307e\u308a\uff09\n<ul class=\"wp-block-list\">\n<li>\u5168\u30c7\u30fc\u30bf\u3092\u524a\u9664\u3057\u305f\u3044\u5834\u5408\u3001\u958b\u59cbIndex\u306b\u300c0\u300d\u3001\u7d42\u4e86Index\u306b\u300c1000\u300d\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/li>\n\n\n\n<li>\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306f JavaScript <code>parseInt()<\/code> \u306b\u3066\u8a55\u4fa1\u3055\u308c\u307e\u3059\u3002\n<ul class=\"wp-block-list\">\n<li>\u6570\u5024\u578b\u30c7\u30fc\u30bf\u3067\u6307\u5b9a\u3059\u308b\u5834\u5408\u3001\u6841\u533a\u5207\u308a\u6587\u5b57\u306e\u6df7\u5165\u30b1\u30fc\u30b9\u306b\u6ce8\u610f\u304c\u5fc5\u8981\u3067\u3059<\/li>\n\n\n\n<li><a href=\"https:\/\/developer.mozilla.org\/docs\/Web\/JavaScript\/Reference\/Global_Objects\/parseInt\" rel=\"nofollow\">https:\/\/developer.mozilla.org\/docs\/Web\/JavaScript\/Reference\/Global_Objects\/parseInt<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>\u7bc4\u56f2\u5916\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u5024\u306f\u88dc\u6b63\u3055\u308c\u307e\u3059\u3002<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306f\u3001URL\u3092\u53c2\u7167\u3059\u308b\u306a\u3069\u3057\u3066 ID \u3067\u6307\u5b9a\u3057\u307e\u3059\u3002(SPREADSHEETID)\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/SPREADSHEETID\/edit#gid=SHEETID\" rel=\"nofollow\">https:\/\/docs.google.com\/spreadsheets\/d\/SPREADSHEETID\/edit#gid=SHEETID<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>\u524a\u9664\u3055\u308c\u305f\u30c7\u30fc\u30bf\u3092Workflow\u30c7\u30fc\u30bf\u3068\u3057\u3066\u53d6\u308a\u8fbc\u3080\uff08\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3059\u308b\uff09\u3053\u3068\u3082\u53ef\u80fd\u3067\u3059\u3002\n<ul class=\"wp-block-list\">\n<li>TSV\u6587\u5b57\u5217\u306f\u3001\u3044\u305a\u308c\u306e\u884c\u3082\u5747\u4e00\u306e\u5217\u6570\uff08\u77e9\u5f62\u30c7\u30fc\u30bf\uff09\u3068\u306a\u308a\u307e\u3059\u3002<\/li>\n\n\n\n<li>TSV\u6587\u5b57\u5217\u306e\u672b\u5c3e\u306b\u6539\u884c\u30b3\u30fc\u30c9\u306f\u3042\u308a\u307e\u305b\u3093\u3002<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-images\"><\/i> Capture<\/h3>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-sheets-row-range-delete-2022-capture-ja.png?ssl=1\" target=\"_blank\" rel=\"noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"675\" data-attachment-id=\"122713\" data-permalink=\"https:\/\/support.questetra.com\/ja\/addons\/excel-find-row\/attachment\/google-sheets-row-range-delete-2022-capture-ja-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-sheets-row-range-delete-2022-capture-ja.png?fit=1200%2C675&amp;ssl=1\" data-orig-size=\"1200,675\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"google-sheets-row-range-delete-2022-capture-ja\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-sheets-row-range-delete-2022-capture-ja.png?fit=1024%2C576&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-sheets-row-range-delete-2022-capture-ja.png?fit=1200%2C675&amp;ssl=1\" alt=\"\u6307\u5b9a\u7bc4\u56f2\u306e\u884c\u3092\u5168\u3066\u524a\u9664\u3057\u307e\u3059\u3002\u5b58\u7d9a\u884c\u306f\u5168\u3066\u4e0a\u65b9\u5411\u306b\u30b7\u30d5\u30c8\u3055\u308c\u307e\u3059\u3002\u958b\u59cb\u884c\u3068\u7d42\u4e86\u884c\u306f\u30bc\u30ed\u59cb\u307e\u308a\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u5024\u3067\u6307\u5b9a\u3057\u307e\u3059\u3002\u306a\u304a\u300c\u958b\u59cb\u30a4\u30f3\u30c7\u30c3\u30af\u30b9:0\u3001\u7d42\u4e86\u30a4\u30f3\u30c7\u30c3\u30af\u30b9:1\u300d\u3068\u6307\u5b9a\u3057\u305f\u5834\u5408\u3001\u5148\u982d\u306e1\u884c\u3060\u3051\u304c\u524a\u9664\u3055\u308c\u307e\u3059\u3002\uff08\u7d42\u4e86\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306f\u6392\u4ed6\u7684\uff09\" class=\"wp-image-122713\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-sheets-row-range-delete-2022-capture-ja.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-sheets-row-range-delete-2022-capture-ja.png?resize=560%2C315&amp;ssl=1 560w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-sheets-row-range-delete-2022-capture-ja.png?resize=1024%2C576&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-sheets-row-range-delete-2022-capture-ja.png?resize=768%2C432&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default q-box\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"795\" height=\"630\" data-attachment-id=\"122717\" data-permalink=\"https:\/\/support.questetra.com\/ja\/addons\/excel-find-row\/attachment\/google-sheets-row-range-delete-2022-config-ja-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-sheets-row-range-delete-2022-config-ja.png?fit=1199%2C950&amp;ssl=1\" data-orig-size=\"1199,950\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"google-sheets-row-range-delete-2022-config-ja\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-sheets-row-range-delete-2022-config-ja.png?fit=795%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-sheets-row-range-delete-2022-config-ja.png?resize=795%2C630&#038;ssl=1\" alt=\"\" class=\"wp-image-122717\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-sheets-row-range-delete-2022-config-ja.png?resize=795%2C630&amp;ssl=1 795w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-sheets-row-range-delete-2022-config-ja.png?resize=398%2C315&amp;ssl=1 398w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-sheets-row-range-delete-2022-config-ja.png?resize=768%2C609&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-sheets-row-range-delete-2022-config-ja.png?w=1199&amp;ssl=1 1199w\" sizes=\"auto, (max-width: 795px) 100vw, 795px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-book\"><\/i> Appendix<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u540c\u6642\u7de8\u96c6\u306b\u3088\u308a\u3001\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u884c\u3068\u524a\u9664\u884c\u304c\u30ba\u30ec\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002<\/li>\n\n\n\n<li>\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3092\u904e\u53bb\u30d0\u30fc\u30b8\u30e7\u30f3\u306b\u5fa9\u5143\u3057\u305f\u3044\u5834\u5408\u3001\u30d5\u30a1\u30a4\u30eb\u306e &#8220;\u5909\u66f4\u5c65\u6b74&#8221; \u306b\u30a2\u30af\u30bb\u30b9\u3057\u307e\u3059\u3002\n<ul class=\"wp-block-list\">\n<li>(Google \u5f62\u5f0f\u306e) &#8220;\u30d5\u30a1\u30a4\u30eb\u306e\u5909\u66f4\u5185\u5bb9\u3092\u78ba\u8a8d\u3059\u308b&#8221;<\/li>\n\n\n\n<li>&#8220;\u5bb9\u91cf\u7bc0\u7d04\u306e\u305f\u3081\u3001\u30d5\u30a1\u30a4\u30eb\u306e\u7248\u304c\u7d71\u5408\u3055\u308c\u308b\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002&#8221;<\/li>\n\n\n\n<li><a href=\"https:\/\/support.google.com\/docs\/answer\/190843\" rel=\"nofollow\">https:\/\/support.google.com\/docs\/answer\/190843<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>&#8220;HTTP\u8a8d\u8a3c&#8221;\uff08OAuth2\uff09\u306e\u8a2d\u5b9a\u4f8b\n<ul class=\"wp-block-list\">\n<li>Authorization Endpoint URL:\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/accounts.google.com\/o\/oauth2\/v2\/auth?access_type=offline&#038;prompt=consent\" rel=\"nofollow\">https:\/\/accounts.google.com\/o\/oauth2\/v2\/auth?access_type=offline&#038;prompt=consent<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Token Endpoint URL:\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/oauth2.googleapis.com\/token\" rel=\"nofollow\">https:\/\/oauth2.googleapis.com\/token<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Scope:\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.googleapis.com\/auth\/spreadsheets\" rel=\"nofollow\">https:\/\/www.googleapis.com\/auth\/spreadsheets<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Client ID, Consumer Secret:\n<ul class=\"wp-block-list\">\n<li>( from <a href=\"https:\/\/console.developers.google.com\/\" rel=\"nofollow\">https:\/\/console.developers.google.com\/<\/a> )<\/li>\n\n\n\n<li>Redirect URLs: <a href=\"https:\/\/s.questetra.net\/oauth2callback\" rel=\"nofollow\">https:\/\/s.questetra.net\/oauth2callback<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>(OFFICIAL) <a href=\"https:\/\/developers.google.com\/identity\/protocols\/oauth2\/web-server#httprest\" rel=\"nofollow\">https:\/\/developers.google.com\/identity\/protocols\/oauth2\/web-server#httprest<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-balance-scale\"><\/i> See also<\/h3>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-questetra-support wp-block-embed-questetra-support\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"gUoJmE7lQ1\"><a href=\"https:\/\/support.questetra.com\/ja\/addons\/google-sheets-sheet-append-tsv\/\">Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: Sheet, TSV\u30c7\u30fc\u30bf\u3092\u8ffd\u8a18<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: Sheet, TSV\u30c7\u30fc\u30bf\u3092\u8ffd\u8a18&#8221; &#8212; Questetra Support\" src=\"https:\/\/support.questetra.com\/ja\/addons\/google-sheets-sheet-append-tsv\/embed\/#?secret=gzjSklHsjh#?secret=gUoJmE7lQ1\" data-secret=\"gUoJmE7lQ1\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>\u6307\u5b9a\u7bc4\u56f2\u306e\u884c\u3092\u5168\u3066\u524a\u9664\u3057\u307e\u3059\u3002\u5b58\u7d9a\u884c\u306f\u5168\u3066\u4e0a\u65b9\u5411\u306b\u30b7\u30d5\u30c8\u3055\u308c\u307e\u3059\u3002\u958b\u59cb\u884c\u3068\u7d42\u4e86\u884c\u306f\u30bc\u30ed\u59cb\u307e\u308a\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u5024\u3067\u6307\u5b9a\u3057\u307e\u3059\u3002\u306a\u304a\u300c\u958b\u59cb\u30a4\u30f3\u30c7\u30c3\u30af\u30b9:0\u3001\u7d42\u4e86\u30a4\u30f3\u30c7\u30c3\u30af\u30b9:1\u300d\u3068\u6307\u5b9a\u3057\u305f\u5834\u5408\u3001\u5148\u982d\u306e1\u884c\u3060\u3051\u304c\u524a\u9664\u3055\u308c\u307e\u3059\u3002\uff08\u7d42\u4e86\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306f\u6392\u4ed6\u7684\uff09<\/p>\n","protected":false},"author":2,"featured_media":122713,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_crdt_document":"","_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"advanced_seo_description":"\u6307\u5b9a\u7bc4\u56f2\u306e\u884c\u3092\u5168\u3066\u524a\u9664\u3057\u307e\u3059\u3002\u5b58\u7d9a\u884c\u306f\u5168\u3066\u4e0a\u65b9\u5411\u306b\u30b7\u30d5\u30c8\u3055\u308c\u307e\u3059\u3002\u958b\u59cb\u884c\u3068\u7d42\u4e86\u884c\u306f\u30bc\u30ed\u59cb\u307e\u308a\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u5024\u3067\u6307\u5b9a\u3057\u307e\u3059\u3002\u306a\u304a\u300c\u958b\u59cb\u30a4\u30f3\u30c7\u30c3\u30af\u30b9:0\u3001\u7d42\u4e86\u30a4\u30f3\u30c7\u30c3\u30af\u30b9:1\u300d\u3068\u6307\u5b9a\u3057\u305f\u5834\u5408\u3001\u5148\u982d\u306e1\u884c\u3060\u3051\u304c\u524a\u9664\u3055\u308c\u307e\u3059\u3002\uff08\u7d42\u4e86\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306f\u6392\u4ed6\u7684\uff09","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","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},"_wpas_customize_per_network":false},"categories":[169],"tags":[431,3163,451],"class_list":["post-122722","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons","tag-google-sheets-api-v4","tag-google-workspace-ja","tag-tsv-csv"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-sheets-row-range-delete-2022-capture-ja.png?fit=1200%2C675&ssl=1","uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-sheets-row-range-delete-2022-capture-ja.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-sheets-row-range-delete-2022-capture-ja.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-sheets-row-range-delete-2022-capture-ja.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-sheets-row-range-delete-2022-capture-ja.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-sheets-row-range-delete-2022-capture-ja.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-sheets-row-range-delete-2022-capture-ja.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-sheets-row-range-delete-2022-capture-ja.png?fit=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-sheets-row-range-delete-2022-capture-ja.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-sheets-row-range-delete-2022-capture-ja.png?resize=900%2C675&ssl=1",900,675,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-sheets-row-range-delete-2022-capture-ja.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-sheets-row-range-delete-2022-capture-ja.png?resize=800%2C600&ssl=1",800,600,true],"newspack-article-block-portrait-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-sheets-row-range-delete-2022-capture-ja.png?resize=600%2C675&ssl=1",600,675,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-sheets-row-range-delete-2022-capture-ja.png?resize=800%2C675&ssl=1",800,675,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-sheets-row-range-delete-2022-capture-ja.png?resize=600%2C450&ssl=1",600,450,true],"newspack-article-block-portrait-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-sheets-row-range-delete-2022-capture-ja.png?resize=450%2C600&ssl=1",450,600,true],"newspack-article-block-square-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-sheets-row-range-delete-2022-capture-ja.png?resize=600%2C600&ssl=1",600,600,true],"newspack-article-block-landscape-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-sheets-row-range-delete-2022-capture-ja.png?resize=400%2C300&ssl=1",400,300,true],"newspack-article-block-portrait-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-sheets-row-range-delete-2022-capture-ja.png?resize=300%2C400&ssl=1",300,400,true],"newspack-article-block-square-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-sheets-row-range-delete-2022-capture-ja.png?resize=400%2C400&ssl=1",400,400,true],"newspack-article-block-landscape-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-sheets-row-range-delete-2022-capture-ja.png?resize=200%2C150&ssl=1",200,150,true],"newspack-article-block-portrait-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-sheets-row-range-delete-2022-capture-ja.png?resize=150%2C200&ssl=1",150,200,true],"newspack-article-block-square-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-sheets-row-range-delete-2022-capture-ja.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-sheets-row-range-delete-2022-capture-ja.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"IMAMURA, Genichi","author_link":"https:\/\/support.questetra.com\/ja\/author\/imamuragenichi\/"},"uagb_comment_info":0,"uagb_excerpt":"\u6307\u5b9a\u7bc4\u56f2\u306e\u884c\u3092\u5168\u3066\u524a\u9664\u3057\u307e\u3059\u3002\u5b58\u7d9a\u884c\u306f\u5168\u3066\u4e0a\u65b9\u5411\u306b\u30b7\u30d5\u30c8\u3055\u308c\u307e\u3059\u3002\u958b\u59cb\u884c\u3068\u7d42\u4e86\u884c\u306f\u30bc\u30ed\u59cb\u307e\u308a\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u5024\u3067&hellip;","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-vVo","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":111990,"url":"https:\/\/support.questetra.com\/ja\/addons\/multiline-string-get-range-lines-2021\/","url_meta":{"origin":122722,"position":0},"title":"\u8907\u6570\u884c\u6587\u5b57\u5217, \u7bc4\u56f2\u884c\u306e\u53d6\u5f97","author":"IMAMURA, Genichi","date":"2021-08-30","format":false,"excerpt":"\u6307\u5b9a\u7bc4\u56f2\u306e\u884c\u3092\u62bd\u51fa\u3057\u307e\u3059\u3002\u62bd\u51fa\u7bc4\u56f2\u306f\u958b\u59cb\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3068\u7d42\u4e86\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3067\u6307\u5b9a\u3055\u308c\u307e\u3059\u3002\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306f\u2026","rel":"","context":"\u30a2\u30c9\u30aa\u30f3","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"\u8907\u6570\u884c\u6587\u5b57\u5217, \u7bc4\u56f2\u884c\u306e\u53d6\u5f97","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-get-range-lines-2021-nocode-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-get-range-lines-2021-nocode-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-get-range-lines-2021-nocode-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-get-range-lines-2021-nocode-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/multiline-string-get-range-lines-2021-nocode-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":119770,"url":"https:\/\/support.questetra.com\/ja\/developer-blog\/google-sheets-employee-master\/","url_meta":{"origin":122722,"position":1},"title":"Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u793e\u54e1\u60c5\u5831\u3092\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30a2\u30d7\u30ea\u3067\u7ba1\u7406\u3059\u308b","author":"Hirotaka NISHI","date":"2022-03-16","format":false,"excerpt":"Questetra \u304b\u3089 Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u7ba1\u7406\u3055\u308c\u3066\u3044\u308b\u300c\u793e\u54e1\u60c5\u5831\u300d\u3092\u64cd\u4f5c\u3059\u308b\u30a2\u30d7\u30ea\u2026","rel":"","context":"Questetra Developers Blog","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/ja\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/03\/featured-google-sheet-employee-master-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/03\/featured-google-sheet-employee-master-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/03\/featured-google-sheet-employee-master-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/03\/featured-google-sheet-employee-master-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/03\/featured-google-sheet-employee-master-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":174814,"url":"https:\/\/support.questetra.com\/ja\/addons\/tsv-string-extract-range-columns-2025\/","url_meta":{"origin":122722,"position":2},"title":"#TSV\u6587\u5b57\u5217: \u7bc4\u56f2\u5217\u306e\u62bd\u51fa","author":"IMAMURA, Genichi","date":"2025-07-10","format":false,"excerpt":"\u6307\u5b9a\u306e\u5217\u7bc4\u56f2\u3092\u62bd\u51fa\u3057\u307e\u3059\u3002\u62bd\u51fa\u7bc4\u56f2\u306fSTART\u5217\u304b\u3089END\u5217\u624b\u524d\u307e\u3067\uff08END\u306f\u542b\u307e\u306a\u3044\uff09\u3067\u3059\u3002\u30a4\u30f3\u30c7\u2026","rel":"","context":"\u30a2\u30c9\u30aa\u30f3","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/07\/tsv-string-extract-range-columns-2025-ja.png?fit=1200%2C628&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/07\/tsv-string-extract-range-columns-2025-ja.png?fit=1200%2C628&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/07\/tsv-string-extract-range-columns-2025-ja.png?fit=1200%2C628&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/07\/tsv-string-extract-range-columns-2025-ja.png?fit=1200%2C628&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/07\/tsv-string-extract-range-columns-2025-ja.png?fit=1200%2C628&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":106500,"url":"https:\/\/support.questetra.com\/ja\/addons\/google-sheets-two-valueranges-xlookup-reference-2021\/","url_meta":{"origin":122722,"position":3},"title":"Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: 2\u3064\u306e\u7bc4\u56f2\u30c7\u30fc\u30bf, Xlookup\u53c2\u7167","author":"IMAMURA, Genichi","date":"2024-02-28","format":false,"excerpt":"2\u3064\u306e\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u9818\u57df\u3092\u53c2\u7167\u3057\u3066\u3001\u6587\u5b57\u5217b\u3092\u6587\u5b57\u5217c\u306b\u5909\u63db\u3057\u307e\u3059\u3002\u3059\u306a\u308f\u3061\u3001\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u7bc4\u2026","rel":"","context":"\u30a2\u30c9\u30aa\u30f3","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: 2\u3064\u306e\u7bc4\u56f2\u30c7\u30fc\u30bf, Xlookup\u53c2\u7167","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/Google-Sheets-Two-ValueRanges-Xlookup-Reference-2021-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":84387,"url":"https:\/\/support.questetra.com\/ja\/addons\/google-sheets-master-table-simple-xlookup\/","url_meta":{"origin":122722,"position":4},"title":"Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: \u30de\u30b9\u30bf\u30fc\u30c6\u30fc\u30d6\u30eb, \u30b7\u30f3\u30d7\u30eb Xlookup","author":"IMAMURA, Genichi","date":"2020-02-06","format":false,"excerpt":"Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u5185\u306e\u30de\u30b9\u30bf\u30c7\u30fc\u30bf\u3092\u53c2\u7167\u3057\u3066\u5024\u3092\u8fd4\u3057\u307e\u3059\u3002\u914d\u5217C\u306e\u4e2d\u306b\u691c\u7d22\u8a9e\u3092\u691c\u7d22\u3057\u3001\u5b8c\u2026","rel":"","context":"\u30a2\u30c9\u30aa\u30f3","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: \u30de\u30b9\u30bf\u30fc\u30c6\u30fc\u30d6\u30eb, \u30b7\u30f3\u30d7\u30eb Xlookup","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Google-Sheets-Master-Table-Simple-Xlookup-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Google-Sheets-Master-Table-Simple-Xlookup-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Google-Sheets-Master-Table-Simple-Xlookup-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Google-Sheets-Master-Table-Simple-Xlookup-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Google-Sheets-Master-Table-Simple-Xlookup-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":111598,"url":"https:\/\/support.questetra.com\/ja\/developer-blog\/gmail-start\/","url_meta":{"origin":122722,"position":5},"title":"Gmail \u306e\u53d7\u4fe1\u306b\u3088\u308a\u30d7\u30ed\u30bb\u30b9\u3092\u958b\u59cb\u3059\u308b","author":"Hirotaka NISHI","date":"2024-10-17","format":false,"excerpt":"Google Workspace \u306e Gmail \u306e\u53d7\u4fe1\u3092\u76e3\u8996\u3057\u3001\u6307\u5b9a\u3057\u305f\u6761\u4ef6\u306e\u30e1\u30fc\u30eb\u304c\u53d7\u4fe1\u3055\u308c\u308c\u3070\u2026","rel":"","context":"Questetra Developers Blog","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/ja\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/eye-catch-gmail-start.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/eye-catch-gmail-start.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/eye-catch-gmail-start.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/eye-catch-gmail-start.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/eye-catch-gmail-start.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"amp_enabled":false,"_links":{"self":[{"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/posts\/122722","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/comments?post=122722"}],"version-history":[{"count":4,"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/posts\/122722\/revisions"}],"predecessor-version":[{"id":149927,"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/posts\/122722\/revisions\/149927"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/media\/122713"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/media?parent=122722"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/categories?post=122722"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/tags?post=122722"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}