My app is setup with 1 sheet for Users and 1 for promotions. I want to send an email to all Users every time a new promotion is added (which is a new row).
Since Users and Promotions are in separate sheets, how can I get the Users information if we use zapier/integromat as these system will looking at the promotions sheet? Anyway to implement this using Glideapp directly?
Any alternative suggestions are much appreciated.