show the google sheets rows that match your question

bring the unassigned applications to the top of the meeting. the bot can filter or sort a chosen google sheets range using your condition.

by the dusk bot team · checked 12 november 2026 · how we made this

name the tab and table, then ask for a preview. it needs write access because the filter changes the shared sheet. want your own list? ask for matching rows in chat.

pixel art: a cyan pixel bot and a blue pixel bot beside the Google Sheets mark on a white tile, a magnifying glass and a chart on an easel, on a lemon field in front of sand dunes by the sea, one saying "only unassigned applications"

set basic filter, in plain words

show the rows your team needs right now. give the spreadsheet link, tab and columns. describe the condition in ordinary words, such as applications without a reviewer. the bot sets the filter.

for a private report, ask it to read values and list matches in chat. that leaves everyone else's sheet view alone.

a routine to copy

paste this into a chat with your bot

on alternate mondays at 10:55, inspect the applications table in my linked rosehollow bursary sheet. propose a basic filter for rows whose reviewer field is empty. show the tab, range and condition here. ask me before setting it. after i agree, set the filter and report it here. never delete hidden rows or edit applicant details.

when: alternate mondays at 10:55
needs: google sheets with read and write for reading the table and setting its filter

what comes back looks like this (an example)

rosehollow bursary filter proposal
- tab: applications
- range: A1:H41
- condition: reviewer is empty
set this filter for the selection meeting?

good jobs for it

show applications with no reviewer before a selection session
show confirmed orders in a bounded table before packing
filter the working table to the region and status your team needs

before it runs

dusk bot counts Set Basic Filter as a change: it alters something in Google Sheets, and the sending setting does not cover it. a bot you allow only to read can never call it.

the permissions Google Sheets asks for to run it: spreadsheets, drive.file, drive.

how to start

connect google sheets. allow table reading and setting a basic filter with read and write.
link the spreadsheet and name the tab and table. explain which values should count as empty.
ask for the proposed range and condition. keep "ask me before setting it" in the routine.
look at the visible rows after the change. Pause if the selection rules change before the next run.

limits worth knowing

the filter belongs to the sheet. it is not a private report inside dusk chat.
name the table and the rows you want. the spreadsheet link alone leaves the bot guessing.
the filter stays after the bot leaves. turn it off in sheets when the review ends.

the details it works from

input	required	what it is
`filter`	yes	The filter to set.
`spreadsheetId`	yes	The ID of the spreadsheet.
`responseRanges`	no	Limits the ranges included in the response spreadsheet.
`responseIncludeGridData`	no	True if grid data should be returned.
`includeSpreadsheetInResponse`	no	Determines if the updated spreadsheet resource appears in the response.

from composio's catalog for Google Sheets (action GOOGLESHEETS_SET_BASIC_FILTER, read 12 november 2026⁴). your bot fills these in from what you tell it.

try it in 2 minutes

connect sheets and paste the spreadsheet link
name the tab, table and condition you want
compare the proposed range with your table before agreeing

mistakes people make

asking for a private list but allowing a sheet change

request matching rows in chat when other people should keep their view.

including the wrong table in the range

match the tab and first and last columns to your table before setting the filter.

questions

does filtering delete rows that do not match?

the rows stay in the file. the filter hides non-matching rows. keep deletion actions out of this bot's allowance.

can i get a list without changing the sheet filter?

yes, ask for matches in chat. the bot needs a value-reading action for that. set basic filter changes the spreadsheet itself.

sources

dusk bot docs: files and apps
dusk bot docs: routines
dusk bot docs: computer permissions
composio, Google Sheets toolkit (catalog version 20261101_00), checked 12 november 2026

drafted with ai help from the dusk bot docs and the sources listed on this page, then checked against them. if something here is wrong or out of date, write to [email protected].