tr Skip to content
Try for Free
My Account Try for Free
Marketing Automation · Marketing

AI agent that drafts the weekly newsletter from the week's content

Weekly, an AI agent reads the content log, drafts a newsletter with intros and links, and saves it to a Google Doc for review.

ScheduleSchedule Google SheetsGoogle Sheets AI AgentAI Agent Google DriveGoogle Drive SlackSlack
~12 min setup used by 2.8k sites
Download & Use This Workflow Browse more workflows

Free · import into FlowMattic in one click

How it works

Every step, explained

Import the template and this whole chain runs on autopilot — here's exactly what happens on each run.

Schedule → Google Sheets → AI Agent
6 steps
Schedule
TRIGGER
Schedule · Every Week
This workflow runs on a schedule (Every Week) — it starts on its own at the interval and time you set in the Schedule trigger. No incoming event is needed.
Google Sheets
ACTION
Google Sheets · Get Rows
Google Sheets — retrieve rows in JSON format for use with Iterator. Data is mapped from earlier steps; connect your Google Sheets account on import.
AI Agent
ACTION
AI Agent · Execute Agent
An AI agent reads the incoming data and decides what to do on its own, choosing from its tools (Google Drive, Slack) to complete the task. Connect an AI provider on import.
Google Drive
TOOL
Google Drive · Create File From Text
A tool the AI agent can call — Google Drive — create a new file from plain text. The agent uses it only when the task needs it; connect your Google Drive account on import.
Slack
TOOL
Slack · Send Channel Message
A tool the AI agent can call — Slack — post or Schedule a new message to a specific #channel. The agent uses it only when the task needs it; connect your Slack account on import.
Slack
ACTION
Slack · Send Channel Message
Slack — post or Schedule a new message to a specific #channel. Data is mapped from earlier steps; connect your Slack account on import.
Why this workflow

Built to own, not to rent

No-code setup

Import the JSON, connect your accounts, and go live in minutes. Every step is pre-mapped — you only add your own credentials.

Runs on your server

Self-hosted on your WordPress install. No per-task fees, no data leaving your infrastructure, no monthly SaaS bill.

Fully customizable

Open it in the visual builder and reshape it — add branches, swap apps, insert filters. A starting point, not a cage.

Keep exploring

Related workflows

Other ready-to-import automations from the FlowMattic library.

WordPress
Image Builder
Slack
Generate a social card for every new WordPress post
Free template
Mailchimp
Branch
Email
Give VIP subscribers early access, everyone else the standard offer
Free template
Fluent Forms
FluentCRM
Router
Tag and route signups by marketing campaign
Free template

Ready to automate your WordPress site?

Download this workflow free, or grab FlowMattic and own every automation on your site — no per-task fees, ever.

Download Workflow See pricing