Tech With Galvan
Back to Articles
AutomationJun 2, 2029 • 5 min read

How to Auto-Send Monthly Reports to Clients

Automate monthly client reports — generate, format, and send reports automatically. With Python, Google Sheets, and email. Free script included.

Galvan
Galvan

Founder & Creator

Introduction

Monthly reports are essential for client retention — they show the value you’re delivering. But creating them manually takes 1-2 hours per client per month. With 10 clients, that’s 10-20 hours of report writing.

Automated monthly reports generate and send themselves: pull data from your tools, format it into a professional report, and email it to the client. Zero manual work.

What to include in a monthly report

For marketing clients

  • Traffic (sessions, users, page views)
  • Leads generated
  • Conversion rate
  • Top-performing content
  • Social media metrics (followers, engagement)
  • Ad performance (spend, clicks, conversions)
  • Recommendations for next month

For web development clients

  • Uptime (99.9%)
  • Page speed (Core Web Vitals)
  • Traffic and engagement
  • Security updates applied
  • Bug fixes and improvements
  • Recommendations

For SEO clients

  • Keyword rankings (movement)
  • Organic traffic
  • Backlinks gained
  • Technical SEO issues fixed
  • Content published
  • Next month’s plan

Step 1: Data collection (automated)

import requests, os
from datetime import datetime, timedelta

# Google Analytics 4
def get_ga4_data(property_id, start_date, end_date):
    from google.analytics.data_v1beta import BetaAnalyticsDataClient
    from google.analytics.data_v1beta.types import RunReportRequest, DateRange, Metric, Dimension
    
    client = BetaAnalyticsDataClient()
    request = RunReportRequest(
        property=f"properties/{property_id}",
        dimensions=[Dimension(name="pagePath")],
        metrics=[Metric(name="sessions"), Metric(name="totalUsers"), Metric(name="screenPageViews")],
        date_ranges=[DateRange(start_date=start_date, end_date=end_date)],
    )
    response = client.run_report(request)
    return response

# Google Search Console
def get_gsc_data(site_url, start_date, end_date):
    from googleapiclient.discovery import build
    service = build("searchconsole", "v1", credentials=creds)
    request = {
        "startDate": start_date,
        "endDate": end_date,
        "dimensions": ["query"],
        "rowLimit": 25,
    }
    response = service.searchanalytics().query(siteUrl=site_url, body=request).execute()
    return response.get("rows", [])

# Social media (example: Twitter API)
def get_twitter_metrics(handle):
    # Use Twitter API v2
    pass

Step 2: Generate report (PDF)

from fpdf import FPDF
from datetime import datetime

def generate_monthly_report(client_name, data, month, year):
    pdf = FPDF()
    pdf.add_page()
    
    # Header
    pdf.set_font("Arial", "B", 18)
    pdf.cell(0, 12, f"Monthly Report — {client_name}", ln=True, align="C")
    pdf.set_font("Arial", "", 12)
    pdf.cell(0, 8, f"{month} {year}", ln=True, align="C")
    pdf.ln(5)
    
    # Traffic section
    pdf.set_font("Arial", "B", 14)
    pdf.cell(0, 10, "Website Traffic", ln=True)
    pdf.set_font("Arial", "", 11)
    pdf.cell(0, 7, f"Sessions: {data['sessions']:,}", ln=True)
    pdf.cell(0, 7, f"Users: {data['users']:,}", ln=True)
    pdf.cell(0, 7, f"Page Views: {data['page_views']:,}", ln=True)
    pdf.cell(0, 7, f"Change from last month: {data['sessions_change']:+.1f}%", ln=True)
    pdf.ln(5)
    
    # SEO section
    pdf.set_font("Arial", "B", 14)
    pdf.cell(0, 10, "SEO Performance", ln=True)
    pdf.set_font("Arial", "", 11)
    pdf.cell(0, 7, f"Organic Traffic: {data['organic_traffic']:,}", ln=True)
    pdf.cell(0, 7, f"Top Keyword: {data['top_keyword']} (Position {data['top_keyword_pos']})", ln=True)
    pdf.cell(0, 7, f"New Backlinks: {data['new_backlinks']}", ln=True)
    pdf.ln(5)
    
    # Social media section
    pdf.set_font("Arial", "B", 14)
    pdf.cell(0, 10, "Social Media", ln=True)
    pdf.set_font("Arial", "", 11)
    pdf.cell(0, 7, f"Followers: {data['followers']:,} (+{data['follower_growth']})", ln=True)
    pdf.cell(0, 7, f"Engagement Rate: {data['engagement_rate']:.1f}%", ln=True)
    pdf.cell(0, 7, f"Posts Published: {data['posts_published']}", ln=True)
    pdf.ln(5)
    
    # Recommendations
    pdf.set_font("Arial", "B", 14)
    pdf.cell(0, 10, "Recommendations for Next Month", ln=True)
    pdf.set_font("Arial", "", 11)
    for rec in data["recommendations"]:
        pdf.cell(0, 7, f"• {rec}", ln=True)
    
    pdf.ln(5)
    pdf.set_font("Arial", "I", 9)
    pdf.cell(0, 6, "Generated automatically. Questions? Reply to this email.", ln=True)
    
    filename = f"report_{client_name.replace(' ', '_')}_{month}_{year}.pdf"
    pdf.output(filename)
    return filename

Step 3: Send via email

import resend, os, base64

resend.api_key = os.environ["RESEND_API_KEY"]

def send_report(client_name, client_email, filename):
    with open(filename, "rb") as f:
        pdf_data = base64.b64encode(f.read()).decode()
    
    month = datetime.now().strftime("%B %Y")
    
    resend.Emails.send({
        "from": "Reports <[email protected]>",
        "to": [client_email],
        "subject": f"Monthly Report — {client_name} — {month}",
        "html": f"""
        <p>Hi {client_name},</p>
        <p>Please find attached your monthly report for {month}.</p>
        <p>Key highlights:</p>
        <ul>
            <li>Traffic: [X] sessions (+Y%)</li>
            <li>Leads: [X] new leads</li>
            <li>Top keyword: [keyword] (position [X])</li>
        </ul>
        <p>Let me know if you have any questions!</p>
        <p>Best,<br>Your Name</p>
        """,
        "attachments": [{"filename": filename, "content": pdf_data}],
    })
    print(f"Report sent to {client_name}")

Step 4: Automate with cron

# Run on the 1st of every month at 9 AM
0 9 1 * * cd /path/to/project && python generate_reports.py

Or GitHub Actions:

name: Monthly Reports
on:
  schedule:
    - cron: '0 9 1 * *'
jobs:
  reports:
    runs-on: ubuntu-latest
    steps:
      - uses: actions/checkout@v4
      - run: pip install fpdf google-analytics-data google-api-python-client
      - run: python generate_reports.py

Step 5: Google Sheets data source (no-code alternative)

For non-developers, use Google Sheets + Apps Script:

function generateMonthlyReport() {
  const sheet = SpreadsheetApp.getActiveSpreadsheet();
  const data = sheet.getSheetByName("Metrics").getDataRange().getValues();
  
  // Calculate metrics
  const sessions = data[data.length - 1][1];
  const prevSessions = data[data.length - 2][1];
  const change = ((sessions - prevSessions) / prevSessions * 100).toFixed(1);
  
  // Create report doc
  const doc = DocumentApp.create("Monthly Report - " + new Date().toLocaleString("default", {month: "long", year: "numeric"}));
  const body = doc.getBody();
  
  body.appendParagraph("Monthly Report").setHeading(DocumentApp.ParagraphHeading.HEADING1);
  body.appendParagraph(`Sessions: ${sessions} (${change}% vs last month)`);
  body.appendParagraph(`Users: ${data[data.length - 1][2]}`);
  // ... add more metrics
  
  // Email the doc
  const pdf = doc.getAs(MimeType.PDF);
  GmailApp.sendEmail("[email protected]", "Monthly Report", "Please find attached.", {attachments: [pdf]});
}

What to include in reports (by client type)

Marketing clients

  • Traffic (sessions, users, page views)
  • Leads generated
  • Conversion rate
  • Top-performing content
  • Social media metrics
  • Ad performance (spend, clicks, conversions)
  • Recommendations for next month

Web development clients

  • Uptime (99.9%)
  • Page speed (Core Web Vitals)
  • Traffic and engagement
  • Security updates applied
  • Bug fixes and improvements
  • Recommendations

SEO clients

  • Keyword rankings (movement)
  • Organic traffic
  • Backlinks gained
  • Technical SEO issues fixed
  • Content published
  • Next month’s plan

Social media clients

  • Follower growth
  • Engagement rate
  • Top-performing posts
  • Content published
  • Audience demographics
  • Recommendations

Common mistakes

  • Too long — 2-3 pages max. Clients skim.
  • No context — “Sessions: 5,000” means nothing. Add “vs last month: +12%”.
  • No recommendations — data without insights is useless. Always include 2-3 actionable recommendations.
  • Late delivery — send on the 1st or 2nd of the month. Late reports look unprofessional.
  • Generic template — customize for each client’s KPIs. Don’t send the same report to everyone.
  • No visual — include at least one chart. Visuals are easier to digest than numbers.

Key Concepts

  • Monthly report = summary of performance metrics for a client
  • KPI = Key Performance Indicator (the metrics that matter)
  • Automated report = generated and sent without manual intervention
  • Cron job = scheduled task that runs automatically
  • GA4 = Google Analytics 4 (website analytics)

What to Try Next

FAQ

How long should a monthly report be?

1-2 pages. Include: key metrics (3-5 numbers), one chart, 2-3 recommendations, and next steps. Clients don’t read 10-page reports.

Should I send reports even if the month was bad?

Yes — especially then. Clients appreciate transparency. Frame it positively: “Traffic was down 10% due to [reason]. Here’s our plan to recover.” Hiding bad news destroys trust.

What if I don’t have access to the client’s analytics?

Ask for access during onboarding. If they won’t share, use the data you have (your own tracking, social media metrics, etc.). A partial report is better than no report. See Client Onboarding Questionnaire.