# Generate YouTube thumbnails for a whole series from a spreadsheet

> Make matching YouTube thumbnails for every episode from one spreadsheet: title, episode number and guest photo on your template, as 1280 × 720 JPGs.

- **URL**: https://templated.io/workflows/youtube-thumbnails-from-spreadsheet/

---

A series looks like a series when every thumbnail matches. List the episodes once and render all the thumbnails at 1280 × 720.

[Start free](https://app.templated.io/signup) · [See the setup](https://templated.io/workflows/youtube-thumbnails-from-spreadsheet/#how-to-run)

50 free credits. No credit card required.

1. When

   CSV or Excel file

   Episode list

2. Templated

   Render JPG

   1280 × 720 thumbnail

3. Then

   ZIP download

   Download or save to Drive

## At a glance

Podcasts, courses and interview series need a thumbnail per video, and they should look like one family: same layout, same colors, a different title and face each time.

Keep the episode list in a spreadsheet and render the thumbnails in one batch, or connect the sheet so each new episode gets its thumbnail as soon as you add the row.

- Trigger

  CSV or Excel file: Episode list

- Output

  JPG, 1280 × 720 thumbnail

- Delivered to

  ZIP download: Download or save to Drive

- Run it with

  Spreadsheet generation, Make, Zapier, REST API

- 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. ### List the episodes

   Title, episode number and guest photo URL, one row per video.

2. ### Render with your thumbnail template

   Each row fills the same 1280 × 720 template.

3. ### Download or save

   Get a ZIP of every thumbnail, or have each one saved to Google Drive as it is made.

## 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 |
| - | - | - |
| title | Title column | How we hit $1M ARR |
| episode | Episode column | EP 42 |
| guest-photo | Guest photo URL column | https\://.../guest.jpg |

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.

- ![Thumbnail YT Blue Technology preview](https://templated-assets.s3.amazonaws.com/public/thumbnail/fd455011-bc26-4b80-a492-242e546095f4.webp)

  ### [Thumbnail YT Blue Technology](https://templated.io/templates/youtube-thumbnail/thumbnail-yt-blue-technology/)

- ![Thumbnail YT Episode Orange preview](https://templated-assets.s3.amazonaws.com/public/thumbnail/30b2726e-aa43-42ca-8afe-adec614ffe5e.webp)

  ### [Thumbnail YT Episode Orange](https://templated.io/templates/youtube-thumbnail/thumbnail-yt-episode-orange/)

- ![Thumbnail YT Dark Red preview](https://templated-assets.s3.amazonaws.com/public/thumbnail/58037586-60b9-449d-9c4b-f56805e27051.webp)

  ### [Thumbnail YT Dark Red](https://templated.io/templates/youtube-thumbnail/thumbnail-yt-dark-red/)

[Browse all templates](https://templated.io/templates/) · [Generate one with AI](https://templated.io/ai-template-generator/)

## When to use it

- Podcast and interview channels with a guest per episode.
- Courses and tutorial series with numbered lessons.
- Repurposing a back catalog with a new thumbnail style.

## Tips

- Render as **JPG**: YouTube thumbnails must be under 2 MB, and JPG keeps them small.
- For the cut-out look, use guest photos with a transparent background (PNG) and put a colored shape behind the image layer.
- Short titles read better on phones. Keep them under 6 words.

## How to run it

Pick the tool you already use. The first one is the quickest way to set this up.

### Spreadsheet generation

In the dashboard, no code

1. Open **Spreadsheet generation** and pick your thumbnail template.
2. Upload the episode list (CSV or Excel) and map the columns.
3. Preview, render and download the ZIP.

[More about Spreadsheet generation](https://templated.io/integrations/spreadsheet/)

### Make

No-code scenario

1. Add **Google Sheets › Watch New Rows**.
2. Add **Templated › Create a Render** (JPG).
3. Download the file with **HTTP › Get a file** and save it with **Google Drive › Upload a File**.

[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**, then **Google Drive › Upload File** with the render URL.

[More about Zapier](https://templated.io/integrations/zapier/)

### REST API

From your own code

1. Call `POST /v1/render` per episode with the layers below.

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": {
    "title": {
      "text": "How we hit $1M ARR"
    },
    "episode": {
      "text": "EP 42"
    },
    "guest-photo": {
      "image_url": "https://example.com/guest.jpg"
    }
  }
}'
```

[API documentation](https://templated.io/docs/)

## Step-by-step guides

- [Automate Your Image Generation using Spreadsheets (No code needed)](https://templated.io/blog/automate-your-image-generation-using-spreadsheets/)

## Related workflows

- ### [Automate Instagram posts from a Google Sheet](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.

  Run with: Make, Zapier, n8n, REST API, AI agent (MCP)

- ### [Share every new blog post with its own branded image](https://templated.io/workflows/blog-posts-to-social-images/)

  Publish the article and you are done: the RSS feed triggers a branded share image with the title, and the post goes out on your channels.

  Run with: Zapier, Make, n8n

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

[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)
