Power Query load files Google Drive

[apoprio]

Good evening everyone!
Well, I've seen that Microsoft has recently evolved a connector to load data from XLSX files that are inside Google Drive.
Example:

Source = GoogleSheets.Contents(....)
But our need is to read "all" XLSX files from a Google Drive folder.
Does anyone know how to effectively inform if there is a way to load "all" these files from a Google Drive folder as we do today with files that are Sharepoint or Onedrive ???

Example for Sharepoint:
Source = SharePoint.Files("https://site", [ApiVersion = 15]),

Example for Google Drive ???

[ppm1]

I suspect you'll need to use either the Google Drive REST API (e.g., get the actual files or the URL of all the files you can then use in the GoogleSheets.Contents function) or Google Drive File Stream.

Power Query from Google Drive - Excel University (excel-university.com)

Pat