What would be the best way to load data from Google Sheet file?
The idea is to define a Google sheet where data will be available in columns format and pull data to Flexmonster.
Thank you for reaching out to us.
From our experience, the possible option to retrieve the data from Google Sheets is to use the built-in “publish to the web in CSV format” functionality. It allows generating a dedicated link leading to the data in CSV format. Next, this link can be used as a data provider for Flexmonster. Please see our documentation on connecting to CSV for reference.
This approach requires the data to be published in CSV format, which means it will not be available without authentication.
In order to avoid publishing the data to the web, we suggest looking for APIs allowing to operate with Google Sheets. Usually, they allow retrieving the data in JSON/CSV format while keeping the document itself private.
Still, we want to note that Google Drive was not designed to be used as a data provider. It leads to significant limitations on the data retrieving process. It includes both the dataset size limit and the time needed to load the data.
Therefore, we suggest considering changing the data provider for Flexmonster.
You are welcome to see our documentation page dedicated to all the data sources supported by Flexmonster: https://www.flexmonster.com/doc/supported-data-sources/.
Feel free to contact us in case other questions arise.