{"id":67292,"date":"2024-02-27T11:45:06","date_gmt":"2024-02-27T02:45:06","guid":{"rendered":"https:\/\/support.questetra.com\/?p=67292"},"modified":"2024-02-27T11:51:19","modified_gmt":"2024-02-27T02:51:19","slug":"googlesheets-appendcells","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/bpmn-icons\/googlesheets-appendcells\/","title":{"rendered":"Google Sheets: Append New Row"},"content":{"rendered":"\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"58\" data-attachment-id=\"113160\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/how-to-use-timer-start-event\/attachment\/advanced-banner-new-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/advanced-banner-new-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=\"advanced-banner-new-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/advanced-banner-new-en.png?fit=1024%2C58&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/advanced-banner-new-en-1024x58.png?resize=1024%2C58&#038;ssl=1\" alt=\"\" class=\"wp-image-113160\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/advanced-banner-new-en.png?resize=1024%2C58&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/advanced-banner-new-en.png?resize=600%2C34&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/advanced-banner-new-en.png?resize=768%2C44&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/advanced-banner-new-en.png?w=1200&amp;ssl=1 1200w\" 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<h4 class=\"wp-block-heading has-border-color has-product-main-border-color has-white-color has-product-main-background-color has-text-color has-background has-link-color\" style=\"border-width:2px;margin-top:0;margin-right:0;margin-bottom:0;margin-left:0;padding-top:var(--wp--preset--spacing--10);padding-right:var(--wp--preset--spacing--20);padding-bottom:var(--wp--preset--spacing--10);padding-left:var(--wp--preset--spacing--20)\"><strong>Google Sheets: Append New Row<\/strong><\/h4>\n\n\n\n<p class=\"has-text-align-right has-border-color has-product-main-border-color has-white-color has-product-main-background-color has-text-color has-background has-link-color has-small-font-size mt-0 pt-0 wp-block-paragraph\" style=\"border-width:2px;margin-top:0;margin-right:0;margin-bottom:0;margin-left:0;padding-top:0;padding-right:var(--wp--preset--spacing--20);padding-bottom:0;padding-left:var(--wp--preset--spacing--20)\"><a href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/googlesheets-appendcells\/\">Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: \u884c\u8ffd\u52a0<\/a><\/p>\n\n\n\n<p class=\"has-border-color has-product-main-border-color has-text-color has-white-background-color has-background has-link-color mt-0 pt-0 wp-block-paragraph\" style=\"border-width:2px;margin-top:0;margin-right:0;margin-bottom:var(--wp--preset--spacing--30);margin-left:0;padding-top:var(--wp--preset--spacing--20);padding-right:var(--wp--preset--spacing--20);padding-bottom:var(--wp--preset--spacing--20);padding-left:var(--wp--preset--spacing--20)\">This item adds a row at the last of the sheet, and fills each cell of that row with data.<\/p>\n\n\n\n<figure class=\"wp-block-image alignright has-custom-border is-style-default\"><img decoding=\"async\" src=\"data:image;base64,\niVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAADbElEQVRYR8WXS0hUURjH\/2dGJFDz\nlqNimmORhAU5hRVFojgTQSTarl3azN5x1aboQdAqGoVc2AyOFoGCpQuN7E6MRIVW4BBZUqJkbYTw\n+H7M48Sdx3Ve986d0crFuDjfd8\/v+5\/vcQ7Bf\/4jyezPWfX1IKQKDDoAHIj\/P8AwBoCCYAwETnqF\n71f63YQAXEc1B19aE8DMAOGUfZhRgFig8rTQRieV85EF4Gw1DQC5r3zj6K0YBUMjNTn6pCAkATir\n3gJCmpRFnNDKQo18czyruACcVW8HIZcTfjYpA2anRkdjtEsMQHjkvefuoqawQvTxMV8w54S8Y2DM\n\/4uhmRGUZhfj9gcbBn+8lcZirIWaHOZwgwiAwJmrOkIGzro2lOeUJozzxcwITuYf8ts1v2lB39Sw\nHMTF8JwQAQLZrp4KT7hkAbj0LMxvLOHquwfonuQlIBiFyrsvVB2bADbDTQA3wr1SARD8F9zLuD7a\njq6JQSklblEjL+yHTQCrQWgk2akC7FCnY2d6hug+uzqHSy+vSapAjY5dIkCwwz2LtlaqwNz6Ihbd\nyxHuK551nHpqSpgLfgWkal4pQLxdlj1rKOqqTVgRAQCbwQmgKlUFUgIAhqmRrw4pMA1CtHIAK541\nLGxEyhxtr1apkbsjMC4SK4AxauKPhhRg8aIIPwLX7294NPEch3fvR\/d3HpUFOuzJ0IhuHuYF\/\/M9\nus\/eUQYgjE8jT5ICGJoZhU5TivbxPpwvPo2izLxNAJ8X9omBFAGs+oRHICjw6tdHHNMcRNvnXtRq\nz2BvZr4I4PZ58PBLfxIAzEWNDp3iJBQAeiYdOJJzAJ1fB2AoOoHCzFwRwOvzon\/6dRIAkUkYd\/RG\n58Do7DgqcsvQ+qkHdSWV0GYVRChwz\/VEOUBwMIWqQLhqyTaibU9CxvxDSXErFspwyb0q3VgAqAiB\nRkkZMsxTE++v120ZRik0ojjDSBjH3rTp8IH0V1oxwzzUnpKYcRxoyZEXkqELrTieVyYru9Si0DW1\nj+tjl4NnH1qQvZKltLO8kyi9JEBwOm7\/pZSxTmpyNETz\/atreUzksgqEFv0XFRB79E1J8dEICQfW\nkNLDRIQIPM3MYDArBhE2JhCeZpYtPc2iIw0ogmoQogMYB5DygA1zAYSCMeGR6pSLWHEOKJZ5i4Z\/\nAEwJzTC2ALrNAAAAAElFTkSuQmCC\n\" alt=\"Auto Step icon\" class=\"has-border-color has-ast-global-color-4-border-color\" style=\"border-width:0.5em\"\/><\/figure>\n\n\n\n<div class=\"wp-block-coblocks-accordion\">\n<div class=\"wp-block-coblocks-accordion-item\"><details open><summary class=\"wp-block-coblocks-accordion-item__title\">Basic Configs<\/summary><div class=\"wp-block-coblocks-accordion-item__content\">\n<dl style=\"0 0 -0.7em 0\">\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #C3C3C3;\"><\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">Step Name<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #C3C3C3;\"><\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">Note<\/dd>\n<\/dl>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-coblocks-accordion\">\n<div class=\"wp-block-coblocks-accordion-item\"><details open><summary class=\"wp-block-coblocks-accordion-item__title\">Configs for this Auto Step<\/summary><div class=\"wp-block-coblocks-accordion-item__content\">\n<dl style=\"0 0 -0.7em 0\">\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #C3C3C3;\">conf_OAuth2<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C1: OAuth2 Setting<span style=\"color:#990000;\"> *<\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #C3C3C3;\">conf_DataIdW<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C2: Target Spreadsheet ID<span style=\"color:#990000;\"> *<\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #C3C3C3;\">conf_DataIdX<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C3: Target Sheet Title<span style=\"color:#990000;\"> *<\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #C3C3C3;\">conf_RowNum<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C4: Data item to save the appended row number<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #C3C3C3;\">conf_DataIdA<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C-A: Column-A Value of New Row<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #C3C3C3;\">conf_DataIdB<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C-B: Column-B Value of New Row<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #C3C3C3;\">conf_DataIdC<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C-C: Column-C Value of New Row<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #C3C3C3;\">conf_DataIdD<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C-D: Column-D Value of New Row<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #C3C3C3;\">conf_DataIdE<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C-E: Column-E Value of New Row<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #C3C3C3;\">conf_DataIdF<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C-F: Column-F Value of New Row<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #C3C3C3;\">conf_DataIdG<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C-G: Column-G Value of New Row<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #C3C3C3;\">conf_DataIdH<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C-H: Column-H Value of New Row<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #C3C3C3;\">conf_DataIdI<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C-I: Column-I Value of New Row<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #C3C3C3;\">conf_DataIdJ<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C-J: Column-J Value of New Row<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/dd>\n\n<\/dl>\n<\/div><\/details><\/div>\n<\/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>Spreadsheet ID is contained in the URL.\u3000https:\/\/docs.google.com\/spreadsheets\/d\/SPREADSHEETID\/edit#gid=0<\/li>\n\n\n\n<li>If you want to add after the 11th column (K column)\n<ul class=\"wp-block-list\">\n<li>use &#8220;<a href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-google-sheets-row-update\/\">Google Sheets: Update Row<\/a>&#8221; together\n<ul class=\"wp-block-list\">\n<li>Specify and update after &#8220;k column&#8221; of [Added row]<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>replace with &#8220;<a href=\"https:\/\/support.questetra.com\/en\/addons\/google-sheets-sheet-append-tsv\/\">Google Sheets: Sheet, Append TSV<\/a>&#8220;\uff08Add-on Auto-Steps\uff09&nbsp;&nbsp;<img data-recalc-dims=\"1\" decoding=\"async\"  src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-3-1.png?w=60&#038;ssl=1\"><\/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-large\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/googlesheets-appendcells_capture_en.png?ssl=1\" alt=\"\" style=\"border:10px solid #aaaaaa; padding:5px; margin:5px;\"><\/figure>\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\/bpmn-icons\/intermediate-error-catch-event-boundary-type\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Intermediate Error Catch Event (Boundary Type)\n(opens in a new tab)\">Intermediate Error Catch Event (Boundary Type)<\/a><\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-coblocks-accordion\">\n<div class=\"wp-block-coblocks-accordion-item\"><details><summary class=\"wp-block-coblocks-accordion-item__title\">Script (click to open)<\/summary><div class=\"wp-block-coblocks-accordion-item__content\">\n<ul class=\"wp-block-list\">\n<li>An XML file that contains the code below is available to download\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/raw.githubusercontent.com\/Questetra\/Addon-XML\/release-2024-02-13\/google-sheets-row-append.xml\" target=\"_blank\" rel=\"noreferrer noopener\">google-sheets-row-append.xml<\/a> (C) Questetra, Inc. (MIT License)<\/li>\n\n\n\n<li>If you are using Professional, you can modify the contents of this file and use it as your own add-on auto step<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-js\" data-lang=\"JavaScript\"><code>\n\/\/ OAuth2 config sample at [OAuth 2.0 Setting]\n\/\/ - Authorization Endpoint URL: https:\/\/accounts.google.com\/o\/oauth2\/auth?access_type=offline&amp;approval_prompt=force\n\/\/ - Token Endpoint URL: https:\/\/accounts.google.com\/o\/oauth2\/token\n\/\/ - Scope: https:\/\/www.googleapis.com\/auth\/spreadsheets\n\/\/ - Consumer Key: (Get by Google Developers Console)\n\/\/ - Consumer Secret: (Get by Google Developers Console)\n\nfunction main(){\n  \/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\n  const oauth2 = configs.getObject(&quot;conf_OAuth2&quot;);\n  const spreadsheetId = retrieveStringData( &quot;conf_DataIdW&quot;, &quot;Target Spreadsheet ID&quot; );\n  const sheetName = retrieveStringData( &quot;conf_DataIdX&quot;, &quot;Target Sheet Title&quot; );\n  const rowNumDef = configs.getObject( &quot;conf_RowNum&quot; );\n\n  const columns = [&quot;A&quot;, &quot;B&quot;, &quot;C&quot;, &quot;D&quot;, &quot;E&quot;, &quot;F&quot;, &quot;G&quot;, &quot;H&quot;, &quot;I&quot;, &quot;J&quot;];\n  const dataArray = columns.map( i =&gt; configs.get( `conf_DataId${i}` ) );\n\n  \/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\n  const row = buildRowObj(dataArray);\n  const sheetId = getSheetId(oauth2, spreadsheetId, sheetName); \/\/ Access to the API 1st(Get GID)\n  appendRow(oauth2, spreadsheetId, sheetId, row); \/\/ Access to the API 2nd(POST)\n  if(rowNumDef === null) return;\n\n  \/\/ only when rowNumDef is not null\n  const rowNum = getLastRowNum(oauth2, spreadsheetId, sheetName); \/\/ Access to the API 3rd(GET)\n\n  \/\/\/\/ == \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 \/ Data Updating ==\n  engine.setData(rowNumDef, rowNum);\n}\n\n\/**\n * \u6587\u5b57\u5217\u30c7\u30fc\u30bf\u3092 config \u304b\u3089\u8aad\u307f\u51fa\u3059\u3002\u7a7a\u3067\u3042\u308c\u3070\u30a8\u30e9\u30fc\u3002\n * @param  {String} confName config \u540d\n * @param  {String} label \u30a8\u30e9\u30fc\u30e1\u30c3\u30bb\u30fc\u30b8\u7528\u306e\u30e9\u30d9\u30eb\n * @return {String} string \u6587\u5b57\u5217\u30c7\u30fc\u30bf\n *\/\nfunction retrieveStringData( confName, label ){\n  let string = configs.get( confName );\n  const dataDef = configs.getObject( confName );\n  if (dataDef !== null) {\n    string = engine.findData(dataDef);\n  }\n  if (string === null || string === &quot;&quot;) {\n    throw `${label} is empty.`;\n  }\n  return string;\n}\n\n\/**\n * \u6587\u5b57\u5217\u30c7\u30fc\u30bf\u3092\u6240\u5b9a\u306e\u5f62\u5f0f\u306e\u30bb\u30eb\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u5909\u63db\u3059\u308b\u3002\n * @param  {String} data \u6587\u5b57\u5217\u30c7\u30fc\u30bf\n * @return {Object} cellObj \u6587\u5b57\u5217\u30c7\u30fc\u30bf\u304c\u683c\u7d0d\u3055\u308c\u305f\u30bb\u30eb\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\n *\/\nfunction buildCellObj( data ){\n  const cellObj = {};\n  cellObj.userEnteredValue = {};\n  if( data === &quot;&quot; || data === null){\n    cellObj.userEnteredValue.stringValue = &quot;&quot;;\n    return cellObj;\n  }else{ \/\/ for &quot;STRING&quot;\n    if(data.length &gt; 50000){\n      throw &quot;Can&apos;t set text over 50,000 characters.&quot;;\n    }\n    cellObj.userEnteredValue.stringValue = data;\n    return cellObj;\n  }\n}\n\n\/**\n * \u6587\u5b57\u5217\u30c7\u30fc\u30bf\u3092\u6240\u5b9a\u306e\u5f62\u5f0f\u306e\u884c\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u5909\u63db\u3059\u308b\u3002\n * @param  {Array&lt;String&gt;} dataArray \u6587\u5b57\u5217\u30c7\u30fc\u30bf\u306e\u914d\u5217\n * @return {Object} rowObj \u6587\u5b57\u5217\u30c7\u30fc\u30bf\u304c\u683c\u7d0d\u3055\u308c\u305f\u884c\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\n *\/\nfunction buildRowObj( dataArray ){\n  const rowObj = {};\n  rowObj.values = dataArray.map( data =&gt; buildCellObj( data ) );\n\n  \/\/ \u5f8c\u308d\u304b\u3089\u7a7a\u767d\u306e\u8981\u7d20\u6570\u3092\u6570\u3048\u308b\n  let count = 0;\n  for(let i = rowObj.values.length; i &gt; 0; i--) {\n    if(rowObj.values[i-1].userEnteredValue.stringValue === &quot;&quot;){\n      count++;\n    }else{ \/\/ \u7a7a\u767d\u3067\u306a\u3051\u308c\u3070\u3001\u30eb\u30fc\u30d7\u304b\u3089\u629c\u3051\u308b\n      break;\n    }\n  }\n\n  \/\/ \u7a7a\u767d\u90e8\u5206\u3092\u524a\u9664\n  if(count &gt; 0){\n    rowObj.values = rowObj.values.slice(0, -count);\n  }\n\n  \/\/ \u3059\u3079\u3066\u304c\u7a7a\u767d\u306a\u3089\u30a8\u30e9\u30fc\n  if(rowObj.values.length === 0){\n    throw &quot;No Data to add is set.&quot;;\n  }\n\n  return rowObj;\n}\n\n\/**\n * GET \u30ea\u30af\u30a8\u30b9\u30c8\u3092\u9001\u4fe1\u3057\u3001\u30b7\u30fc\u30c8 ID (GID) \u3092\u53d6\u5f97\u3059\u308b\u3002\n * @param {AuthSettingWrapper} oauth  OAuth2 \u8a8d\u8a3c\u8a2d\u5b9a\n * @param {String} spreadsheetId \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8 ID\n * @param {String} sheetName \u30b7\u30fc\u30c8\u540d\n * @return {Number} sheetId \u30b7\u30fc\u30c8 ID (GID)\n *\/\nfunction getSheetId(oauth2, spreadsheetId, sheetName){\n  const uri = `https:\/\/sheets.googleapis.com\/v4\/spreadsheets\/${encodeURIComponent(spreadsheetId)}?includeGridData=false`;\n  const response = httpClient.begin()\n    .authSetting(oauth2)\n    .get(uri);\n  const status = response.getStatusCode();\n  const responseStr = response.getResponseAsString();\n  if (status !== 200) {\n    engine.log(responseStr);\n    throw `Failed to get sheet information. status: ${status}`;\n  }\n  const jsonObj = JSON.parse(responseStr);\n  engine.log(`SPREADSHEET (TITLE: ${jsonObj.properties.title}) has ${jsonObj.sheets.length} sheets`);\n  for (let i = 0; i &lt; jsonObj.sheets.length; i++) {\n    if (jsonObj.sheets[i].properties.title === sheetName) {\n      const sheetId = parseInt(jsonObj.sheets[i].properties.sheetId, 10);\n      engine.log(`SHEET TITLE: ${sheetName} exists (id: ${sheetId})`);\n      return sheetId;\n    }\n  }\n  \/\/ error (not exist)\n  throw `Sheet ${sheetName} does not exist`;\n}\n\n\/**\n * \u884c\u8ffd\u52a0\u306e\u30ea\u30af\u30a8\u30b9\u30c8\u30dc\u30c7\u30a3\u3092\u751f\u6210\u3059\u308b\u3002\n * @param  {Number} sheetId \u30b7\u30fc\u30c8 ID (GID)\n * @return {Object} row \u884c\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\n *\/\nfunction buildRequestObj(sheetId, row){\n  const requestObj = {};\n  requestObj.requests = [];\n  requestObj.requests[0] = {};\n  requestObj.requests[0].appendCells = {};\n  requestObj.requests[0].appendCells.sheetId = sheetId;\n  requestObj.requests[0].appendCells.fields = &quot;*&quot;;\n  requestObj.requests[0].appendCells.rows = [];\n  requestObj.requests[0].appendCells.rows[0] = row;\n  return requestObj;\n}\n\n\/**\n * \u884c\u8ffd\u52a0\u306e POST \u30ea\u30af\u30a8\u30b9\u30c8\u3092\u9001\u4fe1\u3059\u308b\u3002\n * @param {AuthSettingWrapper} oauth  OAuth2 \u8a8d\u8a3c\u8a2d\u5b9a\n * @param {String} spreadsheetId \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8 ID\n * @param {Number} sheetId \u30b7\u30fc\u30c8 ID (GID)\n * @param {Object} row \u884c\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\n *\/\nfunction appendRow(oauth2, spreadsheetId, sheetId, row){\n  const apiUri = `https:\/\/sheets.googleapis.com\/v4\/spreadsheets\/${encodeURIComponent(spreadsheetId)}:batchUpdate`;\n  const requestObj = buildRequestObj(sheetId, row);\n  const response = httpClient.begin()\n    .authSetting( oauth2 )\n    .body( JSON.stringify( requestObj ), &quot;application\/json&quot; )\n    .post( apiUri ); \/\/ HttpResponseWrapper\n  const httpStatus = response.getStatusCode();\n  if( httpStatus !== 200 ){\n    engine.log(response.getResponseAsString());\n    throw `Failed to append data. status: ${httpStatus}`;\n  }\n}\n\n\/**\n * GET \u30ea\u30af\u30a8\u30b9\u30c8\u3092\u9001\u4fe1\u3057\u3001\u30c7\u30fc\u30bf\u304c\u5165\u529b\u3055\u308c\u3066\u3044\u308b\u6700\u7d42\u884c\u306e\u884c\u756a\u53f7\u3092\u8fd4\u3059\u3002\n * @param {AuthSettingWrapper} oauth  OAuth2 \u8a8d\u8a3c\u8a2d\u5b9a\n * @param {String} spreadsheetId \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8 ID\n * @param {String} sheetName \u30b7\u30fc\u30c8\u540d\n * @return {String} \u30c7\u30fc\u30bf\u304c\u5165\u529b\u3055\u308c\u3066\u3044\u308b\u6700\u7d42\u884c\u306e\u884c\u756a\u53f7\n *\/\nfunction getLastRowNum(oauth2, spreadsheetId, sheetName){\n  const range = `&apos;${sheetName}&apos;`; \/\/ \u30b7\u30fc\u30c8\u540d\u304c\u30bb\u30eb\u6307\u5b9a\u3084\u540d\u524d\u4ed8\u304d\u7bc4\u56f2\u3068\u3057\u3066\u8aa4\u3063\u3066\u89e3\u91c8\u3055\u308c\u306a\u3044\u3088\u3046\u3001\u30b7\u30f3\u30b0\u30eb\u30af\u30a9\u30fc\u30c8\u3067\u56f2\u3080\n  const apiUri = `https:\/\/sheets.googleapis.com\/v4\/spreadsheets\/${encodeURIComponent(spreadsheetId)}\/values\/${encodeURIComponent(range)}`;\n  const response = httpClient.begin()\n    .authSetting( oauth2 )\n    .queryParam( &quot;majorDimension&quot;, &quot;ROWS&quot; )\n    .get( apiUri ); \/\/ HttpResponseWrapper\n  const httpStatus = response.getStatusCode();\n  const responseStr = response.getResponseAsString();\n  if( httpStatus !== 200 ){\n    engine.log(responseStr);\n    throw `Failed to get rows in the sheet. status: ${httpStatus}`;\n  }\n  const jsonObj = JSON.parse(responseStr);\n  return jsonObj.values.length.toString();\n}\n\n<\/code><\/pre><\/div>\n<\/div><\/details><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>This item adds a row at the last of the sheet, and fills each cell of that row with data.<\/p>\n","protected":false},"author":17,"featured_media":110732,"comment_status":"closed","ping_status":"closed","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":"","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":"","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":[551],"tags":[392,396,3162],"class_list":["post-67292","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bpmn-icons","tag-beareroauth2token","tag-google-sheets-api-v4","tag-google-workspace"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/11\/bpmn-icon-google-sheets.png?fit=1200%2C675&ssl=1","uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/11\/bpmn-icon-google-sheets.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/11\/bpmn-icon-google-sheets.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/11\/bpmn-icon-google-sheets.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/11\/bpmn-icon-google-sheets.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/11\/bpmn-icon-google-sheets.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/11\/bpmn-icon-google-sheets.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/11\/bpmn-icon-google-sheets.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\/11\/bpmn-icon-google-sheets.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\/11\/bpmn-icon-google-sheets.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\/11\/bpmn-icon-google-sheets.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\/11\/bpmn-icon-google-sheets.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\/11\/bpmn-icon-google-sheets.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\/11\/bpmn-icon-google-sheets.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\/11\/bpmn-icon-google-sheets.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\/11\/bpmn-icon-google-sheets.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\/11\/bpmn-icon-google-sheets.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\/11\/bpmn-icon-google-sheets.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\/11\/bpmn-icon-google-sheets.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\/11\/bpmn-icon-google-sheets.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\/11\/bpmn-icon-google-sheets.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\/11\/bpmn-icon-google-sheets.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\/11\/bpmn-icon-google-sheets.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/11\/bpmn-icon-google-sheets.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"Shiho Tatsumi","author_link":"https:\/\/support.questetra.com\/en\/author\/tatsumi48c607ec82\/"},"uagb_comment_info":0,"uagb_excerpt":"This item adds a row at the last of the sheet, and fills each cell of that row with data.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-hvm","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":67292,"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":97147,"url":"https:\/\/support.questetra.com\/ja\/addons\/google-sheets-sheet-row-update-with-singleline-tsv\/","url_meta":{"origin":67292,"position":1},"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":67294,"url":"https:\/\/support.questetra.com\/ja\/bpmn-icons\/googlesheets-appendcells\/","url_meta":{"origin":67292,"position":2},"title":"Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: \u884c\u8ffd\u52a0","author":"Shiho Tatsumi","date":"2024-02-27","format":false,"excerpt":"\u3053\u306e\u5de5\u7a0b\u306f\u3001\u30b7\u30fc\u30c8\u672b\u5c3e\u306b\uff11\u884c\u8ffd\u52a0\u3057\u3001\u305d\u306e\u5404\u30bb\u30eb\u306b\u30c7\u30fc\u30bf\u3092\u5165\u529b\u3057\u307e\u3059\u3002","rel":"","context":"In &quot;BPMN\u30a2\u30a4\u30b3\u30f3&quot;","block_context":{"text":"BPMN\u30a2\u30a4\u30b3\u30f3","link":"https:\/\/support.questetra.com\/ja\/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":81014,"url":"https:\/\/support.questetra.com\/en\/addons\/google-sheets-values-sum-numbers\/","url_meta":{"origin":67292,"position":3},"title":"Google Sheets: Values, Sum Numbers","author":"IMAMURA, Genichi","date":"2019-10-18","format":false,"excerpt":"Sums the numeric values in the specified range. Values that cannot be recognized as numeric values are regarded as zero. Two ranges of simultaneous calculations are also supported. e.g. The budgeting progress in the general ledger is summarized.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/Google-Sheets-Values-Sum-Numbers-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\/10\/Google-Sheets-Values-Sum-Numbers-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/Google-Sheets-Values-Sum-Numbers-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/Google-Sheets-Values-Sum-Numbers-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/Google-Sheets-Values-Sum-Numbers-en.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":67292,"position":4},"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":67321,"url":"https:\/\/support.questetra.com\/en\/addons\/googlesheets-sumnumberscom\/","url_meta":{"origin":67292,"position":5},"title":"Sum of cells in a Google Sheets (comma removal version)","author":"Hirotaka NISHI","date":"2016-09-13","format":false,"excerpt":"Stores the sum of specified range of a Google Sheet in a Numeric-type Data Item, and stores its communication log in a String-type Data Item. Comma removal version corresponds to the case where the decimal separator \u201c,\u201d is mixed *Note \u201c+3.14\u201d: 3.14, \u201c314e-2\u201d: 3.14, \u201c090\u201d: 90, \u201c2016-12-23\u201d: 2016, \u2018Begin with\u2026","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2016\/09\/google-sheets-sum-numbers-comma-header.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2016\/09\/google-sheets-sum-numbers-comma-header.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2016\/09\/google-sheets-sum-numbers-comma-header.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2016\/09\/google-sheets-sum-numbers-comma-header.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2016\/09\/google-sheets-sum-numbers-comma-header.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\/67292","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\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=67292"}],"version-history":[{"count":41,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/67292\/revisions"}],"predecessor-version":[{"id":158509,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/67292\/revisions\/158509"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/110732"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=67292"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=67292"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=67292"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}