Automated Job Monitoring Workflow

I need a small but solid workflow that runs every day, queries Google Jobs through SerpApi plus the public Greenhouse and Lever feeds, and pulls back any listing whose title or description matches a set of key words my team will maintain (they will be provided once we start).

For every match the script should capture company, role title, location, posting date, source site, and the original link, then write the deduplicated results into a single, well-structured sheet—Google Sheets is ideal because the team already lives in Workspace.

At the same time the workflow should compile a clean HTML digest that groups the new roles and emails it to our shared address before 9 a.m. each morning.

Key expectations
• Use the official/public APIs wherever possible: SerpApi for Google Jobs plus the standard JSON feeds from Greenhouse and Lever.
• Keep the code readable and easily editable so we can add or remove key words or sources without digging through complex logic.
• Handle deduplication gracefully across sources (same job, different feed).
• Schedule the job on a reliable, low-maintenance platform—Github Actions or a lightweight cloud function is fine, as long as it runs daily without fuss.

Deliverables
1. Source code with clear environment instructions (language of your choice, though Python is preferred).
2. A Google Sheet automatically populated by the workflow.
3. HTML email template and send routine hooked to our SMTP or Gmail API.
4. Brief README covering setup, key word editing, and how to add more sources later.