Use views result to send data to a rule
This module will help you views_rules

From module page:


  View loop
  
  A view loop is similar to a regular Rules loop, but allows looping
  over rows of view results.
  
  Collect view result rows (action):
  
  This action collects each variable in all view result rows into list
  variables for use in Rules.