{"id":96354,"date":"2020-10-14T13:16:23","date_gmt":"2020-10-14T04:16:23","guid":{"rendered":"https:\/\/support.questetra.com\/?p=96354"},"modified":"2026-04-27T15:52:29","modified_gmt":"2026-04-27T06:52:29","slug":"google-sheets-sheet-append-tsv","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/google-sheets-sheet-append-tsv\/","title":{"rendered":"Google Sheets: Sheet, Append TSV"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"68\" data-attachment-id=\"89186\" data-permalink=\"https:\/\/support.questetra.com\/en\/maintenance\/maintenance-20251117\/attachment\/professional-banner-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?fit=1200%2C68&amp;ssl=1\" data-orig-size=\"1200,68\" 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=\"professional-banner-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?fit=1024%2C58&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=1200%2C68&#038;ssl=1\" alt=\"\" class=\"wp-image-89186\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=600%2C34&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=1024%2C58&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=768%2C44&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><div class=\"su-box su-box-style-default\" id=\"\" style=\"border-color:#003e04;border-radius:0px;max-width:none\"><div class=\"su-box-title\" style=\"background-color:#267137;color:#ffffff;border-top-left-radius:0px;border-top-right-radius:0px\">Google Sheets: Sheet, Append TSV<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:0px;border-bottom-right-radius:0px\"> Adds the TSV dataset after the last row. New rows will be inserted into the sheet if necessary. Only the specified columns of TSV are added, column ID with an identifier &#8220;d&#8221; as Datetime, and column ID with an identifier &#8220;n&#8221; as Numeric; eg &#8220;0,2d,5n&#8221;.<\/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>A: Select Authorization Setting (OAuth2)<span style=\"color:#990000;\"> *<\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-edit fa-lg\"><\/i><\/span> B: Set TSV dataset<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> C: Set Column IDs to be Thrown (e.g. &#8220;0,1,5d,3n,6&#8221;)<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> D: Set ID of Spreadsheet into which Dataset will be inserted<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> E: Set ID of Sheet into which Dataset will be inserted<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> E2: Or, Set Name of Sheet into which Dataset will be inserted<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/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\/*\nNOTES\n- An error will occur, if the number of Tab codes on each line is not the same.\n    - Skips lines with only Line Break (blank lines)\n- Numerical String is evaluated with &quot;parseFloat()&quot; after removing the comma.\n    - Nothing is added to the cell that failed to be evaluated.\n- Date String is evaluated with &quot;Date()&quot;\n    - Nothing is added to the cell that failed to be evaluated.\n    - new Date(&#39;December 17, 1995 03:24:00&#39;)\n    - new Date(&#39;1995-12-17T03:24:00&#39;)\n    - new Date(&#39;1995-12-17 03:24&#39;)\n    - new Date(&#39;1995-12-17&#39;)\n        - In case of &quot;YYYY-MM-DD&quot;, &quot;T00:00:00&quot; will be added (interpreted as Local Time)\n        - Other date-only forms are interpreted as a UTC time.\n\n- TSV\u6587\u5b57\u5217\u306e Tab \u30b3\u30fc\u30c9\u306e\u6570\u304c\u5168\u884c\u540c\u6570\u3067\u306a\u3044\u5834\u5408\u3001\u30a8\u30e9\u30fc\u3068\u306a\u308a\u307e\u3059\n    - \u6539\u884c\u306e\u307f\u306e\u884c\uff08\u7a7a\u884c\uff09\u306b\u3064\u3044\u3066\u306f\u3001\u5f53\u8a72\u884c\u3092\u30b9\u30ad\u30c3\u30d7\u3057\u3066\u8aad\u307f\u8fbc\u307f\u307e\u3059\n- \u6570\u5024\u6587\u5b57\u5217\u306f\u3001\u30ab\u30f3\u30de\uff08\u6841\u533a\u5207\u308a\u6587\u5b57\uff09\u304c\u9664\u53bb\u3055\u308c\u305f\u4e0a\u3067\u3001&quot;parseFloat()&quot; \u95a2\u6570\u3067\u8a55\u4fa1\u3055\u308c\u307e\u3059\n    - \u8a55\u4fa1\u306b\u5931\u6557\u3057\u305f\u30bb\u30eb\u306f\u3001\u4f55\u3082\u8ffd\u8a18\u3055\u308c\u307e\u305b\u3093\n- \u65e5\u6642\u6587\u5b57\u5217\u306f\u3001&quot;Date()&quot; \u95a2\u6570\u3067\u8a55\u4fa1\u3055\u308c\u307e\u3059\n    - \u8a55\u4fa1\u306b\u5931\u6557\u3057\u305f\u30bb\u30eb\u306f\u3001\u4f55\u3082\u8ffd\u8a18\u3055\u308c\u307e\u305b\u3093\n    - new Date(&#39;December 17, 1995 03:24:00&#39;)\n    - new Date(&#39;1995-12-17T03:24:00&#39;)\n    - new Date(&#39;1995-12-17 03:24&#39;)\n    - new Date(&#39;1995-12-17&#39;)\n        - \u306a\u304a &quot;YYYY-MM-DD&quot; \u66f8\u5f0f\u306e\u5834\u5408 &quot;T00:00:00&quot; \u304c\u81ea\u52d5\u4ed8\u52a0\uff08\u30ed\u30fc\u30ab\u30eb\u30bf\u30a4\u30e0\u5316\uff09\u3055\u308c\u307e\u3059\n        - \u305d\u306e\u4ed6\u306e\u300c\u65e5\u4ed8\u306e\u307f\u306e\u5f62\u5f0f\u300d\u306f UTC \u6642\u523b\u3068\u89e3\u91c8\u3055\u308c\u307e\u3059\n*\/\n\n\/\/\/\/\/\/\/\/ START &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\nmain();\nfunction main(){ \n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst strOauthSetting       = configs.get( &quot;OAuth2ConfA&quot; );   \/\/ required\nconst strTsv                = configs.get( &quot;StrConfB&quot; ) + &quot;&quot;; \/\/ required\nconst strColIds             = configs.get( &quot;StrConfC&quot; ) + &quot;&quot;; \/\/ required\nconst strDocId              = configs.get( &quot;StrConfD&quot; ) + &quot;&quot;; \/\/ required\nlet   strSheetId            = configs.get( &quot;StrConfE&quot; ) + &quot;&quot;;\nlet   strSheetName          = configs.get( &quot;StrConfE2&quot;) + &quot;&quot;;\n\nif( strTsv === &quot;&quot; ){\n  throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                   &quot; Config {B TSV} not specified \\n&quot; );\n}\nif( strColIds === &quot;&quot; ){\n  throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                   &quot; Config {C Column IDs} not specified \\n&quot; );\n}\nif( strDocId === &quot;&quot; ){\n  throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                   &quot; Config {D Spreadsheet ID} not specified \\n&quot; );\n}\nif( strSheetId === &quot;&quot; ){\n  engine.log( &quot; AutomatedTask ConfigWarning:&quot; +\n              &quot; Config {E Sheet Id} (recommended) is empty&quot; );\n  if( strSheetName === &quot;&quot; ){\n    throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                     &quot; Config {E Sheet (both Id and Name)} not specified \\n&quot; );\n  }\n}\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\n\/\/ (nothing)\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\n\/\/\/ check TSV Dataset\nconst arrTsv        = strTsv.split(&quot;\\n&quot;);\nlet arrTsvSpliced = [];\nfor( let i = 0; i &lt; arrTsv.length; i++ ){ \/\/ Remove Blank Lines\n  if( arrTsv[i] !== &quot;&quot;){\n    arrTsvSpliced.push( arrTsv[i] );\n  }else{\n    engine.log( &quot; AutomatedTask StringWarning: TSV LineId &#39;[&quot; + i +\n                  &quot;]&#39;: empty (skipped as dataset)&quot; );\n  }\n}\nlet arrTsvCells  = [];\nfor( let i = 0; i &lt; arrTsvSpliced.length; i++ ){\n  arrTsvCells[i] = [];\n  let arrTmp = arrTsvSpliced[i].split(&quot;\\t&quot;);\n  for( let j = 0; j &lt; arrTmp.length; j++ ){\n    arrTsvCells[i].push( arrTmp[j] );\n  }\n  if( i !== 0 ){\n    if( arrTsvCells[0].length !== arrTsvCells[i].length ){\n      throw new Error( &quot;\\n AutomatedTask UnexpectedTsvError:&quot; +\n                       &quot; Dataset TSV not matrix \\n&quot; );\n    }\n  }\n}\nengine.log( &quot; AutomatedTask TSV Loaded: Number of Rows (Lines) &quot; + arrTsvSpliced.length );\nengine.log( &quot; AutomatedTask TSV Loaded: Number of Columns &quot; + arrTsvCells[0].length );\n\nconst arrColIds = strColIds.split(&quot;,&quot;);\nengine.log( &quot; AutomatedTask Column Ids to be inserted: &quot; +\n              strColIds + &quot; (&quot; + arrColIds.length + &quot;)&quot; );\n\n\n\/\/\/ check Spreadsheet (SheetName to SheetId)\nconst token  = httpClient.getOAuth2Token( strOauthSetting );\nif( strSheetId === &quot;&quot; ){\n  \/\/ prepare request1\n  \/\/ ref) https:\/\/developers.google.com\n  \/\/            \/sheets\/api\/reference\/rest\/v4\/spreadsheets\/get\n  let uri1     = &quot;https:\/\/sheets.googleapis.com\/v4\/spreadsheets\/&quot; +\n                  strDocId;\n  let request1 = httpClient.begin(); \/\/ HttpRequestWrapper\n      request1 = request1.bearer( token );\n  engine.log( &quot; AutomatedTask ApiRequest1 Prepared&quot; );\n\n  \/\/ post request1\n  const response1     = request1.get( uri1 );       \/\/ HttpResponseWrapper\n  engine.log( &quot; AutomatedTask ApiRequest1 Start: &quot; + uri1 );\n  const response1Code = response1.getStatusCode() + &quot;&quot;; \/\/ (primitive string)\n  const response1Body = response1.getResponseAsString() + &quot;&quot;;\n  engine.log( &quot; AutomatedTask ApiResponse Status: &quot; + response1Code );\n  if( 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\n  \/* engine.log( response1Body ); \/\/ debug\n  response sample\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\/17rw......OfHdxxxxRCLM\/edit&quot;\n  }\n  *\/\n  const response1Obj = JSON.parse( response1Body );\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 {E2 Sheet Name} does not exist \\n&quot; );\n\n  }\n}\/\/ end_of: if( strSheetId === &quot;&quot; )\n\n\n\/\/\/ append Dataset to Sheet\n\/\/ prepare request2\n\/\/ ref) https:\/\/developers.google.com\n\/\/            \/sheets\/api\/reference\/rest\/v4\/spreadsheets\/request#appendcellsrequest\nlet request2Obj = {};\n    request2Obj.requests = [];\n    request2Obj.requests[0] = {};\n    request2Obj.requests[0].appendCells = {};\n    request2Obj.requests[0].appendCells.rows = [];\n    request2Obj.requests[0].appendCells.sheetId = strSheetId;\n    request2Obj.requests[0].appendCells.fields = &quot;*&quot;;\nconst regBpmsYMD = \/^\\d{4}-\\d{2}-\\d{2}$\/;\nfor( let i = 0; i &lt; arrTsvCells.length; i++ ){\n  request2Obj.requests[0].appendCells.rows[i] = {};\n  request2Obj.requests[0].appendCells.rows[i].values = [];\n  for( let j = 0; j &lt; arrColIds.length; j++ ){\n    request2Obj.requests[0].appendCells.rows[i].values[j] = {};\n    if( arrColIds[j].slice(-1) === &quot;n&quot; ){ \/\/ Numeric Type\n      request2Obj.requests[0].appendCells.rows[i].values[j].userEnteredValue = {};\n      request2Obj.requests[0].appendCells.rows[i].values[j].userEnteredValue.numberValue =\n                parseFloat( arrTsvCells[i][parseInt( arrColIds[j] )].replace(\/,\/g, &quot;&quot;) );\n    }else if( arrColIds[j].slice(-1) === &quot;d&quot; ){ \/\/ Date Type in Sheet\n      let strDatetimeTmp = arrTsvCells[i][parseInt( arrColIds[j] )];\n      if( regBpmsYMD.test( strDatetimeTmp ) ){\n        strDatetimeTmp += &quot;T00:00:00&quot;;\n      }\n      let dateTmp   = new Date( strDatetimeTmp );\n      let numSerial = dateTmp.getTime() \/ 86400000 + 25569;\n      \/\/ - https:\/\/developers.google.com\/sheets\/api\/reference\/rest\/v4\/DateTimeRenderOption\n      \/\/ 25569 means 1970-01-01 00:00:00, 86400 means the number of seconds per day\n      numSerial += engine.getTimeZoneOffsetInMinutes() \/ (60 * 24); \/\/ WorkflowPlatform TimeZone\n      request2Obj.requests[0].appendCells.rows[i].values[j].userEnteredFormat = {};\n      request2Obj.requests[0].appendCells.rows[i].values[j].userEnteredFormat.numberFormat = {};\n      request2Obj.requests[0].appendCells.rows[i].values[j].userEnteredFormat.numberFormat.type = &quot;DATE&quot;;\n      request2Obj.requests[0].appendCells.rows[i].values[j].userEnteredValue = {};\n      request2Obj.requests[0].appendCells.rows[i].values[j].userEnteredValue.numberValue =\n                                                                               numSerial;\n    }else{\n      request2Obj.requests[0].appendCells.rows[i].values[j].userEnteredValue = {};\n      request2Obj.requests[0].appendCells.rows[i].values[j].userEnteredValue.stringValue =\n                                                arrTsvCells[i][parseInt( arrColIds[j] )];\n    }\n  }\n}\nlet uri2     = &quot;https:\/\/sheets.googleapis.com\/v4\/spreadsheets\/&quot; +\n                strDocId + &quot;:batchUpdate&quot;;\nlet request2 = httpClient.begin(); \/\/ HttpRequestWrapper\n    request2 = request2.bearer( token );\n    request2 = request2.body( JSON.stringify( request2Obj ), &quot;application\/json&quot; );\nengine.log( &quot; AutomatedTask ApiRequest2 Prepared&quot; );\n\n\/\/ post request2\nconst response2     = request2.post( uri2 );       \/\/ HttpResponseWrapper\nengine.log( &quot; AutomatedTask ApiRequest2 Start: &quot; + uri2 );\nconst response2Code = response2.getStatusCode() + &quot;&quot;; \/\/ (primitive string)\nconst response2Body = response2.getResponseAsString() + &quot;&quot;;\nengine.log( &quot; AutomatedTask ApiResponse2 Status: &quot; + response2Code );\nif( 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\/\/ parse response2\n\/\/ (nothing)\n\/* engine.log( response2Body ); \/\/ debug\nresponse sample\n{\n  &quot;spreadsheetId&quot;: &quot;1rviXXXXXHcRYYYYjFN1ZZZZfM6EWWWWqifaVVVVzgSM&quot;,\n  &quot;replies&quot;: [\n    {}\n  ]\n}\n*\/\n\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\n\/\/ (nothing)\n\n\n} \/\/\/\/\/\/\/\/ END &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\n\n\/*\nAPPENDIX\n- &quot;SpreadsheetID&quot; and &quot;SheetID&quot; in URL\n    - https:\/\/docs.google.com\/spreadsheets\/d\/SPREADSHEETID\/edit#gid=SHEETID\n- To Get &quot;ClientId&quot; and &quot;Secret&quot;\n    - Access to https:\/\/console.developers.google.com\/apis\/credentials\n- This request requires authorization with at least one of the following scopes:\n    - https:\/\/www.googleapis.com\/auth\/drive\n    - https:\/\/www.googleapis.com\/auth\/drive.file\n    - https:\/\/www.googleapis.com\/auth\/spreadsheets\n- OAuth Setting sample\n    - &quot;Authorization Endpoint URL&quot;\n        - https:\/\/accounts.google.com\/o\/oauth2\/auth?access_type=offline&approval_prompt=force\n    - &quot;Token Endpoint URL&quot;\n        - https:\/\/accounts.google.com\/o\/oauth2\/token\n    - &quot;Scope&quot;\n        - https:\/\/www.googleapis.com\/auth\/spreadsheets\n- Error Log sample (Tab codes not constant)\n    - AutomatedTask UnexpectedTsvError: Dataset TSV not matrix \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\/1o6zO10FRH-KREv3eKkOldQo01RLnVaCC\/view?usp=drivesdk\" target=\"_blank\">Google-Sheets-Sheet-Append-Tsv.xml<\/a>\n<ul class=\"wp-block-list\">\n<li>2020-10-13 (C) Questetra, Inc. (MIT License)<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"https:\/\/drive.google.com\/file\/d\/1Afad4GZlz3KTGHSlpgWzEO7EQVEwe4RI\/view?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\">Google-Sheets-Sheet-Append-Tsv-2023.xml<\/a>\n<ul class=\"wp-block-list\">\n<li>2023-08-15 (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\n\n\n<li><a href=\"https:\/\/drive.google.com\/file\/d\/1XyLHQKw8kjkuTPSZ6pGUG3kHwVUBuaO0\/view?usp=sharing\">google-sheets-sheet-append-tsv-2026.xml<\/a>\n<ul class=\"wp-block-list\">\n<li>2026-04-26 (C) Questetra, Inc. (MIT License)<\/li>\n\n\n\n<li>Due to the deprecation of the methods <code>getOAuth2Token(String)<\/code> at v18.<\/li>\n\n\n\n<li><a href=\"https:\/\/support.questetra.com\/ja\/versions\/version-180\/\">https:\/\/support.questetra.com\/ja\/versions\/version-180\/<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p class=\"has-text-align-right has-small-font-size wp-block-paragraph\"> The Addon-import feature is available with <span style=\"background-color:rgba(0, 0, 0, 0);color:#4a86e8\" class=\"has-inline-color\"><strong>Professional<\/strong><\/span> edition.<\/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>An error will occur if the number of Tab codes on each line is not the same\n<ul class=\"wp-block-list\">\n<li>Skips lines containing only a line break (blank lines)<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>A Numeric string is evaluated with &#8220;parseFloat()&#8221; after removing the comma\n<ul class=\"wp-block-list\">\n<li>Nothing is added to cells that fail to be evaluated<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>A Date string is evaluated with &#8220;Date()&#8221;\n<ul class=\"wp-block-list\">\n<li>Nothing is added to cells that fail to be evaluated<\/li>\n\n\n\n<li>new Date(&#8216;December 17, 1995 03:24:00&#8217;)<\/li>\n\n\n\n<li>new Date(&#8216;1995-12-17T03:24:00&#8217;)<\/li>\n\n\n\n<li>new Date(&#8216;1995-12-17 03:24&#8217;)<\/li>\n\n\n\n<li>new Date(&#8216;1995-12-17&#8217;)\n<ul class=\"wp-block-list\">\n<li>In the case of &#8220;YYYY-MM-DD&#8221;, &#8220;T00:00:00&#8221; will be added (interpreted as Local Time)<\/li>\n\n\n\n<li>Other date-only forms are interpreted as a UTC time<\/li>\n<\/ul>\n<\/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\/2020\/10\/Google-Sheets-Sheet-Append-TSV-capture-en.png?ssl=1\" target=\"_blank\" rel=\"noopener noreferrer\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"675\" data-attachment-id=\"96357\" data-permalink=\"https:\/\/support.questetra.com\/en\/addons\/google-sheets-sheet-append-tsv\/attachment\/google-sheets-sheet-append-tsv-capture-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-capture-en.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-Sheet-Append-TSV-capture-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-capture-en.png?fit=1024%2C576&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-capture-en.png?resize=1200%2C675&#038;ssl=1\" alt=\"Adds the TSV dataset after the last row. New rows will be inserted into the sheet if necessary. Only the specified columns of TSV are added, column ID with an identifier &quot;d&quot; as Datetime, and column ID with an identifier &quot;n&quot; as Numeric; eg &quot;0,2d,5n&quot;.\" class=\"wp-image-96357\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-capture-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-capture-en.png?resize=560%2C315&amp;ssl=1 560w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-capture-en.png?resize=1024%2C576&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-capture-en.png?resize=768%2C432&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/a><\/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>&#8220;SpreadsheetID&#8221; and &#8220;SheetID&#8221; in URL\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>To Get &#8220;ClientId&#8221; and &#8220;Secret&#8221;\n<ul class=\"wp-block-list\">\n<li>Access to <a href=\"https:\/\/console.developers.google.com\/apis\/credentials\" rel=\"nofollow\">https:\/\/console.developers.google.com\/apis\/credentials<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>This request requires authorization with at least one of the following scopes:\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.googleapis.com\/auth\/drive\" rel=\"nofollow\">https:\/\/www.googleapis.com\/auth\/drive<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.googleapis.com\/auth\/drive.file\" rel=\"nofollow\">https:\/\/www.googleapis.com\/auth\/drive.file<\/a><\/li>\n\n\n\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>OAuth Setting sample\n<ul class=\"wp-block-list\">\n<li>&#8220;Authorization Endpoint URL&#8221;\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/accounts.google.com\/o\/oauth2\/auth?access_type=offline&#038;approval_prompt=force\" rel=\"nofollow\">https:\/\/accounts.google.com\/o\/oauth2\/auth?access_type=offline&#038;approval_prompt=force<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>&#8220;Token Endpoint URL&#8221;\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/accounts.google.com\/o\/oauth2\/token\" rel=\"nofollow\">https:\/\/accounts.google.com\/o\/oauth2\/token<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>&#8220;Scope&#8221;\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<\/ul>\n<\/li>\n\n\n\n<li>Error Log sample (Tab codes not constant)\n<ul class=\"wp-block-list\">\n<li>AutomatedTask UnexpectedTsvError: Dataset TSV not matrix<\/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<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/support.questetra.com\/en\/addons\/google-sheets-spreadsheets-add-sheet\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Google Sheets: Spreadsheets, Add Sheet(opens in a new tab)\">Google Sheets: Spreadsheets, Add Sheet<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/support.questetra.com\/en\/addons\/google-sheets-values-export-as-tsv\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Google Sheets: Values, Export as TSV(opens in a new tab)\">Google Sheets: Values, Export as TSV<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/intermediate-error-catch-event-boundary-type\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Intermediate Error Catch Event (Boundary Type)(opens in a new tab)\">Intermediate Error Catch Event (Boundary Type)<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Adds the TSV dataset after the last row. New rows will be inserted into the sheet if necessary. Only the specified columns of TSV are added, column ID with an identifier &#8220;d&#8221; as Datetime, and column ID with an identifier &#8220;n&#8221; as Numeric; eg &#8220;0,2d,5n&#8221;.<\/p>\n","protected":false},"author":2,"featured_media":96355,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_uag_custom_page_level_css":"","advanced_seo_description":"Adds the TSV dataset after the last row. New rows will be inserted into the sheet if necessary. Only the specified columns of TSV are added, column ID with an identifier \"d\" as Datetime, and column ID with an identifier \"n\" as Numeric; eg \"0,2d,5n\".","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_wpcom_ai_launchpad_first_post":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"{title}\n\n{excerpt}\n\n{url}","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,"jetpack_post_was_ever_published":false},"categories":[168],"tags":[396,3162,389],"class_list":["post-96354","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons","tag-google-sheets-api-v4","tag-google-workspace","tag-tsv-csv"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-en.png?fit=1200%2C675&ssl=1","uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-en.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-en.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-en.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-en.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-en.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-en.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-en.png?fit=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-en.png?resize=900%2C675&ssl=1",900,675,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-en.png?resize=800%2C600&ssl=1",800,600,true],"newspack-article-block-portrait-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-en.png?resize=600%2C675&ssl=1",600,675,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-en.png?resize=800%2C675&ssl=1",800,675,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-en.png?resize=600%2C450&ssl=1",600,450,true],"newspack-article-block-portrait-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-en.png?resize=450%2C600&ssl=1",450,600,true],"newspack-article-block-square-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-en.png?resize=600%2C600&ssl=1",600,600,true],"newspack-article-block-landscape-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-en.png?resize=400%2C300&ssl=1",400,300,true],"newspack-article-block-portrait-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-en.png?resize=300%2C400&ssl=1",300,400,true],"newspack-article-block-square-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-en.png?resize=400%2C400&ssl=1",400,400,true],"newspack-article-block-landscape-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-en.png?resize=200%2C150&ssl=1",200,150,true],"newspack-article-block-portrait-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-en.png?resize=150%2C200&ssl=1",150,200,true],"newspack-article-block-square-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-en.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-en.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"IMAMURA, Genichi","author_link":"https:\/\/support.questetra.com\/en\/author\/imamuragenichi\/"},"uagb_comment_info":12,"uagb_excerpt":"Adds the TSV dataset after the last row. New rows will be inserted into the sheet if necessary. Only the specified columns of TSV are added, column ID with an identifier \"d\" as Datetime, and column ID with an identifier \"n\" as Numeric; eg \"0,2d,5n\".","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-p46","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":97139,"url":"https:\/\/support.questetra.com\/en\/addons\/google-sheets-sheet-row-update-with-singleline-tsv\/","url_meta":{"origin":96354,"position":0},"title":"Google Sheets: Sheet Row, Update with Singleline TSV","author":"IMAMURA, Genichi","date":"2020-10-28","format":false,"excerpt":"Updates a Google Sheet with a single line of TSV data. Searches for an A-Column cell that exactly matches the first value of the TSV and overwrite only the first occurrence. The values will be parsed as if they were entered manually by the user. If no matching line exists,\u2026","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Google Sheets: Sheet Row, Update with Singleline TSV","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Row-Update-with-Singleline-TSV-en.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\/10\/Google-Sheets-Sheet-Row-Update-with-Singleline-TSV-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Row-Update-with-Singleline-TSV-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Row-Update-with-Singleline-TSV-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Row-Update-with-Singleline-TSV-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":96361,"url":"https:\/\/support.questetra.com\/ja\/addons\/google-sheets-sheet-append-tsv\/","url_meta":{"origin":96354,"position":1},"title":"Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: Sheet, TSV\u30c7\u30fc\u30bf\u3092\u8ffd\u8a18","author":"IMAMURA, Genichi","date":"2020-10-14","format":false,"excerpt":"\u6700\u7d42\u884c\u306bTSV\u30c7\u30fc\u30bf\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002\u5fc5\u8981\u3067\u3042\u308c\u3070\u3001\u65b0\u3057\u3044\u884c\u304c\u633f\u5165\u3055\u308c\u307e\u3059\u3002TSV\u306e\u6307\u5b9a\u5217\u3060\u3051\u304c\u8ffd\u8a18\u3055\u308c\u307e\u3059\u3002\u306a\u304a\u3001\u5217ID\u3092\u6307\u5b9a\u3059\u308b\u969b\u306b\"d\"\u3092\u4ed8\u8a18\u3059\u308c\u3070\u65e5\u6642\u30c7\u30fc\u30bf\u3068\u3057\u3066\u3001\"n\"\u3092\u4ed8\u8a18\u3059\u308c\u3070\u6570\u5024\u30c7\u30fc\u30bf\u3068\u3057\u3066\u8ffd\u8a18\u3055\u308c\u307e\u3059\u3002\u5217\u6307\u5b9a\u306e\u4f8b: \"0,2d,5n\"\u3002","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","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: Sheet, TSV\u30c7\u30fc\u30bf\u3092\u8ffd\u8a18","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-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\/10\/Google-Sheets-Sheet-Append-TSV-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":67292,"url":"https:\/\/support.questetra.com\/en\/bpmn-icons\/googlesheets-appendcells\/","url_meta":{"origin":96354,"position":2},"title":"Google Sheets: Append New Row","author":"Shiho Tatsumi","date":"2024-02-27","format":false,"excerpt":"This item adds a row at the last of the sheet, and fills each cell of that row with data.","rel":"","context":"In &quot;BPMN Icons&quot;","block_context":{"text":"BPMN Icons","link":"https:\/\/support.questetra.com\/en\/category\/bpmn-icons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/11\/bpmn-icon-google-sheets.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\/11\/bpmn-icon-google-sheets.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/11\/bpmn-icon-google-sheets.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/11\/bpmn-icon-google-sheets.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/11\/bpmn-icon-google-sheets.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":79781,"url":"https:\/\/support.questetra.com\/en\/data-items\/table-type\/","url_meta":{"origin":96354,"position":3},"title":"Table-Type","author":"Peter Glover","date":"2021-01-22","format":false,"excerpt":"Displays a table that can use the String, Numeric, Select or Date formats.","rel":"","context":"In &quot;Data Items&quot;","block_context":{"text":"Data Items","link":"https:\/\/support.questetra.com\/en\/category\/data-items\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":97147,"url":"https:\/\/support.questetra.com\/ja\/addons\/google-sheets-sheet-row-update-with-singleline-tsv\/","url_meta":{"origin":96354,"position":4},"title":"Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: \u884c\u30c7\u30fc\u30bf, \u5358\u4e00\u884cTSV\u3067\u66f4\u65b0","author":"IMAMURA, Genichi","date":"2020-10-28","format":false,"excerpt":"\u5358\u4e00\u884cTSV\u30c7\u30fc\u30bf\u3067Google\u30b7\u30fc\u30c8\u3092\u66f4\u65b0\u3057\u307e\u3059\u3002TSV\u306e\u5148\u982d\u5024\u3068\u5b8c\u5168\u4e00\u81f4\u3059\u308bA\u30bb\u30eb\u3092\u63a2\u7d22\u3057\u3001\u6700\u521d\u306b\u5408\u81f4\u3057\u305f\u884c\u306b\u3064\u3044\u3066\u4e0a\u66f8\u304d\u3057\u307e\u3059\u3002\u305d\u308c\u305e\u308c\u5024\u306f\u3001\u624b\u5165\u529b\u3057\u305f\u969b\u3068\u540c\u69d8\u306b\u81ea\u52d5\u89e3\u6790\u3055\u308c\u307e\u3059\u3002\u3082\u3057\u5408\u81f4\u3059\u308b\u884c\u304c\u7121\u3044\u5834\u5408\u306f\u3001\u672b\u5c3e\u8ffd\u8a18\u3055\u308c\u307e\u3059\u3002","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","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: \u884c\u30c7\u30fc\u30bf, \u5358\u4e00\u884cTSV\u3067\u66f4\u65b0","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Row-Update-with-Singleline-TSV-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\/10\/Google-Sheets-Sheet-Row-Update-with-Singleline-TSV-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Row-Update-with-Singleline-TSV-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Row-Update-with-Singleline-TSV-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Row-Update-with-Singleline-TSV-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":77695,"url":"https:\/\/support.questetra.com\/en\/templates\/approval-flow-budget-control-20160920\/","url_meta":{"origin":96354,"position":5},"title":"Approval Flow-Budget Control","author":"Hirotaka NISHI","date":"2022-01-17","format":false,"excerpt":"A Proposal-approval flow that automatically records the approved spending in a Google Sheet. When a new Issue is entered at the [1. Submit plan draft] Step, the \u201cBudget Consumption Log\u201d (Google sheet) is referred to, and the total expenditure so far is calculated automatically. At the Step of [2. Decision],\u2026","rel":"","context":"In &quot;Workflow Apps&quot;","block_context":{"text":"Workflow Apps","link":"https:\/\/support.questetra.com\/en\/category\/templates\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-approval-flow-budget-control-20160920-220-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-approval-flow-budget-control-20160920-220-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-approval-flow-budget-control-20160920-220-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-approval-flow-budget-control-20160920-220-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-approval-flow-budget-control-20160920-220-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"amp_enabled":false,"_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/96354","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=96354"}],"version-history":[{"count":8,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/96354\/revisions"}],"predecessor-version":[{"id":183411,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/96354\/revisions\/183411"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/96355"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=96354"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=96354"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=96354"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}