Auto Publish Graphics to Instagram

For a creator running a branded social presence off a Google Drive asset folder and a Sheets based content calendar. It reads the calendar, builds a branded graphic per post, saves it back to Drive, and publishes to Facebook and Instagram on the scheduled dates.

Google DriveGSGoogle SheetsFAFacebookINInstagram

The grind

Social content is a treadmill

Here's what doing this by hand looks like today, and why it doesn't scale.

A consistent look across five posts a week means five rounds of cropping, exporting, and posting.
The content calendar lives in a sheet that nothing reads on its own.
Half the scheduled posts never ship because the visuals were not ready in time.

MewCP collapses all of this into one prompt. Here's what that looks like.

The flow

8 steps · 4 servers

Your agent runs it end-to-end

Read the content calendar for the date range.

For each pending row, find the base asset in Drive.

Compose a 1080 by 1080 branded graphic with the caption text overlaid, your brand fonts and palette applied, and the logo placed.

Upload the finished graphic back to Drive.

Publish it to Facebook with the caption and image.

The payoff

A week of posts that publish themselves

One prompt reads the calendar, renders the branded graphics, and publishes them on schedule. The content treadmill starts running itself.

Paste this into Claude, Codex, or any MCP-connected agent. It'll connect your apps and run the task from start to finish.

Run it yourself

Copy the prompt

prompt

Goal: Auto Publish Graphics to Instagram

MCP servers needed (connected through MewCP): Google Drive, Google Sheets, Facebook, Instagram

Steps:
1. Read the content calendar for the date range.
2. For each pending row, find the base asset in Drive.
3. Compose a 1080 by 1080 branded graphic with the caption text overlaid, your brand fonts and palette applied, and the logo placed.
4. Upload the finished graphic back to Drive.
5. Publish it to Facebook with the caption and image.
6. Publish it to Instagram with the caption and image.
7. Mark the sheet row as posted with the live URL.
8. Return a summary of what was rendered, published, and failed.

Check with me before sending any message or changing data in a connected app.

More recipes