​

Google Sheets

Use Sheets as a lightweight database for metrics, task logs, or agent outputs. AI Mate can read/write Sheets to automate reporting.

---

​

OAuth scopes required

• https://www.googleapis.com/auth/spreadsheets
• https://www.googleapis.com/auth/userinfo.email
• openid

---

​

Setup

1. Go to Integrations → Google Sheets
2. Click Connect and approve
3. (Optional) Pick key Sheets to bookmark

---

​

What you can do

• Append rows with agent outputs (daily digest, KPIs)
• Read metrics and generate summaries/charts
• Turn sheet rows into tasks or emails

---

​

Conversations

• “Summarize weekly KPI sheet: MRR, churn, activations.”
• “Append today’s digest to the ‘Daily Brief’ sheet.”

---

​

Agents

KPI reporter

• Instruction: “Every Monday, read KPI sheet (tab ‘Weekly’), summarize trends, and email me the highlights.”
• Schedule: Mondays 9 AM
• Destinations: Notes + Email

Sales ops logger (Sheets + HubSpot)

• Instruction: “Nightly, export deals over $10k from HubSpot and append to SalesLog sheet.”
• Schedule: Daily 11 PM
• Destinations: Sheets

---

​

Best practices

• Keep a dedicated ‘Agent Logs’ sheet
• Use consistent column names for reliable parsing