Workflowsn8n and Google Apps Script

Content Marketing On Autopilot, With You In Control

Content marketing workflows that automate repetitive tasks. All built on n8n and Google Apps Script, ready to import, adapt and scale.

Runs onGoogle SheetsGoogle Apps Scriptn8nGmailGeminiGoogle AnalyticsGitHub Pages

From Trigger To Result, Without The Busywork

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.

Source Change Watch
A source behind the NVD guide changed
Awaiting AnalysistoDeferred
Pages to review
nvd-cve-api-docs / reading-recordsReview
nvd-cve-api-docs / indexReview

How The Workflows Run Your Week

The routine checks, follow-ups and reports happen on schedule. You review the drafts and make the calls.

Monday

Your Weekly Report Arrives First Thing

Traffic, sources, sign-ups and enquiries, compared with last week.

Weekly Performance Report
Delivered 8:00
Tuesday

Source Changes Flagged Before Readers Notice

The affected pages arrive in one alert, before a reader spots the error.

Source Change Alert
Pages to review
Wednesday

New Content Ready To Share

LinkedIn and Reddit drafts wait for your edit. Nothing posts on its own.

Distribution Drafts
Awaiting approval
Thursday

Every Enquiry Answered On Time

Matching samples go out at once, and you get the summary.

Documentation project
Auto-reply sent
Friday

Every Reader Gets The Right Follow‑Up

Each subscriber's follow-up matches the topic they clicked most.

Next-best email
5 readers, 5 paths

Every Workflow, Ready To Import

Open any workflow to see its diagram, with links to the n8n file and the Apps Script source.

2Platforms, one control sheet
10 minBetween scheduled checks
0Keys or personal details in the code

Automation With A Person In Charge

Every workflow that writes or sends something checks with a person or a rule first.

A person approves anything AI writes

Gemini drafts posts, broadcasts, metadata and report notes. Each draft waits in the Queue tab or an inbox until someone reviews it.

Test mode

While switched on, marketing emails go only to test subscribers.

Signed links

Every email link carries a signature, so a tampered link is rejected.

One suppression list

Every sending workflow checks it first, and an unsubscribe takes effect at once.

QA before every send

Emails with unfilled fields, missing unsubscribe links, spam-trigger wording or broken links are blocked and logged.

A daily send cap

Sending stops below the Gmail limit.

Facts kept apart from guesses

Reports label measured numbers and AI hypotheses separately.

No personal data in the code

Keys, IDs and addresses live in your own Google account, never in this repository.

One Control Sheet, Two Platforms

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.

Google Apps Script

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.

n8n

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.

Public pages

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.

Example: The Email Journey In Action

Example

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.

Inbox
  1. APArchana PandaConfirm Your Sign-Up For The Launch CourseOpt-in
  2. APArchana PandaProve The Demand Before You Plan The LaunchLesson 1
  3. APArchana PandaName The Buyer Before You Write A WordLesson 2
  4. APArchana PandaGive Buyers One Reason To Choose YouLesson 3
  5. APArchana PandaPlan The Launch And Build Every Asset From One BriefLesson 4
  6. APArchana PandaPrepare Sales For Day One And Measure What MovedLesson 5
  7. APArchana PandaShould The Launch Course Emails Keep Coming?Re-engagement

Example: Test Run Results

Example

The numbers come straight from the control sheet, which records every send, click and status change as it happens.

5Confirmed sign-ups
25Lessons sent
5Next-best emails
1Re-engagement email

Clicks By Topic, Per Test Reader

+research
+positioning
+launch
+sales
+silentNo clicks
ResearchPositioningLaunchSales
Test SubscriberStrongest InterestNext-Best Email
+researchResearchPut Your Research To Work
+positioningPositioningKeep Your Positioning Intact At Launch
+launchLaunchSet The Targets Before Launch Day
+salesSalesSee The Sales Deck Filled In
+silentNo clicksStart With The Module Closest To Your Launch
Control sheet, Subscribers tab
NameStatusCourse StepInterest
2Test Researchactive6research
3Test Positioningactive6positioning
4Test Launchactive6launch
5Test Salesactive6sales
6Test Silentactive6none

Example: Live Runs In n8n

Example

Every workflow here also runs in n8n Cloud, imported straight from this repository and connected to the same control sheet, inbox and AI model.

WorkflowWhat The Run DidRun Time
Source Change WatchChecked 6 official sources and recorded no changes13.5 seconds
Publishing QACrawled 43 pages across 5 guide sites and found no issues11.8 seconds
Enquiry Capture And Follow-UpGemini tagged a test enquiry as a documentation project, the sender got 3 matching samples and the owner got an alert9.2 seconds
Email Performance ReportRead the event log and emailed the click report4.5 seconds

All 19 workflows are imported in the same n8n account. These 4 ran in full.

Set It Up In An Afternoon

Google Apps Script

  1. Create a Google Sheet, then open Extensions and Apps Script.
  2. In Project Settings, tick Show "appsscript.json" manifest file in editor.
  3. Replace appsscript.json with apps-script/appsscript.json and Code.gs with apps-script/Loader.gs, then save.
  4. Deploy a web app: Deploy, New deployment, type Web app, execute as Me, access Anyone.
  5. Run cmaSetup from the editor and allow the permissions.
  6. In the Settings tab, add your web app URL and your Google Analytics property ID.
  7. Add your Gemini API key as the script property GEMINI_API_KEY.
  8. Point docs/assets/config.js at your web app URL and publish the docs folder with GitHub Pages.

n8n

  1. Import a workflow from the n8n folder.
  2. Add credentials for Google Sheets, Gmail, Google Analytics, Google OAuth2 with the Search Console scope, and an HTTP Header Auth credential for Gemini with the header x-goog-api-key.
  3. Replace the placeholders in the Config node and activate the workflow.

Spend The Week On Work Only You Can Do

Import the workflows, connect your accounts and let the routine run.

View On GitHub