Integrating Job and Employee Data for Personalized Emails

How to get the two tables work together? I have this workbook I am first finding jobs and on the second table I am finding the people in those companies now how to add those people in the column of jobs table and If i find more than 1 per company how to send personalized emails with gpt for each person

2 comments

Moon
·
·
I connect the Jobs and People tables using the company website as the key. In the Jobs table, I do a lookup to pull in all people working at that company. If there’s more than one, I either list them all in one row or create separate rows for each person + job combo (helps with personalization). For emails, I use GPT to generate custom messages using both the job info and the person’s details like name, title, and company. Super helpful for sending messages that actually feel 1:1.
Zahir H.
·
·
How do you create separate rows after you pull the data ?