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

This n8n workflow automates the generation of timesheet entries by combining data from your GitHub activity, Google Calendar events, and Gmail, then consolidates them into a Google Sheet. It leverages AI (OpenAI) to intelligently categorize and summarize your work, providing a streamlined way to track your time.

What it does

This workflow runs on a scheduled basis and performs the following steps:

1. Triggers on a Schedule: The workflow starts at predefined intervals (e.g., daily, weekly).
2. Fetches GitHub Activity: Retrieves recent activity from your specified GitHub repositories.
3. Fetches Google Calendar Events: Gathers events from your Google Calendar for a defined period.
4. Fetches Gmail Emails: Collects emails from your Gmail inbox, potentially filtering for relevant work-related communications.
5. Processes Data with AI (OpenAI):
   • Combines the raw data from GitHub, Google Calendar, and Gmail.
   • Sends this combined data to OpenAI to categorize activities, extract key information, and generate concise summaries suitable for timesheet entries.
6. Formats Timesheet Entries: Structures the AI-generated summaries and categories into a consistent format.
7. Appends to Google Sheet: Adds the newly generated timesheet entries as new rows in a designated Google Sheet.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance.
• GitHub Account: With credentials configured in n8n to access your repositories.
• Google Calendar Account: With credentials configured in n8n to access your calendars.
• Gmail Account: With credentials configured in n8n to access your emails.
• Google Sheets Account: With credentials configured in n8n and a target spreadsheet ready for timesheet entries.
• OpenAI API Key: For the OpenAI node to process and categorize your activity data.

Setup/Usage

1. Import the Workflow:
   • Download the provided JSON file for this workflow.
   • In your n8n instance, go to "Workflows" and click "New".
   • Click the "Import from JSON" button and paste the workflow JSON or upload the file.
2. Configure Credentials:
   • Locate the GitHub, Google Calendar, Gmail, Google Sheets, and OpenAI nodes.
   • For each of these nodes, click on the "Credential" field and either select an existing credential or create a new one, following the on-screen instructions to connect your respective accounts.
3. Customize Node Settings:
   • Cron: Adjust the schedule to your preferred frequency (e.g., daily, weekly).
   • GitHub: Specify the repositories or organizations you want to track.
   • Google Calendar: Define the calendar(s) and time range for event retrieval.
   • Gmail: Configure filters for emails if you want to narrow down the scope (e.g., by sender, subject, labels).
   • OpenAI: Review the prompt used for categorization and summarization. You might want to fine-tune it to better suit your specific work activities and desired timesheet format.
   • Google Sheets: Specify the Spreadsheet ID and Sheet Name where the timesheet entries should be appended. Ensure the sheet has appropriate headers.
4. Activate the Workflow: Once all credentials and settings are configured, activate the workflow by toggling the "Active" switch in the top right corner of the workflow editor.

The workflow will now run automatically based on your defined schedule, generating and updating your timesheets.