I got it working!
I created a new automation and started from scratch and it worked.
I want to automate submitting music to playlist curators on Spotify. I will be working with lots of artists so sending their songs individually to hundreds of playlisters would be insanely time-consuming.
The first automation I tried was on a weekly timer. I found the records in my Releases table that match the criteria then found the records in my Playlist table. Then I constructed the email. For some reason that wouldn’t work with all of the data elements in the email.
For the new automation, I chose the Send email automation and the trigger is “when a record matches certain criteria”. Then in the action, I find the records in the Spotify table that match the criteria I want (like genre) and then construct the email with all the data I need from both tables. Then I update the record in the first table so that it wouldn’t run again.
This time it worked!