Library / Content Writing & Generation
Content Writing & Generation
Turn a Trends Spreadsheet into SEO Newsletters with Approval
When a webhook fires, it picks a trend topic from Sheets, has OpenAI write an SEO newsletter with fal.ai assets, waits for approval and stores it in SharePoint.
What it does
### Newsletter Template Branch What it does • Downloads your HTML template from SharePoint. • Extract from Text File → Build Newsletter replaces placeholders with AI-generated content. Credentials needed Microsoft SharePoint OAuth2 (for Get Newsletter Template). User must provide • Your own HTML template with these exact placeholders: {{INTRODUCTION_DE}} {{TOPIC_DE}} {{DESCRIPTION_DE}} {{TEASER1_DE}} {{TEASER2_DE}} {{TEASER3_DE}} {{CTA_DE}} {{FOOTER_TEXT_DE}} {{FOOTER_NAME_DE}} {{TOPIC_TITLE_EN}} {{INTRODUCTION_EN}} {{TOPIC_EN}} {{DESCRIPTION_EN}} {{TEASER1_EN}} {{TEASER2_EN}} {{TEASER3_EN}} {{CTA_EN}} {{FOOTER_TEXT_EN}} {{FOOTER_NAME_EN}} • Upload this template to the SharePoint folder referenced in Get Newsletter Template.
The steps
- Read Trends Data
- Select Topic from Trends
- Build Newsletter
- Check Approval Status
- OpenAI Chat Model
- Get Trends XLSX
- Get Newsletter Template
- Switch
- Get Video
- Create FAL Video
- Create Audio
- Wait for Audio
- Get Audio
- Create Merge Request
42 steps in total.
Similar automations
Email AutomationGenerate an AI Newsletter with Video for HubSpot43 stepsContent Writing & GenerationAnalyze Reddit Social Trends into Excel with OpenAI11 stepsMCP Servers & ToolsManage SharePoint Files and Lists as an MCP Server12 stepsForms & SurveysGenerate vertical AI videos with OpenAI, Grok Imagine, fal.ai and Google Drive13 steps