Weekly branded LinkedIn tip cards from a Google Sheet

Every Monday at 8am in my local timezone, publish a branded tip card to LinkedIn using the next tip in my Google Sheet. The trigger is a cron schedule.

Read from the tips tab of the sheet with Google Sheets Get Values. Each row has these columns: headline, sub-copy, caption, posted (empty when unposted), and post URL. Pick the first row where the posted column is empty. If that row's caption column is also empty, stop the run without posting anything so I can fill it in later without losing the row.

Generate a square social card with Ideogram Generate (Ideogram 4.0). Pass a text_prompt that renders the tip's headline as the main poster text and the sub-copy underneath in a clean, brand-styled layout on a solid background. Request a 1:1 aspect ratio. Ideogram's in-image typography is the whole reason this workflow uses it, so the text should be baked into the image itself, not overlaid afterwards. Download the returned image bytes since the Ideogram URLs expire.

If the response comes back with is_image_safe = false, retry once with a simpler prompt that drops adjectives and brand-jargon and just asks for the headline and sub-copy on a plain colored background. If the retry is still flagged unsafe, stop and leave the row untouched so I can look at it.

Once you have a valid image, post it to LinkedIn with Create Post as an image post. Use the caption column from the same row verbatim as the post commentary.

After LinkedIn returns the post URN, build the public post URL from it and write today's date into the posted column and the URL into the post URL column for that row with Google Sheets Update Values. That is how the workflow guarantees the same tip is never posted twice.