How do you add the "Find People" Column to a companies table? (Link to Workbook) I have a source that is set up perfectly for the find people table, which finds ppl from companies in my find companies table. I need to have that column in the companies table that automatically updates when a new company is added, and the new people it finds needs to be sent to the same find people tbale. Thanks!
To add a "Find People" column to your companies table that automatically updates, you can use our "write to table" feature. Here's how: 1. Go to "Actions" and select "Find people at these companies" 2. Ensure you have the company's domain or LinkedIn URL in your companies table 3. Set up your search parameters for the people you want to find 4. Instead of creating a new table, use the "write to table" feature to add the results to your existing Find People table 5. Set up a lookup column in your companies table to reference the Find People table To keep it updated: ** Enable auto-update for your companies table ** Rerun the lookup column in your Find People table when you add new company data This way, new companies will trigger people searches, and the results will be added to your existing Find People table.
To join both the tables Dustin S.
To add a "Find People" column to your companies table using a lookup single row from another table, follow these steps: 1. First, set up a "Find People" action for your companies table. 2. Use the "write to table" feature to add the results to your existing Find People table. 3. In your companies table, add a new column using the "Lookup Single Row in Other Table" action. 4. Configure the lookup to search your Find People table, matching on the company identifier (e.g., domain or LinkedIn URL). 5. Enable auto-update for your companies table to keep it current. This setup will automatically update the "Find People" column when new companies are added, and new people found will be sent to the same Find People table.
To join your companies table with the Find People table and keep it automatically updated, follow these steps: 1. Set up a "Find People" action for your companies table. 2. Use the "write to table" feature to add the results to your existing Find People table. 3. In your companies table, add a new "Find People" column using the "Lookup Single Row in Other Table" action. 4. Configure this lookup to search your Find People table, matching on the company identifier (e.g., domain or LinkedIn URL). 5. Enable auto-update for your companies table. This setup will automatically update the "Find People" column when new companies are added, linking to the same Find People table. You can click on any row in the "Find People" column to see all fields from the Find People table for the relevant company.
And as a lookup function, you can use the company domain.
To join your companies table with the Find People table using a lookup function based on the company domain, follow these steps: 1. Set up a "Find People" action for your companies table. 2. Use our "write to table" feature to add the results to your existing Find People table. 3. In your companies table, add a new "Find People" column using the "Lookup Single Row in Other Table" action. 4. Configure this lookup to search your Find People table, matching on the company domain. 5. Enable auto-update for your companies table to keep it current. This setup will automatically update the "Find People" column when new companies are added, linking to the same Find People table. The lookup column in your Find People table will refresh whenever changes are made to the companies table, ensuring automatic linking and easy access to company-level data.
To join your companies table with the Find People table using a lookup function based on the company domain: 1. Set up a "Find People" action for your companies table. 2. Use our "write to table" feature to add results to your existing Find People table. 3. In your companies table, add a new "Find People" column using the "Lookup Single Row in Other Table" action. 4. Configure this lookup to search your Find People table, matching on the company domain. 5. Enable auto-update for your companies table. This setup will automatically update the "Find People" column when new companies are added, linking to the same Find People table. The lookup column refreshes whenever changes are made to the companies table, ensuring automatic linking and easy access to company-level data.