Content marketing workflows that automate repetitive tasks. All built on n8n and Google Apps Script, ready to import, adapt and scale.
Most of a content marketer's week goes to work nobody planned for. Each workflow takes one of those tasks from trigger to result, and anything that needs judgement waits for a person to approve it.
The routine checks, follow-ups and reports happen on schedule. You review the drafts and make the calls.
Traffic, sources, sign-ups and enquiries, compared with last week.
The affected pages arrive in one alert, before a reader spots the error.
LinkedIn and Reddit drafts wait for your edit. Nothing posts on its own.
Matching samples go out at once, and you get the summary.
Each subscriber's follow-up matches the topic they clicked most.
Open any workflow to see its diagram, with links to the n8n file and the Apps Script source.
Every workflow that writes or sends something checks with a person or a rule first.
Gemini drafts posts, broadcasts, metadata and report notes. Each draft waits in the Queue tab or an inbox until someone reviews it.
While switched on, marketing emails go only to test subscribers.
Every email link carries a signature, so a tampered link is rejected.
Every sending workflow checks it first, and an unsubscribe takes effect at once.
Emails with unfilled fields, missing unsubscribe links, spam-trigger wording or broken links are blocked and logged.
Sending stops below the Gmail limit.
Reports label measured numbers and AI hypotheses separately.
Keys, IDs and addresses live in your own Google account, never in this repository.
A single Google Sheet acts as the control centre for both versions. Its tabs hold the settings, subscribers, email events, enquiries, monitored sources, the claims register, an approval queue and a run log, so every action leaves a record the team can audit.
The script project bound to the sheet contains one short loader, pasted once. On each run it loads the current workflow code from this repository, so fixes and new workflows reach the sheet without anyone copying code. Scheduled jobs run every 10 minutes, every morning at 7 and every Monday at 8, and a Run tab starts any workflow on demand with a single tick box.
Each workflow is a standalone file in the n8n folder. Import it by URL and attach Google and Gemini credentials. The Config node at the start holds every setting, ready for your own values.
The sign-up form, the enquiry form and the landing page behind every email link are hosted on GitHub Pages. Those pages pass requests to the workflows in the background, so a reader signed in to several Google accounts still lands on a working page.
Every email in this sequence came from a live run of the workflows, sent to test addresses that mirror how real subscribers move through the course.
The numbers come straight from the control sheet, which records every send, click and status change as it happens.
| Test Subscriber | Strongest Interest | Next-Best Email |
|---|---|---|
| +research | Research | Put Your Research To Work |
| +positioning | Positioning | Keep Your Positioning Intact At Launch |
| +launch | Launch | Set The Targets Before Launch Day |
| +sales | Sales | See The Sales Deck Filled In |
| +silent | No clicks | Start With The Module Closest To Your Launch |
| Name | Status | Course Step | Interest | |
|---|---|---|---|---|
| 2 | Test Research | active | 6 | research |
| 3 | Test Positioning | active | 6 | positioning |
| 4 | Test Launch | active | 6 | launch |
| 5 | Test Sales | active | 6 | sales |
| 6 | Test Silent | active | 6 | none |
Every workflow here also runs in n8n Cloud, imported straight from this repository and connected to the same control sheet, inbox and AI model.
| Workflow | What The Run Did | Run Time |
|---|---|---|
| Source Change Watch | Checked 6 official sources and recorded no changes | 13.5 seconds |
| Publishing QA | Crawled 43 pages across 5 guide sites and found no issues | 11.8 seconds |
| Enquiry Capture And Follow-Up | Gemini tagged a test enquiry as a documentation project, the sender got 3 matching samples and the owner got an alert | 9.2 seconds |
| Email Performance Report | Read the event log and emailed the click report | 4.5 seconds |
All 19 workflows are imported in the same n8n account. These 4 ran in full.
appsscript.json with apps-script/appsscript.json and Code.gs with apps-script/Loader.gs, then save.cmaSetup from the editor and allow the permissions.GEMINI_API_KEY.docs/assets/config.js at your web app URL and publish the docs folder with GitHub Pages.n8n folder.x-goog-api-key.Import the workflows, connect your accounts and let the routine run.
View On GitHub