Updating Supabase following the deletion of a file in Google Drive

Questions
,
1

Hello n8n community,

Is there a node I can add to the workflow that would delete the rows in Supabase following the deletion of the file in Google Drive?
Or do I nee a seperate workflow comparing the File ID in Google Folder with this those in the metadata in Supase and then deleting the rows that do not match?

Information on your n8n setup

  • n8n version: 1.71.3
  • Database (default: SQLite): unsure
  • n8n EXECUTIONS_PROCESS setting (default: own, main): own
  • Running n8n via (Docker, npm, n8n cloud, desktop app): docker
  • Operating system: macos

Thanking you all in advance.

DB

2

Welcome to the community @blacksand-aero !

Deleting vectorized documents from Supabase is possible with the regular Supabase node but it is not straightforward. See https://www.youtube.com/watch?v=ELAxebGmspY&ab_channel=MarioHaarmann for the guidance.

You seem to be doing that already but your filter allows for more than one file ID. Perhaps you need to adjust that if your current solution does not work.