How to Read google Spreadsheet with name

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.

Please help me with it.

HI @komal.shinde

Welcome to Community!

You can try like this

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

For your reference


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.