n8n Automation Cheatsheet

// Flow: Schedule (every 30min) → Outlook: Get Unread → 
//        Loop → Ollama: Classify → Outlook: Move to Folder → 
//        Aggregate → IF end of day → Teams: Post Summary

// Step 1: Fetch unread (HTTP Request or Microsoft Outlook node)
Method: GET
URL: https://graph.microsoft.com/v1.0/me/mailFolders/Inbox/messages
     ?$filter=isRead eq false&$top=50&$select=subject,from,bodyPreview,receivedDateTime

// Step 2: Ollama Classification (HTTP Request Node)
Method: POST
URL: http://localhost:11434/api/generate
Body:
{
  "model": "llama3.1:8b",
  "prompt": "Classify this email into exactly ONE category: ACTION_REQUIRED, FYI, MEETING, JIRA, APPROVAL, SPAM. Only reply with the category name.\n\nFrom: {{ $json.from.emailAddress.address }}\nSubject: {{ $json.subject }}\nPreview: {{ $json.bodyPreview }}",
  "stream": false
}

// Step 3: Move to folder (HTTP Request Node)  
Method: POST
URL: https://graph.microsoft.com/v1.0/me/messages/{{ $json.id }}/move
Body: { "destinationId": "{{ $json.folderId }}" }

// Folder mapping (Code Node):
const folderMap = {
  'ACTION_REQUIRED': 'AAMkAG...actionFolder',
  'FYI': 'AAMkAG...fyiFolder',
  'MEETING': 'AAMkAG...meetingFolder',
  'JIRA': 'AAMkAG...jiraFolder',
  'APPROVAL': 'AAMkAG...approvalFolder',
  'SPAM': 'AAMkAG...junkFolder'
};

// Flow: Schedule (Mon-Fri 7:30) → Outlook: Get Events → Code: Format → 
//        Send Email / Teams Message

// Fetch today's events (HTTP Request):
Method: GET
URL: https://graph.microsoft.com/v1.0/me/calendarView
     ?startDateTime={{ $now.startOf('day').toISO() }}
     &endDateTime={{ $now.endOf('day').toISO() }}
     &$orderby=start/dateTime
     &$select=subject,start,end,location,organizer,isOnlineMeeting,onlineMeeting

// Code Node — Format Agenda:
const events = $input.first().json.value || [];
if (events.length === 0) return [{ json: { agenda: 'No meetings today! 🎉', count: 0 }}];

let agenda = '<b>📅 Your Agenda — ' + new Date().toLocaleDateString('de-CH') + '</b><br><br>';
let totalMeetingHours = 0;

for (const evt of events) {
  const start = new Date(evt.start.dateTime + 'Z');
  const end = new Date(evt.end.dateTime + 'Z');
  const duration = (end - start) / 3600000;
  totalMeetingHours += duration;
  
  const time = start.toLocaleTimeString('de-CH', {hour:'2-digit', minute:'2-digit'})
    + ' - ' + end.toLocaleTimeString('de-CH', {hour:'2-digit', minute:'2-digit'});
  const meetLink = evt.isOnlineMeeting ? 
    ' <a href="' + (evt.onlineMeeting?.joinUrl || '#') + '">Join →</a>' : '';
  
  agenda += `<b>${time}</b> ${evt.subject}${meetLink}<br>`;
  if (evt.location?.displayName) agenda += `  📍 ${evt.location.displayName}<br>`;
}

agenda += `<br><b>Total meeting time: ${totalMeetingHours.toFixed(1)}h</b>`;
if (totalMeetingHours > 6) agenda += ' ⚠️ Heavy meeting day!';

return [{ json: { agenda, count: events.length, hours: totalMeetingHours }}];

// Flow: Outlook Trigger (new email) → IF importance=high → 
//        Get Presence → IF InAMeeting → Get Current Event End Time → 
//        Outlook: Reply with ETA

// Code Node — Build auto-reply:
const email = $('Outlook Trigger').first().json;
const currentEvent = $('Get Calendar').first().json.value?.[0];
const endTime = currentEvent ? 
  new Date(currentEvent.end.dateTime + 'Z').toLocaleTimeString('de-CH', 
    {hour:'2-digit', minute:'2-digit'}) : 'soon';

return [{
  json: {
    to: email.from.emailAddress.address,
    subject: 'Re: ' + email.subject,
    body: `Hi,\n\nI'm currently in a meeting and will get back to you around ${endTime}.\n\nIf this is truly urgent, please reach me on Teams.\n\nBest regards,\nMarkus`,
    inReplyTo: email.id
  }
}];

