How to Integrate Supabase with Make (Integromat)

1// Edge Function: webhook receiver for Make-to-Supabase integration
2// Deploy: supabase functions deploy make-webhook
3
4import { corsHeaders } from '../_shared/cors.ts'
5import { createClient } from 'npm:@supabase/supabase-js@2'
6
7Deno.serve(async (req) => {
8  if (req.method === 'OPTIONS') {
9    return new Response('ok', { headers: corsHeaders })
10  }
11
12  try {
13    const supabase = createClient(
14      Deno.env.get('SUPABASE_URL')!,
15      Deno.env.get('SUPABASE_SERVICE_ROLE_KEY')!
16    )
17
18    const payload = await req.json()
19    const { action, table, data } = payload
20
21    let result
22
23    switch (action) {
24      case 'insert':
25        result = await supabase.from(table).insert(data).select()
26        break
27      case 'update':
28        result = await supabase.from(table).update(data.values).eq('id', data.id).select()
29        break
30      case 'delete':
31        result = await supabase.from(table).delete().eq('id', data.id)
32        break
33      case 'select':
34        result = await supabase.from(table).select(data.columns || '*').limit(data.limit || 100)
35        break
36      default:
37        return new Response(
38          JSON.stringify({ error: `Unknown action: ${action}` }),
39          { headers: { ...corsHeaders, 'Content-Type': 'application/json' }, status: 400 }
40        )
41    }
42
43    if (result.error) {
44      return new Response(
45        JSON.stringify({ error: result.error.message }),
46        { headers: { ...corsHeaders, 'Content-Type': 'application/json' }, status: 400 }
47      )
48    }
49
50    return new Response(
51      JSON.stringify({ data: result.data }),
52      { headers: { ...corsHeaders, 'Content-Type': 'application/json' }, status: 200 }
53    )
54  } catch (error) {
55    return new Response(
56      JSON.stringify({ error: 'Internal server error' }),
57      { headers: { ...corsHeaders, 'Content-Type': 'application/json' }, status: 500 }
58    )
59  }
60})