54 min readContent generation

Implementation Guide: Generate case studies, annual reports, and program narratives

Step-by-step implementation guide for deploying AI to generate case studies, annual reports, and program narratives for Non-Profit Organizations clients.

Hardware Procurement

Staff Content Workstation - Standard

DellLatitude 5550 (i5-1345U, 16GB DDR5, 512GB SSD, 15.6" FHD)Qty: 4

$800-$1,000 per unit (MSP cost via TechSoup/Dell nonprofit channel) / $1,100-$1,350 suggested resale

Primary workstations for content staff who will use AI platforms daily for drafting case studies, reports, and narratives. 16GB RAM ensures smooth multitasking between AI platforms, CRM, Canva, and document editing. Dell offers nonprofit pricing through TechSoup.

Communications Director Workstation - Premium

LenovoThinkPad X1 Carbon Gen 12 (i7-1365U, 16GB, 512GB SSD, 14" 2.8K OLED)Qty: 1

$1,400-$1,800 per unit (MSP cost) / $1,900-$2,400 suggested resale

Premium workstation for Communications Director or Development Director who oversees all content output, reviews AI-generated drafts, and manages the content approval workflow. Higher-resolution display supports visual layout review of annual reports in Canva.

USB Condenser Microphone

Blue Microphones (Logitech)Yeti Nano USB Microphone (988-000400)Qty: 2

$80-$100 per unit (MSP cost) / $130-$150 suggested resale

Records high-quality audio interviews with program beneficiaries, volunteers, and staff. These recorded interviews are transcribed by AI and used as source material for case studies and program narratives, ensuring authentic voices are captured.

HD Webcam

LogitechBrio 500 (960-001426)Qty: 2

$100-$130 per unit (MSP cost) / $150-$180 suggested resale

Captures video testimonials from beneficiaries and program participants for multimedia annual reports. Video files are also transcribed via AI for written case study content extraction.

Document Scanner

Fujitsu (Ricoh)ScanSnap iX1400 (PA03820-B235)Qty: 1

$350-$400 per unit (MSP cost) / $475-$550 suggested resale

Digitizes legacy paper-based program reports, historical annual reports, and handwritten beneficiary testimonials. Scanned documents are OCR-processed and fed into AI as reference material for maintaining organizational history and voice consistency.

Software Procurement

ChatGPT Business (Nonprofit Discount)

OpenAIGPT-5.4Qty: 5 users

$6.25-$7.50/user/month with 75% nonprofit discount (standard: $25-$30/user/month). For 5 users: ~$31-$38/month MSP cost / $75-$100/month suggested resale to client

Primary AI content generation engine for drafting case studies, annual report sections, program narratives, donor communications, and grant report language. GPT-5.4 provides the highest quality long-form writing with strong instruction following for brand voice consistency.

Claude Team (Nonprofit Discount)

AnthropicClaude TeamQty: 5-seat minimum

~$8/user/month nonprofit rate (5-seat minimum = ~$40/month MSP cost) / $80-$120/month suggested resale

Secondary AI engine providing native Blackbaud, Candid, and Benevity connectors for pulling program and donor data directly into content generation workflows. Claude excels at nuanced, empathetic narrative writing ideal for beneficiary stories. Also serves as fallback if OpenAI experiences outages.

Google Workspace for Nonprofits (with Gemini & NotebookLM)

Googleper-seat SaaS (free tier)Qty: Up to 2,000 users (base tier)

Free for up to 2,000 users (base tier). Premium Gemini features included at no additional cost for nonprofits. MSP management fee: $100-$200/month

Foundation productivity suite providing Google Docs (collaborative editing of AI drafts), Google Drive (content storage and version control), Gmail, and now free Gemini AI and NotebookLM. NotebookLM is particularly valuable for uploading past annual reports and program data to create a searchable knowledge base that informs new content generation.

Canva for Nonprofits (Teams)

CanvaQty: Up to 50 users

Free for up to 50 users (value: $5,000+/year). MSP setup and template creation: one-time $500–$1,000

Visual design platform for laying out annual reports, case study one-pagers, social media graphics from AI-generated content, and infographics. AI-powered design suggestions and Magic Write complement the content generation workflow. Brand kit ensures visual consistency.

Grammarly Business

Grammarlyper-seat SaaS

$12/user/month billed annually. For 5 users: $60/month MSP cost / $90-$120/month suggested resale

Final polish layer for all AI-generated content. Checks grammar, tone, clarity, and brand voice consistency. Integrates with Google Docs and Microsoft Word to provide real-time editing suggestions on AI drafts before human approval.

Professional plan ~$49/month minus 15% nonprofit discount = ~$42/month MSP cost / $75-$100/month suggested resale

Integration middleware connecting CRM (Salesforce/Bloomerang), AI platforms, Google Drive, and notification systems. Automates data flow from program databases into AI content generation prompts and routes finished drafts through the approval workflow.

Otter.ai Business

Otter.aiQty: 2 seats

$16.67/user/month billed annually. For 2 seats: ~$33/month MSP cost / $55-$70/month suggested resale

AI-powered transcription service for converting recorded beneficiary interviews, staff conversations, and program meeting recordings into text that serves as raw material for case studies and program narratives.

Microsoft 365 Business Basic (Nonprofit Grant)

Microsoftper-seat SaaS (free grant)Qty: Up to 300 users

Free for up to 300 users (nonprofit grant). Optional M365 Business Premium at 75% discount: ~$5.50/user/month

Provides Teams for internal collaboration, OneDrive/SharePoint for document management, and Outlook. Serves as secondary productivity suite alongside Google Workspace. Free grant licenses available through Microsoft Nonprofits program. Note: E1 free licenses retiring July 1, 2025 — use Business Basic grant instead.

OpenAI API (GPT-5.4)

OpenAIGPT-5.4

$2.50/million input tokens, $10.00/million output tokens. Estimated monthly: $15-$50 for typical nonprofit usage / $40-$100 suggested resale

Programmatic API access for custom automation workflows, bulk content generation scripts, and integration with Zapier. Used for automated monthly program narrative generation from CRM data exports and batch processing of quarterly report sections.

Prerequisites

  • Stable internet connection: minimum 25 Mbps download / 10 Mbps upload at the nonprofit's office location. Verify with speedtest before engagement begins.
  • Valid nonprofit status documentation: 501(c)(3) determination letter (US), registered charity number (UK/Canada), or equivalent. Required for all vendor nonprofit discount applications.
  • TechSoup account registration: Client must have an active TechSoup profile (https://www.techsoup.org/). If not already registered, allow 2-4 weeks for validation. This unlocks Dell hardware discounts, Microsoft grants, and other nonprofit pricing.
  • Existing donor/program CRM system identified: Confirm whether client uses Salesforce Nonprofit Cloud, Bloomerang, Blackbaud (Raiser's Edge/eTapestry), Little Green Light, or another system. Document API availability and admin credentials.
  • At least 5-10 existing content samples: Collect previous annual reports, case studies, newsletters, and program narratives. These serve as training material for brand voice calibration in AI prompts. PDFs, Word docs, or web URLs all acceptable.
  • Designated Content Approval Authority: Identify 1-2 staff members (typically Communications Director and Executive Director) who will serve as final approvers for all AI-generated content before publication.
  • Organization brand guidelines document: Logo files, color codes, font specifications, approved terminology, and tone-of-voice guidelines. If none exist, the MSP should flag this as a pre-engagement deliverable ($500-$1,000 add-on).
  • Admin access to existing Google Workspace or Microsoft 365 tenant: Required for SSO configuration, user provisioning, and integration setup. If no tenant exists, the MSP will provision one during implementation.
  • Staff availability for training: Minimum 3 half-day blocks (4 hours each) across weeks 10-12 for hands-on training workshops. All content-producing staff must attend.
  • Firewall and network whitelist capability: Must be able to whitelist api.openai.com, api.anthropic.com, *.google.com, *.canva.com, *.zapier.com, and *.grammarly.com if any web filtering or firewall policies are in place.

Installation Steps

...

Step 1: Discovery & Content Audit

Conduct a comprehensive discovery session with the nonprofit's leadership and content team. Inventory all existing content types (annual reports, case studies, newsletters, grant reports, program narratives), document production frequency, identify pain points, and map current workflows from data collection through publication. Collect 5-10 exemplar documents that represent the organization's best content and authentic voice. Catalog the CRM system, existing productivity tools, and any current AI tool usage (even informal ChatGPT usage by individual staff).

Note

Use a structured intake questionnaire. Key questions: How many annual reports per year? How many case studies? What's your average production timeline? Who writes, who edits, who approves? What CRM do you use? Do you have brand guidelines? Have staff already been using AI tools informally? Budget this as a 2-3 hour on-site or video session plus 2-3 hours of document review.

Step 2: Apply for Nonprofit Vendor Discounts

Submit nonprofit discount applications to all relevant vendors. This must happen early because some approvals take 1-3 weeks.

1
OpenAI for Nonprofits — submit 501(c)(3) documentation via openai.com/nonprofit
2
Anthropic Claude for Nonprofits — apply at anthropic.com/claude-for-nonprofits
3
Google for Nonprofits — register at google.com/nonprofits (requires TechSoup validation)
4
Canva for Nonprofits — apply at canva.com/canva-for-nonprofits
5
Microsoft for Nonprofits — register at nonprofit.microsoft.com
6
Zapier — email support with nonprofit documentation for 15% discount
7
TechSoup registration if not already active
Note

Start ALL applications on Day 1 of the engagement. Google and Microsoft nonprofit validation through TechSoup can take 2-4 weeks. Track application status in a shared spreadsheet. Some vendors (OpenAI, Anthropic) have launched their nonprofit programs recently — if the application portal is unclear, contact their sales teams directly referencing the nonprofit program.

Step 3: Provision Google Workspace for Nonprofits

Set up or verify the Google Workspace for Nonprofits tenant. This serves as the foundational productivity and identity layer. Create user accounts for all content team members. Enable Gemini AI features and NotebookLM (now included free for nonprofits). Configure Google Drive folder structure for content workflow: /AI-Content-Drafts, /Approved-Content, /Annual-Reports, /Case-Studies, /Program-Narratives, /Source-Materials, /Brand-Assets.

  • Navigate to admin.google.com > Apps > Google Workspace > Gemini
  • Enable 'Gemini for Workspace' for the Content Team organizational unit
  • Create shared drives via Google Admin Console or Drive UI:
  • AI Content Production (shared drive): 00-Source-Materials/ → Interview-Transcripts/, Program-Data/, Historical-Reports/, Brand-Guidelines/
  • 01-AI-Drafts/ → Case-Studies/, Annual-Report-Sections/, Program-Narratives/
  • 02-Human-Review/
  • 03-Final-Approved/
  • 04-Published/
Note

If client already has Google Workspace, verify the plan level supports Gemini features. The free Nonprofit tier now includes Gemini and NotebookLM. If client is on Microsoft 365 instead of Google, adapt this step to use SharePoint/OneDrive with equivalent folder structure. Both can coexist.

Step 4: Configure Microsoft 365 Nonprofit Grant (Optional but Recommended)

Register for Microsoft 365 Business Basic free grant licenses (up to 300 seats). Even if Google Workspace is primary, M365 provides Teams for video meetings with beneficiaries, OneDrive as backup storage, and compatibility with donors/partners who use Office formats. Apply through nonprofit.microsoft.com and provision licenses through the Microsoft 365 Admin Center.

1
After M365 nonprofit tenant is provisioned, navigate to admin.microsoft.com
2
Go to Billing > Purchase Services > Search 'Microsoft 365 Business Basic (Nonprofit)'
3
Add up to 300 free licenses
4
Assign licenses to content team users
5
Enable MFA: Security > Authentication methods > Enable Microsoft Authenticator
6
If adding Copilot (optional, $25.50/user/month nonprofit): Billing > Purchase Services > Search 'Microsoft 365 Copilot'
7
Assign Copilot to Communications Director and key content staff only
Note

The free E1 grant is being retired July 1, 2025 — use Business Basic grant instead. M365 Copilot at $25.50/user/month is optional and should only be recommended if the client heavily uses Word/PowerPoint for final document production. For most nonprofits, the AI content generation will happen in ChatGPT/Claude with final formatting in Canva or Google Docs.

Step 5: Set Up OpenAI ChatGPT Business Workspace

Provision the ChatGPT Business workspace with nonprofit discount pricing. Create the team workspace, invite content team members, configure SSO if available, and set up organization-level settings including data privacy controls. ChatGPT Business ensures that conversation data is NOT used for model training, which is critical for donor and beneficiary data protection.

1
Navigate to chat.openai.com/business
2
Sign up for ChatGPT Business with nonprofit discount (Applied during onboarding after nonprofit verification)
3
Admin Settings: Workspace name: [Nonprofit Name] Content Team | Enable SSO via Google Workspace SAML (Settings > Authentication) | Data Controls: Verify 'Improve our models' is OFF | Set workspace-level custom instructions (see Custom AI Components)
4
Invite team members via email
5
Create shared GPT projects: 'Case Study Generator', 'Annual Report Writer', 'Program Narrative Builder', 'Donor Communication Drafter'
Note

The 75% nonprofit discount brings cost to approximately $6.25-$7.50/user/month. Verify data privacy settings carefully — ChatGPT Business/Enterprise does NOT train on your data, but ChatGPT Plus (consumer) does. Never use consumer ChatGPT Plus for nonprofit client work. If SSO via Google SAML is not available on the Business tier, enforce strong passwords + MFA via the OpenAI admin panel.

Step 6: Set Up Anthropic Claude Team Workspace

Provision Claude Team with nonprofit discount. Claude serves as the secondary AI engine with unique advantages: native connectors to Blackbaud, Candid, and Benevity (nonprofit-specific platforms), and Claude's writing style tends to produce more empathetic, nuanced narratives ideal for beneficiary stories. Configure the workspace with SSO and data privacy settings.

1
Navigate to claude.ai/team
2
Apply for Claude for Nonprofits discount at anthropic.com/claude-for-nonprofits
3
Provision Team plan (minimum 5 seats at ~$8/user/month nonprofit rate)
4
Admin Configuration: Enable SSO integration with Google Workspace; Review and accept data privacy terms (Claude Team does not train on user data)
5
Install nonprofit-specific connectors: Blackbaud connector (if client uses Raiser's Edge/eTapestry); Candid connector (for grant/foundation research); Benevity connector (if applicable for corporate giving data)
6
Create Projects: 'Case Study Development'; 'Annual Report Drafting'; 'Grant Narrative Support'
Note

Claude's nonprofit connectors are open-source and recently released. Check github.com/anthropics for the latest connector code if custom configuration is needed. The minimum 5-seat requirement aligns well with typical nonprofit content teams. Claude excels at maintaining consistent tone across long documents — particularly valuable for annual reports.

Step 7: Configure Canva for Nonprofits

Set up Canva Teams (free for nonprofits, up to 50 users). Create the brand kit with the nonprofit's visual identity. Build template frameworks for annual reports, case study one-pagers, and program narrative documents. These templates will receive AI-generated text content and transform it into publication-ready designed documents.

1
Verify Canva nonprofit approval at canva.com/canva-for-nonprofits
2
Set up Brand Kit: Upload logo files (primary, secondary, icon) | Set brand colors (primary, secondary, accent) | Upload brand fonts (or select closest Google Fonts matches) | Add brand photography style guidelines
3
Create Template Library: Annual Report Template (multi-page, data visualization ready) | Case Study One-Pager (single-page, print-optimized) | Case Study Long-Form (4-6 pages, digital-optimized) | Program Narrative Summary (2-page layout) | Impact Infographic (data visualization) | Donor Thank-You Card (AI-personalized)
4
Invite team members and assign roles (Admin, Designer, Member)
5
Enable Magic Write and AI image generation features
Note

Canva for Nonprofits is completely free and worth over $5,000/year. The MSP should create 6-8 polished templates during implementation as a value-add deliverable. These templates become the 'last mile' of the content workflow — AI generates the words, Canva makes them beautiful. Consider creating templates in both Letter (US) and A4 (international) sizes if the nonprofit has global operations.

Step 8: Set Up Integration Middleware (Zapier)

Configure Zapier as the integration backbone connecting the CRM, AI platforms, Google Drive, and notification systems. Build automated workflows (Zaps) that pull program data from the CRM, trigger AI content generation, route drafts for review, and notify approvers. Apply the 15% nonprofit discount.

Core Zap workflows and API configuration overview
plaintext
# Core Zap 1: New Program Data → AI Draft Generation
# Trigger: New/Updated record in Salesforce/Bloomerang (program completion)
# Action 1: Format program data into structured prompt template
# Action 2: Send to OpenAI API (GPT-5.4) with case study prompt
# Action 3: Save AI draft to Google Drive /01-AI-Drafts/Case-Studies/
# Action 4: Send Slack/Email notification to content reviewer

# Core Zap 2: Monthly Program Narrative Automation
# Trigger: Schedule (1st of each month)
# Action 1: Pull previous month's program metrics from CRM
# Action 2: Send to OpenAI API with program narrative prompt
# Action 3: Save draft to Google Drive
# Action 4: Create task in project management tool for review

# Core Zap 3: Interview Transcript → Case Study Pipeline
# Trigger: New file in Google Drive /Source-Materials/Interview-Transcripts/
# Action 1: Extract text from transcript
# Action 2: Send to Claude API with case study extraction prompt
# Action 3: Save structured case study draft to review folder
# Action 4: Notify Communications Director

# Zapier API Configuration:
# OpenAI Connection: API key from platform.openai.com/api-keys
# Google Drive: OAuth 2.0 connection
# Salesforce: OAuth 2.0 connection (use Connected App)
# Bloomerang: API key from Settings > Integrations
Note

Zapier Professional plan ($49/month minus 15% nonprofit discount = ~$42/month) provides 2,000 tasks/month which is adequate for most nonprofits. If the client has simpler needs, Zapier Starter at ~$17/month may suffice. Alternative: Make (formerly Integromat) offers similar functionality at lower cost but with a steeper learning curve. For clients with Bloomerang CRM, note that Bloomerang already includes an AI Content Assistant in its email builder — leverage this for donor communications and use Zapier for the broader content workflow.

Step 9: Configure Otter.ai for Interview Transcription

Set up Otter.ai Business for the content team members who conduct beneficiary interviews. Configure automatic transcription of recorded interviews, integration with Google Drive for transcript storage, and establish the interview-to-case-study pipeline.

1
Sign up at otter.ai/business
2
Provision 2 Business seats (interviewer + backup)
3
Configure integrations: Connect Google Calendar for automatic meeting transcription, Connect Google Drive for transcript export, Set auto-export: completed transcripts → Google Drive /Source-Materials/Interview-Transcripts/
4
Configure transcription settings: Language: English (adjust if multilingual), Speaker identification: Enable, Custom vocabulary: Add nonprofit-specific terms, program names, location names
5
Test with a sample interview recording
Note

Otter.ai pairs with the Blue Yeti Nano microphones for in-person interviews and with Zoom/Teams/Google Meet for virtual interviews. For budget-constrained clients, Google Workspace now includes built-in transcription in Google Meet — this can serve as a free alternative to Otter.ai, though with less accuracy and no speaker identification.

Step 10: Install and Configure Grammarly Business

Deploy Grammarly Business across all content team endpoints. Configure the organization's style guide, tone preferences, and brand-specific terminology. Grammarly serves as the quality assurance layer between AI-generated drafts and human approval, catching tone inconsistencies, jargon, and readability issues.

1
Provision Grammarly Business at grammarly.com/business
2
Admin Console (admin.grammarly.com): Add users and assign Business licenses — Configure SSO with Google Workspace SAML — Set organization-wide style guide: Tone: Informative, empathetic, hopeful (not desperate or preachy) | Formality: Neutral to slightly formal | Domain: Nonprofit/Social Impact | Custom terms: Add program names, beneficiary terminology preferences (e.g., 'participants' not 'clients', 'community members' not 'the poor') — Set brand tones and communication guidelines
3
Deploy browser extension to all team Chrome/Edge browsers
4
Install Grammarly for Google Docs add-on
5
Install Grammarly for Microsoft Word (if applicable)
Note

Grammarly's style guide feature is critical for nonprofit content — it ensures that AI-generated text uses person-first language, avoids savior narratives, and matches the organization's preferred terminology for describing beneficiaries and programs. Invest time in configuring the custom dictionary and tone settings during implementation. This is a high-value deliverable for the client.

Step 11: Build Custom Prompt Template Library

Develop and test a comprehensive library of prompt templates tailored to the nonprofit's specific programs, voice, and content needs. This is the highest-value intellectual property the MSP creates during the engagement. Each template should include system instructions, variable placeholders for program-specific data, output format specifications, and tone/style guidance derived from the exemplar documents collected in Step 1.

  • Deploy prompt templates as Custom GPTs in ChatGPT Business workspace AND as Projects in Claude Team workspace
  • See 'Custom AI Components' section for complete prompt specifications
  • Template Deployment Checklist:
  • Case Study Generator - short form (1-page)
  • Case Study Generator - long form (4-6 pages)
  • Annual Report Section Writer - Letter from ED
  • Annual Report Section Writer - Program Impact Summary
  • Annual Report Section Writer - Financial Narrative
  • Annual Report Section Writer - Donor Acknowledgment
  • Program Narrative Generator - Monthly Update
  • Program Narrative Generator - Quarterly Report
  • Program Narrative Generator - Grant Report Narrative
  • Donor Communication - Thank You Letter
  • Donor Communication - Impact Update Email
  • Social Media - Content Repurposing (long-form → social posts)
  • Test each template with real client data (anonymized) before training
Note

This step typically requires 2-3 weeks of iterative development and testing. Work directly with the Communications Director to calibrate tone and voice. Use the 5-10 exemplar documents from Step 1 as the 'gold standard' — have the AI generate content and compare quality side-by-side with human-written examples. Refine prompts until the AI output requires only light editing rather than major rewrites.

Step 12: Establish AI Governance Policy and Data Handling Procedures

Create and implement an AI Acceptable Use Policy tailored to the nonprofit's obligations around donor privacy, beneficiary confidentiality, and data protection. This is legally and ethically critical — nonprofits handle sensitive information about vulnerable populations and must maintain trust with donors and grantors.

1
Purpose and Scope
2
Approved AI Tools (whitelist only what MSP has configured)
3
Prohibited Inputs: Full names of minor beneficiaries (use first name + last initial only); Social Security numbers, immigration status, medical details; Donor credit card or banking information; Confidential grant reviewer feedback; Attorney-client privileged communications
4
Required Data Anonymization Procedures: Replace real names with pseudonyms before AI input; Remove specific addresses (use neighborhood/city only); Generalize ages (use ranges: 'school-aged child' not 'age 7'); Remove case numbers and internal IDs
5
Human Review Requirements: ALL AI-generated content requires human review before publication; Minimum two-person review for annual reports and case studies; Executive Director sign-off on any content featuring beneficiary stories
6
AI Disclosure Policy: Decide whether to disclose AI assistance in publications; Some grantors require disclosure — check grant agreements
7
Data Retention: AI conversation logs reviewed quarterly and purged annually; No sensitive data stored in AI platform history
8
Save as PDF in /Source-Materials/Brand-Guidelines/AI-Governance-Policy.pdf
9
Have Executive Director and Board Chair sign off
Note

76% of nonprofits lack an AI governance policy. Creating one is a significant value-add and differentiator for the MSP. Consider PCI DSS 4.0 implications if the CRM handles donor payment data — the AI system should never touch payment data. If the nonprofit serves EU beneficiaries or has EU donors, GDPR applies and requires explicit consent for any personal data processing. This document should be reviewed by the nonprofit's legal counsel before finalization.

Step 13: Configure NotebookLM Knowledge Base

Set up Google NotebookLM as the nonprofit's institutional knowledge base. Upload historical annual reports, past case studies, program descriptions, strategic plans, and brand guidelines. NotebookLM creates a searchable, AI-queryable archive that content creators can reference when generating new content, ensuring historical consistency and factual accuracy.

1
Navigate to notebooklm.google.com
2
Create notebooks: 'Annual Report Archive' - Upload past 3-5 annual reports (PDF), 'Case Study Library' - Upload all existing case studies, 'Program Documentation' - Upload program descriptions, logic models, 'Brand Voice Guide' - Upload brand guidelines, style guide, past comms, 'Financial Summaries' - Upload 990s, audited financials (public data only), 'Board & Strategy' - Upload strategic plan, theory of change
3
For each notebook: Add sources (up to 50 per notebook, PDFs/Docs/URLs), Generate initial notebook guide (summary), Test queries: 'What programs did we launch in 2023?', Test queries: 'How did we describe our impact methodology in last year's report?', Test queries: 'What statistics did we cite about the communities we serve?'
4
Share notebooks with content team via Google Workspace permissions
Note

NotebookLM is now free for Google Workspace for Nonprofits users. It is distinct from ChatGPT/Claude in that it ONLY draws from sources you explicitly upload — no hallucination from general training data. This makes it ideal for fact-checking AI-generated content against the nonprofit's actual historical records. Train staff to use NotebookLM as their 'organizational memory' before drafting in ChatGPT/Claude.

Step 14: End-to-End Workflow Integration Testing

Test the complete content generation workflow from data input through published output. Run three test scenarios: (1) Generate a case study from a mock beneficiary interview transcript, (2) Generate an annual report program section from CRM program data, (3) Generate a monthly program narrative from the previous month's metrics. Verify each integration point: CRM → Zapier → AI API → Google Drive → Notification → Human Review → Canva Layout.

1
Test Scenario 1: Case Study from Interview — Record a test interview using Blue Yeti Nano + Otter.ai
2
Verify transcript auto-exports to Google Drive
3
Verify Zapier triggers on new transcript file
4
Verify AI draft appears in /01-AI-Drafts/Case-Studies/
5
Verify notification sent to reviewer
6
Open draft, run through Grammarly
7
Copy approved text into Canva case study template
8
Export final PDF to /03-Final-Approved/
9
Test Scenario 2: Annual Report Section from CRM Data — Export program data from CRM (or use test data)
10
Input into Annual Report Section Writer prompt in ChatGPT
11
Verify output matches expected format and tone
12
Cross-reference statistics with NotebookLM sources
13
Route through Grammarly and human review
14
Place in Canva annual report template
15
Test Scenario 3: Automated Monthly Narrative — Manually trigger the Zapier monthly narrative Zap
16
Verify CRM data pull is accurate
17
Verify AI-generated narrative is saved to correct folder
18
Verify notification sent to reviewer
19
Review narrative quality and factual accuracy
Note

Document all test results including any failures and resolutions. This testing phase typically reveals integration configuration issues (wrong folder paths, API key permissions, Zapier filter logic). Allow 2-3 days for testing and troubleshooting. Involve at least one client staff member in testing to begin building familiarity.

Step 15: Staff Training and Supervised Rollout

Conduct three structured training workshops for the nonprofit's content team. Workshop 1: AI Fundamentals and Prompt Engineering (how to get the best output from ChatGPT/Claude). Workshop 2: Content Workflow and Tools (the full pipeline from data collection through publication). Workshop 3: Supervised Content Production (staff create real content with MSP technician observing and coaching). Provide written documentation and video recordings of all training sessions.

  • Workshop 1 (4 hours): AI Fundamentals — What AI can and cannot do for content; How to write effective prompts; When to use ChatGPT vs. Claude vs. Gemini vs. NotebookLM; Hands-on: Generate a case study together; AI governance policy review and sign-off
  • Workshop 2 (4 hours): Workflow & Tools — Full content pipeline walkthrough; Google Drive folder structure and conventions; Zapier automations overview (when they trigger, what they do); Canva template usage; Grammarly configuration and usage; NotebookLM as organizational memory
  • Workshop 3 (4 hours): Supervised Production — Each staff member generates one real piece of content; MSP technician observes, coaches, troubleshoots; Content goes through full review and approval process; Debrief: what worked, what needs refinement
  • Deliver: Written SOP document + recorded training videos
Note

Schedule workshops across 2-3 weeks to allow staff to practice between sessions. The most critical training outcome is prompt engineering confidence — staff should leave Workshop 1 able to modify prompt templates for their specific needs without MSP assistance. Consider Anthropic's free 'AI Fluency for Nonprofits' course as pre-work before Workshop 1. Record all workshops and save videos to the /Source-Materials/ shared drive for onboarding future staff.

Custom AI Components

Case Study Generator

Type: prompt A comprehensive system prompt template for generating compelling nonprofit case studies from beneficiary interview transcripts, program data, and outcome metrics. Produces both short-form (1-page) and long-form (4-6 page) case studies with emotional narrative arc, quantitative impact data, and clear call-to-action. Designed to be deployed as a Custom GPT in ChatGPT Business and as a Project in Claude Team. Implementation:

Case Study Generator — System Prompt

## System Instructions (paste as Custom GPT instructions or Claude Project instructions) You are a nonprofit communications specialist who writes compelling case studies that balance emotional storytelling with evidence-based impact reporting. You write for [NONPROFIT NAME], a [BRIEF ORG DESCRIPTION]. ## Brand Voice Guidelines - Tone: Warm, hopeful, empowering — never pitying or exploitative - Perspective: Center the beneficiary's agency and resilience, not the organization's heroism - Language: Person-first, strengths-based (e.g., 'person experiencing homelessness' not 'homeless person') - Reading level: 8th-9th grade (accessible to general donor audience) - Always use pseudonyms unless explicit written consent for real names is provided - Include specific data points and statistics when available ## Input Format The user will provide one or more of the following: 1. **Interview Transcript**: Raw or lightly edited transcript of a conversation with a beneficiary, staff member, or volunteer 2. **Program Data**: Statistics, metrics, dates, program name, services provided 3. **Background Context**: Community context, challenge being addressed, organizational history relevant to this story 4. **Outcome Data**: Measurable results, before/after comparisons, timeline of change ## Output Format — Short Form (1-Page Case Study) ### [COMPELLING HEADLINE — 8-12 words, active voice] **[Program Name] | [Location] | [Year]** **The Challenge** (2-3 sentences) Briefly describe the situation the beneficiary/community faced before the program intervention. **The Journey** (3-4 paragraphs) Narrate the beneficiary's experience with the program. Include: - A humanizing detail that makes the person real to readers - Specific services or support received - A turning point or moment of transformation - A direct quote from the beneficiary (synthesized from transcript if not verbatim) **The Impact** (1-2 paragraphs + bullet points) - Quantitative outcomes (numbers, percentages, timeframes) - Qualitative outcomes (confidence, stability, community connection) - Broader program statistics that contextualize this individual story **Looking Forward** (1-2 sentences) Forward-looking statement connecting this story to the organization's ongoing mission. **Call to Action** (1 sentence) A specific, actionable invitation for the reader (donate, volunteer, learn more). --- ## Output Format — Long Form (4-6 Page Case Study) Follow the same structure as short form but expand each section: - The Challenge: Full context paragraph including community-level data - The Journey: 6-8 paragraphs with narrative arc (setup, rising action, climax, resolution) - Include 2-3 direct quotes woven throughout - Include a sidebar with key statistics - Include a timeline of the beneficiary's journey - The Impact: Detailed outcome analysis with program-wide data - Include a 'By the Numbers' callout box - Looking Forward: Connect to strategic goals and upcoming initiatives - Include a donor acknowledgment paragraph ## Rules 1. NEVER fabricate statistics or outcomes — if data is not provided, write '[INSERT SPECIFIC DATA]' as a placeholder 2. NEVER use real names unless the user explicitly states consent was obtained — default to pseudonyms 3. NEVER use poverty porn, trauma exploitation, or savior narrative framing 4. Always include at least one direct quote (synthesized from transcript material) 5. Always include at least 3 specific data points 6. Flag any content that might identify a minor or vulnerable individual 7. End with a clear call-to-action appropriate for the nonprofit's primary audience ## Example Prompt from User: "Generate a short-form case study from this interview transcript: [TRANSCRIPT]. Program: Youth Mentorship Program. Location: Chicago South Side. Key outcomes: GPA improved from 1.8 to 3.2, participant enrolled in community college, completed 18 months of mentorship." ## Quality Checklist (apply before outputting): - [ ] Headline is compelling and specific (not generic) - [ ] Beneficiary has agency in the narrative (they are the hero, not the org) - [ ] At least one direct quote included - [ ] Specific numbers and data points included - [ ] Person-first, strengths-based language throughout - [ ] Clear call-to-action at the end - [ ] No identifying information for minors or vulnerable individuals - [ ] Reading level is accessible (8th-9th grade)
Sonnet 4.6

Annual Report Section Writer

Type: prompt A modular system prompt that generates individual sections of a nonprofit annual report. Supports six section types: Executive Director Letter, Program Impact Summary, Financial Narrative, Year in Review Timeline, Donor Acknowledgment, and Looking Ahead. Each section type has specific formatting, tone, and data requirements. Designed for iterative use — the content team generates each section separately and assembles the full report in Canva.

Annual Report Section Writer — System Prompt

# ANNUAL REPORT SECTION WRITER — System Prompt ## System Instructions You are an expert nonprofit annual report writer for [NONPROFIT NAME]. You specialize in creating individual sections of annual reports that are compelling, data-rich, and donor-focused. Each section you produce should stand alone as a complete, polished piece while also fitting cohesively into a larger annual report narrative. ## Organization Context - Organization: [NONPROFIT NAME] - Mission: [MISSION STATEMENT] - Fiscal Year: [FY START] to [FY END] - Total Budget: [APPROXIMATE BUDGET] - Primary Programs: [LIST 3-5 PROGRAMS] - Service Area: [GEOGRAPHIC AREA] - Key Audiences: Individual donors, foundation/grant funders, board members, community partners, beneficiaries ## Brand Voice for Annual Reports - Tone: Confident, grateful, transparent, forward-looking - Balance celebration of achievements with honest acknowledgment of challenges - Lead with impact (outcomes), not activities (outputs) - Use active voice and concrete language - Weave individual stories into broader data narratives - Reading level: 10th grade (slightly more sophisticated than case studies due to board/funder audience) ## Section Types — Specify which section you need: ### TYPE 1: Executive Director Letter **Input needed:** Key accomplishments, challenges faced, strategic priorities, personal anecdote or reflection, forward-looking goals **Format:** 500-700 words, first person from ED's voice, warm and personal yet professional, opens with a compelling hook (not 'Dear Friends'), includes 2-3 specific achievements with numbers, acknowledges one challenge or lesson learned with transparency, ends with gratitude and a forward-looking vision statement. Should feel like it was genuinely written by the ED, not a committee. ### TYPE 2: Program Impact Summary **Input needed:** Program name, description, number served, key outcomes/metrics, one beneficiary vignette, year-over-year comparison if available **Format:** 300-500 words per program. Structure: Program overview (2 sentences) → By the Numbers (3-5 bullet points with statistics) → Impact Story (1 paragraph micro-narrative) → What's Next (1-2 sentences). Use data visualization callouts: "📊 [STAT]" for numbers that should become infographics in design. ### TYPE 3: Financial Narrative **Input needed:** Revenue breakdown (donations, grants, events, earned income), expense breakdown (programs, admin, fundraising), year-over-year comparison, efficiency ratios **Format:** 250-400 words. Translate financial data into accessible narrative. Lead with program spending ratio ('83 cents of every dollar goes directly to programs'). Highlight revenue diversification. Acknowledge any significant changes transparently. Include suggested chart descriptions: "[CHART: Pie chart showing revenue sources]" for the designer. Avoid jargon — write for a donor who doesn't read financial statements. ### TYPE 4: Year in Review Timeline **Input needed:** 8-12 key events/milestones from the fiscal year with approximate dates **Format:** Monthly or quarterly timeline format. Each entry: [MONTH] — [EVENT TITLE]: [1-2 sentence description with impact data if applicable]. Highlight variety: program launches, community events, partnerships formed, awards received, milestones reached. Include at least one item showing organizational growth/learning. ### TYPE 5: Donor Acknowledgment **Input needed:** List of donors by giving level, any naming conventions, special recognition categories **Format:** Opening gratitude paragraph (100-150 words) that's heartfelt and specific (not generic). Giving level headers with creative names if desired (e.g., 'Visionary Circle' instead of '$10,000+'). Format donor names consistently. Include a disclaimer: 'We have made every effort to accurately recognize our supporters. Please contact [EMAIL] with any corrections.' End with an invitation to join or increase giving. ### TYPE 6: Looking Ahead **Input needed:** 2-3 strategic priorities for the coming year, new programs or expansions planned, capital campaigns, key dates **Format:** 300-500 words. Aspirational but concrete. Each priority gets a paragraph: what, why, and how. Include a specific call-to-action for each priority (volunteer, donate, attend, partner). End with the organization's vision for long-term impact. This section should leave the reader feeling inspired and invested in the organization's future. ## Rules 1. Always include specific numbers — never say 'many people' when you can say '847 families' 2. If data is missing, insert [INSERT: description of needed data] as a placeholder 3. Match the section length guidelines — annual reports have limited space 4. Every section should work independently (no references to 'as mentioned on page 3') 5. Include suggested data visualization notes in brackets for the designer 6. Balance quantitative data with qualitative human stories
Sonnet 4.6

Program Narrative Generator

Type: prompt Generates ongoing program narratives for monthly updates, quarterly reports, and grant compliance reports. Pulls from CRM program data and translates raw metrics into compelling narrative summaries suitable for board reports, funder updates, and internal documentation. Includes specific formatting for common grant report requirements. Implementation:

Program Narrative Generator — System Prompt

## System Instructions You are a grant writer and program reporting specialist for [NONPROFIT NAME]. You transform raw program data and metrics into clear, compelling narrative reports. You understand that different audiences need different framings: grant funders want evidence of outcomes and compliance, board members want strategic overview, and program staff want operational insight. ## Report Types: ### MONTHLY PROGRAM UPDATE **Input:** Program name, month, participants served, activities completed, key outcomes, challenges, upcoming plans **Output Format (300-500 words):** **[Program Name] — [Month Year] Update** **Summary:** [2-3 sentence overview of the month's highlights] **Participants & Services:** - Total participants served: [N] - New enrollments: [N] - Services delivered: [list with quantities] - [Year-to-date cumulative if provided] **Key Accomplishments:** [2-3 paragraphs highlighting meaningful outcomes, not just activities. Lead with impact: 'Fifteen participants completed job readiness training' not 'We held job readiness training.'] **Challenges & Adaptations:** [1 paragraph — honest, solution-oriented. Show learning and responsiveness.] **Next Month Preview:** [Brief look ahead — upcoming events, expected milestones, needs] --- ### QUARTERLY BOARD REPORT **Input:** Program name, quarter, cumulative metrics, goal progress, budget status, strategic alignment notes **Output Format (500-800 words):** **[Program Name] — Q[X] [Year] Board Report** **Executive Summary:** [3-4 sentences — could the board member read only this and be informed?] **Progress Toward Annual Goals:** | Goal | Annual Target | Q[X] Actual | YTD Actual | % of Target | |------|--------------|-------------|------------|-------------| | [Goal 1] | [Target] | [Actual] | [YTD] | [%] | **Narrative Analysis:** [2-3 paragraphs interpreting the data — what do the numbers mean? Are we on track? Why or why not?] **Budget Status:** [Brief financial narrative — on budget, under, over? Why?] **Strategic Alignment:** [How does this quarter's work advance the strategic plan?] **Recommendation/Request:** [Any board action needed — approval, input, resources?] --- ### GRANT REPORT NARRATIVE **Input:** Funder name, grant purpose, reporting period, required metrics, activities completed, outcomes achieved, challenges, budget expenditure, plans for remaining grant period **Output Format (800-1,500 words, formal):** **Grant Progress Report: [Grant Name/Purpose]** **Reporting Period:** [Start Date] — [End Date] **Submitted to:** [Funder Name] **Prepared by:** [Staff Name, Title] **I. Program Overview & Context** [Restate the grant purpose and how activities align with funder priorities. Reference the original proposal.] **II. Activities & Outputs** [Detailed accounting of all activities completed during the period. Use specific numbers. Tie activities to the work plan/timeline in the original proposal.] **III. Outcomes & Impact** [Report on measurable outcomes. Use the funder's own outcome metrics if specified. Include both quantitative data and qualitative evidence (quotes, observations).] **IV. Challenges & Lessons Learned** [Honest reporting builds funder trust. Frame challenges as learning opportunities. Describe adaptations made.] **V. Financial Summary** [Brief narrative of grant expenditures to date. Flag any significant variances from budget.] **VI. Plans for Remaining Period** [What comes next? How will remaining funds be used? Any adjustments to the work plan?] ## Rules: 1. Grant reports must use formal, evidence-based language 2. Never overstate outcomes — funders audit, and credibility is everything 3. Include data placeholders [INSERT] rather than inventing statistics 4. Match the funder's terminology and framework (if provided) 5. Board reports should be scannable — use headers, bullets, tables 6. Monthly updates should be conversational but professional
Sonnet 4.6

Content Repurposing Workflow

Type: workflow An automated workflow that takes a single long-form content piece (case study or annual report section) and generates multiple derivative content pieces for different channels: social media posts, email newsletter blurbs, website copy, and presentation talking points. This maximizes the ROI of each content creation effort.

Implementation:

Workflow Architecture

  • [Approved Long-Form Content] → Input to Repurposing Prompt → AI generates 6 derivative pieces → Human reviews/selects → Distributes to channels

Zapier Automation Configuration

Trigger

  • New file added to Google Drive folder: /03-Final-Approved/
  • Filter: File type is .docx or .gdoc or .pdf

Actions

1
Extract text from document (Zapier Document Parser or Google Docs API)
2
Send to OpenAI API with the repurposing prompt below
3
Save all outputs to /04-Repurposed-Content/[Original-Title]/ folder
4
Send email notification to social media manager and email marketer

Repurposing System Prompt

You are a nonprofit content strategist. You will receive a long-form content piece (case study, annual report section, or program narrative). Your job is to repurpose it into 6 channel-specific derivative pieces. For each piece, maintain the core message and key data points but adapt the tone, length, and format for the target channel. ## Output all 6 of these: ### 1. SOCIAL MEDIA — FACEBOOK/LINKEDIN POST (150-250 words) - Open with a hook (surprising statistic, quote, or question) - Include 1-2 key data points - End with a call-to-action and link placeholder [LINK] - Include 3-5 suggested hashtags - Tone: Warm, conversational, shareable ### 2. SOCIAL MEDIA — TWITTER/X THREAD (3-5 tweets, 280 chars each) - Tweet 1: Hook with key stat or quote - Tweets 2-3: Supporting details and impact - Final tweet: Call-to-action with link placeholder - Include relevant hashtags in thread ### 3. SOCIAL MEDIA — INSTAGRAM CAPTION (125-200 words) - Start with an emoji that matches the content theme - Brief, impactful narrative - End with CTA and hashtag block (10-15 hashtags) - Note: [Suggest image concept for accompanying visual] ### 4. EMAIL NEWSLETTER BLURB (100-150 words) - Compelling subject line (A/B test: provide 2 options) - Preview text (40-90 characters) - Body: Brief teaser with key highlight - CTA button text: [Specific action verb] - Tone: Personal, direct-to-donor ### 5. WEBSITE IMPACT STORY SNIPPET (75-100 words) - Headline (SEO-optimized, include location/program name) - 2-3 sentence summary with key outcome - 'Read More' link format - Meta description (155 characters) for SEO ### 6. PRESENTATION TALKING POINTS (5-7 bullets) - For board meetings, donor events, or community presentations - Each bullet: one clear statement with supporting data - Include a suggested slide title - Note the source/attribution for each data point
Sonnet 4.6

Implementation Notes

OpenAI API call parameters
python
model='gpt-5.4', max_tokens=2000, temperature=0.7
  • Estimated API cost per repurposing run: ~$0.03-$0.05
  • Store all outputs in structured Google Docs with clear section headers
  • Human review is mandatory before any channel publication

CRM-to-AI Data Pipeline

Type: integration A Zapier-based integration that extracts program data from the nonprofit's CRM (Salesforce Nonprofit Cloud or Bloomerang) and formats it for input into AI content generation prompts. Handles data anonymization, metric aggregation, and structured formatting to ensure AI receives clean, privacy-compliant input data.

Pipeline Architecture

1
CRM Database
2
Zapier Scheduled Trigger (monthly/quarterly)
3
Data Extraction (CRM API)
4
Privacy Filter (anonymize PII)
5
Data Formatter (structure for AI prompt)
6
AI API Call (GPT-5.4)
7
Output to Google Drive
8
Notification to Content Team

Zapier Configuration — Salesforce Nonprofit Cloud

Zap 1: Monthly Program Data Extract

Trigger: Schedule by Zapier — 1st of every month at 8:00 AM

Action 1: Salesforce — Find Records (SOQL)

Adapt field names to client's Salesforce schema
sql
SELECT 
  Program__c.Name,
  COUNT(Contact.Id) as Participants_Served,
  SUM(Service_Hours__c) as Total_Service_Hours,
  COUNT(CASE WHEN Outcome_Status__c = 'Completed' THEN 1 END) as Completed_Outcomes,
  COUNT(CASE WHEN Enrollment_Date__c >= LAST_MONTH THEN 1 END) as New_Enrollments
FROM Program_Enrollment__c
WHERE Program_Start_Date__c >= LAST_N_MONTHS:1
GROUP BY Program__c.Name

Action 2: Code by Zapier (JavaScript) — Privacy Filter & Formatter

javascript
// Input: raw CRM data from Action 1
// Output: anonymized, structured prompt input

const programData = inputData.records;
const currentMonth = new Date().toLocaleDateString('en-US', { month: 'long', year: 'numeric' });

let formattedOutput = `PROGRAM DATA FOR ${currentMonth}\n\n`;

// Aggregate data by program (no individual names)
programData.forEach(program => {
  formattedOutput += `PROGRAM: ${program.Name}\n`;
  formattedOutput += `- Participants Served: ${program.Participants_Served}\n`;
  formattedOutput += `- Total Service Hours: ${program.Total_Service_Hours}\n`;
  formattedOutput += `- Completed Outcomes: ${program.Completed_Outcomes}\n`;
  formattedOutput += `- New Enrollments: ${program.New_Enrollments}\n\n`;
});

formattedOutput += `NOTE: All data is aggregated. No individual beneficiary names or identifying information included.`;

return { formatted_data: formattedOutput };

Action 3: OpenAI — Chat Completion

  • Model: gpt-5.4
  • System Prompt: [Program Narrative Generator — Monthly Update prompt from above]
  • User Message: {{formatted_data}}
  • Max Tokens: 1500
  • Temperature: 0.7

Action 4: Google Drive — Create File

  • Folder: /01-AI-Drafts/Program-Narratives/
  • File Name: Monthly-Update-{{current_month}}-DRAFT.gdoc
  • Content: {{ai_response}}

Action 5: Gmail — Send Email

  • To: communications@nonprofitclient.org
  • Subject: [AI Draft Ready] Monthly Program Update — {{current_month}}
  • Body: A new AI-generated monthly program narrative has been saved to the AI Drafts folder. Please review, edit, and move to the Approved folder when finalized.

Zapier Configuration — Bloomerang

Bloomerang uses a REST API. Replace the Salesforce trigger with the following Actions. The rest of the pipeline (privacy filter, AI call, Drive save, notification) remains identical.

Action 1: Webhooks by Zapier — GET Request (Constituents)

http
GET https://api.bloomerang.co/v2/constituents?type=Individual&lastModified=[LAST_MONTH_START]
Authorization: Bearer {{bloomerang_api_key}}
Content-Type: application/json

Action 1b: Webhooks by Zapier — GET Request (Program Metrics)

Use Bloomerang's reporting API endpoints for program metrics
http
GET https://api.bloomerang.co/v2/transactions?startDate=[LAST_MONTH]&endDate=[CURRENT_DATE]
Authorization: Bearer {{bloomerang_api_key}}
Content-Type: application/json

Data Anonymization Rules (enforced in Code by Zapier step)

1
Never pass individual names — aggregate only
2
Never pass addresses — use neighborhood/zip code aggregates only
3
Never pass case IDs or internal reference numbers
4
Age data: use ranges only (0-5, 6-12, 13-17, 18-24, 25-54, 55+)
5
If <5 individuals in a category, suppress to prevent re-identification
6
Log all data passed to AI in an audit Google Sheet for compliance review

Interview-to-Case-Study Pipeline

Type: agent A semi-automated agent workflow that processes a recorded beneficiary interview from audio through transcription, AI analysis, case study draft generation, and review routing. Orchestrates Otter.ai, Google Drive, OpenAI API, and notification systems in sequence.

Implementation

Workflow Trigger Options

Step 1: Interview Recording & Transcription

Tool: Otter.ai Business + Blue Yeti Nano microphone

1
Staff opens Otter.ai and starts recording
2
Conducts interview using the Interview Guide Template (see below)
3
Otter.ai transcribes in real-time with speaker identification
4
Staff reviews transcript, corrects major errors
5
Exports transcript to Google Drive (auto-configured)

Interview Guide Template (provide to staff)

Before the Interview

Core Questions (adapt to program type)

1
Can you tell me a little about yourself and your life before connecting with [PROGRAM]?
2
How did you first hear about or get connected to [PROGRAM]?
3
What was your experience like in the beginning?
4
Can you describe a specific moment or experience in the program that was meaningful to you?
5
What skills or support did you gain through the program?
6
How has your life changed since participating?
7
What would you tell someone who is considering joining the program?
8
Is there anything else you'd like to share about your experience?

Interviewer Notes Section

Step 2: Transcript Processing (Zapier)

  • Trigger: New file in Google Drive /Source-Materials/Interview-Transcripts/
  • Filter: Filename contains 'transcript' or file type is .txt/.docx
Action 1: Code by Zapier
javascript
// Extract & Format transcript and build prompt input

const transcript = inputData.fileContent;

// Strip Otter.ai metadata, keep speaker labels
const cleanTranscript = transcript
  .replace(/\[\d{2}:\d{2}:\d{2}\]/g, '') // Remove timestamps
  .replace(/\n{3,}/g, '\n\n'); // Clean excess whitespace

const promptInput = `INTERVIEW TRANSCRIPT FOR CASE STUDY GENERATION\n\n` +
  `Organization: [NONPROFIT NAME]\n` +
  `Interview Date: ${inputData.fileName.match(/\d{4}-\d{2}-\d{2}/) || 'Unknown'}\n` +
  `Program: [TO BE FILLED BY REVIEWER]\n\n` +
  `TRANSCRIPT:\n${cleanTranscript}\n\n` +
  `INSTRUCTIONS: Generate a short-form (1-page) case study from this transcript. ` +
  `Use a pseudonym for the beneficiary. Focus on transformation, agency, and measurable outcomes.`;

return { prompt_input: promptInput };

Case Study Generator — OpenAI System Prompt (Action 2)

You are a nonprofit communications expert specializing in writing compelling, ethical beneficiary case studies. When given an interview transcript, generate a short-form (1-page) case study. Use a pseudonym for the beneficiary. Focus on transformation, agency, and measurable outcomes. Write in a warm, dignified tone that centers the beneficiary's voice and avoids savior framing.
Sonnet 4.6
  • Action 2: OpenAI — Chat Completion
  • Model: gpt-5.4
  • System: [Case Study Generator system prompt]
  • User: {{prompt_input}}
  • Max Tokens: 2000
  • Temperature: 0.7
  • Action 3: Google Drive — Create File
  • Folder: /01-AI-Drafts/Case-Studies/
  • File: Case-Study-DRAFT-{{date}}-{{transcript_name}}.gdoc
  • Action 4: Gmail — Notify Reviewer
  • To: communications-director@nonprofit.org
  • Subject: [ACTION REQUIRED] New AI Case Study Draft from Interview
  • Body: An AI-generated case study draft has been created from a new interview transcript. Please review for accuracy, tone, and privacy compliance within 5 business days. Draft location: [LINK]

Step 3: Human Review & Approval

1
Reviewer opens draft in Google Docs
2
Runs Grammarly check
3
Cross-references facts against NotebookLM organizational knowledge
4
Verifies beneficiary consent level and pseudonym usage
5
Edits for voice, accuracy, and sensitivity
6
Moves approved file to /03-Final-Approved/Case-Studies/

Step 4: Auto-Repurposing (triggers Content Repurposing Workflow)

File landing in /03-Final-Approved/ triggers the repurposing workflow automatically. Social media, email, website, and presentation versions are generated.

Testing & Validation

  • TEST 1 — AI Platform Access: Each content team member logs into ChatGPT Business, Claude Team, Gemini (via Google Workspace), and Canva. Verify SSO works, verify each user can access shared projects/workspaces, and verify data privacy settings show 'model training: disabled' in each platform's admin console.
  • TEST 2 — Case Study Generation Quality: Input a real (anonymized) beneficiary interview transcript into the Case Study Generator prompt in both ChatGPT and Claude. Compare outputs side-by-side against an existing human-written case study for tone, accuracy, reading level, and emotional resonance. Score each on a 1-5 rubric. Acceptable: score 3.5+ with minimal editing needed.
  • TEST 3 — Annual Report Section Coherence: Generate all 6 annual report section types using real organizational data. Verify: (a) consistent brand voice across sections, (b) no contradictory statistics between sections, (c) each section meets the specified word count range, (d) placeholder tags [INSERT] appear where data was not provided rather than fabricated numbers.
  • TEST 4 — CRM Data Pipeline End-to-End: Trigger the monthly CRM data extraction Zap manually. Verify: (a) data is correctly pulled from CRM, (b) anonymization code strips all PII, (c) formatted data is sent to OpenAI API, (d) AI-generated narrative appears in the correct Google Drive folder, (e) notification email is received by the designated reviewer within 5 minutes.
  • TEST 5 — Interview Transcription Pipeline: Record a 10-minute test interview using the Blue Yeti Nano and Otter.ai. Verify: (a) audio quality is clear, (b) transcription accuracy is 90%+, (c) transcript auto-exports to Google Drive, (d) Zapier triggers on the new file, (e) AI case study draft is generated and saved, (f) reviewer notification is sent.
  • TEST 6 — Content Repurposing Workflow: Place an approved case study document in the /03-Final-Approved/ folder. Verify: (a) Zapier triggers within 5 minutes, (b) all 6 derivative content pieces are generated, (c) outputs are saved in the correct subfolder, (d) social media posts are within character limits, (e) email newsletter blurb includes subject line options.
  • TEST 7 — Grammarly Integration: Open an AI-generated draft in Google Docs. Verify Grammarly browser extension activates, custom style guide terms are flagged appropriately (e.g., preferred terminology corrections appear), and tone detector matches the configured nonprofit voice settings.
  • TEST 8 — Privacy Compliance Audit: Review the last 10 AI conversations in ChatGPT Business admin panel. Verify: (a) no full beneficiary names appear in prompts, (b) no SSNs, addresses, or medical data present, (c) all conversations align with the AI Governance Policy, (d) ChatGPT data controls confirm zero data used for training.
  • TEST 9 — Failover Test: Simulate OpenAI outage by temporarily revoking the API key in Zapier. Verify: (a) Zapier error notification is sent to MSP, (b) content team knows to switch to Claude Team as backup, (c) Claude produces comparable quality output using the same input data, (d) no data is lost in the pipeline.
  • TEST 10 — Full Annual Report Simulation: Conduct a complete annual report generation exercise using the full toolchain: pull program data from CRM, generate all report sections via AI, review and edit in Google Docs with Grammarly, place in Canva annual report template, export final PDF. Time the entire process and compare to the client's historical annual report production timeline. Target: 60-80% time reduction.

Client Handoff

The client handoff should be a structured 2-hour session with the Communications Director, Executive Director, and all content team members. Cover the following topics in order:

1
Solution Architecture Overview (15 min): Walk through the complete system diagram showing how CRM data flows through AI platforms to published content. Ensure the ED understands the high-level workflow even if they won't use it daily.
2
AI Governance Policy Review (15 min): Review the signed AI Governance Policy. Emphasize prohibited inputs (beneficiary PII, donor financial data), required human review for all content, and the data anonymization checklist. Have each staff member acknowledge understanding in writing.
3
Daily Workflow Demonstration (20 min): Live walkthrough of generating a case study from an interview transcript, generating a monthly program narrative from CRM data, and repurposing approved content for social media. Show the Google Drive folder structure and file naming conventions.
4
Prompt Template Library Tour (15 min): Walk through each Custom GPT and Claude Project. Show how to select the right template for each content type. Demonstrate how to modify prompts for edge cases without breaking the core instructions.
5
Troubleshooting Playbook (10 min): Cover common issues: AI output is off-tone (adjust prompt), API errors in Zapier (check API key, contact MSP), quality degradation (may indicate model update — contact MSP), and 'I'm stuck' escalation path.
6
Success Criteria Review (15 min): Review agreed-upon KPIs: content production time reduction (target 60-80%), content volume increase, staff confidence scores (pre/post survey), and AI governance compliance rate. Set a 30-day check-in meeting.
7
Documentation Handoff (10 min): Provide the following documents: (a) AI Content Production SOP (step-by-step standard operating procedures), (b) Prompt Template Library (all prompts in a shared Google Doc), (c) AI Governance Policy (signed copy), (d) Vendor Account Credentials (stored in password manager), (e) Zapier Workflow Documentation (screenshot + description of each Zap), (f) Training Video Recordings (from Workshops 1-3), (g) MSP Support Contact Card (email, phone, portal, SLA response times).
8
Q&A and Confidence Check (20 min): Open floor for questions. Ask each team member to rate their confidence (1-10) in using the system independently. Any score below 7 warrants follow-up training. Schedule the 30-day check-in before leaving.

Maintenance

Monthly Maintenance Tasks (MSP responsibility, included in managed services agreement):

  • Review AI platform usage analytics: check active users, conversation volumes, and API consumption across ChatGPT Business, Claude Team, and OpenAI API. Flag underutilization (may indicate adoption issues) or overconsumption (may indicate misuse or need for plan upgrade).
  • Audit Zapier workflow execution logs: verify all automated Zaps ran successfully, investigate and resolve any failed runs, and monitor task consumption against plan limits.
  • Review AI governance compliance: spot-check 5-10 AI conversations for PII violations or policy non-compliance. Document findings and report to designated staff member.
  • Verify all software licenses and nonprofit discount renewals are current. Track renewal dates for annual subscriptions.
  • Test CRM-to-AI data pipeline with a manual trigger to ensure data flow integrity.

Quarterly Maintenance Tasks:

  • Prompt template optimization session (1-2 hours): review AI output quality with the content team, identify prompts that need refinement based on 3 months of usage, and update templates to reflect any organizational changes (new programs, updated brand voice, new staff).
  • Software update review: check for major updates to ChatGPT, Claude, Gemini, Canva, and other tools. Test updates in a sandbox before rolling to production. Pay special attention to AI model updates (e.g., new GPT versions) which may change output behavior.
  • Security review: verify MFA is enabled for all users, review user access lists (remove departed staff), rotate API keys, and update firewall whitelists if vendor domains have changed.
  • Content quality audit: randomly sample 5 published pieces that used AI assistance. Score for brand voice consistency, factual accuracy, and adherence to governance policy.

Annual Maintenance Tasks:

  • Comprehensive AI strategy review with nonprofit leadership: assess ROI, identify new AI opportunities, and plan any platform migrations or additions.
  • Renew all nonprofit discount applications (some require annual reverification).
  • Update AI Governance Policy to reflect new regulations, platform changes, or organizational lessons learned.
  • Archive previous year's AI conversation logs per retention policy.
  • Conduct staff refresher training (half-day workshop) for existing team and onboard any new hires.

SLA Considerations:

  • Response time for critical issues (pipeline failures, data breaches): 1 hour
  • Response time for standard issues (AI quality degradation, user access problems): 4 business hours
  • Response time for optimization requests (prompt refinement, new template creation): 2 business days
  • Scheduled maintenance windows: Second Tuesday of each month, 6-8 AM local time

Escalation Path:

1
Level 1: Client staff attempts self-service troubleshooting using SOP documentation
2
Level 2: Client contacts MSP helpdesk via email/portal for standard issues
3
Level 3: MSP senior technician engages for complex integration or API issues
4
Level 4: MSP escalates to vendor support (OpenAI, Anthropic, Google, Zapier) for platform-level issues

Model Retraining/Update Triggers:

  • AI platform announces major model version change (e.g., GPT-5.4 → GPT-5): MSP tests all prompt templates against new model, adjusts as needed, and communicates changes to client within 2 weeks of release.
  • Client undergoes organizational change (rebrand, new programs, merger): MSP schedules prompt library update session within 1 week of change notification.
  • Content quality scores drop below 3.5/5 threshold on quarterly audit: MSP initiates prompt optimization sprint within 1 week.

Alternatives

...

Google Gemini-Only Free Stack

For extremely budget-constrained nonprofits, build the entire solution on Google's free nonprofit offerings: Google Workspace for Nonprofits (free for up to 2,000 users) with Gemini AI and NotebookLM (both now included free), plus Canva for Nonprofits (free for up to 50 users). No paid AI platforms at all. Use Gemini in Google Docs for content generation, NotebookLM for organizational knowledge, and Google Apps Script for basic automation instead of Zapier.

Microsoft 365 Copilot-Centric Approach

For nonprofits heavily invested in the Microsoft ecosystem (SharePoint, Teams, Word, PowerPoint), center the solution on Microsoft 365 Copilot ($25.50/user/month nonprofit pricing) instead of ChatGPT/Claude. Copilot integrates natively with Word for document generation, PowerPoint for presentation creation, and Teams for meeting summaries. Combine with Microsoft's free 300-license Business Basic grant.

Jasper AI for Brand-Controlled Content Teams

Replace ChatGPT/Claude with Jasper AI as the primary content engine. Jasper is purpose-built for marketing and communications content with 50+ templates, brand voice training, and campaign management features. Apply the 20% nonprofit discount (email hey@jasper.ai with documentation).

Open-Source Self-Hosted LLM (Advanced)

For nonprofits with strict data sovereignty requirements (e.g., serving refugees, domestic violence survivors, or other extremely sensitive populations), deploy an open-source LLM (Llama 3.1 70B or Mistral Large) on local or private cloud infrastructure. All data stays within the organization's control — no third-party AI vendor ever sees any data.

Warning

Tradeoffs: Cost: Significantly higher upfront ($5,000-$15,000 for GPU hardware or $500-$1,500/month for cloud GPU instances) plus ongoing MSP management overhead. Complexity: Requires MSP staff with ML/AI operations expertise, not just SaaS administration. Writing quality of open-source models is 70-85% of GPT-5.4/Claude for creative content tasks. Recommend this ONLY for nonprofits handling highly sensitive populations (refugees, DV survivors, undocumented individuals) where even enterprise-grade SaaS data protections are insufficient, or where funders/regulators explicitly require on-premise data processing. Dual RTX 5090 configurations can now run 70B models effectively at a fraction of H100 cost.

Bloomerang + Built-in AI (Minimal Implementation)

For nonprofits already using Bloomerang CRM, leverage Bloomerang's built-in AI Content Assistant (included in existing subscription at no extra cost) for donor communications, and add only Google Workspace for Nonprofits (free) with Gemini for longer-form content. Minimal new tools, minimal change management.

Note

Tradeoffs: Cost: Essentially $0 additional software cost if already on Bloomerang. Capability: Bloomerang's AI is limited to email/letter content within the CRM — it cannot generate case studies, annual reports, or program narratives. Google Gemini fills some gaps but is less capable than GPT-5.4/Claude for long-form content. No automation pipeline. Recommend this as a Phase 1 'quick win' for nonprofit clients who are AI-skeptical or have extremely limited budgets — prove value with donor communications first, then propose the full implementation as Phase 2.

Want early access to the full toolkit?