Google Workspace Sentiment Analyzer

"Team Communication Health Metrics" by John Rippy | johnrippy.link

🏆 2025 Zapier Automation Hero of the Year — Project Phoenix: A 95-step AI sales pipeline cutting development time by 50%. Read more →

---

Analyze sentiment across your entire Google Workspace: Gmail, Calendar, Chat, and Docs. Get company health scores, client relationship insights, and team burnout indicators in a single comprehensive report.

What This Actor Does

This actor aggregates sentiment analysis from multiple Google Workspace sources to provide:

• Company Health Score: Overall communication health across your organization
• Client Sentiment Score: How your external communications are trending
• Team Burnout Indicators: Early warning signs of team overload
• Client Risk Alerts: Identify at-risk client relationships
• Actionable Recommendations: Prioritized steps to improve communication health

Data Sources

Source	What We Analyze	Metrics
Gmail	Email sentiment, response times	Tone, urgency, client segmentation
Calendar	Meeting patterns, attendance	Load, cancellations, after-hours
Chat	Team communication (coming soon)	Collaboration health
Docs	Comment sentiment (coming soon)	Feedback tone, revision friction

Perfect For

• Operations Leaders: Monitor organizational communication health
• Customer Success Teams: Track client relationship sentiment
• HR/People Teams: Identify burnout risks early
• Executives: Get high-level Workspace intelligence
• Agency Owners: Monitor client relationship health

Input Examples

Demo Mode (No Credentials Required)

{
  "demoMode": true,
  "dateRange": "last_7_days",
  "dataSources": ["gmail", "calendar"],
  "includeClientSegments": true,
  "includeBurnoutIndicators": true
}

Real Mode with Google OAuth

{
  "demoMode": false,
  "accessToken": "ya29.your-access-token",
  "refreshToken": "your-refresh-token",
  "clientId": "your-client-id.apps.googleusercontent.com",
  "clientSecret": "your-client-secret",
  "companyDomain": "yourcompany.com",
  "dateRange": "last_14_days",
  "dataSources": ["gmail", "calendar"],
  "includeClientSegments": true,
  "includeBurnoutIndicators": true
}

Output

Summary

{
  "summary": {
    "companyHealthScore": 60,
    "clientSentimentScore": 62,
    "teamBurnoutRisk": "medium",
    "dataSourcesAnalyzed": ["gmail", "calendar"],
    "dateRange": "last_7_days"
  }
}

Client Segments

{
  "clientSegments": [
    {
      "domain": "acmecorp.com",
      "overallSentiment": 78,
      "trend": "improving",
      "riskLevel": "low"
    },
    {
      "domain": "troubledclient.com",
      "overallSentiment": 35,
      "trend": "declining",
      "riskLevel": "high"
    }
  ]
}

Burnout Indicators

{
  "burnoutIndicators": [
    {
      "metric": "After-Hours Email Activity",
      "value": 18,
      "threshold": 15,
      "status": "warning",
      "description": "18% of emails sent outside business hours"
    },
    {
      "metric": "Meeting Load",
      "value": 28,
      "threshold": 25,
      "status": "warning",
      "description": "28 hours/week in meetings"
    }
  ]
}

Alerts & Recommendations

{
  "alerts": [
    {
      "type": "client_risk",
      "severity": "critical",
      "message": "1 client(s) at high risk: troubledclient.com",
      "action": "Schedule immediate check-in calls"
    }
  ],
  "recommendations": [
    {
      "priority": "high",
      "category": "Client Retention",
      "action": "Schedule recovery calls with at-risk clients",
      "impact": "Prevent potential client churn"
    }
  ]
}

Scoring System

Company Health Score (0-100)

Score	Label	Meaning
80-100	Excellent	Strong communication culture
60-79	Good	Healthy with minor concerns
40-59	Fair	Needs attention
20-39	Poor	Significant issues present
0-19	Critical	Immediate intervention needed

Burnout Risk Levels

Level	Indicators	Action
Low	All metrics healthy	Continue monitoring
Medium	1-2 warning indicators	Address proactively
High	Multiple warnings or critical	Immediate intervention

Google OAuth Setup

Required Scopes

https://www.googleapis.com/auth/gmail.readonly
https://www.googleapis.com/auth/calendar.readonly

Setup Steps

1. Create a Google Cloud project
2. Enable Gmail API and Calendar API
3. Configure OAuth consent screen
4. Create OAuth credentials
5. Get access token via OAuth flow

Limitations (Apify Version)

• Point-in-time snapshot (no historical trends)
• Single user mailbox only
• Manual OAuth token management
• Limited to 100 items per source
• No real-time monitoring

Enterprise Version

For continuous monitoring and team-wide insights:

Workspace Intelligence by LocalHowl

Enterprise features:

• Real-time OAuth connection (no token management)
• Continuous monitoring & Slack/Teams alerts
• Historical trend analysis over months
• Team-wide and department rollups
• Executive dashboards
• Client health CRM integration
• SSO/SAML authentication
• Dedicated support

Use Cases

1. Weekly Health Check

Run weekly to get a pulse on company communication:

const result = await apifyClient.actor("localhowl/workspace-sentiment-analyzer").call({
  accessToken: process.env.GOOGLE_ACCESS_TOKEN,
  dateRange: "last_7_days",
  dataSources: ["gmail", "calendar"]
});

if (result.summary.companyHealthScore < 60) {
  // Send alert to leadership
}

2. Client Relationship Monitoring

Track client sentiment before quarterly reviews:

const result = await apifyClient.actor("localhowl/workspace-sentiment-analyzer").call({
  accessToken: process.env.GOOGLE_ACCESS_TOKEN,
  companyDomain: "mycompany.com",
  dateRange: "last_30_days",
  includeClientSegments: true
});

const atRiskClients = result.clientSegments.filter(c => c.riskLevel === "high");

3. Burnout Prevention

Monitor team health metrics:

const result = await apifyClient.actor("localhowl/workspace-sentiment-analyzer").call({
  accessToken: process.env.GOOGLE_ACCESS_TOKEN,
  includeBurnoutIndicators: true
});

if (result.summary.teamBurnoutRisk === "high") {
  // Implement intervention measures
}

Privacy & Security

• Uses Google OAuth 2.0 with read-only scopes
• Analyzes metadata and snippets only
• No full email/document content stored
• All analysis is aggregated, not individual
• Compliant with Google's API usage policies

Related Actors

• Gmail Sentiment Scanner: Deep-dive Gmail analysis
• Teams Meeting Cost Tracker: Microsoft Teams analysis
• Meeting Culture Score Checker: Public meeting culture analysis

Support

• Documentation: https://meeting.localhowl.com/docs
• Email: support@localhowl.com
• Issues: Report bugs or request features

---

Author

Built by John Rippy | johnrippy.link

2025 Zapier Automation Hero of the Year — Project Phoenix: A 95-step AI sales pipeline cutting development time by 50%. Read more

Part of the Workspace Intelligence suite by LocalHowl