{"id":113830,"date":"2024-07-08T09:00:22","date_gmt":"2024-07-08T00:00:22","guid":{"rendered":"https:\/\/support.questetra.com\/?p=113830"},"modified":"2024-07-08T09:15:38","modified_gmt":"2024-07-08T00:15:38","slug":"service-task-google-sheets-row-get","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-google-sheets-row-get\/","title":{"rendered":"Google Sheets: Get 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: Get 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-get\/\">Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: \u884c\u53d6\u5f97<\/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 gets data in a specified row from 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: #C3C3C3;\">conf_OAuth2<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C1: OAuth2 Setting<span style=\"color:#990000;\"> *<\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #C3C3C3;\">conf_SheetId<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C2: Source Spreadsheet ID<span style=\"color:#990000;\"> *<\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #C3C3C3;\">conf_SheetTitle<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C3: Source Sheet Title<span style=\"color:#990000;\"> *<\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #C3C3C3;\">conf_RowNo<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C4: Row to Get (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: #C3C3C3;\">conf_Range<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C5: Column Range to Get (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: #C3C3C3;\">conf_Column1<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C6_1: Data item that stores the value in the 1st column <\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #C3C3C3;\">conf_Column2<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C6_2: Data item that stores the value in the 2nd column <\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #C3C3C3;\">conf_Column3<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C6_3: Data item that stores the value in the 3rd column <\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #C3C3C3;\">conf_Column4<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C6_4: Data item that stores the value in the 4th column <\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #C3C3C3;\">conf_Column5<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C6_5: Data item that stores the value in the 5th column <\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #C3C3C3;\">conf_Column6<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C6_6: Data item that stores the value in the 6th column <\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #C3C3C3;\">conf_Column7<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C6_7: Data item that stores the value in the 7th column <\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #C3C3C3;\">conf_Column8<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C6_8: Data item that stores the value in the 8th column <\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #C3C3C3;\">conf_Column9<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C6_9: Data item that stores the value in the 9th column <\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #C3C3C3;\">conf_Column10<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C6_10: Data item that stores the value in the 10th column <\/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<\/ul>\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\/07\/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%E5%8F%96%E5%BE%97-16-1-en.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-05-30\/google-sheets-row-get.xml\" target=\"_blank\" rel=\"noreferrer noopener\">google-sheets-row-get.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&amp;approval_prompt=force\n\/\/ Token Endpoint URL: https:\/\/accounts.google.com\/o\/oauth2\/token\n\/\/ Scope: https:\/\/www.googleapis.com\/auth\/spreadsheets.readonly\n\/\/ Consumer Key: (Get by Google Developers Console)\n\/\/ Consumer Secret: (Get by Google Developers Console)\n\nconst COLUMN_NUM = 10;\n\nfunction main(){\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;Spreadsheet ID&quot; );\n  const sheetTitle = retrieveStringData( &quot;conf_SheetTitle&quot;, &quot;Spreadsheet Title&quot; );\n  const rowNo = retrieveRowNo();\n  const range = configs.get( &quot;conf_Range&quot; );\n\n  checkRowNoAndRange( rowNo, range );\n  const columnDefList = [];\n  retrieveValueConfigs( columnDefList );\n  \n  \n  \/\/\/\/ == \u6f14\u7b97 \/ Calculating ==\n  const dataStringList = getRowData( oauth, sheetId, sheetTitle, rowNo, range );\n\n  \/\/\/\/ == \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 \/ Data Updating ==\n  setDataByLists( columnDefList, dataStringList );\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  const dataDef = configs.getObject( confName );\n  let string;\n  if (dataDef !== null) {\n    string = engine.findData(dataDef);\n  } else {\n    string = configs.get(confName);\n  }\n  if (string === null || string === &quot;&quot;) {\n    throw new Error(`${label} is empty.`);\n  }\n  return string;\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  let rowNo = configs.get( &quot;conf_RowNo&quot; );\n  if ( rowNoDef !== null ) {\n    rowNo = engine.findData( rowNoDef );\n  }\n  return rowNo;\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 new Error(&quot;Row number is empty.&quot;);\n  }\n  if ( !isValidNo(rowNo) ) {\n    throw new Error(&quot;Invalid Row number.&quot;);\n  }\n  if ( !isValidRange(range) ) {\n    throw new Error(&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( &apos;^[1-9][0-9]*$&apos; );\n  return idReg.test( noString );\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( &apos;^[A-Z]+:[A-Z]+$&apos; );\n  return idReg.test( rangeString );\n}\n\n\n\/**\n  * config \u306e\u5217\u306e\u5024\u3092\u683c\u7d0d\u3059\u308b\u30c7\u30fc\u30bf\u9805\u76ee\u306e\u60c5\u5831\u3092\u8aad\u307f\u51fa\u3057\u3001\u914d\u5217\u306b\u683c\u7d0d\u3059\u308b\n  * \u4ee5\u4e0b\u306e\u5834\u5408\u306f\u30a8\u30e9\u30fc\u3068\u3059\u308b\n  * 1. \u5024\u3092\u4fdd\u5b58\u3059\u308b\u30c7\u30fc\u30bf\u9805\u76ee\u304c\u91cd\u8907\u3057\u3066\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u308b\n  * 2. \u5217\u306e\u5024\u3092\u683c\u7d0d\u3059\u308b\u30c7\u30fc\u30bf\u9805\u76ee\u304c\u4e00\u3064\u3082\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u306a\u3044\n  * @param {Array&lt;ProcessDataDefinitionView&gt;} valueDefList  \u5217\u306e\u5024\u3092\u683c\u7d0d\u3059\u308b\u30c7\u30fc\u30bf\u9805\u76ee\u306e ProcessDataDefinitionView \u3092\u683c\u7d0d\u3059\u308b\u914d\u5217\n  *\/\nfunction retrieveValueConfigs( columnDefList ) {\n  const dataItemNumList = []; \/\/ \u30c7\u30fc\u30bf\u9805\u76ee\u306e\u91cd\u8907\u78ba\u8a8d\u7528\n  for (let i = 0; i &lt; COLUMN_NUM; i++) {\n    const columnConfigName = `conf_Column${i+1}`;\n    const columnValueDef = configs.getObject( columnConfigName );\n    columnDefList.push( columnValueDef );\n    if ( columnValueDef !== null ) {\n      const dataItemNum = configs.get( columnConfigName ); \/\/ \u30c7\u30fc\u30bf\u9805\u76ee\u306e\u91cd\u8907\u78ba\u8a8d\u7528\n      if ( dataItemNumList.indexOf( dataItemNum ) !== -1 ) { \/\/ \u65e2\u306b\u6307\u5b9a\u3055\u308c\u3066\u3044\u308b\u30c7\u30fc\u30bf\u9805\u76ee\n        throw new Error(&quot;The same data item is set multiple times.&quot;);\n      }\n      dataItemNumList.push( dataItemNum ); \/\/ \u30c7\u30fc\u30bf\u9805\u76ee\u306e\u91cd\u8907\u78ba\u8a8d\u7528\n    }\n  }\n  if ( columnDefList.filter( v =&gt; v !== null ).length === 0 ) { \/\/ \u5217\u306e\u5024\u3092\u683c\u7d0d\u3059\u308b\u30c7\u30fc\u30bf\u9805\u76ee\u304c\u4e00\u3064\u3082\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u306a\u3044\n    throw new Error(&quot;No Data Item is set.&quot;);\n  }\n}\n\n\n\n\/**\n * Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u884c\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\n * @param {AuthSettingWrapper} oauth2  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 \u53d6\u5f97\u3059\u308b\u884c\n * @param {String} range \u53d6\u5f97\u3059\u308b\u5217\u7bc4\u56f2\n * @return {Array&lt;String&gt;} jsonObj.values[0] \u53d6\u5f97\u3057\u305f\u884c\u30c7\u30fc\u30bf \u3092\u683c\u7d0d\u3057\u305f\u914d\u5217\n *\/\nfunction getRowData( oauth, sheetId, sheetTitle, rowNo, range ) {\n\n  const rangeArr = range.split(&apos;:&apos;);\n  const enSheetId = encodeURIComponent(sheetId);\n  const enSheetTitle = encodeURIComponent(sheetTitle);\n\n  \/\/ Method: spreadsheets.values.get\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;valueRenderOption&quot;, &quot;UNFORMATTED_VALUE&quot; )\n    .queryParam( &quot;dateTimeRenderOption&quot;, &quot;FORMATTED_STRING&quot; )\n    .queryParam( &quot;majorDimension&quot;, &quot;ROWS&quot; )\n    .get( 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 new Error(`Failed to get. status:${status}`);\n  }\n  const jsonObj = JSON.parse( responseStr );\n  if (jsonObj.values === undefined ) {\n    throw new Error(`No Data in range.`);\n  }\n\n  const dataStringList = jsonObj.values[0]\n    .slice(0, COLUMN_NUM) \/\/ \u6700\u592710\u5217\n    .map( v =&gt; v.toString() ); \/\/ \u3059\u3079\u3066 String \u306b\u5909\u63db\n\n  return dataStringList;\n}\n\n\n\/**\n  * \u30c7\u30fc\u30bf\u9805\u76ee\u306b\u51fa\u529b\u3059\u308b\n  * @param {Array&lt;ProcessDataDefinitionView&gt;} valueDefList  \u4fdd\u5b58\u5148\u30c7\u30fc\u30bf\u9805\u76ee\u306e ProcessDataDefinitionView \u304c\u683c\u7d0d\u3055\u308c\u305f\u914d\u5217\n  * @param {Array&lt;String&gt;} dataStringList  \u51fa\u529b\u3059\u308b\u30c7\u30fc\u30bf\u304c\u683c\u7d0d\u3055\u308c\u305f\u914d\u5217\n  *\/\nfunction setDataByLists( valueDefList, dataStringList ) {\n  valueDefList.forEach( (valueDef, i) =&gt; {\n    if ( valueDef !== null) {\n      if ( i &gt; dataStringList.length - 1 ) { \/\/ dataStringList \u306e\u8981\u7d20\u304c\u306a\u3044\u5834\u5408\n        engine.setData( valueDef, null ); \n        return;\n      }\n      const dataString = dataStringList[i];\n\n\/\/    if ( valueDef.matchDataType(&quot;STRING&quot;) ) { \/\/ \u4fdd\u5b58\u5148\u30c7\u30fc\u30bf\u9805\u76ee\u304c\u6587\u5b57\u578b\u306e\u5834\u5408\n        \/\/ \u4fdd\u5b58\u5148\u30c7\u30fc\u30bf\u9805\u76ee\u304c\u6539\u884c\u306b\u5bfe\u5fdc\u3057\u3066\u304a\u3089\u305a\u3001\u4fdd\u5b58\u3059\u308b\u6587\u5b57\u5217\u306b\u6539\u884c\u304c\u542b\u307e\u308c\u308b\u5834\u5408\u306e\u30a8\u30e9\u30fc\u306f QBPMS \u306e\u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3\u306b\u4efb\u305b\u308b\n        engine.setData( valueDef, dataString );\n\/\/      } else if ( valueDef.matchDataType(&quot;DECIMAL&quot;) ) { \/\/ \u4fdd\u5b58\u5148\u30c7\u30fc\u30bf\u9805\u76ee\u304c\u6570\u5024\u578b\u306e\u5834\u5408\n\/\/        convertTypeAndSetData( valueDef, dataString, &quot;DECIMAL&quot;, &quot;Numeric&quot; );\n\/\/      } else if ( valueDef.matchDataType(&quot;SELECT&quot;) ) { \/\/ \u4fdd\u5b58\u5148\u30c7\u30fc\u30bf\u9805\u76ee\u304c\u9078\u629e\u578b\u306e\u5834\u5408\n\/\/        convertTypeAndSetData( valueDef, dataString, &quot;SELECT&quot;, &quot;Select&quot; );\n\/\/      } else if ( valueDef.matchDataType(&quot;DATE&quot;) ) { \/\/ \u4fdd\u5b58\u5148\u30c7\u30fc\u30bf\u9805\u76ee\u304c\u65e5\u4ed8\u578b\u306e\u5834\u5408\n\/\/        convertTypeAndSetData( valueDef, dataString, &quot;DATE&quot;, &quot;Date&quot; );\n\/\/      } else if ( valueDef.matchDataType(&quot;DATETIME&quot;) ) { \/\/ \u4fdd\u5b58\u5148\u30c7\u30fc\u30bf\u9805\u76ee\u304c\u65e5\u6642\u578b\u306e\u5834\u5408\n\/\/        convertTypeAndSetData( valueDef, dataString, &quot;DATETIME&quot;, &quot;Datetime&quot; );\n\/\/      }\n      \n    }\n  });\n}\n\n\n\/**\n  * \u30c7\u30fc\u30bf\u9805\u76ee\u306e\u578b\u306b\u3057\u305f\u304c\u3063\u3066\u30c7\u30fc\u30bf\u3092\u5909\u63db\u3057\u3066\u51fa\u529b\u3059\u308b\n  * \u5bfe\u5fdc\u3057\u306a\u3044\u30d5\u30a3\u30fc\u30eb\u30c9\u578b\u306e\u5834\u5408\u306f\u30a8\u30e9\u30fc\u3068\u3059\u308b\n  * \u5909\u63db\u3067\u304d\u306a\u3044\u5024\u306e\u5834\u5408\u306f\u30a8\u30e9\u30fc\u3068\u3059\u308b\n  * @param {ProcessDataDefinitionView} dataDef  \u4fdd\u5b58\u5148\u30c7\u30fc\u30bf\u9805\u76ee\u306e ProcessDataDefinitionView\n  * @param {String} dataString  \u51fa\u529b\u3059\u308b\u30c7\u30fc\u30bf\uff08\u5909\u63db\u524d\u306e\u6587\u5b57\u5217\u30c7\u30fc\u30bf\uff09\n  * @param {String} dataType  \u4fdd\u5b58\u5148\u30c7\u30fc\u30bf\u9805\u76ee\u306e\u30c7\u30fc\u30bf\u578b\n  * @param {String} dataTypeLabel  \u4fdd\u5b58\u5148\u30c7\u30fc\u30bf\u9805\u76ee\u306e\u30c7\u30fc\u30bf\u578b\u306e\u8868\u793a\u540d\uff08\u30a8\u30e9\u30fc\u51fa\u529b\u7528\uff09\n  *\/\n\/*\n  function convertTypeAndSetData( dataDef, dataString, dataType, dataTypeLabel ) {\n  \n    let convertedData;\n    if ( dataString === &quot;&quot; || dataString === null ) { \/\/ \u7a7a\u5024\u306e\u5834\u5408\u306f null \u3092\u8a2d\u5b9a\n      convertedData = null;\n    } else {\n      try { \/\/  try-catch \u3067\u30a8\u30e9\u30fc\u3092\u6355\u6349\n        switch (dataType) {\n          case &apos;DECIMAL&apos;:\n            convertedData = new java.math.BigDecimal( dataString );\n            break;\n          case &apos;SELECT&apos;: \/\/ \u4e00\u81f4\u3059\u308b\u9078\u629e\u80a2 ID \u304c\u306a\u3044\u5834\u5408\u306e\u30a8\u30e9\u30fc\u306f QBPMS \u306e\u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3\u306b\u4efb\u305b\u308b\n            convertedData = new java.util.ArrayList();\n            convertedData.add( dataString );\n            break;\n          case &apos;DATE&apos;:\n            convertedData = java.sql.Date.valueOf( dataString );\n            break;\n          case &apos;DATETIME&apos;:\n            const dateFormatter = new java.text.SimpleDateFormat( &quot;yyyy-MM-dd HH:mm&quot; );\n            convertedData = new java.sql.Timestamp( dateFormatter.parse( dataString ).getTime() );\n          break;\n        }\n      } catch (e) { \/\/ \u5909\u63db\u3067\u304d\u306a\u3044\u5024\u306e\u5834\u5408\u306f\u30a8\u30e9\u30fc\n        throw new Error(`Returned value &quot;${dataString}&quot; cannot be saved to ${dataTypeLabel} type data item.`);\n      }\n    }\n    engine.setData( dataDef, convertedData );\n  }\n *\/\n\n<\/code><\/pre><\/div>\n<\/div><\/details><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>This item gets data in a specified row from a Google Sheet.<\/p>\n","protected":false},"author":15,"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,3162],"class_list":["post-113830","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":"suesesayaka","author_link":"https:\/\/support.questetra.com\/en\/author\/suesesayaka\/"},"uagb_comment_info":3,"uagb_excerpt":"This item gets data in a specified row from a Google Sheet.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-tBY","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":67292,"url":"https:\/\/support.questetra.com\/en\/bpmn-icons\/googlesheets-appendcells\/","url_meta":{"origin":113830,"position":0},"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":116684,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/google-sheet-table-add-sum\/","url_meta":{"origin":113830,"position":1},"title":"Adding Table Values to Google Sheets and Getting the Aggregate Value","author":"Hirotaka NISHI","date":"2021-11-11","format":false,"excerpt":"Adds the contents of a Table-type Data Item to a Google Sheet and retrieves the aggregated value. Various aggregations can be performed automatically depending on the spreadsheet settings.","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\/2021\/11\/eyecatch-google-sheet-table-add-sum-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\/2021\/11\/eyecatch-google-sheet-table-add-sum-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/eyecatch-google-sheet-table-add-sum-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/eyecatch-google-sheet-table-add-sum-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/eyecatch-google-sheet-table-add-sum-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":97327,"url":"https:\/\/support.questetra.com\/en\/bpmn-icons\/google-sheets-file-create\/","url_meta":{"origin":113830,"position":2},"title":"Google Sheets: Create File","author":"nishiokac","date":"2024-02-27","format":false,"excerpt":"This item creates a new Spreadsheet in the specified folder on Google Drive.","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":97139,"url":"https:\/\/support.questetra.com\/en\/addons\/google-sheets-sheet-row-update-with-singleline-tsv\/","url_meta":{"origin":113830,"position":3},"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":119881,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/google-sheets-employee-master\/","url_meta":{"origin":113830,"position":4},"title":"Managing Employee Information in Google Spreadsheets with Workflow Apps","author":"Peter Glover","date":"2022-05-11","format":false,"excerpt":"Introducing an application to manipulate employee information managed in Google Spreadsheets from Questetra.","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\/2022\/03\/google-sheet-employee-master-fi-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\/2022\/03\/google-sheet-employee-master-fi-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/03\/google-sheet-employee-master-fi-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/03\/google-sheet-employee-master-fi-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/03\/google-sheet-employee-master-fi-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":67338,"url":"https:\/\/support.questetra.com\/en\/bpmn-icons\/googlesheets-getidslabels\/","url_meta":{"origin":113830,"position":5},"title":"Google Sheets: Download Choice Data","author":"suesesayaka","date":"2024-07-05","format":false,"excerpt":"This item downloads Choice Data in specified 2 columns from Google Sheet.","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\/113830","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\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=113830"}],"version-history":[{"count":28,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/113830\/revisions"}],"predecessor-version":[{"id":163008,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/113830\/revisions\/163008"}],"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=113830"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=113830"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=113830"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}