{"id":113812,"date":"2024-02-27T12:15:21","date_gmt":"2024-02-27T03:15:21","guid":{"rendered":"https:\/\/support.questetra.com\/?p=113812"},"modified":"2024-03-04T12:41:00","modified_gmt":"2024-03-04T03:41:00","slug":"service-task-google-sheets-row-update","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-google-sheets-row-update\/","title":{"rendered":"Google Sheets: Update 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-background\" style=\"background-color:#ccffcc;margin-top:var(--wp--preset--spacing--30);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)\"><strong>Google Sheets: Update Row<\/strong><\/h4>\n\n\n\n<p class=\"has-text-align-right has-background has-small-font-size mt-0 pt-0 wp-block-paragraph\" style=\"background-color:#ccffcc;margin-top:0;margin-right:0;margin-bottom:0;margin-left:0;padding-top:0;padding-right:var(--wp--preset--spacing--30);padding-bottom:0;padding-left:var(--wp--preset--spacing--30)\"><a href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-google-sheets-row-update\/\">Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: \u884c\u66f4\u65b0<\/a><\/p>\n\n\n\n<p class=\"has-background mt-0 pt-0 wp-block-paragraph\" style=\"background-color:#f0fff0;margin-top:0;margin-right:0;margin-bottom:var(--wp--preset--spacing--60);margin-left:0;padding-top:var(--wp--preset--spacing--20);padding-right:var(--wp--preset--spacing--30);padding-bottom:var(--wp--preset--spacing--20);padding-left:var(--wp--preset--spacing--40)\">This item updates data in a specified row of a Google Sheet.<\/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: #aaa;\">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: #aaa;\">conf_SheetId<\/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: #aaa;\">conf_SheetTitle<\/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: #aaa;\">conf_ValueInputOption<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C4: How values should be interpreted when updating row<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">conf_RowNo<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C5: Row to Update (e.g. &#8220;1&#8221;, &#8220;11&#8221;)<span style=\"color:#990000;\"> *<\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">conf_Range<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C6: Column Range to Update (e.g. &#8220;A:J&#8221;)(Up to 10 columns)<span style=\"color:#990000;\"> *<\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">conf_Column1<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C7_1: Value that is updated in the 1st column <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: #aaa;\">conf_Column2<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C7_2: Value that is updated in the 2nd column<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: #aaa;\">conf_Column3<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C7_3: Value that is updated in the 3rd column <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: #aaa;\">conf_Column4<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C7_4: Value that is updated in the 4th column <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: #aaa;\">conf_Column5<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C7_5: Value that is updated in the 5th column <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: #aaa;\">conf_Column6<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C7_6: Value that is updated in the 6th column <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: #aaa;\">conf_Column7<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C7_7: Value that is updated in the 7th column <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: #aaa;\">conf_Column8<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C7_8: Value that is updated in the 8th column <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: #aaa;\">conf_Column9<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C7_9: Value that is updated in the 9th column <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: #aaa;\">conf_Column10<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C7_10: Value that is updated in the 10 column <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>When [C4: How values should be interpreted when updating cells] is\n<ul class=\"wp-block-list\">\n<li>not selected or &#8220;as RAW values&#8221;, the new values will be saved as string, as it is\n<ul class=\"wp-block-list\">\n<li>For example, when the new value is &#8220;=1+2&#8221;, the updated cell value is a string &#8220;=1+2&#8221; (not treated as a formula)<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>&#8220;as USER_ENTERED values&#8221;, the new values will be interpreted in the same way as when you enter the values on Google Sheets\n<ul class=\"wp-block-list\">\n<li>For example, when the new value is &#8220;=1+2&#8221;, it will be interpreted and saved as a formula<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n\n<h3 class=\"wp-block-heading\" style=\"margin-top:var(--wp--preset--spacing--60)\"><span style=\"text-decoration: underline;\">Capture<\/span><\/h3>\n\n\n\n<figure class=\"wp-block-image size-large has-custom-border is-style-rounded is-style-rounded--1\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/02\/Google-%E3%82%B9%E3%83%97%E3%83%AC%E3%83%83%E3%83%89%E3%82%B7%E3%83%BC%E3%83%88_%E8%A1%8C%E6%9B%B4%E6%96%B0_%E8%8B%B1%E8%AA%9E_16_0.png?ssl=1\" alt=\"\" class=\"has-border-color wp-image-157859\" style=\"border-color:#009900;border-width:3px;border-radius:9px\"\/><\/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\/\">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-08\/google-sheets-row-update.xml\" target=\"_blank\" rel=\"noreferrer noopener\">google-sheets-row-update.xml<\/a> (C) Questetra, In. (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\n\/\/ OAuth2 config\n\/\/ Authorization Endpoint URL: https:\/\/accounts.google.com\/o\/oauth2\/auth?access_type=offline&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\nconst COLUMN_MAX_NUM = 10;\n\nfunction main(){\n\n  \/\/\/\/ == \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 \/ Config Retrieving ==\n  const oauth = configs.getObject(&quot;conf_OAuth2&quot;);\n  const sheetId = retrieveStringData( &quot;conf_SheetId&quot;, &quot;Target Spreadsheet ID&quot; );\n  const sheetTitle = retrieveStringData( &quot;conf_SheetTitle&quot;, &quot;Target Sheet Title&quot; );\n  const rowNo = retrieveRowNo();\n  const range = configs.get( &quot;conf_Range&quot; );\n  checkRowNoAndRange( rowNo, range );\n  const rangeArr = range.split(&#39;:&#39;);\n  const dataArray = retrieveRowValues(rangeArr);\n\n  let valueInputOption = configs.get(&#39;conf_ValueInputOption&#39;);\n  if (valueInputOption === &#39;&#39;) {\n    valueInputOption = &#39;RAW&#39;;\n  }\n  \n  \/\/\/\/ == \u6f14\u7b97 \/ Calculating ==\n  updateRowData( oauth, sheetId, sheetTitle, valueInputOption, rowNo, rangeArr, dataArray  );\n\n}\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\/**\n  * config \u304b\u3089\u884c\u756a\u53f7 \u3092\u8aad\u307f\u51fa\u3059\n  * @return {String} rowNo  \u884c\u756a\u53f7\n  *\/\nfunction retrieveRowNo() {\n  const rowNoDef = configs.getObject( &quot;conf_RowNo&quot; );\n  return engine.findData( rowNoDef );\n}\n\n\n\/**\n  * \u5217\u7bc4\u56f2 \u306e\u6700\u521d\u306e\u5217\u3068\u6700\u7d42\u306e\u5217\u304b\u3089 \u66f4\u65b0\u5217\u6570\u3092\u8aad\u307f\u51fa\u3057\u3001\u66f4\u65b0\u5f8c\u306e\u5024\u3092\u5217\u6570\u5206\u3060\u3051\u683c\u7d0d\u3059\u308b\n  * @param {Array&lt;String&gt;} rangeArr \u66f4\u65b0\u3059\u308b\u5217\u7bc4\u56f2\u306e\u6700\u521d\u306e\u5217\u3068\u6700\u7d42\u306e\u5217\u304c\u683c\u7d0d\u3055\u308c\u305f\u914d\u5217\n  * @return {Array&lt;String&gt;} dataArray \u66f4\u65b0\u5f8c\u306e\u5024\u306e\u914d\u5217\n  *\/\nfunction retrieveRowValues(rangeArr) {\n  const dataArray = [];\n  let columnNum = lettersToNumber(rangeArr[1]) - lettersToNumber(rangeArr[0]) + 1;\n  if (columnNum &lt;= 0) {\n    throw &quot;Invalid Range.&quot;;\n  }\n  if (columnNum &gt; COLUMN_MAX_NUM) {\n    columnNum = COLUMN_MAX_NUM;\n  }\n  for (let i = 0; i &lt; columnNum; i++) {    \n    const value = configs.get(`conf_Column${i+1}`);\n    if(value.length &gt; 50000){\n      throw &quot;Can&#39;t set text over 50,000 characters.&quot;;\n    }\n    dataArray.push(value);\n  }\n  return dataArray;\n}\n\n\n\/**\n  * \u884c\u756a\u53f7\u304c\u7a7a\u3001\u4e0d\u6b63\u306a\u6587\u5b57\u5217\u3067\u3042\u308c\u3070\u30a8\u30e9\u30fc\u3068\u3059\u308b\n  * \u5217\u7bc4\u56f2\u304c\u4e0d\u9069\u5207\u306a\u6587\u5b57\u5217\u3067\u3042\u308c\u3070\u30a8\u30e9\u30fc\u3068\u3059\u308b\n  * @param {String} rowNo  \u884c\u756a\u53f7\n  * @param {String} range  \u5217\u7bc4\u56f2\n  *\/\nfunction checkRowNoAndRange( rowNo, range ) {\n  if ( rowNo === &quot;&quot; || rowNo === null ) {\n    throw &quot;Row number is empty.&quot;;\n  }\n  if ( !isValidNo(rowNo) ) {\n    throw &quot;Invalid Row number.&quot;;\n  }\n  if ( !isValidRange(range) ) {\n    throw &quot;Invalid Range.&quot;;\n  }\n}\n\n\n\/**\n  * \u884c\u756a\u53f7 \u304c\u6709\u52b9\u304b\uff08\u81ea\u7136\u6570\u304b\uff09\u3092\u5224\u5b9a\u3059\u308b\n  * @param {String} noString  \u884c\u756a\u53f7 \u306e\u6587\u5b57\u5217\n  * @return {Boolean}  \u6709\u52b9\u306a \u884c\u756a\u53f7 \u304b\u3069\u3046\u304b\n  *\/\nfunction isValidNo( noString ) {\n  const idReg = new RegExp( &#39;^[1-9][0-9]*$&#39; );\n  return idReg.test( noString );\n}\n\n\n\/**\n  * \u5217\u7bc4\u56f2 \u304c\u6709\u52b9\u304b\u3092\u5224\u5b9a\u3059\u308b\n  * @param {String} rangeString  \u5217\u7bc4\u56f2 \u306e\u6587\u5b57\u5217\n  * @return {Boolean}  \u6709\u52b9\u306a \u5217\u7bc4\u56f2 \u304b\u3069\u3046\u304b\n  *\/\nfunction isValidRange( rangeString ) {\n  const idReg = new RegExp( &#39;^[A-Z]+:[A-Z]+$&#39; );\n  return idReg.test( rangeString );\n}\n\n\n\/**\n * Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u884c\u30c7\u30fc\u30bf\u3092\u66f4\u65b0\n * @param {AuthSettingWrapper} oauth  OAuth2 \u8a8d\u8a3c\u8a2d\u5b9a\n * @param {String} sheetId \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e ID\n * @param {String} sheetTitle \u30b7\u30fc\u30c8\u540d\n * @param {String} rowNo \u66f4\u65b0\u3059\u308b\u884c\n * @param {Array&lt;String&gt;} rangeArr \u66f4\u65b0\u3059\u308b\u5217\u7bc4\u56f2\u306e\u6700\u521d\u306e\u5217\u3068\u6700\u7d42\u306e\u5217\u304c\u683c\u7d0d\u3055\u308c\u305f\u914d\u5217\n * @param {Array&lt;String&gt;} dataArray \u66f4\u65b0\u5f8c\u306e\u5024\u306e\u914d\u5217\n *\/\nfunction updateRowData( oauth, sheetId, sheetTitle, valueInputOption, rowNo, rangeArr, dataArray  ) {\n\n  const enSheetId = encodeURIComponent(sheetId);\n  const enSheetTitle = encodeURIComponent(sheetTitle);\n  \n  const requestObj = buildRequestObj(dataArray);\n  \n  \/\/ Method: spreadsheets.values.update\n  const uri = `https:\/\/sheets.googleapis.com\/v4\/spreadsheets\/${enSheetId}\/values\/${enSheetTitle}!${rangeArr[0]}${rowNo}:${rangeArr[1]}${rowNo}`;\n  const response = httpClient.begin()\n    .authSetting( oauth )\n    .queryParam( &quot;valueInputOption&quot;,  valueInputOption )\n    .body( JSON.stringify( requestObj ), &quot;application\/json&quot; )\n    .put( uri );\n  const status = response.getStatusCode();\n  const responseStr = response.getResponseAsString();\n  if (status !== 200) {\n    const accessLog = `---GET request--- ${status}\\n${responseStr}`;\n    engine.log( accessLog );\n    throw `Failed to update. status:${status}`;\n  }\n}\n\n\n\/**\n  * config\u304b\u3089\u66f4\u65b0\u60c5\u5831\u3092\u8aad\u307f\u51fa\u3057\u3001JSON \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u8fd4\u3059\n  * @param {Array&lt;String&gt;} dataArray \u66f4\u65b0\u5f8c\u306e\u5024\u306e\u914d\u5217\n  * @return {Object} requestObj  JSON \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\n  *\/\nfunction buildRequestObj( dataArray ) {\n  const requestObj = {};\n  requestObj.majorDimension = &quot;ROWS&quot;;\n  requestObj.values = [];\n  requestObj.values.push(dataArray);\n  return requestObj;\n}\n\n\n\/\/ convert A to 1, Z to 26, AA to 27\nfunction lettersToNumber(letters){\n  const chrs = &#39; ABCDEFGHIJKLMNOPQRSTUVWXYZ&#39;;\n  const mode = chrs.length - 1;\n  let number = 0;\n  for(let p = 0; p &lt; letters.length; p++){\n    number = number * mode + chrs.indexOf(letters[p]);\n  }\n  return number;\n}\n\n<\/code><\/pre><\/div>\n<\/div><\/details><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>This item updates data in a specified row of a Google Sheet.<\/p>\n","protected":false},"author":17,"featured_media":110732,"comment_status":"closed","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":"","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":[551],"tags":[396,396,3162],"class_list":["post-113812","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bpmn-icons","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":2,"uagb_excerpt":"This item updates data in a specified row of a Google Sheet.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-tBG","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":113812,"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":81186,"url":"https:\/\/support.questetra.com\/en\/addons\/google-sheets-values-export-as-tsv\/","url_meta":{"origin":113812,"position":1},"title":"Google Sheets: Values, Export as TSV","author":"IMAMURA, Genichi","date":"2021-02-01","format":false,"excerpt":"Exports the values in the rectangular range as TSV text, which has the same number of tab delimiters on each line. Empty cells are regarded as the null string. Two range export are also supported: e.g. Freezed headings and recent data.","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-Export-as-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\/2019\/10\/Google-Sheets-Values-Export-as-TSV-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-Export-as-TSV-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-Export-as-TSV-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-Export-as-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":113812,"position":2},"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":81014,"url":"https:\/\/support.questetra.com\/en\/addons\/google-sheets-values-sum-numbers\/","url_meta":{"origin":113812,"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":67292,"url":"https:\/\/support.questetra.com\/en\/bpmn-icons\/googlesheets-appendcells\/","url_meta":{"origin":113812,"position":4},"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":84381,"url":"https:\/\/support.questetra.com\/en\/addons\/google-sheets-master-table-simple-xlookup\/","url_meta":{"origin":113812,"position":5},"title":"Google Sheets: Master Table, Simple Xlookup","author":"IMAMURA, Genichi","date":"2020-02-06","format":false,"excerpt":"Returns a value by referencing master data in Google Spreadsheets. Searches for the Lookup Value in array C, and if an exact match, returns the value in array D at the same index. C and D are defined in A1Notation. The length must be the same.","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: Master Table, Simple Xlookup","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Google-Sheets-Master-Table-Simple-Xlookup-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\/02\/Google-Sheets-Master-Table-Simple-Xlookup-en.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-en.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-en.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-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\/113812","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=113812"}],"version-history":[{"count":26,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/113812\/revisions"}],"predecessor-version":[{"id":158705,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/113812\/revisions\/158705"}],"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=113812"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=113812"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=113812"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}