bplmp / metabase-google-sheets-add-on

Import a Metabase question directly to a Google Sheet.

Metabase Google Sheets Add-on

This Google Sheets add-on imports the result of a Metabase question to a Google Sheet by using the Metabase API.

It has two main functions that an user can access:

• importQuestion: import a single question from Metabase using it's question id number (you can find this at the end of a question URL) into the current Google Sheet tab
• importAllQuestions: imports all questions in a Google Sheet using the following name convention: (metabase/123) -> imports question number 123

What Users See

Metabase API Access

Currently, the add-on authenticates with Metabase by using a user account. You can use your own user account or create a dedicated one for the add-on. It sends the username and password and gets a token in response that it uses to make requests. If the token is expired (after a certain period of time it will expire) then the script requests a new token.

When deploying for the first time, remember to set following ENV vars in your Google Script Project file, by going to File -> Project Properties:

• BASE_URL (the url to your metabase instance with a trailing slash, e.g. https://my-company.metabase.com/)
• USERNAME (a Metabase username)
• PASSWORD (a Metabase user password)
• TOKEN (do not set it; it will be set automatically)

Publishing the Add-on

Publishing a Google Apps Add-on is a tricky process. For help on how to publish a Google Sheets Add-on: https://developers.google.com/gsuite/add-ons/how-tos/publishing-editor-addons.

Otherwise, you can just use the code as a simple Google Apps Script. Remember, to access the Project Properties, you might have to switch to the old (legacy) Google Apps Script editor.

metabase-google-sheets-add-on's Issues

Update data in real time without import the question

Hello! Is it possible to update this data extracted from metabase in real time without import the question?

Add on not available anymore?

It seems the add-on is no longer available through Google, so are you able to update your Readme to give more detail on how to set this up as a Google Apps script?

Addressing the metabase from internal server

I will appreciate it if someone helps me on running this addon for Metabase internal server. When I call all questions for the URL which I Provided, it showed me "Couldn't find any question numbers to import". It seems it can not query that link.

This action would increase the number of cells in the workbook above the limit of 5000000 cells."

When I try to run the script, I get this error in Google Sheets:

"Question 1 failed to import. Exception: This action would increase the number of cells in the workbook above the limit of 5000000 cells."

I'm tried limiting the number of rows on the Metabase size to 1,000, but I still get this error.

Auto import specific question instead of all questions

Hi @bplmp
I am wondering if it is possible to auto importing a specific question instead of all questions.
I added triggers in the Script based on time, but I have three different questions to update regularly. The issue is that they are too large to properly update all in one go. The script times out.
I am looking for a function to add a specific question, but pre-populated in the function already so I don't need to confirm the question number like with the importQuestion function.
Your help would be awesome!
Thank you!

Getting this error.

How do I resolve it?

Metabase Google Auth Login

This is a great script! How would we setup the script to login to our Metabase account if we use Google authorization for login?

Filter by column

Hi! I was wondering if there was any way to implement your code by providing a filter for the query, for example, import only the data from the querry corrresponding to a certain user_id.
Like n the image attached, filter by external_request_id.
Thanks!

Could not parse text

I received this message, I didn't run the script

Error popup

Hi, The code was perfect. The problem was when I run the code (Metabase, Import question) The below error is coming everytime

Exception: Request failed for https://insights.censanext.com returned code 401. Truncated server response: {"errors":{"password":"did not match stored password"}} (use muteHttpExceptions option to examine full response)

Please help

DNS error

@bplmp the script is running; however, I am getting a message saying "DNS error: http://nullapi/card/57/query/csv". Any thoughts?

Exception: Could not parse text

Hey @bplmp , how have you been?
I'm struggling in here with this:

Can you please help me out?

Thanks in advance.

DNS Error

Hi @bplmp! This is wonderful!

I have set up my variables in Script Properties (legacy editor), but am still getting a DNS error of: Exception: DNS error: http://nullapi/session. This makes me think for some reason it isn't referencing the properties I've set up. Any thoughts?

Thanks!

Possibility to add variables

Hello all, I was wondering if there is a possibility to add variables to this script? my questions usually depend on a id number that I have as a variable, I tried to hard-code like

function getQuestionAndFillSheet(baseUrl, token, metabaseQuestionNum, sheetName) { var questionUrl = baseUrl + "api/card/" + metabaseQuestionNum + "?id=1193" + "/query/csv";

but it throws an error saying that the end point does not exist :(

Can't see functions after publishing the add-on

If I run the script as a Google App-script, it works as great

but if I publish the add-on, the functions disappear, and I can only see the "help" option