Automate Instagram posts from a Google Sheet
Plan posts in a spreadsheet. Each new row becomes a branded image on your template and goes to Instagram with its caption.
50 free credits. No credit card required.
When
Google Sheets
New row

Templated
Render JPG
1080 × 1080 or 1080 × 1350 post
Then
Instagram
Publish photo post
At a glance
Most content calendars already live in a spreadsheet: a headline, a caption, a photo, a date. The slow part is turning each row into an image, one design file at a time.
Connect the sheet to Templated and that step disappears. A new row fills your template, and the finished image is published to Instagram with the caption from the same row. The design stays consistent because everyone writes in the sheet, not in the design tool.
- Trigger
- Google Sheets: New row
- Output
- JPG, 1080 × 1080 or 1080 × 1350 post
- Delivered to
- Instagram: Publish photo post
- Run it with
- Make, Zapier, n8n, REST API, AI agent (MCP)
- Cost
- 1 credit per image (each page of a multi-page template counts as one)
- Free plan
- 50 credits, no credit card required
How it works
Three steps, from the event to the finished file.
- 1
Add a row to the sheet
Headline, photo URL and caption, plus any extra field your template uses.
- 2
Templated renders the image
The row fills the template layers and Templated returns a JPG URL.
- 3
Instagram publishes it
Instagram for Business posts the image with the caption from the row.
Map your data to the template
Each dynamic layer in your template gets its value from one field. Name your layers like this, or map whatever names you use.
| Template layer | Comes from | Example |
|---|---|---|
| headline | Headline column | 5 ways to reuse a blog post |
| photo | Photo URL column | https://images.unsplash.com/... |
| subtitle | Subtitle column | Swipe-worthy tips for busy teams |
Text layers take text, image layers take image_url. You can also change colors, hide layers or swap fonts per render. See every layer property .
Templates for this workflow
Start from one of these and make it yours in the editor, import a Canva design, or describe one to the AI template generator.
When to use it
- Your team plans posts in Google Sheets and someone exports images by hand.
- You post several times a week and want every image on brand.
- An agency runs the same format for several clients, each with its own template and sheet.
Tips
- Render as JPG: Instagram's publishing API accepts JPEG only.
- Want to post on a date instead of right away? Add a "Publish on" column and use a daily schedule that picks the rows for today, like the daily quote workflow.
- Add a "Status" column and write "Posted" back after publishing, so nothing goes out twice.
- Instagram needs a Business or Creator account linked to a Facebook Page for API publishing.
How to run it
Pick the tool you already use. The first one is the quickest way to set this up.
Make
No-code scenario
- Add Google Sheets › Watch New Rows on your calendar sheet.
- Add Templated › Create a Render, pick the template and map the columns. Format: JPG.
- Add Instagram for Business › Create a Photo Post with the render URL and the caption column.
- Optionally add Google Sheets › Update a Row to mark the row as posted.
Zapier
No-code Zap
- Trigger on Google Sheets › New Spreadsheet Row.
- Add Templated › Create Render and map the columns to the layers.
- Add Instagram for Business › Publish Photo(s) with the render URL and caption.
n8n
Cloud or self-hosted
- Start with a Google Sheets Trigger on Row Added.
- Add the Templated node (Create a Render, format JPG).
- Publish with the Facebook Graph API node:
/{ig-user-id}/mediawithimage_urlandcaption, then/media_publish.
In a new n8n workflow, click ⋯ at the top right and choose Import from File. Install the Templated node first (search "Templated" in the nodes panel). The note on the canvas lists the credentials and YOUR_ values to fill in.
REST API
From your own code
- Read the row in your code and call
POST /v1/renderwith the layers below, then publish the URL.
curl -X POST https://api.templated.io/v1/render \
-H "Authorization: Bearer $TEMPLATED_API_KEY" \
-H "Content-Type: application/json" \
-d '{
"template": "YOUR_TEMPLATE_ID",
"format": "jpg",
"layers": {
"headline": {
"text": "5 ways to reuse a blog post"
},
"photo": {
"image_url": "https://images.unsplash.com/photo-1499750310107-5fef28a66643"
},
"subtitle": {
"text": "Swipe-worthy tips for busy teams"
}
}
}'AI agent (MCP)
Claude, ChatGPT, Cursor
- Connect the Templated MCP server to Claude, ChatGPT or Cursor.
- Paste the rows and use the prompt below. The agent renders each post and returns the links for you to schedule.
“Use Templated to render one Instagram post per row below with my "Weekly tip" template: headline in headline, photo URL in photo. Render JPG and give me the links.”More about AI agent (MCP)
Step-by-step guides
Related workflows
Turn spreadsheet rows into Instagram carousels
One row, one carousel: the cover and every slide come from the same row and a multi-page template, published as a single Instagram carousel.
Run with: Make, n8n, REST API
Post a quote graphic every day from a list
Fill a sheet with quotes or tips once. Every morning the next one becomes a branded graphic and goes out, and the sheet records what was posted.
Run with: Zapier, Make, n8n
Turn your Notion content calendar into ready-to-post graphics
Write the post in Notion, set the status, and the finished graphic shows up in the same database item a few seconds later.
Run with: n8n, Make, Zapier, AI agent (MCP) n8n template
Set up your first workflow today
Create a template, connect your tool and render your first image in minutes.
50 free credits. No credit card required.