Daily AI Content: Scripts, Captions, Overlays

# Daily AI news to video content: scripts, captions, overlays saved to Google Sheets

This automation workflow enables AI experts to consistently produce high-quality short-form video content without manual research or script writing. The system runs daily on schedule, fetches the latest AI news, and transforms it into structured content packages ready for publishing.

## Who it´s for
- AI startup founders aiming to publish expert-level content regularly.
- Agency marketers automating content production for clients in tech.
- Tech bloggers and content creators focusing on innovation and automation.
- Entrepreneurs building personal authority in the AI space to attract leads.

## What the automation does
- Triggers daily via cron schedule.
- Fetches recent AI-related news from three categories using Perplexity API.
- Processes aggregated data with OpenAI to generate video scripts, captions, and overlay texts.
- Parses and saves generated content into Google Sheets.
- Sends a completion notification via Gmail.

## What´s included
- Ready-to-use n8n workflow.
- Pre-configured trigger and handler logic.
- Integrations with Perplexity API, OpenAI, Google Sheets, and Gmail.
- Basic text guide for setup and adaptation.

## Requirements for setup
- n8n account (cloud or self-hosted).
- API keys for Perplexity and OpenAI.
- Google account with access to Google Sheets and Gmail.
- Credentials to connect services within n8n.

## Benefits and outcomes
- Saves 5–7 hours per week on content ideation and drafting.
- Enables consistent publishing without creative blocks.
- Accelerates positioning as an AI thought leader.
- Scales content output across multiple channels or clients.
- Reduces reliance on external writers or agencies.

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat