Clay Icon
Join the Community
02 Support

I have a question about importing manual data into a table. I have a l...

Avatar of Ali Y.Ali Y.
·
·

I have a question about importing manual data into a table. I have a list of companies in a clay table and then a CSV of those same companies with a 2nd column of data that I want to use clay to peform an if/than statement based on the data in the CSV. what is the easiest way to do this? Happy to provide further clarity 🙂

12 comments

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉

  • Avatar of Ali Y.
    Ali Y.
    ·
    ·
  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Hey Ali, thanks for reaching out! What comes to mind is that you'd like to use something like a lookup to then use that as part of a condition, right? If you have that data in two tables, you can use our Lookup Record integration, or if its from a Google Sheet, there's also a lookup option for that... but let me know!

  • Avatar of Alex
    Alex
    ·
    ·

    how do we query from a google sheet?

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Hey Alex! We don't currently have the option to query a google sheet, the best way would be to do this by filtering it, getting the CSV, and importing into Clay. Or some users also like to automate a similar process but they import via webhooks + zapier/make.com

  • Avatar of Ali Y.
    Ali Y.
    ·
    ·

    Arturo O. if we have 2 clay tables and we want to import the data from column 2 into the other table based on a match of data in column 1 in both tables. is that possible?

  • Avatar of Ali Y.
    Ali Y.
    ·
    ·

    i was trying to just manually import the CSV into the first table but for some reason it was appending the table to the bottom of the original data in table 1

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Yep, so like a lookup as mentioned above, right? When you import files our tables don't currently 'lookup' existing rows/columns to append them, and that's why rows are created at the bottom instead.Here's a video and our docs page for Lookup Record! That integration can help you achieve this though, and we also have an integration for Lookup Google Sheets which could check files you don't have in Clay to append them if there's a match

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Let me know if you run into any issues!

  • Avatar of Ali Y.
    Ali Y.
    ·
    ·

    awesome! Arturo O. that worked