Improve Table Functionality: Manual Entry and Automation Solutions

This table (https://app.clay.com/workspaces/251093/tables/t_99awSZHvjADf/views/gv_hRrNPFkDssYB) receives people's names from another table that I import companies to. I need to do 2 things with this table: 1 I want to be able to manually add a person by adding a new row, adding their LI URL, full name and company URL so that the 'find email' and 'find mobile' automations can be used on them. Currently I'm not able to edit cells in a newly added row manually. AND 2) I want to be able to manually make the email waterfall work and, separately, manually make the mobile waterfall work. Currently if I turn off the auto-run functionality I have to manually tick every stage of the email or mobile waterfalls, but I only want to have to click once to have all the email stages work, and click another time to make all the mobile stages work.

15 comments

Channeled
APP
·
·
💤 You've caught us outside of our support hours (9am-9pm EST), but don't worry - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in the thread below so that we can help you as quickly as possible!
Bo (.
·
·
Hey Steve, 1. Manual Entry in Rows: To add people manually, create a new text column where you can enter data manually (e.g., LinkedIn URL, full name, company URL). Then, create a merge column where you set the order as your text column first, followed by the automatic field. This way, if you add something manually, it takes priority, and it will trigger the enrichment (like ‘Find Email’ and ‘Find Mobile’). 2. Simplifying the Waterfall Process: Turn off the auto-update for the table itself, but leave auto-update on for the enrichment. This will allow you to manually trigger the entire email waterfall or mobile waterfall with just one click for each, instead of manually ticking every stage. Let me know if you need further help with this! 😊
Steve M.
·
·
Thanks! Where do I turn off the auto update for the table itself Bo?
Bo (.
·
·
Great question, there you go: https://downloads.intercomcdn.com/i/o/1188202760/ea84a53a46f802a50ac8ad36/CleanShot+2024-09-21+at+_31TeZR8Rel%402x.png?expires=1726932600&signature=747dc76fb145bf2df5496c72958568165b23917cc5b1832736f6ec0f665c99c4&req=dSEvHst%2Bn4ZZWfMW1HO4zR%2BFkyTt55xszdkfjgtl6z2XIcSuGExzIh8ehewR%0Aupwk%0A
Steve M.
·
·
So I've merged the 3 manual columns I created for full name, person's LI URL and company URL. But how do I have the table try to use the manual data first with the email/mobile finders?
Bo (.
·
·
I've recorded a quick loom for you :) https://cln.sh/gZCR55Wz
Steve M.
·
·
Thank you for that Bo, but I think I may have confused you. The reason I want to do this is because sometimes (often actually) Clay doesn't pick up some of the people who have job titles like the ones in my people search. So I need to find them on sales nav myself. But then I want to get their email and phone numbers using the same clay table so I have them in the same place. I want to be able to create a blank row and add in ther full name, LI URL and company URL to the same table and be able to start those automations manually. Is this possible?
Steve M.
·
·
Also another question....How can I have the mobile number search only return mobile numbers not landlines?
Steve M.
·
·
And another...if the source of the mobile number finds more than one mobile number, how can I have it return all of them in the same row?
Bo (.
·
·
That would be exactly like in the video! Here’s a breakdown for all the values: 1. Follow the steps in the video for Full Name, LinkedIn URL, and Company URL: • Create 3 text columns for these fields. • Then, create 3 merge columns to combine manual and automatic data. 2. Reference the merge columns inside the enrichment process to pull the correct data. 3. Add a new row at the bottom, then enter your values for Full Name, LinkedIn URL, and Company URL. Regarding the mobile number source, our provider returns the data they have, but we’ve recently added a tool called SureConnect to verify if the number is indeed a mobile number. If you want to combine everything into one row (e.g., multiple values returned in a comma-separated line), go to the row settings: • Click the header > Edit > Formulas • Add this prompt: If any of those values (link the columns) are present, return them in a comma-separated line. Let me know if that helps! 😊 https://downloads.intercomcdn.com/i/o/1188273966/732b45509703e92f8d29c8d1/CleanShot+2024-09-21+at+_27Pn3b7W3R.gif?expires=1726938900&signature=657a6b4f715f082b3f1f6adf28ded584c3fab986dbb91fdf54411ffc598c710c&req=dSEvHst5nohZX%2FMW1HO4zRakP7%2BJcZxYgLgZrwdg%2FQhcnEEsHV3V4vaqCEDN%0Aba7h%0A https://downloads.intercomcdn.com/i/o/1188272644/aa197503e597d5043d42df0b/CleanShot+2024-09-21+at+_192p3XnBEo%402x.png?expires=1726938900&signature=2be47133f1b100f0f1f6f8fd8aa2dc26937fdf3ce91967447e4e7019e8d7b422&req=dSEvHst5n4dbXfMW1HO4zT3JYp6eu3%2By%2Bl7SPMPM%2BsfBVX32S5mMz41eZ60M%0AnFti%0A
Steve M.
·
·
Let me take a look at these. But thanks very much for your awesome help Bo. It's much appreciated!
Steve M.
·
·
I made you a Loom in return Bo! Thanks: https://www.loom.com/share/3673c7b0f6f44cc7beb2f8c39cdd3aa5?sid=65b7b38d-b36e-4d89-96c2-372bf9ee01a0
Bo (.
·
·
Replying with one too :) https://cln.sh/WlvC740y
Channeled
APP
·
·
We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!
Channeled
APP
·
·
Hi Steve M.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: