- \n
- C1: OAuth2 Setting *<\/span><\/li>\n
- <\/i><\/span> C2: Source Spreadsheet ID *<\/span><\/li>\n
- <\/i><\/span> C3: Source Sheet Title *<\/span><\/li>\n
- <\/i><\/span> C4: Target Col (e.g. “A”) *<\/span><\/li>\n
- <\/i><\/span> C5: Start Row of Target Col (e.g. “D2:D”) *<\/span><\/li>\n
- C6: String type data item for specified value *<\/span><\/li>\n
- C7: String type data item to save row number *<\/span><\/li>\n<\/ul>\n<\/div><\/div>\n\n\n
<\/span>Script (click to open)<\/div>\n\n\n\n\n const oauth2 = configs.getObject( "conf_OAuth2" );\n const docId = configs.get( "conf_DataIdB" );\n const sheet = configs.get( "conf_DataIdC" );\n const col = configs.get( "conf_DataIdD" );\n const startRow = configs.get( "conf_DataIdE" );\n\n const key = engine.findDataByNumber( configs.get("conf_DataIdF") ) + "";\n const valDataDef = configs.get( "conf_DataIdG" );\n\n const range = col + startRow + ":" + col;\n\n const uri = `https:\/\/sheets.googleapis.com\/v4\/spreadsheets\/${docId}\/values\/:batchGet`;\n const response = httpClient.begin()\n .authSetting( oauth2 )\n .queryParam( "ranges", `${sheet}!${range}` )\n .queryParam( "valueRenderOption", "UNFORMATTED_VALUE" )\n .queryParam( "majorDimension", "COLUMNS" )\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 `Failed to get. status:${status}`;\n }\n const jsonObj = JSON.parse( responseStr );\n\n const keyList = jsonObj.valueRanges[0].values[0];\n\n let row = -1;\n for (let i = 0; i < keyList.length; i++) {\n if (keyList[i] == key) {\n row = parseInt(startRow) + i;\n break;\n }\n }\n\n \/\/\/\/ == \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 \/ Data Updating ==\n engine.setDataByNumber( valDataDef, row + "");\n<\/code><\/pre><\/div>\n\n\n<\/div><\/div>\n\n\n\n<\/a><\/figure>\n\n\n\n
<\/i> Download<\/h3>\n\n\n\n
- \n
- Google-Sheets-Find-Row-202604.xml<\/a>\n
- \n
- 2026-04-22 (C) Questetra, Inc. (MIT License)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
https:\/\/support.questetra.com\/en\/addons\/google-sheets-find-row-202604\/<\/a>
<\/i> The Add-on import feature is available with Professional<\/strong><\/span> edition.
Freely modifiable JavaScript (ECMAScript) code. No warranty of any kind.<\/p>\n\n\n<\/div>\n\n\n\n<\/i> Notes<\/h3>\n\n\n\n
- \n
- Thinking of Google Sheets as a master data management database, we will search a specified column with a specified value and identify the row number. Using the identified row number, it is assumed that the data will be retrieved by [Google Spreadsheet: Get Row<\/a>].<\/li>
- Returns -1 if there are no applicable rows.<\/li>\n<\/ul>\n\n\n\n
<\/i> Capture<\/h3>\n\n\n\n
![\"\"](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/google-sheets-find-row-number.png?ssl=1\")
<\/figure>\n\n\n\n<\/i> Appendix<\/h3>\n\n\n\n
- \n
- FILE-ID\/SpreadsheetID in Drive (“\/d\/” subsequent character string)\n
- \n
- docs.google.com\/d\/1xXXxXx-xx9XXXXX1xx2x3-5XxXxXXxxxxX1x7XX<\/strong>\/edit#gid=0<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- HTTP Authorization\uff08OAuth2\uff09configuration example\n
- \n
- Authorization Endpoint URL:\n
- \n
- https:\/\/accounts.google.com\/o\/oauth2\/auth?access_type=offline&approval_prompt=force<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Token Endpoint URL:\n
- \n
- https:\/\/accounts.google.com\/o\/oauth2\/token<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Scope:\n
- \n
- https:\/\/www.googleapis.com\/auth\/spreadsheets<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Client ID, Consumer Secret:\n
- \n
- ( from https:\/\/console.developers.google.com\/<\/a> )<\/li>\n\n\n\n
- Redirect URLs: https:\/\/s.questetra.net\/oauth2callback<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u5bfe\u8c61\u5217\u304b\u3089\u6307\u5b9a\u5024\u304c\u5165\u3063\u3066\u3044\u308b\u884c\u756a\u53f7\u3092\u7279\u5b9a\u3057\u307e\u3059\u3002<\/p>\n","protected":false},"author":3,"featured_media":116898,"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_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":"","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":[396],"faq_section":[],"class_list":["post-183435","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons","tag-google-sheets-api-v4"],"jetpack_publicize_connections":[],"uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/google-sheets-find-row-number-fi-en.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/google-sheets-find-row-number-fi-en.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/google-sheets-find-row-number-fi-en.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/google-sheets-find-row-number-fi-en.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/google-sheets-find-row-number-fi-en.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/google-sheets-find-row-number-fi-en.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/google-sheets-find-row-number-fi-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\/11\/google-sheets-find-row-number-fi-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\/11\/google-sheets-find-row-number-fi-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\/11\/google-sheets-find-row-number-fi-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\/11\/google-sheets-find-row-number-fi-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\/11\/google-sheets-find-row-number-fi-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\/11\/google-sheets-find-row-number-fi-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\/11\/google-sheets-find-row-number-fi-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\/11\/google-sheets-find-row-number-fi-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\/11\/google-sheets-find-row-number-fi-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\/11\/google-sheets-find-row-number-fi-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\/11\/google-sheets-find-row-number-fi-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\/11\/google-sheets-find-row-number-fi-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\/11\/google-sheets-find-row-number-fi-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\/11\/google-sheets-find-row-number-fi-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\/11\/google-sheets-find-row-number-fi-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\/11\/google-sheets-find-row-number-fi-en.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"Hirotaka NISHI","author_link":"https:\/\/support.questetra.com\/en\/author\/nishiquestetra\/"},"uagb_comment_info":0,"uagb_excerpt":"Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u5bfe\u8c61\u5217\u304b\u3089\u6307\u5b9a\u5024\u304c\u5165\u3063\u3066\u3044\u308b\u884c\u756a\u53f7\u3092\u7279\u5b9a\u3057\u307e\u3059\u3002","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-LID","jetpack-related-posts":[{"id":67292,"url":"https:\/\/support.questetra.com\/en\/bpmn-icons\/googlesheets-appendcells\/","url_meta":{"origin":183435,"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 "BPMN\u30a2\u30a4\u30b3\u30f3"","block_context":{"text":"BPMN\u30a2\u30a4\u30b3\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/bpmn-icons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/11\/bpmn-icon-google-sheets.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/11\/bpmn-icon-google-sheets.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/11\/bpmn-icon-google-sheets.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/11\/bpmn-icon-google-sheets.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/11\/bpmn-icon-google-sheets.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":94768,"url":"https:\/\/support.questetra.com\/en\/bpmn-icons\/excel-row-insert\/","url_meta":{"origin":183435,"position":1},"title":"Microsoft 365 Excel for Business: Insert New Row","author":"Shiho Tatsumi","date":"2024-06-25","format":false,"excerpt":"This item inserts a new row with data at the specified position in a sheet.","rel":"","context":"In "BPMN Icons"","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\/2021\/06\/bpmn-icon-Excel-insert-row.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\/06\/bpmn-icon-Excel-insert-row.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/06\/bpmn-icon-Excel-insert-row.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/06\/bpmn-icon-Excel-insert-row.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/06\/bpmn-icon-Excel-insert-row.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":183435,"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 "Add-ons"","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":67294,"url":"https:\/\/support.questetra.com\/ja\/bpmn-icons\/googlesheets-appendcells\/","url_meta":{"origin":183435,"position":3},"title":"Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: \u884c\u8ffd\u52a0","author":"Shiho Tatsumi","date":"2024-02-27","format":false,"excerpt":"\u3053\u306e\u5de5\u7a0b\u306f\u3001\u30b7\u30fc\u30c8\u672b\u5c3e\u306b\uff11\u884c\u8ffd\u52a0\u3057\u3001\u305d\u306e\u5404\u30bb\u30eb\u306b\u30c7\u30fc\u30bf\u3092\u5165\u529b\u3057\u307e\u3059\u3002","rel":"","context":"In "BPMN\u30a2\u30a4\u30b3\u30f3"","block_context":{"text":"BPMN\u30a2\u30a4\u30b3\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/bpmn-icons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/11\/bpmn-icon-google-sheets.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/11\/bpmn-icon-google-sheets.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/11\/bpmn-icon-google-sheets.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/11\/bpmn-icon-google-sheets.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/11\/bpmn-icon-google-sheets.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":116896,"url":"https:\/\/support.questetra.com\/en\/addons\/google-sheets-find-row\/","url_meta":{"origin":183435,"position":4},"title":"Google Sheets: Find Row Number By Specified Value","author":"Peter Glover","date":"2025-07-22","format":false,"excerpt":"Finds the row number that contains a specified value in the target column of a Google Sheet.","rel":"","context":"In "Add-ons"","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\/2021\/11\/google-sheets-find-row-number-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\/2021\/11\/google-sheets-find-row-number-fi-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/google-sheets-find-row-number-fi-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/google-sheets-find-row-number-fi-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/google-sheets-find-row-number-fi-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":84381,"url":"https:\/\/support.questetra.com\/en\/addons\/google-sheets-master-table-simple-xlookup\/","url_meta":{"origin":183435,"position":5},"title":"Google Sheets: Master Table, Simple Xlookup","author":"IMAMURA, Genichi","date":"2020-02-06","format":false,"excerpt":"Returns a value by referencing master data in Google Spreadsheets. Searches for the Lookup Value in array C, and if an exact match, returns the value in array D at the same index. C and D are defined in A1Notation. The length must be the same.","rel":"","context":"In "Add-ons"","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Google Sheets: Master Table, Simple Xlookup","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Google-Sheets-Master-Table-Simple-Xlookup-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Google-Sheets-Master-Table-Simple-Xlookup-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Google-Sheets-Master-Table-Simple-Xlookup-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Google-Sheets-Master-Table-Simple-Xlookup-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Google-Sheets-Master-Table-Simple-Xlookup-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/google-sheets-find-row-number-fi-en.png?fit=1200%2C675&ssl=1","_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/183435","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\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=183435"}],"version-history":[{"count":15,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/183435\/revisions"}],"predecessor-version":[{"id":191616,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/183435\/revisions\/191616"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/116898"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=183435"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=183435"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=183435"},{"taxonomy":"faq_section","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/faq_section?post=183435"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- Redirect URLs: https:\/\/s.questetra.net\/oauth2callback<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
- Client ID, Consumer Secret:\n
- Scope:\n
- Token Endpoint URL:\n
- https:\/\/accounts.google.com\/o\/oauth2\/auth?access_type=offline&approval_prompt=force<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n
- HTTP Authorization\uff08OAuth2\uff09configuration example\n
- docs.google.com\/d\/1xXXxXx-xx9XXXXX1xx2x3-5XxXxXXxxxxX1x7XX<\/strong>\/edit#gid=0<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Returns -1 if there are no applicable rows.<\/li>\n<\/ul>\n\n\n\n
- Thinking of Google Sheets as a master data management database, we will search a specified column with a specified value and identify the row number. Using the identified row number, it is assumed that the data will be retrieved by [Google Spreadsheet: Get Row<\/a>].<\/li>
- 2026-04-22 (C) Questetra, Inc. (MIT License)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
- <\/i><\/span> C2: Source Spreadsheet ID *<\/span><\/li>\n