Branded Social Graphics from Drive + Sheet Calendar
For a creator running a branded social presence off a Google Drive asset folder and a Sheets-based content calendar. Reads the calendar, composes branded graphics per post, uploads back to Drive, publishes to Facebook and Instagram on scheduled dates.
Social content is a treadmill
Here's what doing this by hand looks like today — and why it doesn't scale.
A consistent brand across 5 posts a week means 5 rounds of cropping, exporting, posting
The content calendar lives in a sheet that nobody reads automatically
Half the scheduled posts never ship because the visuals aren't ready
Composio collapses all of this into one prompt — here's what that looks like.
Your agent runs it end-to-end.
- 01Read the content calendar for the date range
- 02For each pending row, resolve the base asset from Drive
- 03Compose a 1080×1080 branded graphicOverlay caption text, apply brand fonts and palette, place logo.
- 04Upload the rendered graphic back to Drive
- 05Publish to Facebook with caption + image
- 06Publish to Instagram with caption + image
- 07Update the sheet row status to posted with the live URL
- 08Return a summary: rendered, published, failed
A week of posts, auto-published
One prompt reads the calendar, renders branded graphics, and publishes on schedule — the content treadmill runs itself.
Paste this into Claude, Cursor, or Codex. It'll install the CLI, connect your apps, and run the task — end to end.
Triage Your Inbox
Clear 200 unread in one pass — label, archive the noise, draft replies for what actually matters.
Read →Graduate Job Hunt with Recruiter Outreach
Find entry-level roles, identify the recruiters, and draft personalized outreach — all in one run.
Read →Personal Finance Tracker in Sheets
Build a full personal-finance sheet from zero — income, expenses, goals, formulas, conditional formatting.
Read →