Google Sheets

Overview

Sync summary data to Google Sheets for easy sharing, simple reporting, and integration with other Google Workspace tools.

Setup

1. 1

   Create a Google Cloud service account and download the JSON key file.

2. 2

   Share your target spreadsheet with the service account email (give Editor access).

3. 3

   Go to Dashboard > Outputs, click Connect on Google Sheets, and paste the spreadsheet ID and service account JSON.

Tips

• Google Sheets has a 10 million cell limit — best for summary data rather than raw transaction logs.
• Enable the Google Sheets API in your GCP project.

Fields Required

Setup Guide

1. 1

   Go to GCP Service Accounts and select your project (or create one).

   https://console.cloud.google.com/iam-admin/serviceaccounts
2. 2

   Click "+ Create Service Account", name it smartecom-sheets, then click Create and Continue.

3. 3

   Skip adding a role (none needed), then click Done.

4. 4

   Click the new service account, go to the Keys tab, click "Add Key" > "Create new key" > JSON.

5. 5

   Copy the downloaded JSON file contents into the Service Account JSON field below.

6. 6

   Note the service account email (e.g., smartecom-sheets@project.iam.gserviceaccount.com).

7. 7

   Open your Google Sheet, click Share, paste the service account email, and give it Editor access.

8. 8

   Copy the Spreadsheet ID from the URL — the string between /d/ and /edit.