// Send Reply (HTTP Request):
Method: POST
URL: https://graph.microsoft.com/v1.0/me/messages/{{ $json.inReplyTo }}/reply
Body: { "message": { "body": { "content": "{{ $json.body }}", "contentType": "text" }}}

// Flow: Schedule (every 15min) → Get Recently Ended Meetings → 
//        Loop → Get Transcript → Ollama: Summarize → 
//        Send Notes Email to Attendees

// Fetch meetings that ended in last 15 min:
Method: GET
URL: https://graph.microsoft.com/v1.0/me/calendarView
     ?startDateTime={{ $now.minus({minutes: 20}).toISO() }}
     &endDateTime={{ $now.minus({minutes: 1}).toISO() }}
     &$filter=isOnlineMeeting eq true

// Ollama Summarize (HTTP Request):
Method: POST
URL: http://localhost:11434/api/generate
Body: {
  "model": "llama3.1:8b",
  "prompt": "Summarize these meeting notes. Include: Key Decisions, Action Items (with owners), Open Questions.\n\nTranscript:\n{{ $json.transcript }}",
  "stream": false
}

// Flow: Schedule (every 10min) → Outlook: Get Emails with Attachments → 
//        Loop → Download Attachment → Categorize → Save to Folder

// Fetch emails with attachments:
Method: GET  
URL: https://graph.microsoft.com/v1.0/me/messages
     ?$filter=hasAttachments eq true and isRead eq false
     &$expand=attachments&$top=20

// Code Node — Save logic:
const msg = $input.first().json;
const senderRules = {
  'invoice': /buchhaltung|accounting|rechnung|invoice/i,
  'contracts': /vertrag|contract|legal/i,
  'reports': /report|bericht|weekly|monthly/i,
};

for (const att of msg.attachments || []) {
  if (att['@odata.type'] !== '#microsoft.graph.fileAttachment') continue;
  
  let folder = 'general';
  for (const [cat, regex] of Object.entries(senderRules)) {
    if (regex.test(msg.subject) || regex.test(msg.from.emailAddress.address)) {
      folder = cat; break;
    }
  }
  
  return [{ 
    json: { 
      filename: att.name,
      content: att.contentBytes, // base64
      folder: '/home/markus/Documents/outlook-attachments/' + folder,
      sender: msg.from.emailAddress.address
    }
  }];
}

// Write File Node: 
// Path: {{ $json.folder }}/{{ $json.filename }}
// Content: {{ $json.content }} (base64 decode)

// Flow: Schedule (Fri 17:00) → Get This Week's Events → 
//        Code: Analyze → Format Report → Email

// Code Node — Weekly Analysis:
const events = $input.first().json.value || [];
const categories = {};
let totalHours = 0;

for (const evt of events) {
  const start = new Date(evt.start.dateTime + 'Z');
  const end = new Date(evt.end.dateTime + 'Z');
  const hours = (end - start) / 3600000;
  totalHours += hours;
  
  // Categorize by keywords in subject
  let cat = 'Other';
  if (/standup|daily|sync/i.test(evt.subject)) cat = 'Standups & Syncs';
  else if (/review|code review|pr/i.test(evt.subject)) cat = 'Code Reviews';
  else if (/planning|sprint|retro|grooming/i.test(evt.subject)) cat = 'Agile Ceremonies';
  else if (/1:1|1-1|one.on.one/i.test(evt.subject)) cat = '1:1 Meetings';
  else if (/workshop|training/i.test(evt.subject)) cat = 'Workshops';
  else if (/interview/i.test(evt.subject)) cat = 'Interviews';
  
  categories[cat] = (categories[cat] || 0) + hours;
}

const sorted = Object.entries(categories).sort((a,b) => b[1] - a[1]);
let report = '<b>📊 Weekly Meeting Report</b><br><br>';
report += '<b>Total: ' + totalHours.toFixed(1) + 'h in meetings</b><br>';
report += '<b>Focus time: ' + (40 - totalHours).toFixed(1) + 'h available</b><br><br>';

for (const [cat, hrs] of sorted) {
  const bar = '█'.repeat(Math.round(hrs * 2)) + '░'.repeat(Math.round((10-hrs)*2));
  report += `${cat}: ${hrs.toFixed(1)}h ${bar}<br>`;
}

if (totalHours > 25) report += '<br>⚠️ Over 60% in meetings — consider declining some!';

return [{ json: { report, totalHours }}];