Google Sheets: Row Range, Delete<\/div>
Deletes rows in the specified range. Existing cells will be shifted upward. Both the start and end rows are specified by zero-based index. For example, “startIndex: 0, endIndex: 1” means only the first line. (End index is exclusive)<\/div><\/div>\n\n\n
<\/span>Configs<\/div>
\n
- \n
- U: Select HTTP_Authz Setting *<\/span><\/li>\n
- <\/i><\/span> A1: Set SPREADSHEET-ID in Drive *<\/span>#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> A2: Set SHEET-ID in SPREADSHEET#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> A3: Or, Set SHEET-NAME in SPREADSHEET#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> B1: Set Range (StartRowIndex) *<\/span>#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> B2: Set Range (EndRowIndex) *<\/span>#{EL}<\/sup><\/span><\/li>\n
- C1: If to Backup TSV, Select STRING that stores TSV (update)<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n
<\/span>Script (click to open)<\/div>\n\n\n\n\/\/ GraalJS Script (engine type: 2)\n\n\/\/\/\/\/\/\/\/ START "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\nmain();\nfunction main(){ \n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst strAuthzSetting = configs.get ( "AuthzConfU" ); \/\/\/ REQUIRED\n engine.log( " AutomatedTask Config: Authz Setting: " + strAuthzSetting );\nconst strFileId = configs.get ( "StrConfA1" ); \/\/\/ REQUIRED\n if( strFileId === "" ){\n throw new Error( "\\n AutomatedTask ConfigError:" +\n " Config {A1: FileID} is empty \\n" );\n }\nlet strSheetId = configs.get ( "StrConfA2" ); \/\/ NotRequired\nlet strSheetName = configs.get ( "StrConfA3" ); \/\/ NotRequired\n if( strSheetId === "" ){\n engine.log( " AutomatedTask ConfigWarning:" +\n " Config {A2: SheetId} (recommended) is empty" );\n if( strSheetName === "" ){\n throw new Error( "\\n AutomatedTask ConfigError:" +\n " Config {A2: Id} or {A3: Name} must be specified \\n" );\n }\n }\nconst strRowRangeStart = configs.get ( "StrConfB1" ); \/\/\/ REQUIRED\n let numRowRangeStart = parseInt( strRowRangeStart, 10 );\nconst strRowRangeEnd = configs.get ( "StrConfB2" ); \/\/\/ REQUIRED\n let numRowRangeEnd = parseInt( strRowRangeEnd, 10 );\n if( numRowRangeStart >= numRowRangeEnd ){\n throw new Error( "\\n AutomatedTask ConfigError:" +\n " {B1: StartRowIndex} must be smaller than {B2: EndRowIndex} \\n" );\n }\nconst strPocketTsv = configs.getObject( "SelectConfC1" ); \/\/ NotRequired\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\n\/\/ (Nothing. Retrieved via Expression Language in Config Retrieving)\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\n\n\/\/\/ get Sheet Properties\n\n\/\/ request1, prepare\n\/\/ Sheets for Developers > API v4\n\/\/ https:\/\/developers.google.com\/sheets\/api\/reference\/rest\/v4\/spreadsheets\/get\nlet request1Uri = "https:\/\/sheets.googleapis.com\/v4\/spreadsheets\/" + strFileId;\nlet request1 = httpClient.begin(); \/\/ HttpRequestWrapper\n request1 = request1.authSetting( strAuthzSetting ); \/\/ with "Authorization: Bearer XX"\n \/\/ https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024574471-R2300#HttpRequestWrapper\n\n\/\/ request1, try\nconst response1 = request1.get( request1Uri ); \/\/ HttpResponseWrapper\nengine.log( " AutomatedTask ApiRequest1 Start: " + request1Uri );\nconst response1Code = response1.getStatusCode() + ""; \/\/ (primitive string)\nconst response1Body = response1.getResponseAsString() + "";\nengine.log( " AutomatedTask ApiResponse Status: " + response1Code );\nif( response1Code !== "200"){\n throw new Error( "\\n AutomatedTask UnexpectedResponseError: " +\n response1Code + "\\n" + response1Body + "\\n" );\n}\n\n\/\/ parse response1\nconst response1Obj = JSON.parse( response1Body );\n\/* response sample\nengine.log( response1Body ); \/\/ debug\n{\n "spreadsheetId": "17rwXXXXxS34yyyyYr-KzzzzX0_iWWWWOfHdxxxxRCLM",\n "properties": { \u2026 },\n "sheets": [\n {\n "properties": {\n "sheetId": 0,\n "title": "sheet1",\n "index": 0,\n "sheetType": "GRID",\n "gridProperties": {\n "rowCount": 100,\n "columnCount": 20,\n "frozenRowCount": 1\n }\n }\n }\n ],\n "spreadsheetUrl": "https:\/\/docs.google.com\/spreadsheets\/d\/17rwXXXXxS34yyyyYr-KzzzzX0_iWWWWOfHdxxxxRCLM\/edit"\n}\n*\/\n\nif( strSheetId === "" ){\n \/\/\/ get SheetId from SheetName\n for( let i = 0; i < response1Obj.sheets.length; i++ ){\n engine.log( " - " + response1Obj.sheets[i].properties.title );\n if( response1Obj.sheets[i].properties.title === strSheetName ){\n strSheetId = response1Obj.sheets[i].properties.sheetId;\n engine.log( " AutomatedTask SheetName '" + strSheetName +\n "': SheetId " + strSheetId );\n break;\n }\n }\n if( strSheetId === "" ){\n throw new Error( "\\n AutomatedTask ConfigError:" +\n " Config {A3 Sheet Name} does not exist \\n" );\n }\n}else{\n const numSheetId = parseInt( strSheetId, 10 );\n \/\/\/ get SheetName from SheetId\n for( let i = 0; i < response1Obj.sheets.length; i++ ){\n engine.log( " - " + response1Obj.sheets[i].properties.sheetId );\n if( response1Obj.sheets[i].properties.sheetId === numSheetId ){\n strSheetName = response1Obj.sheets[i].properties.title;\n engine.log( " AutomatedTask SheetId '" + strSheetId +\n "': SheetName " + strSheetName );\n break;\n }\n }\n}\n\n\n\/\/\/ backup RowRange\n\nlet strTsv = "";\nif( strPocketTsv !== null ){\n const strA1Notation = strSheetName + "!" + (numRowRangeStart+1) + ":" + numRowRangeEnd;\n engine.log( " AutomatedTask Backup Range: " + strA1Notation );\n\n \/\/\/ Sheets for Developers > API v4\n \/\/\/ https:\/\/developers.google.com\/sheets\/api\/reference\/rest\/v4\/spreadsheets.values\/batchGet\n\n \/\/ request2, prepare\n let request2Uri = "https:\/\/sheets.googleapis.com\/v4\/spreadsheets\/" + strFileId + "\/values:batchGet";\n let request2 = httpClient.begin(); \/\/ HttpRequestWrapper\n request2 = request2.authSetting( strAuthzSetting ); \/\/ with "Authorization: Bearer XX"\n \/\/ https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024574471-R2300#HttpRequestWrapper\n request2 = request2.queryParam( "majorDimension", "ROWS" );\n request2 = request2.queryParam( "valueRenderOption", "FORMATTED_VALUE" ); \n \/\/ Even if formatted as currency, return "$1.23" not "1.23".\n request2 = request2.queryParam( "dateTimeRenderOption", "FORMATTED_STRING" ); \n \/\/ Date as strings (the spreadsheet locale) not SERIAL_NUMBER\n request2 = request2.queryParam( "ranges", strA1Notation );\n\n \/\/ request2, try\n const response2 = request2.get( request2Uri ); \/\/ HttpResponseWrapper\n engine.log( " AutomatedTask ApiRequest2 Start: " + request2Uri );\n const response2Code = response2.getStatusCode() + "";\n const response2Body = response2.getResponseAsString() + "";\n engine.log( " AutomatedTask ApiResponse Status: " + response2Code );\n if( response2Code !== "200"){\n throw new Error( "\\n AutomatedTask UnexpectedResponseError: " +\n response2Code + "\\n" + response2Body + "\\n" );\n }\n\n \/\/ response2, parse\n const response2Obj = JSON.parse( response2Body );\n \/* response sample\n engine.log( response2Body ); \/\/ debug\n {\n "spreadsheetId": "17rwXXXXxS34yyyyYr-KzzzzX0_iWWWWOfHdxxxxRCLM",\n "valueRanges": [\n {\n "range": "Sheet1!A1:Z3",\n "majorDimension": "ROWS",\n "values": [\n [\n "Date",\n "Account (\u79d1\u76ee)",\n "Description (\u6458\u8981)",\n "Debit (\u501f\u65b9)",\n "Credit (\u8cb8\u65b9)",\n "Balance (\u6b8b\u9ad8)"\n ],\n [\n "2019-10-01",\n "\\u003cBUDGET\\u003e",\n "",\n "",\n "4,000,000.00",\n "4,000,000.00"\n ],\n [\n "2019-10-17",\n "Design Fee",\n "Web Display: BPM ",\n "2,000,000.00",\n "",\n "2,000,000.00"\n ]\n ]\n }\n ]\n }\n *\/\n\n engine.log( " AutomatedTask ApiResponse: range: " + response2Obj.valueRanges[0].range );\n let numTsvWidth = 0;\n for( let j = 0; j < response2Obj.valueRanges[0].values.length; j++ ){\n if( numTsvWidth < response2Obj.valueRanges[0].values[j].length ){\n numTsvWidth = response2Obj.valueRanges[0].values[j].length;\n }\n }\n engine.log( " AutomatedTask ApiResponse: tmpTsv width: " + numTsvWidth );\n for( let j = 0; j < response2Obj.valueRanges[0].values.length; j++ ){\n for( let k = 0; k < numTsvWidth; k++ ){\n if( k < response2Obj.valueRanges[0].values[j].length ){\n strTsv += response2Obj.valueRanges[0].values[j][k];\n }\n if( k != response2Obj.valueRanges[0].values[j].length - 1 ){\n strTsv += "\\t";\n }\n }\n if( j != response2Obj.valueRanges[0].values.length - 1 ){\n strTsv += "\\n";\n }\n }\n}\n\n\n\/\/\/ delete RowRange\n\/\/ Google Sheets for Developers > Sheets API\n\/\/ https:\/\/developers.google.com\/sheets\/api\/reference\/rest\/v4\/spreadsheets\/request#DeleteRangeRequest\n\n\/\/ request3, prepare\nlet request3Obj = {};\n request3Obj.requests = [];\n request3Obj.requests[0] = {};\n request3Obj.requests[0].deleteRange = {};\n request3Obj.requests[0].deleteRange.shiftDimension = "ROWS";\n request3Obj.requests[0].deleteRange.range = {};\n request3Obj.requests[0].deleteRange.range.sheetId = (strSheetId - 0);\n request3Obj.requests[0].deleteRange.range.startRowIndex = numRowRangeStart;\n request3Obj.requests[0].deleteRange.range.endRowIndex = numRowRangeEnd; \nlet request3Uri = "https:\/\/sheets.googleapis.com\/v4\/spreadsheets\/" + strFileId + ":batchUpdate";\nlet request3 = httpClient.begin(); \/\/ HttpRequestWrapper\n request3 = request3.authSetting( strAuthzSetting ); \/\/ with "Authorization: Bearer XX"\n \/\/ https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024574471-R2300#HttpRequestWrapper\n request3 = request3.body( JSON.stringify( request3Obj ), "application\/json" );\nengine.log( " AutomatedTask ApiRequest3 Prepared" );\n\n\/\/ request3, try\nconst response3 = request3.post( request3Uri ); \/\/ HttpResponseWrapper\nengine.log( " AutomatedTask ApiRequest3 Start: " + request3Uri );\nconst response3Code = response3.getStatusCode() + ""; \/\/ (primitive string)\nconst response3Body = response3.getResponseAsString() + "";\nengine.log( " AutomatedTask ApiResponse3 Status: " + response3Code );\nif( response3Code !== "200"){\n throw new Error( "\\n AutomatedTask UnexpectedResponseError: " +\n response3Code + "\\n" + response3Body + "\\n" );\n}\n\/* response sample\nengine.log( response3Body ); \/\/ debug\n{\n "spreadsheetId": "1Wfruxxxxxl6FmwyyyyyWzYLxzzzzzLQmiPxxxxxR_4I",\n "replies": [\n {}\n ]\n}\n*\/\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nif( strPocketTsv !== null ){\n engine.setData( strPocketTsv, strTsv );\n}\n\n\n} \/\/\/\/\/\/\/\/ END "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\n\/*\nNotes:\n- When the process reaches this automated step, rows in Google Sheets will be deleted.\n - Automates deletions by using the wider API Scope (strong privilege).\n- The range is specified by the zero-based indexes of start index and end index.\n - If to delete all cell, specify "0" for the start index and "1000" for the end index.\n - The index is evaluated by JavaScript `parseInt ()`.\n - When specifying with numeric data, be careful not to mix digit delimiters.\n - https:\/\/developer.mozilla.org\/docs\/Web\/JavaScript\/Reference\/Global_Objects\/parseInt\n - Index values outside the range will be corrected.\n- Spreadsheets are specified by ID, such as by referencing a URL. (SPREADSHEETID)\n - https:\/\/docs.google.com\/spreadsheets\/d\/SPREADSHEETID\/edit#gid=SHEETID\n- It is also possible to import (back up) deleted data as Workflow data.\n - The TSV string has a uniform number of columns (rectangular data) in each row.\n - There is no line feed code at the end of the TSV string.\n\nAPPENDIX-en\n- The backup lines and the deleted lines may be out of alignment if edited at the same time.\n- To restore the spreadsheet to a previous version, go to the "Change History" of the file.\n - "Find what's changed in a file" (Google file)\n - "The revisions for your file may occasionally be merged to save storage space."\n - https:\/\/support.google.com\/docs\/answer\/190843\n- Setting example of "HTTP Authentication" (OAuth2)\n - Authorization Endpoint URL:\n - https:\/\/accounts.google.com\/o\/oauth2\/v2\/auth?access_type=offline&prompt=consent\n - Token Endpoint URL:\n - https:\/\/oauth2.googleapis.com\/token\n - Scope:\n - https:\/\/www.googleapis.com\/auth\/spreadsheets.readonly\n - Client ID, Consumer Secret:\n - ( from https:\/\/console.developers.google.com\/ )\n - Redirect URLs: https:\/\/s.questetra.net\/oauth2callback\n - (OFFICIAL) https:\/\/developers.google.com\/identity\/protocols\/oauth2\/web-server#httprest\n\nNotes-ja:\n- \u6848\u4ef6\u304c\u81ea\u52d5\u5de5\u7a0b\u306b\u5230\u9054\u3057\u305f\u969b\u3001Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u4e00\u90e8\u306e\u884c\u304c\u81ea\u52d5\u524a\u9664\u3055\u308c\u307e\u3059\u3002\n - \u5e83\u7bc4\u306a API Scope\uff08\u5f37\u3044\u6a29\u9650\uff09\u3092\u4f7f\u3063\u305f\u524a\u9664\u4f5c\u696d\u306e\u81ea\u52d5\u5316\u3002\n- \u524a\u9664\u7bc4\u56f2\u306f\u958b\u59cb\u884c\u3068\u7d42\u4e86\u884c\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u5024\u3067\u6307\u5b9a\u3057\u307e\u3059\u3002\uff08\u30bc\u30ed\u59cb\u307e\u308a\uff09\n - \u5168\u30c7\u30fc\u30bf\u3092\u524a\u9664\u3057\u305f\u3044\u5834\u5408\u3001\u958b\u59cbIndex\u306b\u300c0\u300d\u3001\u7d42\u4e86Index\u306b\u300c1000\u300d\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002\n - \u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306f JavaScript `parseInt()` \u306b\u3066\u8a55\u4fa1\u3055\u308c\u307e\u3059\u3002\n - \u6570\u5024\u578b\u30c7\u30fc\u30bf\u3067\u6307\u5b9a\u3059\u308b\u5834\u5408\u3001\u6841\u533a\u5207\u308a\u6587\u5b57\u306e\u6df7\u5165\u30b1\u30fc\u30b9\u306b\u6ce8\u610f\u304c\u5fc5\u8981\u3067\u3059\n - https:\/\/developer.mozilla.org\/docs\/Web\/JavaScript\/Reference\/Global_Objects\/parseInt\n - \u7bc4\u56f2\u5916\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u5024\u306f\u88dc\u6b63\u3055\u308c\u307e\u3059\u3002\n- \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306f\u3001URL\u3092\u53c2\u7167\u3059\u308b\u306a\u3069\u3057\u3066 ID \u3067\u6307\u5b9a\u3057\u307e\u3059\u3002(SPREADSHEETID)\n - https:\/\/docs.google.com\/spreadsheets\/d\/SPREADSHEETID\/edit#gid=SHEETID\n- \u524a\u9664\u3055\u308c\u305f\u30c7\u30fc\u30bf\u3092Workflow\u30c7\u30fc\u30bf\u3068\u3057\u3066\u53d6\u308a\u8fbc\u3080\uff08\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3059\u308b\uff09\u3053\u3068\u3082\u53ef\u80fd\u3067\u3059\u3002\n - TSV\u6587\u5b57\u5217\u306f\u3001\u3044\u305a\u308c\u306e\u884c\u3082\u5747\u4e00\u306e\u5217\u6570\uff08\u77e9\u5f62\u30c7\u30fc\u30bf\uff09\u3068\u306a\u308a\u307e\u3059\u3002\n - TSV\u6587\u5b57\u5217\u306e\u672b\u5c3e\u306b\u6539\u884c\u30b3\u30fc\u30c9\u306f\u3042\u308a\u307e\u305b\u3093\u3002\n\nAPPENDIX-ja\n- \u540c\u6642\u7de8\u96c6\u306b\u3088\u308a\u3001\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u884c\u3068\u524a\u9664\u884c\u304c\u30ba\u30ec\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002\n- \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3092\u904e\u53bb\u30d0\u30fc\u30b8\u30e7\u30f3\u306b\u5fa9\u5143\u3057\u305f\u3044\u5834\u5408\u3001\u30d5\u30a1\u30a4\u30eb\u306e "\u5909\u66f4\u5c65\u6b74" \u306b\u30a2\u30af\u30bb\u30b9\u3057\u307e\u3059\u3002\n - (Google \u5f62\u5f0f\u306e) "\u30d5\u30a1\u30a4\u30eb\u306e\u5909\u66f4\u5185\u5bb9\u3092\u78ba\u8a8d\u3059\u308b"\n - "\u5bb9\u91cf\u7bc0\u7d04\u306e\u305f\u3081\u3001\u30d5\u30a1\u30a4\u30eb\u306e\u7248\u304c\u7d71\u5408\u3055\u308c\u308b\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002"\n - https:\/\/support.google.com\/docs\/answer\/190843\n- "HTTP\u8a8d\u8a3c"\uff08OAuth2\uff09\u306e\u8a2d\u5b9a\u4f8b\n - Authorization Endpoint URL:\n - https:\/\/accounts.google.com\/o\/oauth2\/v2\/auth?access_type=offline&prompt=consent\n - Token Endpoint URL:\n - https:\/\/oauth2.googleapis.com\/token\n - Scope:\n - https:\/\/www.googleapis.com\/auth\/spreadsheets\n - Client ID, Consumer Secret:\n - ( from https:\/\/console.developers.google.com\/ )\n - Redirect URLs: https:\/\/s.questetra.net\/oauth2callback\n - (OFFICIAL) https:\/\/developers.google.com\/identity\/protocols\/oauth2\/web-server#httprest\n*\/\n\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-row-range-delete-2022.xml<\/a><\/li>\n\n\n\n
- google-sheets-row-range-delete-2023.xml<\/a>\n
- \n
- 2023-08-21 (C) Questetra, Inc. (MIT License)<\/li>\n\n\n\n
- for “GraalJS standard (engine-type 3)” on v15.0 or above<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- google-sheets-row-range-delete-2026.xml<\/a>\n
- \n
- 2026-04-26 (C) Questetra, Inc. (MIT License)<\/li>\n\n\n\n
- Due to the deprecation of the methods
getOAuth2Token(String)<\/code> andauthSetting(String)<\/code> at v18.<\/li>\n\n\n\n- https:\/\/support.questetra.com\/ja\/versions\/version-180\/<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
2021-06-02 (C) Questetra, Inc. (MIT License)
https:\/\/support.questetra.com\/addons\/google-sheets-row-range-delete-2022\/<\/a>
<\/i> The Addon-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
- When the process reaches this automated step, rows in Google Sheets will be deleted.\n
- \n
- Automates deletions by using the wider API Scope (strong privilege).<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- The range is specified by the zero-based indexes of start index and end index.\n
- \n
- If to delete all cell, specify “0” for the start index and “1000” for the end index.<\/li>\n\n\n\n
- The index is evaluated by JavaScript
parseInt ()<\/code>.\n- \n
- When specifying with numeric data, be careful not to mix digit delimiters.<\/li>\n\n\n\n
- https:\/\/developer.mozilla.org\/docs\/Web\/JavaScript\/Reference\/Global_Objects\/parseInt<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Index values outside the range will be corrected.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Spreadsheets are specified by ID, such as by referencing a URL. (SPREADSHEETID)\n
- \n
- https:\/\/docs.google.com\/spreadsheets\/d\/SPREADSHEETID\/edit#gid=SHEETID<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n
- It is also possible to import (back up) deleted data as Workflow data.\n
- \n
- The TSV string has a uniform number of columns (rectangular data) in each row.<\/li>\n\n\n\n
- There is no line feed code at the end of the TSV string.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
<\/i> Capture<\/h3>\n\n\n\n
![\"Deletes](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-sheets-row-range-delete-2022-capture-en.png?fit=1200%2C675&ssl=1\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/google-sheets-row-range-delete-2022-config-en-796x630.png?resize=796%2C630&ssl=1\")
<\/figure>\n\n\n\n<\/i> Appendix<\/h3>\n\n\n\n
- \n
- The backup lines and the deleted lines may be out of alignment if edited at the same time.<\/li>\n\n\n\n
- To restore the spreadsheet to a previous version, go to the “Change History” of the file.\n
- \n
- “Find what’s changed in a file” (Google file)<\/li>\n\n\n\n
- “The revisions for your file may occasionally be merged to save storage space.”<\/li>\n\n\n\n
- https:\/\/support.google.com\/docs\/answer\/190843<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Setting example of “HTTP Authentication” (OAuth2)\n
- \n
- Authorization Endpoint URL:\n
- \n
- https:\/\/accounts.google.com\/o\/oauth2\/v2\/auth?access_type=offline&prompt=consent<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Token Endpoint URL:\n
- \n
- https:\/\/oauth2.googleapis.com\/token<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Scope:\n
- \n
- https:\/\/www.googleapis.com\/auth\/spreadsheets.readonly<\/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\n\n\n
- (OFFICIAL) https:\/\/developers.google.com\/identity\/protocols\/oauth2\/web-server#httprest<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
<\/i> See also<\/h3>\n\n\n\n
- Redirect URLs: https:\/\/s.questetra.net\/oauth2callback<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Client ID, Consumer Secret:\n
- Scope:\n
- Token Endpoint URL:\n
- https:\/\/accounts.google.com\/o\/oauth2\/v2\/auth?access_type=offline&prompt=consent<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Setting example of “HTTP Authentication” (OAuth2)\n
- It is also possible to import (back up) deleted data as Workflow data.\n
- https:\/\/support.questetra.com\/ja\/versions\/version-180\/<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
- google-sheets-row-range-delete-2023.xml<\/a>\n
- <\/i><\/span> A1: Set SPREADSHEET-ID in Drive *<\/span>#{EL}<\/sup><\/span><\/li>\n