What you need before you start
An active Google Cloud account
A Google Sheet on your Google drive
Steps to connect Google Sheets to Nettla
1️⃣ Set up your Google Service account for Google Sheet
Follow the guide on this link:
2️⃣ Collect your integration details
From your BigQuery project, make note of the following:
Sheet ID
Sheet Name
Credentials (JSON key)
3️⃣ Share your Google Sheet with the service account
Go to the Sheet on your Google Drive
Share it with the service account email, with a similar format as:
<service-name>@<project-name>.iam.gserviceaccount.com
Find email address on
Google Cloud after service account has been created (or)
Inside of the JSON credentials file
4️⃣ Enter details into Nettla
Log in to Nettla Admin → Settings → Integrations → Google Sheet and paste the Sheet ID, Sheet Name, and Credentials. Save to confirm.