Automated Content Generation Pipeline
A pipeline that watches a Google Sheet for new clients and produces their whole content pack, blogs, website copy, emails, ad copy and social posts, formatted and filed in Google Docs.
A new client in a spreadsheet, a full content pack in Google Docs
01Overview
Onboarding a client at a marketing agency starts with writing everything from scratch. Blog posts, website copy, email sequences, ad copy, social posts. It takes days per client and the formatting comes out different every time.
We built a pipeline that starts the moment a new client is added to a Google Sheet. n8n picks up the new row, reads the business details, and runs the content types one after another through Cassidy AI: blogs first, then website copy, then emails, then Meta and Google ad copy, then social media.
Each piece is passed to Zapier, which formats it for its type and files it in Google Docs. What lands at the end is an organised set of documents for that client, produced without anyone opening a blank page.
02Relevant keywords
Solving real problems with smart engineering
Days of writing for every new client
A full content pack had to be written by hand before a client could be launched.
The pipeline produces the whole pack from the details entered in the sheet.
Formatting that came out different every time
Each writer laid out blogs, emails and ad copy in their own way.
Zapier formats every piece by type before it is saved, so each client’s pack looks the same.
Delivery and filing done by hand
Finished copy had to be organised into documents and passed to the client.
Documents are created and filed in Google Docs as part of the run.
Copywriting billed by the hour
Every content type carried a separate hourly cost.
The routine first pass is generated, so paid time goes on editing rather than starting from nothing.
A failed step could go unnoticed
A long chain of steps can stop halfway without anyone seeing it.
The workflow reports on failures so a stalled run is visible rather than silent.
From a new row to a finished pack
The sheet is checked every minute, so a new client starts the run on its own.
New client detected
n8n watches the Google Sheet and picks up the new row.
Business details read
Name, services, USPs and SEO keywords are extracted and passed on.
Content generated in order
Blogs, then website copy, then emails, then ad copy, then social.
Formatted by type
Cassidy passes each piece to Zapier, which formats and groups it.
Filed in Google Docs
The organised pack is saved and ready for review.
What it does
What it produces per client
Blog posts Website copy Email copy Meta and Google ad copy Social media content
How it runs
Watches the Google Sheet for new client rows Passes business name, services, USPs and SEO keywords into each step Runs each content type in sequence through Cassidy AI Formats each piece by type in Zapier Files the finished pack in Google Docs Reports failures instead of stopping quietly
Inside Automated Content Generation Pipeline
Built with
Orchestration
n8n
Generation
Cassidy AI workflows
Formatting
Zapier
Input
Google Sheets
Output
Google Docs
What actually changed
Client onboarding stopped waiting on a writing queue. The first version of everything is ready before anyone sits down to edit it.
- A full content pack produced from one row in a spreadsheet
- Five content types generated in sequence without manual handoffs
- Consistent formatting across every client
- Finished documents filed in Google Docs automatically
Measured against writing the same pack by hand.
Against hourly copywriting rates for each content type.
Have a similar project in mind?
Let's talk about how AI can transform your service business.
- 30 minutes on Google Meet
- Usually reply in 2–4 hours
- Talk to a senior engineer
More case studies
Restaurant Reservation Voice Agent
A voice agent that answers a restaurant’s incoming calls, books, moves and cancels reservations, and writes every booking into Google Calendar and a customer database without anyone typing it in.
Pet Care Appointment Booking Agent
A voice agent for grooming, vet and boarding appointments that books by phone, picks the right staff member and slot, and creates the customer in Square CRM without anyone re-typing it.
Outbound Database Reactivation Agent
An outbound voice agent that called more than 500 dormant event leads, asked what each business was struggling with, and sent the interested ones to a product demo.
