i have a table of companies. i want to append new companies into that list from a clay run. how do i do this and automate to run say once a week?
https://app.clay.com/workspaces/10798/tables/t_Ve4syreo19Wh/views/gv_jsJhmQbMDK0k
list of existing companies
https://app.clay.com/workspaces/10798/tables/t_jEehgoyqhiX0/views/gv_w0isSmVeMwXp
list of poential additional companies
Hey Jeff, thanks for reaching out! Happy to share a bit more, just want to clarify. I see the first table is a list of companies you imported via CSV, right? And then you found jobs for them or are those records in the second table separate from the initial list?
it is a seperate list. i want to add the list of companies that are hiring for my keywork to that list
Also, currently, the Find Jobs feature can't be automated/scheduled to run after a certain period of time but the concept has been brought up and may be included on the roadmap.But when you run the Find Jobs search, you can choose import into an existing table instead of creating a new one if that helps.
For this particular case, it may be easier/faster to download the CSV from the second table and import it into the first one, as a unique instance. Future imports can be added to the table directly instead
sorry expand on that last sentence
so i can run find jobs on the same table and itβll automatically update / upsert the table
so effectively emrge the two and then run the find jobs function?
Correct, except for the automatically update part if you're referring to having it run once every X days on its own. You'll need to run each search separately for now.
When you run a new find jobs search, it gives you some options but the default is to create a new table, instead, you would import to an existing one to consolidate the data. And the option to exclude previous jobs is also there, so you only get new records, but does require the corresponding plans (Explorer or above).