Hello, Any suggestions how could the following be done!
I would like to use information from two tables
First table (Orders) contains Customer_Email and Product_ID (Filled automatically using Zapier Integration)
Second Table (Products) contains Product_ID and Product_URL
When a new order is made, an email message should be sent to the customer’s email contains the related Product_URL
Note: Zapier does not read Capsio Views also does not update a table