How to Automatically Delete Rows and Enrich Data in Tables

Fahad T. · 2024-10-16T10:49:59.97047+00:00

Hi, two questions: 1. How to delete rows? I need to delete rows in a table on conditions, I can delete the rows using sort/filter, but that is not scalable. Example - One day I have data, and I can sort filter out then delete rows. Another day I will have to repeat the same process again. I want to apply a condition, if there is new data delete the rows that meet the specific conditions automatically. 2. How to enrich new data in the same table? Example - Day 1 searched for jobs and created the table based on my requirements. Day 2 I can't create the new jobs table and do the whole process again. I want the new jobs to be published in the same table created on Day 1.

Fahad T.

Hi, two questions:

1.
How to delete rows? I need to delete rows in a table on conditions, I can delete the rows using sort/filter, but that is not scalable. Example - One day I have data, and I can sort filter out then delete rows. Another day I will have to repeat the same process again. I want to apply a condition, if there is new data delete the rows that meet the specific conditions automatically.
2.
How to enrich new data in the same table? Example - Day 1 searched for jobs and created the table based on my requirements. Day 2 I can't create the new jobs table and do the whole process again. I want the new jobs to be published in the same table created on Day 1.

5 comments

Channeled
APP
·
·
💤 You've caught us outside of our support hours (9am-9pm EST), but don't worry - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in the thread below so that we can help you as quickly as possible!
Muhammad S.
·
·
1- Not possible directly programatically 2- Use n8n.io and apify combo to achieve this.
Fahad T.
·
·
Thank you
Owen C.
·
·
Hey Fahad, thanks for reaching out! As Muhammad mentioned, there's no way to automatically delete rows in Clay tables since we don’t expose that endpoint. However, you can hide rows you don’t want to see or export by applying filters. Currently, we don’t offer an option to automatically track and add new job listings from a specific list of companies. That said, you can use n8n along with an Apify scraper to achieve this, and it can automatically upload the new listings into the same table. Regardless, to manually import additional data (like jobs, in this case) into the same Clay table, simply click 'Actions' -> 'Find More Companies' and choose how many jobs you want to add. These new entries will go through any enrichments or automation you’ve already set up. Hope this helps! Let me know if you have any other questions! 😊
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.