Documentation Plugins Google Sheets data source Setup Configure

Configure the Google Sheets data source plugin

To configure the Google Sheets data source plugin, you need to perform the following steps:

1. Navigate into Grafana and click on the menu option on the top left.

2. Browse to the Connections menu and then click on the Data sources.

3. Click on the Add new data source button.

4. Click on the Google Sheets data source plugin which you have installed.

5. Go to its settings tab and find the Authentication section.

6. It supports the following three ways of authentication:

   with an API keywith a service account JWTwith the default GCE service account

   Before you begin, create an API key.

   1. Select the API Key option in the Authentication type.
   2. Paste the API key.
   3. Click Save & Test button and you should see a confirmation dialog box that says “Data source is working”.

   Before you begin, create a service account and download the JWT file.

   1. Select the Google JWT File option in the Authentication type.

   2. You can perform one of the following three options:

      1. Upload the Google JWT file by clicking the Click to browse files and select the JSON file you downloaded.
      2. Click the Paste JWT Token button and paste the complete JWT token manually
      3. Click the Fill In JWT Token manually button and provide the JWT details including Project ID, Client email, Token URI, and Private key.

   3. Click Save & Test button and you should see a confirmation dialog box that says “Data source is working”.

   Before you begin, set up authentication with the default GCE service account

   1. Select the GCE Default Service Account option in the Authentication type.
   2. Type the Default project name
   3. Click Save & Test button and you should see a confirmation dialog box that says “Data source is working”.

   Tip

   If you see errors, check the Grafana logs for troubleshooting.