AI Timesheet Generator with Gmail, Calendar & GitHub to Google Sheets

n8n template #5396

Summary

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 developers, consultants, agencies, and remote teams. Get Started with n8n now! 🚀 Key Features Automated Google Sheets time-tracking — zero spreadsheet prep. AI-generated activity summaries (≤ 120 chars) via OpenAI GPT-4o-mini. Gmail integration — logs only important emails, skipping newsletters & no-replies. Google Calendar time logger — captures confirmed events, duration, and attendees. GitHub commit & PR tracker — records your commits pl

How to set it up

Open template #5396 on n8n.io and click Use for free, or copy the template JSON and paste it onto an empty canvas in n8n.
Create 5 credentials under Credentials → Add credential: GitHub, Google Sheets, Google Calendar, Gmail, OpenAI. Then open each of those nodes and pick the credential.
Check the model in the OpenAI node. The template may point at a model your account can't use; swap it for one you have access to.
Click Execute workflow and step through each node's output to confirm the data looks right.
Toggle the workflow to Active so its trigger runs on its own.

Hand off to your agent

Prompt

Help me set up the n8n workflow "AI Timesheet Generator with Gmail, Calendar & GitHub to Google Sheets" (https://n8n.io/workflows/5396). It uses: GitHub, Google Sheets, HTTP Request, Google Calendar, Gmail, Code, OpenAI. Import the template JSON into my n8n instance, list every credential I need to create, and walk me through testing it.

Paste into Claude Code and it will do the rest.

Apps and nodes

GitHub Google Sheets HTTP Request Google Calendar Gmail Code OpenAI

Questions

Yes. Luka Zivkovic published it free on n8n.io as a verified creator, and it has 20K views. It runs on n8n Cloud or a self-hosted n8n instance.

GitHub, Google Sheets, Google Calendar, Gmail, OpenAI. The other 2 nodes are built into n8n.

Similar workflows

NameViews