Setting Up Automated Personalized Videos with Dynamic URLs

I’m trying to set up an automation where a personalized video from SendSpark is sent to contacts, and the video dynamically includes the correct returns page URL for each contact’s company. Here’s the setup:

I have one table with companies and their respective returns page URLs (sourced from Store Leads).
I have another table with enriched contacts from those companies.
Both tables are in the same Clay workbook.

My question is: How can I map the correct returns URL from the company table to the corresponding contact in the contact table? Then I can have the URLs and email push to SendSpark to generate the videos, and then instantly to ship the campaign. Thanks!

7 comments

Channeled
APP
·
·
You can use the "write to table" feature to map company returns URLs to your contacts table. Here's how: 1. Select your Clay account 2. Choose your contacts table as the destination 3. Enter "/" to skip list selection 4. Map the company data to your contacts table by matching on a common identifier (like company domain) 5. Select the returns URL column from your company table to map to your contacts table With this setup, each contact will have their company's returns URL, which you can then use in your SendSpark video campaign.
Sources: Write to Other Table | Documentation | Clay University Write to Other Table | Documentation | Clay University
Collin S.
·
·
tried this but couldnt get the table to populate
Collin S.
·
·
https://app.clay.com/workspaces/580168/workbooks/wb_0sxsz703GbbwG5PSche/tables/t_0sxsz7zcFCoYbMZfX73/views/gv_0sxsz7z6T5cji477PhT
Bo (.
·
·
Yes, we have two ways of doing this - sounds like you need #2 here ! :) 1. [Send Table Data::](https:://www.clay.com/university/guide/send-table-data) You can send data into a new table using the “Send Table Data” option. This is great for sending lists of objects, individual values, or both. For example, if you have an enrichment with a list of multiple objects, you would select the “write to table list” option. You can also add other values to match that are in this table but not as a list. 2. [Lookup::](https:://www.loom.com/share/ad767e3be9914d19a2f6647efe4dfa85?sid=c8b78c32-9bc1-4501-8124-d6c70d2218cf) If you want to add more information that you already found from a previous table to the current data you have (e.g., matching domains), then “lookup” is the best option. This allows you to call matching data into one table. Let me know if that answers your questions. Happy prospecting! 💪✨
Collin S.
·
·
hey thanks for sending this over. it worked for some, but it still is not pulling everything in. Here is a quick video to show an example: https://sendspark.com/share/7xnjfcqabhky8w3h3g5ddq5bbfql348v
Bo (.
·
·
I recorded this walkthrough video showing exactly how to set this up: https://cln.sh/043kSnt9 Let me know if you have any follow-up questions!
Collin S.
·
·
Thank you so much!

Setting Up Automated Personalized Videos with Dynamic URLs | Clay