How to Integrate Lovable with OmniFocus

1// supabase/functions/omnifocus-sync/index.ts
2import { serve } from 'https://deno.land/std@0.168.0/http/server.ts';
3import { createClient } from 'https://esm.sh/@supabase/supabase-js@2';
4
5const corsHeaders = {
6  'Access-Control-Allow-Origin': '*',
7  'Access-Control-Allow-Headers': 'authorization, x-client-info, apikey, content-type',
8};
9
10serve(async (req) => {
11  if (req.method === 'OPTIONS') {
12    return new Response('ok', { headers: corsHeaders });
13  }
14
15  try {
16    const body = await req.json();
17    const expectedSecret = Deno.env.get('OMNIFOCUS_WEBHOOK_SECRET');
18
19    if (body.secret !== expectedSecret) {
20      return new Response(
21        JSON.stringify({ error: 'Unauthorized' }),
22        { status: 401, headers: { ...corsHeaders, 'Content-Type': 'application/json' } }
23      );
24    }
25
26    const supabase = createClient(
27      Deno.env.get('SUPABASE_URL')!,
28      Deno.env.get('SUPABASE_SERVICE_ROLE_KEY')!
29    );
30
31    const now = new Date().toISOString();
32    const tasks = (body.tasks || []).map((t: Record<string, unknown>) => ({ ...t, synced_at: now }));
33    const projects = (body.projects || []).map((p: Record<string, unknown>) => ({ ...p, synced_at: now }));
34
35    if (projects.length > 0) {
36      const { error: projErr } = await supabase
37        .from('omnifocus_projects')
38        .upsert(projects, { onConflict: 'id' });
39      if (projErr) throw projErr;
40    }
41
42    if (tasks.length > 0) {
43      const { error: taskErr } = await supabase
44        .from('omnifocus_tasks')
45        .upsert(tasks, { onConflict: 'id' });
46      if (taskErr) throw taskErr;
47    }
48
49    await supabase.from('sync_log').insert({
50      timestamp: now,
51      item_count: tasks.length + projects.length,
52    });
53
54    return new Response(
55      JSON.stringify({ success: true, tasks: tasks.length, projects: projects.length }),
56      { status: 200, headers: { ...corsHeaders, 'Content-Type': 'application/json' } }
57    );
58  } catch (err) {
59    return new Response(
60      JSON.stringify({ error: err.message }),
61      { status: 500, headers: { ...corsHeaders, 'Content-Type': 'application/json' } }
62    );
63  }
64});

1-- AppleScript alternative for macOS
2-- Save as: ~/Documents/omnifocus-export.scpt
3-- Run from Script Editor or Automator
4
5set webhookURL to "https://YOUR-PROJECT.supabase.co/functions/v1/omnifocus-sync"
6set webhookSecret to "YOUR-WEBHOOK-SECRET"
7
8tell application "OmniFocus"
9  set theDoc to default document
10  
11  -- Collect tasks
12  set taskList to "{\"tasks\":["
13  set allTasks to every inbox task of theDoc
14  set taskCount to count of allTasks
15  
16  repeat with i from 1 to taskCount
17    set t to item i of allTasks
18    set taskJSON to "{\"id\":\"" & id of t & "\",\"name\":\"" & name of t & "\",\"completed\":" & (completed of t as string) & "}"
19    set taskList to taskList & taskJSON
20    if i < taskCount then set taskList to taskList & ","
21  end repeat
22  
23  set taskList to taskList & "]}"
24end tell
25
26-- POST to Edge Function (requires curl available on macOS)
27do shell script "curl -s -X POST '" & webhookURL & "' -H 'Content-Type: application/json' -d '{\"secret\":\"" & webhookSecret & "\"," & (characters 2 thru -1 of taskList as string) & "'"