Your Bills Live in a Spreadsheet. Your Calendar Has No Idea They Exist.

说明与用途

将包含账单截止日期的 CSV 表格自动转换为标准 .ics 文件，并通过 cron 定时导入到 Google Calendar、Outlook 等日历应用的自动化流程。

问题

Freelancers and small‑business owners keep due dates in a spreadsheet but never sync them to their calendar, causing missed deadlines.

结果

Automated pipeline turns spreadsheet deadlines into calendar events with reminders, all‑day or timed, and handles bad rows gracefully.

工作流

• 1. Prepare a CSV/TSV spreadsheet with deadline data (title, date, due, etc.).
• 2. Run python csv2cal.py shared_deadlines.csv -o team.ics to convert the file to .ics.
• 3. Import the resulting team.ics into Google Calendar, Outlook, Apple Calendar, or Thunderbird.
• 4. Schedule the command in cron (e.g., 0 22 * * * python csv2cal.py shared_deadlines.csv -o team.ics || echo "csv2cal failed" >&2).
• 5. Repeat the cron job nightly to keep the calendar up‑to‑date.

证据

A single-file Python CLI (pure standard library, zero dependencies — no pip install) that converts any deadline spreadsheet into a calendar file:

来源

0 22 * * * python csv2cal.py shared_deadlines.csv -o team.ics || echo "csv2cal failed" >&2

来源