How to Read google Spreadsheet with name

[komal.shinde]

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.

[Sudharsan_Ka]

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

Know about G Drive steps 1

Hello Everyone Let’s Learn and Let Learn. Checkout this for knowing about working with G Drive Activities First we will do the required set up okay…,

Now checkout the steps and do the required setup also leaving a video so that you can check that too

<a href="https://forum.uipath.com/t/g-suite-guidelines/474146" class="inline-onebox">G-Suite Guidelines</a> <a href="https://www.youtube.com/watch?v=okrKQemOKN0" class="inline-onebox">How …

Regards
Sudharsan