Hi, is there any way that allow me export question result to google sheet?
you could use Google Sheet IMPORTDATA (=IMPORTDATA) functionality to pull info from Metabase (enable sharing from settings->admin->public sharing) and then from your question go to share and get the public link in csv
put the CSV link in your google sheet formula and voilá
Thanks for the help, I did it step by step, I can download the .csv data from the shared Metabase link but Google Sheet can not fetch the url
. I tried other public data source, the IMPORTDATA function worked. Is there any limitation for the IMPORTDATA function?
maybe your Metabase server is not exposed to the internet?
Wow this is really amazing. I just knew this feature. its really works! amazing
Thanks Luiggi
maybe you forget to use " " in the url.
the format is :
IMPORTDATA(url, delimiter, locale)
Example
IMPORTDATA("http://www.census.gov/2010census/csv/pop_change.csv", ",", "en_US")