
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
$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
$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
$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
$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
$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)
$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)
~$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)
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)
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
$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
$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)
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)
$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).
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.
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/
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.
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.
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.
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.
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 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 > IntegrationsZapier 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.
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.
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
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.
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.
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.
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
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
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
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
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
Repurposing System Prompt
Implementation Notes
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
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)
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.NameAction 2: Code by Zapier (JavaScript) — Privacy Filter & Formatter
// 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)
GET https://api.bloomerang.co/v2/constituents?type=Individual&lastModified=[LAST_MONTH_START]
Authorization: Bearer {{bloomerang_api_key}}
Content-Type: application/jsonAction 1b: Webhooks by Zapier — GET Request (Program Metrics)
GET https://api.bloomerang.co/v2/transactions?startDate=[LAST_MONTH]&endDate=[CURRENT_DATE]
Authorization: Bearer {{bloomerang_api_key}}
Content-Type: application/jsonData Anonymization Rules (enforced in Code by Zapier step)
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
Interview Guide Template (provide to staff)
Before the Interview
Core Questions (adapt to program type)
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
// 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)
- 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
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:
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:
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.
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.
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?