Python/Google Collab Work For Custom Email CSV Reporting

I have a report from an LMS I am using that comes to me every morning in csv format. I would like someone to help me take this csv and create a custom email report out of it where some of the column heads are named differently, and so that there is some reasoning/logic into the new email.

For instance, the LMS only lets me see the last date a user accessed the course. I would like it to have a coulumn on a custom report that shows the user as "stalled" if they have not accessed the course for 3 days, "active" if they have logged in within the last 3 days, and "stale" if they have not logged in for 5 days.

The heading on the column for first name says this User:First Name. I would like the User: removed so that it just says First Name. This is not a capability of the LMS reporting tool itself. I asked ChatGPT and it gave me the answer below, which I need someone to help me set up. If there is another way to do it I am open to it. If you are capable of doing this, please apply.

option 1. Zapier + Google Sheets + Gmail
Strengths: Easier setup than Make; integrates easily with Google ecosystem.
How it helps:
Zapier triggers on a new CSV email.
Uploads and parses the CSV into Google Sheets.
Google Sheets uses formulas to flag stalled users (e.g., =IF(TODAY()-A2>3,"Stalled","Active")).
Gmail or another mail integration sends the polished report.
Limitations: Less powerful logic and formatting than Make or full custom scripting.
????????? Custom Code-Based Solutions

option 2. Python + Google Colab + Gmail API or SendGrid
Strengths: Fully customizable, scalable, powerful logic, rich formatting.
How it helps:
Python script (can run in Google Colab) loads the daily CSV.
Reformats, applies logic (like "stalled" detection), and outputs a polished HTML or PDF report.
Sends it using Gmail API or via SendGrid/Mailgun.
Best for: Full control. You can even schedule it using cron jobs or Google Apps Script triggers.
I can help you build this entire script in Colab if you like — you’d just need to upload your daily CSV and specify the formatting/logic you want.
???? Smart Tools That Merge Data & Report
4. Google Looker Studio (formerly Data Studio) + Google Sheets
Strengths: Professional-looking dashboards, email scheduling, visualizations.
How it helps:
Use a tool like Zapier or Make to auto-update a Google Sheet with CSV content.
Google Sheets calculates "stalled" logic.
Looker Studio pulls from that sheet to show charts/tables.
Scheduled PDF/email reports go to stakeholders.
Great for: More visual reports and dashboards.
? Summary Recommendation

???? Low-Code / No-Code Solutions
Option 2. Make (formerly Integromat)
Strengths: Highly customizable, visual interface, supports scheduled workflows, CSV parsing, email reports.
How it helps:
Upload CSV from email or cloud storage.
Add a logic module that flags “stalled” users.
Format the data into a Google Sheet, PDF, or HTML email.
Automatically send that report to your recipients.
Best for: Moderate tech-savvy users who want a visual editor without deep coding.

If you're looking for:
Quick setup, less code ? Use Zapier + Google Sheets + Gmail
Power and flexibility ? Use Upgrade to see actual info
Full customization ? Use Python in Google Colab
Clean visuals and auto-reports ? Use Looker Studio