I am working on a task for Personalized News Digest (RSS & Perplexity to Email). In the scenario, it will fetch the news of NGOs from RSS and Perplexity and then store in a google sheet. Then, the scenario will search the email_address Google sheet file to look for users’ email address and their preferences.
However, my scenario cannot map the Category in Stored_data Google sheet and the Users’ Preference in email_address Google sheet.
And its Output is show as below (which Operation 2, 3 & 4 are the same Output):
I don’t know whether my setup for “Search Row: Google sheet” (file: Store_data) and the filter after this module correct or not:
Could you tell me what should I do/ correct in order to send News Digest with Users’ preferences to them?