Plan a multi-platform social calendar in Gemini

Gemini helped turn a few article ideas into a multi-week posting plan for Substack, LinkedIn, and X, with the final review left to a human.

Done with Geminiยท Beginner

What they did
The author described the problem to Gemini Advanced and asked it to draft the agent instructions. They then asked for a calendar in markdown format with the days laid out as columns, and Gemini pushed that into Google Sheets. After a third prompt about extending the plan across several weeks, they saved the setup as a Gem and continued to inspect and polish the output themselves.
How it went
They say the whole setup was finished in less than 20 minutes. From 3 blog ideas, the agent produced 36+ social posts for Substack, LinkedIn, and X, and the author says their daily social workload went from 3 hours down to 30 minutes. Posting itself was not shown, and extra agents for copywriting, SEO, and publishing were only mentioned as future plans.
Tips
The first response may come back as ordinary prose, so be ready to ask again for a table format, such as pipe-separated columns. Even after export to Sheets, manual cleanup and approval were still needed.

Try it yourself with Gemini

You are my social media planning assistant for [brand or creator name]. I publish about [topics] for [audience]. Turn [number] source ideas, posts, or articles into a [number]-week content calendar for [platforms]. For each entry, include the posting day, platform, content angle, a short draft, and any notes needed for me to revise it. Use this voice: [paste a sample or describe the tone]. Format the result as a table I can copy into a spreadsheet, and if my request is incomplete, ask questions before drafting. Do not schedule, send, or publish anything; pause and wait for my approval before any irreversible action.

Fill in the [brackets]. Agents can make mistakes, so review anything before it is sent, paid or deleted.

Get 3 agent uses like this every morning

With the day's top AI news. Free, and one click to unsubscribe.