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!
