How I can make my agent to read and summaries 1000+ rows of google sheet which have some dropdown options too for some coloums

I am facing problem where my agent uses google sheet tools and fetching only 100 rows first later when we ask if it's fetching the remaining next 100

My excel sheet consists of tasks and there progress (dropdown) which have options like completed in progress and not completed