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
Google Sheets

How it works

To move data from Mailjet to Google Sheets automatically, use a ready-made scenario — no manual exports.

  1. Starts when: Start Manual Trigger
  2. Then: Read Config Sheet
  3. Check: Check if Status is Start
  4. If yes: Read Guest Post Input
  5. Check: Merge All Inputs
  6. Then: Generate post with AI (German)
  7. Then: Save Generated Content to Outreach
  8. Then: Mark Config Row as Finished
  9. If yes: Read Writting Rules
  10. If yes: Read Portfolio Requirements
  11. If no: Notify When No Action is Taken
  12. 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.