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

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

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

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 😉
Ali Y.
·
·
https://app.clay.com/workspaces/83297/tables/t_kusjZAmwLLrs/views/gv_qbJsDZ5TNOe4
Ali Y.
·
·
Alex
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!
Alex
·
·
how do we query from a google sheet?
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
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?
Ali Y.
·
·
we want this table https://app.clay.com/workspaces/83297/tables/t_kusjZAmwLLrs/views/gv_qbJsDZ5TNOe4 to populate data from column 2 in this table https://app.clay.com/workspaces/83297/tables/t_t7lYQgvWutkp/views/gv_aqvovuzGhmVd
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
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
Clay Team
APP
·
·
Let me know if you run into any issues!
Ali Y.
·
·
awesome! Arturo O. that worked