Turn Airtable content-calendar rows into finished posters

Watch my Airtable content-calendar base for new rows and turn each row into a finished marketing poster with Ideogram.

Trigger: poll Airtable with the new_record event on the base and table I pick during setup. Each row carries a headline, sub-copy, style keywords, and an aspect ratio (values like 1:1, 9:16, or 16:9).

For every new row, if the polled payload does not already include the fields I need, call Airtable List Records (filtered to that record id) to fetch the full record. Then assemble an Ideogram prompt from the fields: put the headline in quotes so Ideogram renders it verbatim as in-image typography, include the sub-copy as smaller supporting text if present, and fold the style keywords and any brand notes into the prompt as descriptive language.

Call Ideogram Generate (Ideogram 4.0) with that assembled prompt and pass the row's aspect ratio through. Important: Ideogram's aspect_ratio and resolution parameters are mutually exclusive — pick one, defaulting to aspect_ratio when the column holds a ratio like 16:9. Request a single image per row.

When the response comes back, inspect data[0]. On success, PATCH the source row with Airtable Update Record and write three things: the returned image URL into the image field, the final prompt string that was sent to Ideogram into the prompt field, and the returned seed into the seed field so the marketer can regenerate variants of the same design later. If is_image_safe is false, do not write an image URL — write a short human-readable safety message into the status field instead.

Guard rails: if a row is missing a headline, skip Ideogram entirely and write a 'missing headline' note into the status field so we do not burn credits on empty briefs. Handle 429 rate limits from either service with a short backoff.

Nuance to mention to the customer in the finished workflow's description: Ideogram-hosted image URLs expire after a limited time. If they want permanent storage they should download the image bytes and re-host them somewhere durable (Google Drive, Dropbox, their own CDN) and store that permanent link on the row. This workflow files the ephemeral Ideogram URL as-is; a downstream permanent-hosting step is a natural add-on.