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.
Pls use ‘Get sheets’ activity which will give you array output of sheets
Then use for each loop , for each loop of SheetsArray
For each argument type should be string
Create a counter variable (int) and give default value as zero
Inside for each loop body use a if condition
counter = sheetsarray.length
Then use read data from that sheet
Below to the if condition use assign activity
Counter = Counter +1
I did as suggested (Although there is a possibility that you have gone wrong at some step).
I got the number of sheets in the document. Should the result be anything else? Or, how could I use this information? Is it possible to indicate the sheet to be used by informing its position in the spreadsheet?