Hey there, wondering if someone can help me. I work for a membership site and want to send new members a welcome email, but extracting information from two sources on Airtable. One source is the new members details and the other is a table with that week’s latest Mailchimp campaign link(we want new members to receive that week’s newsletter)
When a member joins, their information goes on Table 1.
When a newsletter gets sent out, a Table 2 is populated with the Campaign Link from Mailchimp. The view I want to use filters the links so that only the latest week’s link is sent out.
I want to use Zapier to say “Hello [Member Name from table 1], Thank you for joining blah blah blah. This weeks newsletter can be found here [Link from table 2]” automatically.
At the moment I was thinking of using Airtable - New Record in view > Airtable - Find Record > Then the Zapier email app. Wondered if there was an easier way of doing this? I can’t seem to work out a search formula that works.
Thank you in advance
