I'm working in automating a report draft from google sheets to google docs.
For this workflow my users go to the 'Evaluation table' and use the sheet filters to select the title and user of the report they want to create.
Thing is when I use my code to copy for the report it always gets the first line of data of all the table instead of the filtered view. I just need to retrieve this one line of filterred data.
Is there a way to retrieve the rows that are shown on the UI? That the users manually filtered?