Clay Icon
Join the Community
02 Support

Automating Weekly Appending of New Companies to Table

Avatar of Jeff R.Jeff R.
·
·

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?

10 comments

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    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?

  • Avatar of Jeff R.
    Jeff R.
    ·
    ·

    it is a seperate list. i want to add the list of companies that are hiring for my keywork to that list

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    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.

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    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

  • Avatar of Jeff R.
    Jeff R.
    ·
    ·

    sorry expand on that last sentence

  • Avatar of Jeff R.
    Jeff R.
    ·
    ·

    so i can run find jobs on the same table and it’ll automatically update / upsert the table

  • Avatar of Jeff R.
    Jeff R.
    ·
    ·

    so effectively emrge the two and then run the find jobs function?

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    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.

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    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).

    584143fa-ee28-4970-b1bb-782530b0f7fa.png(142 kB)