In my integration project I need to get data in one sheet in Google Sheet.
My problem is: The data I need is on a sheet whose name is unknown, but it is always known to be the last sheet.
Is there any possibility to fetch the data this way? That is, indicate the search on a sheet according to its position within the spreadsheet?
Some information to understand what I am looking for:
A chatbot will capture data that will be stored on a sheet. For each customer served a sheet is created. The automation will be performed as soon as the chatbot service ends, so we know the data is on the last sheet of the spreadsheet.