Skip to main content

How do I connect Google Sheets?

Send Nettla events to a Google Sheet using a Google service account, step by step.

Written by Nettla

Create a Google service account, share your sheet with it, then go to Settings → Integrations, click Google Sheets, enter the Sheet ID, Sheet Name and credentials, and click Connect to Google Sheets.

What you need

  • A Google Cloud account.

  • A Google Sheet in your Google Drive.

Step 1: Create a service account

  1. In Google Cloud, create a service account.

  2. Create a JSON key for it and download the file.

Step 2: Share the sheet with the service account

  1. Open the Google Sheet.

  2. Click Share.

  3. Add the service account's email address with edit access. It looks like [email protected]. You'll find it in Google Cloud or in the JSON key file.

Step 3: Connect in Nettla

  1. Go to Settings → Integrations.

  2. Click the Google Sheets tile.

  3. Enter the Sheet ID. This is the part of the sheet's web address between /d/ and /edit.

  4. Enter the Sheet Name. This is the name of the tab, for example "Sheet1".

  5. Paste the GCP Service Account Credentials JSON.

  6. Click Connect to Google Sheets.

The tile then shows Connected.

Good to know

  • Google Sheets receives all four categories by default: user, booking, payment and court events. Change this with the gear icon.

  • Columns use readable names, for example "Opt In To Marketing Emails".

Related Articles
Did this answer your question?