Track Filtrete Air Filter installations in a Google Sheets spreadsheet
Start today
Popular Filtrete™ Smart and Google Sheets workflows and automations
- Track outdoor air quality in Google Sheets
- Track Filtrete Smart Air Filter life changes in a Google Sheets spreadsheet
Useful Filtrete™ Smart and Google Sheets integrations
Triggers (If this)
- Filtrete Smart Air Filter life changedThis trigger fires when the remaining life (%) of a Filtrete Smart Air Filter changes.
- New spreadsheet added to folderThis trigger fires when a new spreadsheet is added to a Google Drive folder you specify. Note: only works for spreadsheets created after the Applet turned on.
- Filtrete barcode air filter life (days remaining) dropped belowThis trigger fires when the days remaining on any of your Filtrete barcode air filters drops below your chosen value.
- New worksheet in spreadsheetThis trigger fires when a new worksheet is added to a spreadsheet you specify.
- Filtrete Smart Air Filter life (%) dropped belowThis trigger fires when the remaining life of any of your Filtrete Smart Air Filter drops below your chosen percentage.
- New row added to spreadsheetThis trigger fires when a new row is added to a spreadsheet you specify.
- New Filtrete air filter installedThis trigger fires whenever an existing air filter is replaced or a new air filter is added using the Filtrete Smart app.
- Cell updated in spreadsheetThis trigger fires when a particular cell is updated within the spreadsheet you specify.
- Outdoor Air Quality Level changedThis trigger fires when the Filtrete™ outdoor Air Quality Scale level changes; for example: from Good to Fair.
- Outdoor Air Quality Value became lower thanThis trigger fires when the Filtrete outdoor Air Quality Value becomes lower (i.e. better) than a chosen value.
- Outdoor Air Quality updatedThis trigger fires when updated outdoor air quality information becomes available.
- Outdoor Air Quality Value became higher thanThis trigger fires when the Filtrete™ outdoor Air Quality Value becomes higher (i.e. worse) than a chosen value.
Queries (With)
- Current values of a rowThis query returns the current values in a given row. Values from columns A-Z are available as ingredients.
- History of Filtrete Smart Air Filter life (%) dropped belowThis query returns a list of when the remaining life of any of your Filtrete Smart Air Filter drops below your chosen percentage. Note: this query will only return future events after this Applet is created.
- Current value of a cellThis query returns the current value of a single cell in your spreadsheet.
- History of when Filtrete barcode air filter life (days remaining) dropped below a thresholdThis query returns a list of when the days remaining on any of your Filtrete barcode air filters dropped below your chosen value. Note: this query will only return future events after this Applet is created.
- History of rows added to spreadsheetThis query returns a list of when a new row is added to a spreadsheet you specify.
- History of Filtrete Smart Air Filter life changedThis query returns a list of when the remaining life (%) of a Filtrete Smart Air Filter changes.
- History of when Cell was updated in spreadsheetThis query returns a list of when a particular cell was updated within the spreadsheet you specify.
- History of Filtrete air filters installedThis query returns a list of whenever an existing air filter is replaced or a new air filter is added using the Filtrete Smart app.
- History of spreadsheets added to folderThis query returns a list of when a new spreadsheet is added to a Google Drive folder you specify. Note: only works for spreadsheets created after the Applet turned on.
- History of worksheets in spreadsheetThis query returns a list of when a new worksheet is added to a spreadsheet you specify.
Actions (Then that)
- Add row to spreadsheetThis action will add a single row to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.
- Update cell in spreadsheetThis action will update a single cell in the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created if the file doesn't exist.
IFTTT helps all your apps and devices work better together