We run three websites of our own — jrvsystems.app, jrvservices.co and the GFTS site. Each had a blog job writing posts from a fixed topic list, with no link to what people actually searched for. So we built one tool that starts from Search Console instead, and replaced those jobs with it.
Each site had its own scheduled job writing posts from a topic list we picked in advance. The posts were fine to read, but they weren't aimed at a search anyone was making, so they rarely moved a ranking. At the same time, Search Console for each site was already listing searches where we sat on page 2 or low on page 1 — the cheapest traffic there is to win — and nobody had time to work through them by hand.
A daily job pulls each site's Search Console rows. The tool keeps searches with an average position between 3 and 40, at least 10 impressions and no brand name in them, groups searches that mean the same thing, and ranks them by the extra clicks a better position could bring. That list is the Ideas page. When a site is too new to have Search Console data, it falls back to Google autocomplete suggestions for a few seed topics.
Every morning the tool picks the best idea for each site and writes a draft in that site's main language, using the site's Brand DNA — audience, tone, words to avoid — and its existing pages for internal links. It then translates the draft to the other language, English to Bahasa Melayu or the other way. It finds a real photo for the topic on Pexels or Unsplash and builds a cover with the site's logo, colour and the article headline. Anyone can also write an article on demand from any idea.
Publishing writes the article straight into the blog tables behind jrvsystems.app — a paired English and Malay post, followed by a redeploy — and jrvservices.co, with Malay in the main columns and English alongside. Once the article has a public link, the tool posts it to the site's Facebook page and Instagram account with a caption written in the site's voice, and always includes the link back. LinkedIn is built but not connected yet.
The start page asks which site you're working on. From then on every page — home, ideas, articles, social, calendar, Brand DNA, backlinks — shows only that site, in its own logo, colours and fonts. Brand DNA holds what the writing needs: audience, tone tags, words to avoid, topics, emoji level, a caption template, text to always add and a cover style. Sign-in is a 6-digit code over WhatsApp or email, or a passkey.