---
title: "Create Filters in Google Sheet using Google Apps Script"
author: "Martin Hawksey"
date: 2021-06-01T21:27:24+00:00
modified: 2021-10-04T20:21:30+00:00
canonical_url: https://pulse.appsscript.info/p/2021/06/create-filters-in-google-sheet-using-google-apps-script/
markdown_url: https://pulse.appsscript.info/p/2021/06/create-filters-in-google-sheet-using-google-apps-script.md
categories:
  - "Beginner"
  - "Sheets"
  - "Solutions"
tags:
  - "@aryanirani123"
  - "Medium"
featured_image: https://pulse.appsscript.info/files/2021/06/12gxZ1MBHVXO_aUGWasm1zQ.png
description: "There are lots of ways you can filter data in Google Sheets and in this post Aryan Irani uses SpreadsheetApp.newFilterCriteria() to create a filter and then copy the filtered data to a new sheet. The post contains everything you need to know to filter data in this way."
---

# Create Filters in Google Sheet using Google Apps Script

![Create Filters in Google Sheet using Google Apps Script](https://pulse.appsscript.info/files/2021/06/12gxZ1MBHVXO_aUGWasm1zQ.png)

> [https://aryanirani123.medium.com/create-filters-in-google-sheet-using-google-apps-script-145e925e4dc1](https://aryanirani123.medium.com/create-filters-in-google-sheet-using-google-apps-script-145e925e4dc1)
> How to create filters in Google Sheets using Google Apps Script.

There are lots of ways you can filter data in Google Sheets and in this post Aryan Irani uses `[SpreadsheetApp.newFilterCriteria()**](https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app#newFilterCriteria())` to create a filter and then copy the filtered data to a new sheet. The post contains everything you need to know to filter data in this way.

Source: *[Create Filters in Google Sheet using Google Apps Script*](https://blog.yamm.com/create-filters-in-google-sheets-with-google-apps-script/)

---

*Published by [Martin Hawksey](https://pulse.appsscript.info/p/author/admin/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2021/06/create-filters-in-google-sheet-using-google-apps-script/](https://pulse.appsscript.info/p/2021/06/create-filters-in-google-sheet-using-google-apps-script/)*