Question and Google Sheets Integration (Auto-Update)

Get Help
1

Hi, anyone knows how to perform an integration between results from a question and sheets google that are fully automated and synchronised?

It can be by using Apps Script.

Without use any public sharing link.

Thank you

2

You need to authenticate to Metabase as a user with user/password and from there do a request to the Metabase api

3

can you kindly share step by step when you have time? or some links?

4

unfortunately we don't have any guide. There should be guides on the internet about this as it's a very common case

5

I faced this problem of connecting google sheets to Metabase. Got a preliminary script from Github, modified it to my usecase. Here's the detailed guide to it:
https://medium.com/@deepxcode/how-to-connect-metabase-to-google-sheets-and-automate-the-whole-process-d0e79bf75d5

1 Like
6

thank you for your contribution :slight_smile: