Automated Reporting System

#aws #lambda #s3 #awscommunitybuilder

Overview
We’ll build a system using AWS Lambda and other serverless tools to automate daily reporting. The system will:

Collect data from multiple sources.
Generate a PDF report.
Send the report via email.
Trigger this process daily.

This guide assumes you have a basic understanding of AWS. Let’s start!

Step 1: Create an S3 Bucket

Go to the S3 service.
Click Create bucket.
Name your bucket (e.g., daily-reports-s3-bucket).
Keep other settings default and click Create.
This bucket will store the reports if needed.

Step 2: Verify an Email Address in SES

Go to Amazon SES.
Navigate to Email Addresses under Identity Management.
Click Verify a New Email Address and enter your email.
Check your email inbox and click the verification link.

This allows SES to send emails from this address.

Step 3: Write the Lambda Function

Go to AWS Lambda and click the Create function.
Choose:

Author from scratch.
Function name: daily-report-lambda.
Runtime: Python 3.9 (or later).
Click the Create function.

Code for the Lambda Function

Scroll to the Code section.
Replace the default code with the following:

import boto3
from fpdf import FPDF
import os
from email.mime.multipart import MIMEMultipart
from email.mime.text import MIMEText
from email.mime.base import MIMEBase
from email import encoders

def lambda_handler(event, context):
    try:
        # Generate the PDF report
        pdf = FPDF()
        pdf.add_page()
        pdf.set_font("Arial", size=12)
        pdf.cell(200, 10, txt="Daily Report", ln=True, align="C")
        pdf.cell(200, 10, txt="This is your automated report.", ln=True)

        # Save the PDF
        report_path = "/tmp/daily_report.pdf"
        pdf.output(report_path)

        # Upload to S3 (Optional)
        s3 = boto3.client('s3')
        bucket_name = "daily-reports-s3-bucket"
        s3.upload_file(report_path, bucket_name, "daily_report.pdf")

        # Send email via SES with attachment using raw email
        ses = boto3.client('ses')
        msg = MIMEMultipart()
        msg['From'] = "sender_email@gmail.com"  # Replace with your SES verified email
        msg['To'] = "receiver_email@gmail.com"  # Replace with recipient email
        msg['Subject'] = "Daily Report"

        # Attach the text body
        body = MIMEText("Please find the attached report.", 'plain')
        msg.attach(body)

        # Attach the PDF report
        with open(report_path, 'rb') as file:
            part = MIMEBase('application', 'octet-stream')
            part.set_payload(file.read())
            encoders.encode_base64(part)
            part.add_header('Content-Disposition', f'attachment; filename={os.path.basename(report_path)}')
            msg.attach(part)

        # Send the email using SES's send_raw_email
        response = ses.send_raw_email(
            Source=msg['From'],
            Destinations=[msg['To']],
            RawMessage={'Data': msg.as_string()}
        )

        return {"status": "success", "response": response}

    except Exception as e:
        return {"status": "error", "message": str(e)}

Step 4: Install Libraries Locally and Deploy (Optional)

You will use third-party libraries like fpdf, as fpdf is not available in Lambda, package them locally:
Install fpdf locally: