Hi
I am very much new to AirTable so this may be a beginner’s question but I would appreciate the help very much. I try to describe the situation in detail below.
Context: I am setting up a more efficient lead generation & reach-out tool for sales purposes, automating some manual tasks such as data scraping & email generation. We have 3 email templates that we use, depending on the product that we want to advertise, plus we send to two types of contacts - English or German speaking (i.e. up to 6 different email templates)
Goal: I want to set up the process, so that once I have a Contacts table filled, I manually define for each contact which kind of email they should receive and in which language. Then those emails, based on the templates, with personalized tokens (i.e. Hello {Name}, ….) are stored in a new table “Personalized mail”. (then I will use that data to input to Make.com and send these email drafts to my Outlook draft folder).
—
Here how my tables set up look ideally:
Table “Contacts”
Name
Surname
Email
Company
Language (preferred communication language, selected manually after record is added)
Prompt name (the type of email prompt to be sent, selected manually after record is added)
Sender (selected manually after record is added)
Table “Email prompts” (predefined templates, more or less static table)
Prompt name
Language
Subject (e.g. “Special offer for you, {Name}!”)
Body
Table “Personalized emails” (output table I want to achieve)
Email (reference from Contacts table, for which person is this email generated)
Subject (so here where i need the “magic to happen”…. e.g. “Special offer for you, John!”)
Body