{"id":101595,"date":"2021-02-12T16:26:34","date_gmt":"2021-02-12T07:26:34","guid":{"rendered":"https:\/\/support.questetra.com\/?p=101595"},"modified":"2022-06-09T09:59:47","modified_gmt":"2022-06-09T00:59:47","slug":"google-sheets-spreadsheets-value-update","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/google-sheets-spreadsheets-value-update\/","title":{"rendered":"Google Sheets: Spreadsheets Value, Update"},"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-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: Spreadsheets Value, Update<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:0px;border-bottom-right-radius:0px\"> Overwrites a cell of a spreadsheet. The value will be parsed as if user typed text into the Google Sheets UI. For example, if date formated, the value &#8220;12-24&#8221; will be converted to &#8220;12\/24\/2021&#8221;. Or, &#8220;&#8217;12-31&#8221; will be updated as the string &#8220;12-31&#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 HTTP_Authz Setting<span style=\"color:#990000;\"> *<\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-edit fa-lg\"><\/i><\/span> B: Set Value to Overwrite<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> C1: Set ID of Spreadsheet into which Value 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> C2: Set Name of Sheet into which Value 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> C3: Set Cell Coordinate into which Value inserted (eg &#8220;A1&#8221;)<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li> D: To back up the Value before overwrite, Select STRING (update)<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1 su-spoiler-closed\" data-anchor=\"script\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Script (click to open)<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-js\" data-lang=\"JavaScript\"><code>\/\/ GraalJS Script (engine type: 2)\n\n\n\/\/\/\/\/\/\/\/ START &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\nmain();\nfunction main(){ \n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst strAuthzSetting = configs.get( &quot;AuthzConfA&quot; ); \/\/ required\n  engine.log( &quot; AutomatedTask Config: Authz Setting: &quot; + strAuthzSetting );\nconst strValue        = configs.get( &quot;StrConfB&quot; )  + &quot;&quot;; \/\/ required\nconst strFileId       = configs.get( &quot;StrConfC1&quot; ) + &quot;&quot;; \/\/ required\nconst strSheetName    = configs.get( &quot;StrConfC2&quot; ) + &quot;&quot;;\nconst strCellId       = configs.get( &quot;StrConfC3&quot; ) + &quot;&quot;; \/\/ required\nconst strPocketBackup = configs.getObject( &quot;SelectConfD&quot; );\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\n\/\/\/\/ Back up the current value of cell\nif( strPocketBackup !== null ){\n  \/\/\/ Gets values from a spreadsheet.\n  \/\/\/ (Google Sheets &gt; API v4)\n  \/\/\/ https:\/\/developers.google.com\/sheets\/api\/reference\/rest\/v4\/spreadsheets.values\/get\n\n  \/\/ request0, prepare\n  let getUri0  = &quot;https:\/\/sheets.googleapis.com\/v4\/spreadsheets\/&quot; +\n                 strFileId + &quot;\/values\/&quot; + strSheetName + &quot;!&quot; + strCellId;\n  let request0 = httpClient.begin(); \/\/ HttpRequestWrapper\n      request0 = request0.authSetting( strAuthzSetting ); \/\/ with &quot;Authorization: Bearer XX&quot;\n  \/\/ request0, try\n  const response0     = request0.get( getUri0 ); \/\/ HttpResponseWrapper\n  engine.log( &quot; AutomatedTask ApiRequest0 Start: &quot; + getUri0 );\n  const response0Code = response0.getStatusCode() + &quot;&quot;;\n  const response0Body = response0.getResponseAsString() + &quot;&quot;;\n  engine.log( &quot; AutomatedTask ApiResponse Status: &quot; + response0Code );\n  if( response0Code !== &quot;200&quot;){\n    throw new Error( &quot;\\n AutomatedTask UnexpectedResponseError: &quot; +\n                      response0Code + &quot;\\n&quot; + response0Body + &quot;\\n&quot; );\n  }\n  \/\/ response0, parse\n  \/* Example 1 - empty cell\n  {\n    &quot;range&quot;: &quot;Sheet1!D4&quot;,\n    &quot;majorDimension&quot;: &quot;ROWS&quot;\n  }\n  *\/\n  \/* Example 2 - multiline string cell\n  {\n    &quot;range&quot;: &quot;Sheet1!D3&quot;,\n    &quot;majorDimension&quot;: &quot;ROWS&quot;,\n    &quot;values&quot;: [\n      [\n        &quot;Multiline\\nCell&quot;\n      ]\n    ]\n  }\n  *\/\n  const response0Obj = JSON.parse( response0Body );\n  if( response0Obj.hasOwnProperty(&quot;values&quot;) ){\n    engine.setData( strPocketBackup, response0Obj.values[0][0] );\n  }\n}\n\n\n\/\/\/\/ Overwrite the value in the cell\n\/\/\/ Sets values in a range of a spreadsheet.\n\/\/\/ (Google Sheets &gt; API v4)\n\/\/\/ https:\/\/developers.google.com\/sheets\/api\/reference\/rest\/v4\/spreadsheets.values\/update\n\n\/\/ request1, prepare\nlet request1Obj = {};\n    request1Obj.values = [];\n    request1Obj.values[0] = [];\n    request1Obj.values[0][0] = strValue;\nlet putUri1  = &quot;https:\/\/sheets.googleapis.com\/v4\/spreadsheets\/&quot; +\n               strFileId + &quot;\/values\/&quot; + strSheetName + &quot;!&quot; + strCellId;\nlet request1 = httpClient.begin(); \/\/ HttpRequestWrapper\n    request1 = request1.authSetting( strAuthzSetting ); \/\/ with &quot;Authorization: Bearer XX&quot;\n    request1 = request1.queryParam( &quot;valueInputOption&quot;, &quot;USER_ENTERED&quot; );\n    request1 = request1.body( JSON.stringify( request1Obj ), &quot;application\/json&quot; );\n\/\/ request1, try\nconst response1     = request1.put( putUri1 ); \/\/ HttpResponseWrapper\nengine.log( &quot; AutomatedTask ApiRequest1 Start: &quot; + putUri1 );\nconst response1Code = response1.getStatusCode() + &quot;&quot;;\nconst response1Body = response1.getResponseAsString() + &quot;&quot;;\nengine.log( &quot; AutomatedTask ApiResponse Status: &quot; + response1Code );\nif( response1Code !== &quot;200&quot;){\n  throw new Error( &quot;\\n AutomatedTask UnexpectedResponseError: &quot; +\n                    response1Code + &quot;\\n&quot; + response1Body + &quot;\\n&quot; );\n}\n\/\/ response1, parse\n\/* engine.log( response1Body ); \/\/ debug\n{\n  &quot;spreadsheetId&quot;: &quot;1SK4mXXXXXq7ZriYYYYYOJHmIZZZZZAtjynWWWWW-qlE&quot;,\n  &quot;updatedRange&quot;: &quot;Sheet1!C3&quot;,\n  &quot;updatedRows&quot;: 1,\n  &quot;updatedColumns&quot;: 1,\n  &quot;updatedCells&quot;: 1\n}\n*\/\nconst response1Obj = JSON.parse( response1Body );\nengine.log( &quot; AutomatedTask ApiRequest1 updateRange: &quot; + response1Obj.updatedRange );\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\n\/\/ (No Output except Console Log and response0Obj.values[0][0] )\n\n\n} \/\/\/\/\/\/\/\/ END &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\n\/*\nNOTES\n- If the sheet name is omitted, Value will be inserted into the first visible sheet.\n- Cell Coordinates in A1 notation (where &quot;A&quot; is the column and &quot;1&quot; is the row of the cell)\n- If set the value to an empty string, a cell will be an empty value (deleted).\n- It also supports overwriting with multi-line strings.\n- For merged cells, the value can only be stored in the upper left cell.\n\nNOTES-ja\n- \u30b7\u30fc\u30c8\u540d\u3092\u7701\u7565\u3057\u305f\u5834\u5408\u3001\u300c\u975e\u8868\u793a\u3067\u306a\u3044\u5148\u982d\u30b7\u30fc\u30c8\u300d\u306b\u633f\u5165\u3055\u308c\u307e\u3059\u3002\n- \u30bb\u30eb\u5ea7\u6a19\u306fA1\u8a18\u6cd5\u3067\u6307\u5b9a\u3057\u307e\u3059\uff08&quot;A&quot; \u306f\u30bb\u30eb\u306e\u5217\u756a\u53f7\u3001&quot;1&quot; \u306f\u30bb\u30eb\u306e\u884c\u756a\u53f7\u3067\u3059\uff09\n- \u4e0a\u66f8\u304d\u5024\u304c\u7a7a\u6587\u5b57\u5217\u306e\u5834\u5408\u3001\u30bb\u30eb\u30c7\u30fc\u30bf\u306f\u7a7a\u306b\u306a\u308a\u307e\u3059\u3002\uff08\u524a\u9664\u3055\u308c\u307e\u3059\uff09\n- \u8907\u6570\u884c\u6587\u5b57\u5217\u3067\u306e\u4e0a\u66f8\u304d\u306b\u3082\u5bfe\u5fdc\u3057\u3066\u3044\u307e\u3059\u3002\n- \u7d50\u5408\u30bb\u30eb\uff08Merged Cell\uff09\u306e\u5834\u5408\u3001\u5024\u306f\u300c\u5de6\u4e0a\u306e\u30bb\u30eb\u300d\u306b\u306e\u307f\u4fdd\u6301\u3055\u308c\u307e\u3059\u3002\n*\/\n\n\n\/*\nAPPENDIX\n- OAuth Setting sample [HTTP Authorization Setting]\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    - to get your &quot;ClientId&quot; and &quot;Secret&quot;\n        - Access to https:\/\/console.developers.google.com\/apis\/credentials\n- Authorization Scopes (one of the following)\n    - https:\/\/www.googleapis.com\/auth\/drive\n    - https:\/\/www.googleapis.com\/auth\/drive.file\n    - https:\/\/www.googleapis.com\/auth\/spreadsheets\n    - About the levels of access\n        - https:\/\/developers.google.com\/identity\/protocols\/oauth2\/scopes#sheets\n\nAPPENDIX-ja\n- OAuth \u8a2d\u5b9a\u4f8b\uff08\uff3bHTTP\u8a8d\u8a3c\u8a2d\u5b9a\uff3d\u306e\u4f8b\uff09\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    - \u306a\u304a &quot;ClientId&quot; \u3068 &quot;Secret&quot; \u306f\u958b\u767a\u8005\u30b3\u30f3\u30bd\u30fc\u30eb\u306b\u30a2\u30af\u30bb\u30b9\u3057\u3066\u53d6\u5f97\u3057\u307e\u3059\u3002\n        - Access to https:\/\/console.developers.google.com\/apis\/credentials\n- \u8a8d\u53ef\u30b9\u30b3\u30fc\u30d7\uff08\u4ee5\u4e0b\u306e\u3044\u305a\u308c\u304b\uff09\n    - https:\/\/www.googleapis.com\/auth\/drive\n    - https:\/\/www.googleapis.com\/auth\/drive.file\n    - https:\/\/www.googleapis.com\/auth\/spreadsheets\n    - \u305d\u308c\u305e\u308c\u306e\u30a2\u30af\u30bb\u30b9\u30ec\u30d9\u30eb\u306b\u3064\u3044\u3066\n        - https:\/\/developers.google.com\/identity\/protocols\/oauth2\/scopes#sheets\n*\/\n\n\n<\/code><\/pre><\/div>\n\n\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"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><\/div>\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\"><li><a href=\"https:\/\/drive.google.com\/file\/d\/1Sy84vxC6nuUjFZb7BwEzaM3UfQNzuliW\/view?usp=drivesdk\" target=\"_blank\" rel=\"noreferrer noopener\">Google-Sheets-Spreadsheets-Value-Update.xml<\/a><\/li><\/ul>\n\n\n\n<p class=\"has-text-align-right has-small-font-size wp-block-paragraph\">2021-02-10 (C) Questetra, Inc. (MIT License)<br><a href=\"https:\/\/support.questetra.com\/en\/addons\/google-sheets-spreadsheets-value-update\/\">https:\/\/support.questetra.com\/en\/addons\/google-sheets-spreadsheets-value-update\/<\/a><br><i class=\"fal fa-info-circle\"><\/i> The Addon-import feature is available with <span style=\"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\"><li>The File ID can be obtained from the URL<ul><li><a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/SPREADSHEETID\/edit#gid=0\" rel=\"nofollow\">https:\/\/docs.google.com\/spreadsheets\/d\/SPREADSHEETID\/edit#gid=0<\/a><\/li><\/ul><\/li><li>If the sheet name is omitted, Value will be inserted into the first visible sheet.<\/li><li>Cell Coordinates in A1 notation (where &#8220;A&#8221; is the column and &#8220;1&#8221; is the row of the cell)<\/li><li>If set the value to an empty string, a cell will be an empty value (deleted).<\/li><li>It also supports overwriting with multi-line strings.<\/li><li>For merged cells, the value can only be stored in the upper left cell.<\/li><\/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\/2021\/02\/Google-Sheets-Spreadsheets-Value-Update-capture-en.png?ssl=1\" target=\"_blank\" rel=\"noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"675\" data-attachment-id=\"101598\" data-permalink=\"https:\/\/support.questetra.com\/en\/addons\/google-sheets-spreadsheets-value-update\/attachment\/google-sheets-spreadsheets-value-update-capture-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/Google-Sheets-Spreadsheets-Value-Update-capture-en.png?fit=1200%2C675&amp;ssl=1\" data-orig-size=\"1200,675\" data-comments-opened=\"0\" data-image-title=\"Google-Sheets-Spreadsheets-Value-Update-capture-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/Google-Sheets-Spreadsheets-Value-Update-capture-en.png?fit=1024%2C576&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/Google-Sheets-Spreadsheets-Value-Update-capture-en.png?resize=1200%2C675&#038;ssl=1\" alt=\"Overwrites a cell of a spreadsheet. The value will be parsed as if user typed text into the Google Sheets UI. For example, if date formatted, the value &quot;12-24&quot; will be converted to &quot;12\/24\/2021&quot;. Or, &quot;'12-31&quot; will be updated as the string &quot;12-31&quot;.\" class=\"wp-image-101598\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/Google-Sheets-Spreadsheets-Value-Update-capture-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/Google-Sheets-Spreadsheets-Value-Update-capture-en.png?resize=560%2C315&amp;ssl=1 560w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/Google-Sheets-Spreadsheets-Value-Update-capture-en.png?resize=1024%2C576&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/Google-Sheets-Spreadsheets-Value-Update-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\"><li>OAuth Setting sample [HTTP Authorization Setting]<ul><li>&#8220;Authorization Endpoint URL&#8221;<ul><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><\/ul><\/li><li>&#8220;Token Endpoint URL&#8221;<ul><li><a href=\"https:\/\/accounts.google.com\/o\/oauth2\/token\" rel=\"nofollow\">https:\/\/accounts.google.com\/o\/oauth2\/token<\/a><\/li><\/ul><\/li><li>to get your &#8220;ClientId&#8221; and &#8220;Secret&#8221;<ul><li>Access to <a href=\"https:\/\/console.developers.google.com\/apis\/credentials\" rel=\"nofollow\">https:\/\/console.developers.google.com\/apis\/credentials<\/a><\/li><\/ul><\/li><\/ul><\/li><li>Authorization Scopes (one of the following)<ul><li><a href=\"https:\/\/www.googleapis.com\/auth\/drive\" rel=\"nofollow\">https:\/\/www.googleapis.com\/auth\/drive<\/a><\/li><li><a href=\"https:\/\/www.googleapis.com\/auth\/drive.file\" rel=\"nofollow\">https:\/\/www.googleapis.com\/auth\/drive.file<\/a><\/li><li><a href=\"https:\/\/www.googleapis.com\/auth\/spreadsheets\" rel=\"nofollow\">https:\/\/www.googleapis.com\/auth\/spreadsheets<\/a><\/li><li>About the levels of access<ul><li><a href=\"https:\/\/developers.google.com\/identity\/protocols\/oauth2\/scopes#sheets\" rel=\"nofollow\">https:\/\/developers.google.com\/identity\/protocols\/oauth2\/scopes#sheets<\/a><\/li><\/ul><\/li><\/ul><\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-balance-scale\"><\/i> See also<\/h3>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-questetra-support wp-block-embed-questetra-support\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"jA2KFk3XYP\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/google-drive-gfile-export-as-pdf\/\">Google Drive: GFile; Export as PDF<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"\u201cGoogle Drive: GFile; Export as PDF\u201d \u2014 Questetra Support\" src=\"https:\/\/support.questetra.com\/en\/addons\/google-drive-gfile-export-as-pdf\/embed\/#?secret=QmxZx1uUjM#?secret=jA2KFk3XYP\" data-secret=\"jA2KFk3XYP\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Overwrites a cell of a spreadsheet. The value will be parsed as if user typed text into the Google Sheets UI. For example, if date formatted, the value &#8220;12-24&#8221; will be converted to &#8220;12\/24\/2021&#8221;. Or, &#8220;&#8217;12-31&#8221; will be updated as the string &#8220;12-31&#8221;.<\/p>\n","protected":false},"author":2,"featured_media":101596,"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":"Overwrites a cell of a spreadsheet. The value will be parsed as if user typed text into the Google Sheets UI. For example, if date formatted, the value \"12-24\" will be converted to \"12\/24\/2021\". Or, \"'12-31\" will be updated as the string \"12-31\".","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_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_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":[3167,396,3162],"faq_section":[],"class_list":["post-101595","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons","tag-authsetting","tag-google-sheets-api-v4","tag-google-workspace"],"jetpack_publicize_connections":[],"uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/Google-Sheets-Spreadsheets-Value-Update-en.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/Google-Sheets-Spreadsheets-Value-Update-en.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/Google-Sheets-Spreadsheets-Value-Update-en.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/Google-Sheets-Spreadsheets-Value-Update-en.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/Google-Sheets-Spreadsheets-Value-Update-en.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/Google-Sheets-Spreadsheets-Value-Update-en.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/Google-Sheets-Spreadsheets-Value-Update-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\/2021\/02\/Google-Sheets-Spreadsheets-Value-Update-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\/2021\/02\/Google-Sheets-Spreadsheets-Value-Update-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\/2021\/02\/Google-Sheets-Spreadsheets-Value-Update-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\/2021\/02\/Google-Sheets-Spreadsheets-Value-Update-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\/2021\/02\/Google-Sheets-Spreadsheets-Value-Update-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\/2021\/02\/Google-Sheets-Spreadsheets-Value-Update-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\/2021\/02\/Google-Sheets-Spreadsheets-Value-Update-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\/2021\/02\/Google-Sheets-Spreadsheets-Value-Update-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\/2021\/02\/Google-Sheets-Spreadsheets-Value-Update-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\/2021\/02\/Google-Sheets-Spreadsheets-Value-Update-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\/2021\/02\/Google-Sheets-Spreadsheets-Value-Update-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\/2021\/02\/Google-Sheets-Spreadsheets-Value-Update-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\/2021\/02\/Google-Sheets-Spreadsheets-Value-Update-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\/2021\/02\/Google-Sheets-Spreadsheets-Value-Update-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\/2021\/02\/Google-Sheets-Spreadsheets-Value-Update-en.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/Google-Sheets-Spreadsheets-Value-Update-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":1,"uagb_excerpt":"Overwrites a cell of a spreadsheet. The value will be parsed as if user typed text into the Google Sheets UI. For example, if date formatted, the value \"12-24\" will be converted to \"12\/24\/2021\". Or, \"'12-31\" will be updated as the string \"12-31\".","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-qqD","jetpack-related-posts":[{"id":183925,"url":"https:\/\/support.questetra.com\/en\/addons\/google-sheets-multiple-cells-update-202604\/","url_meta":{"origin":101595,"position":0},"title":"Google Sheets: Spreadsheets Multiple Cells Value, Update","author":"Hirotaka NISHI","date":"2026-05-18","format":false,"excerpt":"Overwrites mulitiple cells of a spreadsheet. The value will be parsed as if user typed text into the Google Sheets UI. For example, if date formated, the value \"12-24\" will be converted to \"12\/24\/2021\". Or, \"'12-31\" will be updated as the string \"12-31\".","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\/2024\/11\/Google-Sheets-Multiple-Cells-Update-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\/2024\/11\/Google-Sheets-Multiple-Cells-Update-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/11\/Google-Sheets-Multiple-Cells-Update-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/11\/Google-Sheets-Multiple-Cells-Update-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/11\/Google-Sheets-Multiple-Cells-Update-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":165298,"url":"https:\/\/support.questetra.com\/en\/addons\/google-sheets-multiple-cells-update\/","url_meta":{"origin":101595,"position":1},"title":"Google Sheets: Spreadsheets Multiple Cells Value, Update","author":"Hirotaka NISHI","date":"2024-11-28","format":false,"excerpt":"Overwrites multiple cells of a spreadsheet. The value will be parsed as if user typed text into the Google Sheets UI. For example, if date formatted, the value \"12-24\" will be converted to \"12\/24\/2021\". Or, \"'12-31\" will be updated as the string \"12-31\".","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\/2024\/11\/Google-Sheets-Multiple-Cells-Update-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\/2024\/11\/Google-Sheets-Multiple-Cells-Update-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/11\/Google-Sheets-Multiple-Cells-Update-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/11\/Google-Sheets-Multiple-Cells-Update-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/11\/Google-Sheets-Multiple-Cells-Update-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":97139,"url":"https:\/\/support.questetra.com\/en\/addons\/google-sheets-sheet-row-update-with-singleline-tsv\/","url_meta":{"origin":101595,"position":2},"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":101595,"position":3},"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":67330,"url":"https:\/\/support.questetra.com\/en\/addons\/googlesheets-sumnumbers\/","url_meta":{"origin":101595,"position":4},"title":"Sum of cells in a Google Sheet","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. *Note \u201c+3.14\u201d: 3.14, \u201c314e-2\u201d: 3.14, \u201c090\u201d: 90, \u201c2016-12-23\u201d: 2016, \u2018Begin with letter\u2019: 0 (parseFloat() sum) ** https:\/\/docs.google.com\/spreadsheets\/d\/1exampleEXAMPLEexampleEXAMPLEexampleEXAMPLE0\/edit#gid=0 Spreadsheet ID: 1exampleEXAMPLEexampleEXAMPLEexampleEXAMPLE0 *** Specify the sum of\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-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-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-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-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-header.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":96354,"url":"https:\/\/support.questetra.com\/en\/addons\/google-sheets-sheet-append-tsv\/","url_meta":{"origin":101595,"position":5},"title":"Google Sheets: Sheet, Append TSV","author":"IMAMURA, Genichi","date":"2020-10-14","format":false,"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\".","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, Append TSV","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-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-Append-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-Append-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-Append-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-Append-TSV-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/Google-Sheets-Spreadsheets-Value-Update-en.png?fit=1200%2C675&ssl=1","_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/101595","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=101595"}],"version-history":[{"count":7,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/101595\/revisions"}],"predecessor-version":[{"id":122290,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/101595\/revisions\/122290"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/101596"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=101595"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=101595"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=101595"},{"taxonomy":"faq_section","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/faq_section?post=101595"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}