{"id":15599,"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-google-sheets-with-apps-script\/"},"modified":"2025-09-15T17:14:43","modified_gmt":"2025-09-15T08:14:43","slug":"filtering-data-in-google-sheets-with-apps-script","status":"publish","type":"post","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/08\/16\/filtering-data-in-google-sheets-with-apps-script\/","title":{"rendered":"Filtering data using include 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

    In this blog post, we will explore how to filter data in Google Sheets using Apps Script. We will write a function that filters a specific column in a worksheet based on a given criteria and returns the filtered data.<\/p>\n

    Code<\/h2>\n
    function filterName() {\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[1].includes('\ubcf4\ubbf8'))\n  Logger.log(dataFilter)\n}<\/code><\/pre>\n
    Code Explanation<\/h2>\n
    The code declares a function named filterName<\/code>. It retrieves the active spreadsheet and gets a specific sheet using getSheetByName<\/code> method.<\/p>\n
    The getDataRange<\/code> method is used to get the range of data in the sheet, and the getValues<\/code> method retrieves the values in the range.<\/p>\n
    The filter<\/code> method is applied to the data array, filtering rows where the second column (index 1) includes the string ‘\ubcf4\ubbf8’. The filtered data is then logged using the Logger.log<\/code> method.<\/p>\n
    Additional explanations about include can be received from AI as follows.<\/span><\/p>\n
    `data.filter(row => row[1].includes(‘Bomi’))` is the element whose second column value (name) contains ‘Bomi’ for each element of array `data` JavaScript code that filters only . This code means using the array’s `filter()` method to return only the elements that meet the condition as a new array.<\/p>\n
    The arrow function used here `row => row[1].includes(‘Bomi’)` takes each element, gets the value of the second column of that element, and determines whether the value includes ‘Bomi’.<\/p>\n
    Description of each part:
    \n– `data`: An array to filter.
    \n– `filter()`: A method of an array, which applies a given function to each element to meet the condition. Returns a new array of .
    \n– `row`: Each element in the array.
    \n– `row[1]`: The value of the second column of each element. Array indexes in JavaScript start at 0, so the second column corresponds to index 1. Inspect. So, `row[1].includes(‘Bomi’)` checks whether the values in the second column contain ‘Bomi’.<\/p>\n
    As a result, `data.filter(row => row[1].includes(‘Bomi’))` is a code that filters only elements whose value in the second column contains ‘Bomi’ and returns it as a new array. .<\/p>\n
    Example<\/h2>\n
    Let’s say we have a Google Sheet with a column containing names of employees. We want to filter the data to only include rows where the name includes the string ‘John’.<\/p>\n
    function filterName() {\n  const SS = SpreadsheetApp.getActiveSpreadsheet()\n  const T_SHEET = SS.getSheetByName('Sheet1')\n\n  const data = T_SHEET.getDataRange().getValues()\n  let filteredData = data.filter(row => row[1].includes('John'))\n  Logger.log(filteredData)\n}<\/code><\/pre>\n
    AI Prompt<\/h2>\n
    Write a function that filters a specific column in a Google Sheet based on a given criteria and logs the filtered data. The criteria should be passed as a parameter to the function.<\/s><\/p>\n
    Example usage: filterColumn('Sheet1', 2, 'John')<\/code><\/s><\/p>\n
    Expected output: An array of rows where the second column in ‘Sheet1’ includes the string ‘John’.<\/s><\/p>\n
    Get data from Google sheet and write code to check if a certain column contains the specified character. <\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
    In this blog post, we will explore how to filter data in Google Sheets using Apps Script. We will write a function that filters a specific column in a worksheet based on a given criteria and returns the filtered data.<\/p>\n","protected":false},"author":1,"featured_media":15630,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_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":[5,118],"tags":[512,69,25,541,7],"class_list":["post-15599","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-spreadsheet","category-apps-script","tag-ai-assisted","tag-script","tag-filter","tag-include","tag-spreadsheet"],"translation":{"provider":"WPGlobus","version":"3.0.2","language":"en","enabled_languages":["ko","en"],"languages":{"ko":{"title":true,"content":true,"excerpt":true},"en":{"title":true,"content":true,"excerpt":true}}},"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/15599","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/comments?post=15599"}],"version-history":[{"count":5,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/15599\/revisions"}],"predecessor-version":[{"id":17160,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/15599\/revisions\/17160"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media\/15630"}],"wp:attachment":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media?parent=15599"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/categories?post=15599"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/tags?post=15599"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}