# Automate Instagram posts from a Google Sheet

> Write your posts in a Google Sheet and publish them to Instagram as branded images: headline, photo and caption from each row. Set up with Make, Zapier or n8n.

- **URL**: https://templated.io/workflows/google-sheets-to-instagram-posts/

---

Plan posts in a spreadsheet. Each new row becomes a branded image on your template and goes to Instagram with its caption.

[Start free](https://app.templated.io/signup) · [Get the n8n workflow](https://templated.io/workflows/google-sheets-to-instagram-posts/#n8n-template)

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. ### 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](https://templated.io/docs/renders/create/).

## 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.

- ![Social Media Modern Instagram preview](https://templated-assets.s3.amazonaws.com/public/thumbnail/cc115cac-0ac6-4238-b087-da5a975b8c40.webp)

  ### [Social Media Modern Instagram](https://templated.io/templates/social-media/social-media-modern-instagram/)

- ![Yellow and Pink Social Media preview](https://templated-assets.s3.amazonaws.com/public/thumbnail/cf9cc886-c791-44d1-8a9c-3eb078998c21.webp)

  ### [Yellow and Pink Social Media](https://templated.io/templates/social-media/yellow-and-pink-social-media/)

- ![Social Media Course Marketing preview](https://templated-assets.s3.amazonaws.com/public/thumbnail/3b9b0c27-3220-4e8e-b85f-d9e6577cf03f.webp)

  ### [Social Media Course Marketing](https://templated.io/templates/social-media/social-media-course-marketing/)

[Browse all templates](https://templated.io/templates/) · [Generate one with AI](https://templated.io/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](https://templated.io/workflows/daily-quote-graphics/).
- 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](https://templated.io/integrations/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](https://templated.io/integrations/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](https://templated.io/workflows/n8n/google-sheets-to-instagram-posts.json)

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](https://templated.io/integrations/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](https://templated.io/docs/)

### AI agent (MCP)

Claude, ChatGPT, Cursor

1. Connect the [Templated MCP server](https://templated.io/docs/integrations/mcp/setup/) 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)](https://templated.io/integrations/mcp/)

## Step-by-step guides

- [How To Automate Instagram Posts using Google Sheets & Make](https://templated.io/blog/automate-instagram-post-using-google-sheets-and-make/)
- [How to Automate Image Generation Using Google Sheets, Make.com & Templated](https://templated.io/blog/how-to-generate-images-from-google-sheets-with-make/)
- [How to Generate Images from Google Sheets with Zapier](https://templated.io/blog/how-to-generate-images-from-google-sheets-with-zapier/)

## Related workflows

- ### [Turn spreadsheet rows into Instagram carousels](https://templated.io/workflows/instagram-carousels-from-google-sheets/)

  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.

  Make, n8n, REST API

- ### [Post a quote graphic every day from a list](https://templated.io/workflows/daily-quote-graphics/)

  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.

  Zapier, Make, n8n

- ### [Turn your Notion content calendar into ready-to-post graphics](https://templated.io/workflows/notion-content-calendar-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)

[See all workflows](https://templated.io/workflows/)

## 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.

[Start free](https://app.templated.io/signup)
