How to delete a record when not created or updated

Hello all,

I am struggling with finding a solution since a while. I have a make scenario that is running weekly and scraping one specific web page, looking for some info with Regex and if found, creating or updating new records in Airtable:

  • List item I don’t have problems with scraping, extracting, and then later create or update (if the record is already there)
  • My problem is that I would like to delete a record, if not found in the last scraping.

Example:
Week 1: Run the scrape > extract the content > find 2 elements > create 2 records in Airtable
Week 2: Run the scrape > extract the content > find only 1 element > update the element which is still there, and delete the other element.

My issue is that I do not know how to delete the element not found and I would like to keep airtable up to date with the latest info.

Thanks a lot!

Thanks a lot!