Run a Database Function Every Week with AI

Every week a run calls a Supabase database function and posts the result as a task comment.

UNIT · TASKADE.FLOW4 STEPS

How this flow runs

When

Every week

Schedule

Then 1

Call Database Function (RPC)

Supabase

Then 2

Ask AI

Taskade AI

Then 3

Add a comment

Taskade

Build this flow with AI

Opens the builder with these steps already described. Free to start, no card.

What does this Supabase automation do?

Every week a run calls a Supabase database function and posts the result as a task comment.

What can you do with it?

  • Run cleanup or rollup jobs on a schedule
  • See the result where the team works
  • Skip a separate job runner

The Steps

This automation runs in 4 steps:

  1. When Schedule: Every week
  2. Then Supabase: Call Database Function (RPC)
  3. Then Taskade AI: Ask AI
  4. Then Taskade: Add a comment

Who is this automation for?

Built for developers who run weekly jobs. Every week a run calls a Supabase database function and posts the result as a task comment.

How do you set it up?

  • Open the "Automations" tab in your workspace.
  • Click ➕ Add automation, then start from scratch.
  • Add the trigger "Every week" from Schedule.
  • Add the action "Call Database Function (RPC)" from Supabase.
  • Add the action "Ask AI" from Taskade AI.
  • Add the action "Add a comment" from Taskade.
  • Connect your Supabase account when prompted, then enable the toggle in the top-right corner.

Prefer to describe it instead? Click Build this flow with AI above and Taskade wires the trigger, the steps for you.

Related from the blog