Supabase Get rows and order by

Hi @Rad, I think the sorting will be tricky using the default Supabase node. But since Supabase is built on PostgreSQL you could consider using n8n’s Postgres node here and write a custom SQL query.

You can find the required credentials directly in the Project Settings in Supabase under Database:

In n8n, you can then run a query such as SELECT * FROM users ORDER BY id DESC LIMIT 20; to fetch the last 20 rows from a users table sorted by id in descending order:

1 Like