That's a completely different API. The article you referenced uses the Google Sheets API, to read a Google Spreadsheet. You need to use the Google Drive API. See here for reference: https://developers.google.com/drive/api/guides/about-sdk
It seems to be doable, but I couldn’t find a step by step tutorial for doing it.
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.