AI Timesheet Generator with Gmail, Calendar & GitHub to Google Sheets
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: Cron. 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 24 nodes and runs on a schedule (legacy Cron node). Along the way it connects Google Calendar, Gmail, GitHub and OpenAI and 1 more.
How it runs
Trigger: On a schedule (legacy Cron node).
- Set Variables (Edit Fields (Set)): sets 4 fields: today_date, github_handle, repositoriesToTrack…
- Get Today's Emails (Gmail): get many
- Get Today's Calendar Events (Google Calendar): get many
- Create Sheet If It Doesn't Exist (Google Sheets): create
- Split Out: splits a list into separate items
- Split Out: splits a list into separate items
- Aggregate: combines items into one
- Aggregate: combines items into one
- If: checks a condition and branches into true / false
- Get Commits From Github (HTTP Request): calls an HTTP API
…plus 13 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Cron in Daily at 7PM: replace with Schedule Trigger.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| Cron Daily at 7PM | Schedule Trigger |
Nodes used (13)
- Google Calendar
n8n-nodes-base.googleCalendar - Gmail
n8n-nodes-base.gmail - GitHub
n8n-nodes-base.github - Code
n8n-nodes-base.code - OpenAI
@n8n/n8n-nodes-langchain.openAi - Aggregate
n8n-nodes-base.aggregate - Merge
n8n-nodes-base.merge - Cron
n8n-nodes-base.cron - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - Split Out
n8n-nodes-base.splitOut - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets
From the author
AI-Powered Automatic Timesheet Generator for Google Sheets Stop wasting billable hours on manual time-tracking. AutoTimesheet Pro uses AI to collect emails, meetings, and GitHub work, then writes a clean timesheet straight into Google Sheets. Perfect for…