Social Media Calendar Template

Generate a month of social media posts in Google Sheets with =GPT_TABLE() and =GPT(): platform-specific copy, hashtags and hooks. Free AI template.

Plan and write a month of posts in one sheet: the calendar structure comes from =GPT_TABLE(), the copy per platform from =GPT().

Step 1 — scaffold the calendar

Headers in A1:E1: Date, Platform, Topic, Hook, CTA. Then:

=GPT_TABLE("30-day content calendar for [your niche], mix of LinkedIn, X and Instagram, 3 posts/week per platform", A1:E1)

Step 2 — write the posts

In F2:

=GPT("Write the full "&B2&" post. Hook: "&D2&". Topic: "&C2&". Platform conventions apply: length, tone, hashtags. Return only the post.")

Step 3 — variations

Repurpose winners: =GPT("Rewrite this LinkedIn post as an X thread, 5 tweets", F2).

Get started

1. Install GPT for Sheets from the Google Workspace Marketplace (free tier included, no API keys needed).
2. Copy the template or paste the formulas into your own sheet.
3. Drag the formula down your rows, then use Replace all GPT formulas with results in the sidebar.

Related prompt guides: captions & hashtags generator, LinkedIn engagement.

FAQ

Can it match my brand voice?

Paste 2-3 of your best posts into the prompt as style examples — or keep a ‘voice guide’ cell and reference it in every formula.

Which platforms does it cover?

Any — LinkedIn, X, Instagram, Facebook, TikTok scripts. The platform name in the prompt switches conventions automatically.

Can I generate images too?

Yes: =GPT_CREATE_IMAGE() (DALL·E) and =GEMINI_CREATE_IMAGE() return image URLs you can render with =IMAGE().