I have a Bardeen playbook that look like this:
- Scrape data from active tab (Basically scrapping pages that appeared on Google News, there are 10 pages in Google News)
- Get page as HTML (converting the pages to HTML)
- Convert HTML to text (converting the HTML content to text)
- Get custom prompt to OpenAI (summarize the text using AI)
- Add rows to Google Sheet (add the summarized content to Google Sheet)
- Send to email (Send the Google Sheet table to my Gmail)
But there is a problem. Notice that there are 10 pages in Google News, meaning that at the end I would receive 10 different emails each for a page from Google News.
I just want to be able to receive one email, containing all the summaries from the 10 pages from Google Sheet. How to make that happen?
Loop? Condition? These two are so unintuitive.