Automated Weekly Newsletter Creation with AI and Airtable Integration
Curated weekly newsletter generator. A separate Lindy collects and analyzes relevant news stories and adds them to Airtable, then once per week, this Lindy puts it all together.
On Recurring Schedule: Triggers the entire newsletter creation process automatically at a set time each week.
List Records In View: Gathers all the pre-analyzed story data collected in Airtable for that week.
Story Selector: An AI acts as an editor, selecting the top stories from the weekly collection.
Newsletter Writer: Writes the first draft of the newsletter using only the selected top stories and fills in each appropriate section.
Fact & Plagiarism Checker: Reviews the draft against the original source content to ensure factual accuracy and originality.
Final Draft: Refines the newsletter text based on the checker's feedback, creating a polished final version.
Generate HTML: Converts the final text into an HTML email format for a visual preview.
Create Gist: Publishes the HTML to a GitHub Gist to create a shareable, live preview link.
Extract Raw URL: Isolates the clean preview link from the raw data generated in the previous step.
Create Document: Generates a Google Doc containing the final, copy-and-paste-ready newsletter text.
Create Record: Archives the entire project by saving the Google Doc link, preview link, and source material into a new Airtable record.
End Result: Takes 100+ news stories each week, finds the most impactful/relevant stories for the target market, generates a highly engaging industry newsletter and design preview.