Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

What are some ways to retrieve data from Googlesheet?

Answered
sodbayar Erdenebaatar asked on December 30, 2020

What are some ways to retrieve data from Googlesheet?.
 
We use Saas license
 
Thank you.

1 answer

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster December 31, 2020

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

Please login or Register to Submit Answer