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

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)

Burnout Risk Levels

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