Google Sheets

Overview

Google Sheets powers everything from pricing tables and inventory trackers to scheduling rosters and customer lists. But most people outside the team that owns the sheet don't know which sheet to open, which tab to check, or which row has their answer.

The Google Sheets integration lets your AI agent read sheet data, inspect metadata like sheet names and row counts, and query specific ranges. Your AI Agent turns a spreadsheet into a conversational lookup tool.

When to Enable This

• Your team maintains pricing, inventory, or scheduling data in Google Sheets and gets frequent lookup requests
• Customer-facing agents need to check a live spreadsheet (e.g., availability, pricing) during conversations
• You want the AI to answer “What's the current price for X?” using real-time sheet data

Available Actions

Available actions depend on your agent type and plan. Customer-facing actions serve customers. Internal team actions are for authenticated team use. AI CoPilot is Enterprise-only. Plus enables up to 5 actions per agent, Pro enables 40, and Enterprise has no enabled-action limit.

Prerequisites

Before connecting Google Sheets, make sure you have:

• A Google Workspace or personal Google account
• OAuth consent configured for the Google Sheets API
• The spreadsheets you want to query shared with the authorized account

Setup Instructions

Step 1: Authorize Google Sheets

1. In ChatSpark, go to AI Actions
2. Find Google Sheets in the Library and click Enable
3. Click Connect Google Account
4. Sign in with the Google account that has access to the spreadsheets
5. Grant ChatSpark read-only access to Google Sheets

Step 2: Configure in ChatSpark

1. After authorizing, select the AI Agent(s) that should have access
2. Add the spreadsheet IDs or URLs you want the AI to query
3. Click Save

Configuration Fields

Testing Your Integration

After setup, open your AI Agent widget and try these realistic queries:

1. Ask: “What's the current price for the Enterprise plan?”
2. The AI should read your pricing sheet and return the matching row

More test phrases:

• “How many units of the Blue Widget are in stock?”
• “Who's scheduled for the morning shift on Friday?”
• “Show me the column headers in the inventory tracker”

Troubleshooting

Spreadsheet not accessible

The connected Google account must have at least “Viewer” access to the spreadsheet. Share the sheet with the authorized account if needed.

Wrong sheet tab

If data comes from the wrong tab, specify the tab name in your query (e.g., “Check the Inventory tab for Widget Pro”). The AI uses Get Metadata to discover available tabs.

OAuth token expired

Google OAuth tokens refresh automatically. If the connection breaks, go to AI Actions in ChatSpark and click Reconnect.