Black Friday: 20% off with BLACKFRIDAY2026 See plans

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.

  1. When

    Google Sheets

    New row

  2. Templated

    Render JPG

    1080 × 1080 or 1080 × 1350 post

  3. 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. 1

    Add a row to the sheet

    Headline, photo URL and caption, plus any extra field your template uses.

  2. 2

    Templated renders the image

    The row fills the template layers and Templated returns a JPG URL.

  3. 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 layerComes fromExample
headlineHeadline column5 ways to reuse a blog post
photoPhoto URL columnhttps://images.unsplash.com/...
subtitleSubtitle columnSwipe-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

  1. Add Google Sheets › Watch New Rows on your calendar sheet.
  2. Add Templated › Create a Render, pick the template and map the columns. Format: JPG.
  3. Add Instagram for Business › Create a Photo Post with the render URL and the caption column.
  4. Optionally add Google Sheets › Update a Row to mark the row as posted.
More about Make

Zapier

No-code Zap

  1. Trigger on Google Sheets › New Spreadsheet Row.
  2. Add Templated › Create Render and map the columns to the layers.
  3. Add Instagram for Business › Publish Photo(s) with the render URL and caption.
More about Zapier

n8n

Cloud or self-hosted

  1. Start with a Google Sheets Trigger on Row Added.
  2. Add the Templated node (Create a Render, format JPG).
  3. Publish with the Facebook Graph API node: /{ig-user-id}/media with image_url and caption, then /media_publish.
Download the n8n workflow

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.

More about n8n

REST API

From your own code

  1. Read the row in your code and call POST /v1/render with the layers below, then publish the URL.
cURL
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"
    }
  }
}'
API documentation

AI agent (MCP)

Claude, ChatGPT, Cursor

  1. Connect the Templated MCP server to Claude, ChatGPT or Cursor.
  2. 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)

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.