{"id":15596,"date":"2023-08-16T09:00:00","date_gmt":"2023-08-16T00:00:00","guid":{"rendered":"https:\/\/www.autooffice.co.kr\/blog\/2023\/08\/16\/filtering-data-in-apps-script\/"},"modified":"2026-08-21T16:52:38","modified_gmt":"2026-08-21T07:52:38","slug":"filtering-data-in-apps-script","status":"publish","type":"post","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/08\/16\/filtering-data-in-apps-script\/","title":{"rendered":"Filtering Data in Apps Script"},"content":{"rendered":"

This post is a corrected post after AI explains the code included in the book “Google Apps Script 101: Building Work Automation For Free”<\/a>. Added a strikethrough<\/s> when editing what AI has written, and added color<\/span> when edited by author<\/p>\n

Table of Contents<\/h2>\n
    \n
  1. Summary<\/a><\/li>\n
  2. Code<\/a><\/li>\n
  3. Code Explanation<\/a><\/li>\n
  4. Example<\/a><\/li>\n
  5. AI Prompt<\/a><\/li>\n<\/ol>\n

    Summary<\/h2>\n

    This blog post will demonstrate how to filter data in Apps Script using the filter<\/code> method. We will write a function that retrieves data from a Google Spreadsheet and filters it based on a specified criteria.<\/p>\n

    Code<\/h2>\n
    function filterCat() {\n  const SS = SpreadsheetApp.getActiveSpreadsheet()\n  const T_SHEET6 = SS.getSheetByName('\uc2dc\ud2b86')\n\n  const data = T_SHEET6.getDataRange().getValues()\n  let dataFilter = data.filter(row => row[0] == '\uace0\uc591\uc774')\n  Logger.log(dataFilter)\n}<\/code><\/pre>\n
    Code Explanation<\/h2>\n
    The code defines a function named filterCat<\/code>. It retrieves the active Google Spreadsheet and gets a specific sheet named ‘\uc2dc\ud2b86’. The getDataRange()<\/code> method is used to get the range of data in the sheet, and the getValues()<\/code> method retrieves the values from the range.<\/p>\n
    The filter<\/code> method is then applied to the data array, using an arrow function as the filtering condition. In this example, the code filters the data based on the first column matching the value ‘cat’. The filtered data is stored in the dataFilter<\/code> variable.<\/p>\n
    Finally, the filtered data is logged using the Logger.log()<\/code> function.<\/p>\n
    Example<\/h2>\n
    Suppose we have a Google Spreadsheet with a sheet named ‘\uc2dc\ud2b86’ that contains a column of animal names in the first column. We want to filter the data to only include rows where the animal type is ‘cat’.<\/p>\n\n\n\n\n\n\n\n
    Column A<\/th>\nColumn B<\/th>\nColumn C<\/th>\n<\/tr>\n
    Type<\/td>\nName<\/td>\nAge<\/td>\n<\/tr>\n
    cat<\/td>\nPong<\/td>\n10<\/td>\n<\/tr>\n
    Puppy<\/td>\nTami<\/td>\n12<\/td>\n<\/tr>\n
    cat<\/td>\nping<\/td>\n10<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
    When the filterCat()<\/code> function is executed, the filtered data is logged to the Apps Script logger.<\/p>\n\n\n\n\n
    cat<\/td>\nPong<\/td>\n10<\/td>\n<\/tr>\n
    cat<\/td>\nping<\/td>\n10<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
    AI Prompt<\/h2>\n
    Write a function that filters data from a Google Spreadsheet based on a specified condition. Retrieve the active spreadsheet, get a specific sheet by name, and use the filter<\/code> method to filter the data. Log the filtered data.<\/p>\n","protected":false},"excerpt":{"rendered":"
    This blog post will demonstrate how to filter data in Apps Script using the filter method. We will write a function that retrieves data from a Google Spreadsheet and filters it based on a specified criteria.<\/p>\n","protected":false},"author":1,"featured_media":15611,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[118],"tags":[512,355,25,7],"class_list":["post-15596","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-apps-script","tag-ai-assisted","tag-apps-script","tag-filter","tag-spreadsheet"],"translation":{"provider":"WPGlobus","version":"3.0.5","language":"en","enabled_languages":["ko","en"],"languages":{"ko":{"title":true,"content":true,"excerpt":true},"en":{"title":true,"content":true,"excerpt":true}}},"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t