{"id":95583,"date":"2020-10-05T10:23:08","date_gmt":"2020-10-05T01:23:08","guid":{"rendered":"https:\/\/support.questetra.com\/?p=95583"},"modified":"2022-06-09T10:22:26","modified_gmt":"2022-06-09T01:22:26","slug":"google-sheets-spreadsheets-add-sheet","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/google-sheets-spreadsheets-add-sheet\/","title":{"rendered":"Google Sheets: Spreadsheets, Add Sheet"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"68\" data-attachment-id=\"89186\" data-permalink=\"https:\/\/support.questetra.com\/en\/maintenance\/maintenance-20251117\/attachment\/professional-banner-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?fit=1200%2C68&amp;ssl=1\" data-orig-size=\"1200,68\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"professional-banner-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?fit=1024%2C58&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=1200%2C68&#038;ssl=1\" alt=\"\" class=\"wp-image-89186\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=600%2C34&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=1024%2C58&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=768%2C44&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><div class=\"su-box su-box-style-default\" id=\"\" style=\"border-color:#003e04;border-radius:0px;max-width:none\"><div class=\"su-box-title\" style=\"background-color:#267137;color:#ffffff;border-top-left-radius:0px;border-top-right-radius:0px\">Google Sheets: Spreadsheets, Add Sheet<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:0px;border-bottom-right-radius:0px\"> Adds a new sheet to the end of the spreadsheet. If the specified sheet name already exists, this Automated Task will end with an error. If needed, SheetId can also be specified.<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1\" data-anchor=\"configs\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Configs<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<ul class=\"fa-ul\">\n<li>A: Select Authorization Setting (OAuth2)<span style=\"color:#990000;\"> *<\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> B: Set Document ID (Spreadsheet ID)<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> C: Set Name of Sheet (e.g. &#8220;#{#format(#q_date, &#8216;yyyy-MM&#8217;)}&#8221;)<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> C2: If needed Set Id Rule of Sheet (e.g. &#8220;#{processInstanceId}&#8221;)<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li> D: Select STRING DATA that stores ID of Added Sheet (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\/*\nNotes:\n- See URL for &quot;Spreadsheet ID&quot;.\n    - https:\/\/docs.google.com\/spreadsheets\/d\/SPREADSHEETID\/edit#gid=0\n- When setting the SheetId rule, ensure that a unique positive integer is generated.\n     - If no rule, SheetId will be randomly generated by Google.\n     - Set as &quot;#{processInstanceId}&quot; to make &quot;Process ID&quot; SheetId.\n         - R2290: Dynamic value insertion by EL expression\n         - https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024293072-R2290\n     - If the SheetId already exists, the automated task ends with an error.\nNotes(ja):\n- \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306eID\u306fURL\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002\n    - https:\/\/docs.google.com\/spreadsheets\/d\/SPREADSHEETID\/edit#gid=0\n- SheetId \u30eb\u30fc\u30eb\u3092\u8a2d\u5b9a\u3059\u308b\u5834\u5408\u306f\u3001\u30e6\u30cb\u30fc\u30af\u306a\u6b63\u306e\u6574\u6570\uff08int32\uff09\u304c\u751f\u6210\u3055\u308c\u308b\u3088\u3046\u306b\u3057\u307e\u3059\u3002\n    - \u30eb\u30fc\u30eb\u3092\u8a2d\u5b9a\u3057\u306a\u3044\u5834\u5408\u3001Google \u306b\u3088\u3063\u3066\u30e9\u30f3\u30c0\u30e0\u306b\u751f\u6210\u3055\u308c\u307e\u3059\u3002\n    - &quot;\u30d7\u30ed\u30bb\u30b9ID&quot; \u3092 SheetId \u3068\u3059\u308b\u5834\u5408\u306f &quot;#{processInstanceId}&quot; \u306e\u3088\u3046\u306b\u8a2d\u5b9a\u3057\u307e\u3059\u3002\n        - R2290: EL\u5f0f\u306b\u3088\u308b\u52d5\u7684\u306a\u5024\u306e\u633f\u5165\n        - https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024293072-R2290\n    - SheetId \u304c\u65e2\u306b\u5b58\u5728\u3057\u3066\u3044\u305f\u5834\u5408\u3001\u81ea\u52d5\u5de5\u7a0b\u306f\u30a8\u30e9\u30fc\u7d42\u4e86\u3057\u307e\u3059\u3002\n\n- To Get &quot;ClientId&quot; and &quot;Secret&quot;\n    - Access to &quot;https:\/\/console.developers.google.com\/&quot;\n- OAuth Setting sample\n    - &quot;Authorization Endpoint URL&quot;\n        - https:\/\/accounts.google.com\/o\/oauth2\/auth?access_type=offline&approval_prompt=force\n    - &quot;Token Endpoint URL&quot;\n        - https:\/\/accounts.google.com\/o\/oauth2\/token\n    - &quot;Scope&quot;\n        - https:\/\/www.googleapis.com\/auth\/spreadsheets\n- Error Log sample\n    - AutomatedTask UnexpectedResponseError: 400\n        - { &quot;error&quot;: {\n        - &quot;code&quot;: 400,\n        - &quot;message&quot;: &quot;Invalid requests[0].addSheet: \u30b7\u30fc\u30c8\u540d\u300cTest\u300d\u306f\u3059\u3067\u306b\u5b58\u5728\u3057...&quot;,\n        - &quot;status&quot;: &quot;INVALID_ARGUMENT&quot;\n        - } }\n    - AutomatedTask UnexpectedResponseError: 400\n        - { &quot;error&quot;: {\n        - &quot;code&quot;: 400,\n        - &quot;message&quot;: &quot;Invalid requests[0].addSheet: Sheet with id 1234 already exists.&quot;,\n        - &quot;status&quot;: &quot;INVALID_ARGUMENT&quot;\n        - } }\n\n*\/\n\n\/\/\/\/\/\/\/\/ START &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\nmain();\nfunction main(){ \n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst strOauthSetting     = configs.get      ( &quot;OAuth2ConfA&quot; );   \/\/ required\nconst strSpreadsheetId    = configs.get      ( &quot;StrConfB&quot; ) + &quot;&quot;; \/\/ required\nconst strSheetName        = configs.get      ( &quot;StrConfC&quot; ) + &quot;&quot;; \/\/ required\nconst strSpecifiedSheetId = configs.get      ( &quot;StrConfC2&quot;) + &quot;&quot;;\nconst strPocketSheetId    = 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\/\/ prepare request1\n\/\/ ref) https:\/\/developers.google.com\n\/\/            \/sheets\/api\/reference\/rest\/v4\/spreadsheets\/request#addsheetrequest\nlet request1Obj = {};\n    request1Obj.requests = [];\n    request1Obj.requests[0] = {};\n    request1Obj.requests[0].addSheet = {};\n    request1Obj.requests[0].addSheet.properties = {};\n    if( strSpecifiedSheetId !== &quot;&quot; ){\n      request1Obj.requests[0].addSheet.properties.sheetId = strSpecifiedSheetId;\n    }\n    request1Obj.requests[0].addSheet.properties.title = strSheetName;\nlet uri1     = &quot;https:\/\/sheets.googleapis.com\/v4\/spreadsheets\/&quot; +\n                strSpreadsheetId + &quot;:batchUpdate&quot;;\nconst token  = httpClient.getOAuth2Token( strOauthSetting );\nengine.log( &quot; AutomatedTask ApiRequest Token: prepared&quot; );\nlet request1 = httpClient.begin(); \/\/ HttpRequestWrapper\n    request1 = request1.bearer( token );\n    request1 = request1.body( JSON.stringify( request1Obj ), &quot;application\/json&quot; );\n\n\/\/ post request1\nconst response1     = request1.post( uri1 );       \/\/ HttpResponseWrapper\nengine.log( &quot; AutomatedTask ApiRequest Start: &quot; + uri1 );\nconst response1Code = response1.getStatusCode() + &quot;&quot;; \/\/ (primitive string)\nconst response1Body = response1.getResponseAsString() + &quot;&quot;;\nengine.log( &quot; AutomatedTask ApiResponse Status: &quot; + response1Code );\nif( response1Code !== &quot;200&quot;){\n  throw new Error( &quot;\\n AutomatedTask UnexpectedResponseError: &quot; +\n                    response1Code + &quot;\\n&quot; + response1Body + &quot;\\n&quot; );\n}\n\n\/\/ parse response1\n\/* engine.log( response1Body ); \/\/ debug\nresponse sample\n{\n  &quot;spreadsheetId&quot;: &quot;1uwGxxxx0UWaxxxxsiCZxxxx6Y3UxxxxO0BgxxxxYRdo&quot;,\n  &quot;replies&quot;: [\n    {\n      &quot;addSheet&quot;: {\n        &quot;properties&quot;: {\n          &quot;sheetId&quot;: 12345,\n          &quot;title&quot;: &quot;Test12345&quot;,\n          &quot;index&quot;: 4,\n          &quot;sheetType&quot;: &quot;GRID&quot;,\n          &quot;gridProperties&quot;: {\n            &quot;rowCount&quot;: 1000,\n            &quot;columnCount&quot;: 26\n          }\n        }\n      }\n    }\n  ]\n}\n*\/\nconst response1Obj  = JSON.parse( response1Body );\nlet strSheetId = response1Obj.replies[0].addSheet.properties.sheetId + &quot;&quot;;\nengine.log( &quot; AutomatedTask ApiResponse NewSheetId: &quot; + strSheetId );\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nif( strPocketSheetId !== null ){\n  engine.setData( strPocketSheetId, strSheetId );\n}\n\n} \/\/\/\/\/\/\/\/ END &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\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\/1GTLSubwY4c2XOz7PPGbNvPKROHl6qLTC\/view?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\">Google-Sheets-Spreadsheets-Add-Sheet.xml<\/a><\/li><\/ul>\n\n\n\n<p class=\"has-text-align-right has-small-font-size wp-block-paragraph\">2020-10-04 (C) Questetra, Inc. (MIT License)<br><a href=\"https:\/\/support.questetra.com\/en\/addons\/google-sheets-spreadsheets-add-sheet\/\">https:\/\/support.questetra.com\/en\/addons\/google-sheets-spreadsheets-add-sheet\/<\/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>See URL for &#8220;Spreadsheet ID&#8221;.<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>When setting the SheetId rule, ensure that a unique positive integer is generated.<ul><li>If no rule, SheetId will be randomly generated by Google.<\/li><li>Set as &#8220;#{processInstanceId}&#8221; to make &#8220;Process ID&#8221; SheetId.<ul><li>R2290: Dynamic value insertion by EL expression<\/li><li><a href=\"https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024293072-R2290\" rel=\"nofollow\">https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024293072-R2290<\/a><\/li><\/ul><\/li><li>If the SheetId already exists, the automated task ends with an error.<\/li><\/ul><\/li><li>To Get &#8220;ClientId&#8221; and &#8220;Secret&#8221;<ul><li>Access to <a href=\"https:\/\/console.developers.google.com\/\" rel=\"nofollow\">https:\/\/console.developers.google.com\/<\/a><\/li><\/ul><\/li><li>OAuth Setting sample<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>&#8220;Scope&#8221;<ul><li><a href=\"https:\/\/www.googleapis.com\/auth\/spreadsheets\" rel=\"nofollow\">https:\/\/www.googleapis.com\/auth\/spreadsheets<\/a><\/li><\/ul><\/li><\/ul><\/li><li>Error Log sample<ul><li>AutomatedTask UnexpectedResponseError: 400<ul><li>{ &#8220;error&#8221;: {<\/li><li>&#8220;code&#8221;: 400,<\/li><li>&#8220;message&#8221;: &#8220;Invalid requests[0].addSheet: \u30b7\u30fc\u30c8\u540d\u300cTest\u300d\u306f\u3059\u3067\u306b\u5b58\u5728\u3057\u2026&#8221;,<\/li><li>&#8220;status&#8221;: &#8220;INVALID_ARGUMENT&#8221;<\/li><li>} }<\/li><\/ul><\/li><li>AutomatedTask UnexpectedResponseError: 400<ul><li>{ &#8220;error&#8221;: {<\/li><li>&#8220;code&#8221;: 400,<\/li><li>&#8220;message&#8221;: &#8220;Invalid requests[0].addSheet: Sheet with id 1234 already exists.&#8221;,<\/li><li>&#8220;status&#8221;: &#8220;INVALID_ARGUMENT&#8221;<\/li><li>} }<\/li><\/ul><\/li><\/ul><\/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\/2020\/10\/Google-Sheets-Spreadsheets-Add-Sheet-capture-en.png?ssl=1\" target=\"_blank\" rel=\"noopener noreferrer\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"675\" data-attachment-id=\"95586\" data-permalink=\"https:\/\/support.questetra.com\/en\/addons\/google-sheets-spreadsheets-add-sheet\/attachment\/google-sheets-spreadsheets-add-sheet-capture-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Spreadsheets-Add-Sheet-capture-en.png?fit=1200%2C675&amp;ssl=1\" data-orig-size=\"1200,675\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Google-Sheets-Spreadsheets-Add-Sheet-capture-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Spreadsheets-Add-Sheet-capture-en.png?fit=1024%2C576&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Spreadsheets-Add-Sheet-capture-en.png?resize=1200%2C675&#038;ssl=1\" alt=\"Adds a new sheet to the end of the spreadsheet. If the specified sheet name already exists, this Automated Task will end with an error. If needed, SheetId can also be specified.\" class=\"wp-image-95586\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Spreadsheets-Add-Sheet-capture-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Spreadsheets-Add-Sheet-capture-en.png?resize=560%2C315&amp;ssl=1 560w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Spreadsheets-Add-Sheet-capture-en.png?resize=1024%2C576&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Spreadsheets-Add-Sheet-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-balance-scale\"><\/i> See also<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/support.questetra.com\/en\/addons\/googledrive-foldercreate\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Google Drive: Create Folder(opens in a new tab)\">Google Drive: Create Folder<\/a><\/li><li><a href=\"https:\/\/support.questetra.com\/en\/addons\/google-sheets-master-table-simple-xlookup\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Google Sheets: Master Table, Simple Xlookup(opens in a new tab)\">Google Sheets: Master Table, Simple Xlookup<\/a><\/li><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><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Adds a new sheet to the end of the spreadsheet. If the specified sheet name already exists, this Automated Task will end with an error. If needed, SheetId can also be specified.<\/p>\n","protected":false},"author":2,"featured_media":95584,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_uag_custom_page_level_css":"","advanced_seo_description":"Adds a new sheet to the end of the spreadsheet. If the specified sheet name already exists, this Automated Task will end with an error. If needed, SheetId can also be specified.","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_wpcom_ai_launchpad_first_post":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"{title}\n\n{excerpt}\n\n{url}","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_wpas_customize_per_network":false,"jetpack_post_was_ever_published":false},"categories":[168],"tags":[392,396,3162,378],"class_list":["post-95583","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons","tag-beareroauth2token","tag-google-sheets-api-v4","tag-google-workspace","tag-json-parse"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Spreadsheets-Add-Sheet-en.png?fit=1200%2C675&ssl=1","uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Spreadsheets-Add-Sheet-en.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Spreadsheets-Add-Sheet-en.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Spreadsheets-Add-Sheet-en.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Spreadsheets-Add-Sheet-en.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Spreadsheets-Add-Sheet-en.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Spreadsheets-Add-Sheet-en.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Spreadsheets-Add-Sheet-en.png?fit=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Spreadsheets-Add-Sheet-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Spreadsheets-Add-Sheet-en.png?resize=900%2C675&ssl=1",900,675,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Spreadsheets-Add-Sheet-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Spreadsheets-Add-Sheet-en.png?resize=800%2C600&ssl=1",800,600,true],"newspack-article-block-portrait-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Spreadsheets-Add-Sheet-en.png?resize=600%2C675&ssl=1",600,675,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Spreadsheets-Add-Sheet-en.png?resize=800%2C675&ssl=1",800,675,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Spreadsheets-Add-Sheet-en.png?resize=600%2C450&ssl=1",600,450,true],"newspack-article-block-portrait-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Spreadsheets-Add-Sheet-en.png?resize=450%2C600&ssl=1",450,600,true],"newspack-article-block-square-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Spreadsheets-Add-Sheet-en.png?resize=600%2C600&ssl=1",600,600,true],"newspack-article-block-landscape-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Spreadsheets-Add-Sheet-en.png?resize=400%2C300&ssl=1",400,300,true],"newspack-article-block-portrait-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Spreadsheets-Add-Sheet-en.png?resize=300%2C400&ssl=1",300,400,true],"newspack-article-block-square-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Spreadsheets-Add-Sheet-en.png?resize=400%2C400&ssl=1",400,400,true],"newspack-article-block-landscape-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Spreadsheets-Add-Sheet-en.png?resize=200%2C150&ssl=1",200,150,true],"newspack-article-block-portrait-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Spreadsheets-Add-Sheet-en.png?resize=150%2C200&ssl=1",150,200,true],"newspack-article-block-square-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Spreadsheets-Add-Sheet-en.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Spreadsheets-Add-Sheet-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":"Adds a new sheet to the end of the spreadsheet. If the specified sheet name already exists, this Automated Task will end with an error. If needed, SheetId can also be specified.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-oRF","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":95590,"url":"https:\/\/support.questetra.com\/ja\/addons\/google-sheets-spreadsheets-add-sheet\/","url_meta":{"origin":95583,"position":0},"title":"Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: Spreadsheet, \u30b7\u30fc\u30c8\u3092\u8ffd\u52a0","author":"IMAMURA, Genichi","date":"2020-10-05","format":false,"excerpt":"\u65b0\u3057\u3044\u30b7\u30fc\u30c8\u3092 Spreadsheet \u5185\u306e\u672b\u5c3e\u306b\u8ffd\u52a0\u3057\u307e\u3059\u3002\u6307\u5b9a\u3057\u305f\u30b7\u30fc\u30c8\u540d\u304c\u65e2\u306b\u5b58\u5728\u3059\u308b\u5834\u5408\u3001\u81ea\u52d5\u5de5\u7a0b\u306f\u30a8\u30e9\u30fc\u7d42\u4e86\u3057\u307e\u3059\u3002\u5225\u9014 SheetId \u3092\u6307\u5b9a\u3059\u308b\u3053\u3068\u3082\u53ef\u80fd\u3067\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: Spreadsheet, \u30b7\u30fc\u30c8\u3092\u8ffd\u52a0","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Spreadsheets-Add-Sheet-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-Spreadsheets-Add-Sheet-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-Spreadsheets-Add-Sheet-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-Spreadsheets-Add-Sheet-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-Spreadsheets-Add-Sheet-ja.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":95583,"position":1},"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":[]},{"id":97139,"url":"https:\/\/support.questetra.com\/en\/addons\/google-sheets-sheet-row-update-with-singleline-tsv\/","url_meta":{"origin":95583,"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":67305,"url":"https:\/\/support.questetra.com\/en\/addons\/googlesheets-appendtsv\/","url_meta":{"origin":95583,"position":3},"title":"New Record to Google Sheets (TSV)","author":"Hirotaka NISHI","date":"2018-09-03","format":false,"excerpt":"Download google-drive-file-copy.xml Capture Notes \u201c0,1,5d, 3n, 6\u201d means that appending ID: 0 as a String, ID: 1 as a String, ID: 5 as Date-time, ID: 3 as a number, ID: 6 as a String.The File ID can be obtained from the URLhttps:\/\/docs.google.com\/spreadsheets\/d\/SPREADSHEETID\/edit#gid=0 See also 2016-11-07 Episode 508: Officialize Corporate Names\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\/2018\/09\/google-sheets-row-addition-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\/2018\/09\/google-sheets-row-addition-header.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/09\/google-sheets-row-addition-header.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/09\/google-sheets-row-addition-header.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/09\/google-sheets-row-addition-header.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":78460,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/choices-google-sheets\/","url_meta":{"origin":95583,"position":4},"title":"Utilize Customer Data on Google Sheets as Choices","author":"Hirotaka NISHI","date":"2020-04-23","format":false,"excerpt":"Get the Customer List stored in Google Sheet via API, and save\/use it as the Options Master.","rel":"","context":"In &quot;Questetra Developers Blog&quot;","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/en\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/google-sheet-choice-master-featured-image.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/google-sheet-choice-master-featured-image.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/google-sheet-choice-master-featured-image.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/google-sheet-choice-master-featured-image.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/google-sheet-choice-master-featured-image.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":95583,"position":5},"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":[]}],"amp_enabled":false,"_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/95583","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=95583"}],"version-history":[{"count":8,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/95583\/revisions"}],"predecessor-version":[{"id":114821,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/95583\/revisions\/114821"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/95584"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=95583"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=95583"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=95583"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}