Connecting with Google Sheet
Connecting with Google Sheet

Connecting with Google Sheet

đź“Ś
Your connection details will be encrypted in KAWA’s database and will be decrypted only to import data from your bases when an ETL runs (Manual trigger on the GUI or according to your schedule). It is NOT accessible to KAWA support team.

1. Configure the provider on KAWA

By default, KAWA comes in with a way to load data from public Google Sheets. If you wish to connect to restricted sheets, follow this guide.

In the data source section:

  • Click on “+” button and choose: “Connect to an external system” (#1 on schema)
  • Then, click on “+ Connector ” button next to the data import section (#2 on schema)
  • Pick the Google Sheet provider (#3 on schema)
image

2. Configure your service account JSON key

image

The JSON key must be similar to this:

{
  "type": "service_account",
  "project_id": "project-12345",
  "private_key_id": "aaaa09863f500cbbd7e8748eb06ad50c849",
  "private_key": "-----BEGIN PRIVATE KEY-----\nMIIpoAABAAaIQYt0UPDJd4L6JCH+MGc=\n-----END PRIVATE KEY-----\n",
  "client_email": "me@somewhere.iam.gserviceaccount.com",
  "client_id": "104354531353375714144",
  "auth_uri": "https://accounts.google.com/o/oauth2/auth",
  "token_uri": "https://oauth2.googleapis.com/token",
  "auth_provider_x509_cert_url": "https://www.googleapis.com/oauth2/v1/certs",
  "client_x509_cert_url": "https://www.googleapis.com/....iam.gserviceaccount.com"
}

Your service account key can be found on your Google Cloud Platform console, in the IAM section.

image

Please refer to this section for help creating a service account: https://cloud.google.com/iam/docs/service-accounts-create

Click on Test Connection then Create.

đź“Ś
While keeping your sheets protected, share them with the service account whose key you’ve used.
image