Hello Team,
I want to read google spreadsheet with name(not with ID). My spreadsheet will be different every month so can’t rely on spreadsheetID.
I am using gsuit read range activity but it has only option to read with spreadsheetID.
I have tried using “use google spreadsheet” activity but then it is not allowing to dynamically pass spreadsheet name.
Use Find files and folders get the list of files and check for the name and get the id of that particular gsheet name and then use that id in the read range