What are some ways to retrieve data from Googlesheet?

Hello,
 
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.
 
Another option is to use various APIs allowing to operate with Google Sheets.
Still, we want to notice that Google Drive is 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.
 
Kind regards,
Illia