​

Google Sheets Service Account Credentials

Google Sheets Service Account credentials allow your SubverseAI agents to read from and write to Google Sheets — including private sheets — using server-to-server authentication.

​

Overview

Google Sheets Service Account credentials provide access to:

• Reading and writing data on private and public spreadsheets
• Appending, updating, and deleting rows
• Managing multiple sheets programmatically
• Secure, non-interactive authentication without user login

​

Steps to Create Google Sheets Service Account Credentials

​

1. Set Up a Google Cloud Project

1. Visit the Google Cloud Console
2. Sign in with your Google account
3. Create a new project or select an existing one

​

2. Enable the Google Sheets API

1. Navigate to APIs & Services > Library
2. Search for Google Sheets API
3. Click Enable

​

3. Create a Service Account

1. Go to IAM & Admin > Service Accounts
2. Click Create Service Account
3. Enter a name and description (e.g., “SubverseAI Sheets Integration”)
4. Click Create and Continue
5. Skip optional role grants for now and click Done

​

4. Generate a JSON Key File

1. Click on the service account you just created
2. Go to the Keys tab
3. Click Add Key > Create new key
4. Select JSON and click Create
5. The key file is downloaded — keep it secure

​

5. Share Your Sheet with the Service Account

1. Open the Google Sheet you want to access
2. Click Share
3. Add the service account email (e.g., [email protected]) as an Editor (or Viewer for read-only)
4. Click Send

​

6. Add to SubverseAI

1. Go to Credentials in your SubverseAI dashboard
2. Click Create New Credential
3. Select Google Sheets Service Account from the credential types
4. Enter a name for your credential (e.g., “Production Service Account”)
5. Fill in the required fields from your JSON key file:
   • Service Account Email: The client_email field
   • Private Key: The private_key field (including -----BEGIN PRIVATE KEY----- header)
   • Project ID (optional): The project_id field
6. Click Save Credential

​

Required Fields

• Name: A descriptive name for your credential
• Service Account Email: The client_email from your JSON key file
• Private Key: The private_key from your JSON key file

​

Optional Fields

• Project ID: The project_id from your JSON key file

​

Usage Tips

• Grant the service account only the minimum necessary permissions on each sheet
• Rotate JSON keys periodically for security
• Use separate service accounts for different environments (dev/staging/prod)
• Store the downloaded JSON key file securely and never commit it to version control

​

Troubleshooting

Permission Denied (403): Ensure the sheet has been shared with the service account email Invalid JWT / Private Key Error: Verify the private_key value includes the full PEM block — newlines must be preserved (use \n if pasting inline) API Not Enabled: Ensure the Google Sheets API is enabled in your Cloud project Service Account Not Found: Confirm the client_email value was copied correctly from the JSON key file

​

Next Steps

After creating your Google Sheets Service Account credentials:

• Build data entry and update workflows
• Automate report generation and sheet population
• Sync CRM or database records to Google Sheets
• Set up scheduled data exports and imports