I have installed dremio hopefully that it will help me initially pull data from multiple google spreadsheets in order to compile the dataset for reporting.
Not sure if this the best use of dremio, but is there any relevant info/doc/example showing such a case ?
Google Sheets is not directly supported as a source today. However, there are plenty of workarounds. You could always extract/download the sheet and either upload that directly into our UI or store it in some type of data storage. This could also be potentially automated using a combination of Google Sheets API + Dremio API