Guest posts written to your rules, straight from a sheet
The scenario pulls the topic, your writing rules, and the target site's requirements from a sheet, writes the article, and files the finished text on a separate tab, marking the brief as done.
The post follows your rules and the site's requirements, not whatever the model felt like
You control everything with one status column in the sheet
Finished texts collect on their own tab, ready to send
Completed briefs are marked done, so no topic is written twice
To move data from Mailjet to Google Sheets automatically, use a ready-made scenario — no manual exports.
Starts when: Start Manual Trigger
Then: Read Config Sheet
Check: Check if Status is Start
If yes: Read Guest Post Input
Check: Merge All Inputs
Then: Generate post with AI (German)
Then: Save Generated Content to Outreach
Then: Mark Config Row as Finished
If yes: Read Writting Rules
If yes: Read Portfolio Requirements
If no: Notify When No Action is Taken
Then: OpenAI Chat Model
You can launch this Mailjet + Google Sheets integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.