Hi, I have question about efficiently replacing the data in the Clay.com tables, so the other data won’t be affected. Is it possible to do command: replace [certain data] as it is possible in for example SQL/Excel? 🙂
You can manage data updates in specific columns while preserving other data through these approaches: 1. Use Clay's built-in cleaning tools found in the "Tools" section of the enrichment panel. These tools allow you to manipulate and clean specific data without affecting other columns. 2. For targeted updates: • First, create a filtered view to isolate the specific rows you want to modify • Then apply the changes only to those filtered rows • This ensures your updates are applied selectively without affecting other dataClay's data cleaning tools are credit-free since they work by parsing existing data rather than using external providers. Source: Data Cleaning + Normalization [Automated Outbound] - Clay University
Hi I think that I would need a bit more support from the Support team. I got the table EU companies that contains the data I need to get updated. The new data is in Crunchbase ZAPIER table. Both of the tables are in the same worksheet: EU companies: https://app.clay.com/workspaces/306102/workbooks/wb_nChWvdCAJzS5/tables/t_UTYXMapBpeqT/views/gv_dwe4VRoCqYZw Cruncgbase ZAPIER: https://app.clay.com/workspaces/306102/workbooks/wb_nChWvdCAJzS5/tables/t_WbJszos2UCiu/views/gv_nXNox39YhsN8 I would like to update the existing data in EU companies table
You can update your EU companies table with data from the Crunchbase Zapier table using the "Write to Table" integration. Here's how: 1. In your worksheet, add a "Write to Table" integration 2. Select your EU companies table as the destination table 3. Choose the columns from your Crunchbase Zapier table that contain the data you want to transfer 4. Map these columns to the corresponding columns in your EU companies tableSince both tables are in the same workbook, they're automatically linked, making the data transfer process smoother.To ensure other data isn't affected: ** Carefully select only the specific columns you want to update ** Use the "Only run if" condition to set rules for when the update should occur * Configure auto-update settings based on your needsAfter the update, you can rerun the relevant columns to refresh the data if needed. Sources: Find People [Clay 101] - Clay University Write to table integration overview | Documentation | Clay University Enrich People (Waterfalls) [Automated Outbound] - Clay University
Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!
Hi Helena, thanks for reaching out! Could you specify which data you are looking to replace in the EU companies table? Additionally, is this a one-time replacement or do you need to update this data frequently?
Hi Tanvi, I’d need to update the data frequently. The other table is Crunchbase Zapier. I especially need to update the Last funding date, Last funding amount and Total funding amount
I still have not resolved the issue I asked to be resolved
Hi Helena, happy to help you get this resolved! When you use write to other table to send data to a different table, it does not write over existing cells in that table but rather creates new rows in that table.
Could you clarify why you need to update data from Crunchbase ZAPIER into the EU Companies table? If you're just looking to update this data in Google Sheets, you can actually just use the Google Sheets Lookup, Add, or Update Row enrichment to update these new values in Gsheets. Happy to help you set this up if you'd like
Hi Tanvi, Thank you for reaching back. The issue with Google sheets is that it take long time to upload and update about 13000 rows of data.
That’s why I am looking for an alternative
Hi Helena! Google API is known for its low rate limit, around 60 requests per minute per project, so this is completely normal. Unfortunately, there’s not much we can do to increase that limit. A great way to work around this is to choose a certain number of rows at a time. Alternatively, have you considered using no-code databases with more flexible API limits? Here are a few options that I would recommend: - NocoDB - Seatable.io - Baserow.io - Gigasheet - Airtable - Xano (more technical) - Supabase (more technical and free) Additionally, some of these solutions can also be self-hosted but I'd only recommend it for technical users. Hope this helps! :) Let me know if you need more help!
Hi Daniel, thank you for your reply. I will stick to Clay. It is helpful to know the requests limit. As Tanvi suggested I will try updating the rows via Google Sheets Lookup, Add, or Update Row enrichment so the final product will be in Google sheets.
Sounds good! If there's anything else I can assist you with, please let me know! 😊 Have a great Wednesday, Daniel
I’m good for now. Thank you Daniel and Tanvi :)
.png){kind=logo}
