PICKED FROM N8N.IO · MARKETING & REVIEWS

On a schedule, this workflow takes the first Pending row from a Google Sheet, asks OpenAI to write a LinkedIn post from the description and instructions, and emails it to a person for approval. They can accept, reject or edit it. Approved posts go to LinkedIn, with or without an image, and the sheet row is updated.

Template by Aryan Shinde · 46.7k views on n8n.io · listed there as “AI-generated LinkedIn posts with OpenAI, Google Sheets & email approval workflow”

THE WORKFLOW13 NODES
↯Get Image◷Schedule Trigger◆OpenAI Chat Model▦Get Data fromSheets✦Generate PostContent≡Data Formatting 1@Send ContentConfirmation⑂ContentConfirmation Log…✦Regenerate PostContent⑂If Image ProvidedinPost With ImageinPost WithoutImage▦Update GoogleSheet
DIFFICULTY
Intermediate
NODES
13
USES AI
Yes
PUBLISHED
May 2025

001 / WHAT HAPPENS

  1. 01

    A schedule trigger starts the run and reads the first row marked Pending in Google Sheets.

  2. 02

    OpenAI writes a LinkedIn post from the post description and instructions in that row.

  3. 03

    Gmail sends the draft to an approver with a form to accept, reject or edit.

  4. 04

    A switch handles the answer, and rejected drafts are regenerated by the AI.

  5. 05

    Approved posts publish to LinkedIn, using the image URL if one was supplied.

  6. 06

    The Google Sheet row is updated with the result.

WHO IT SUITS

Suits a small business that posts on LinkedIn regularly and wants someone to approve each post before it goes live.

CONNECTS

  • Google Sheets
  • OpenAI
  • Gmail
  • LinkedIn

002 / BEFORE YOU USE IT HERE

  • !Customer or staff details are sent to OpenAI in the US, which is a cross-border disclosure under APP 8 of the Privacy Act, so say so in your privacy policy.
  • !Posts publish to a public LinkedIn profile or page, so keep the approval step switched on and read each draft before accepting it.
  • !Set the workflow timezone to Australia/Sydney (or your city) so the schedule runs at the right local time.

LOCAL SWAP

Swap Gmail for the Microsoft Outlook node if your team uses Microsoft 365 email.

Need n8n and the AI hosted in Australia? →

004 / QUESTIONS

Anything else is quicker to answer on a call. Thirty minutes, free, with the people who would build it.

Yes. Every template on this list is free on n8n.io. You need an n8n account (n8n Cloud or self-hosted) and accounts for the apps it connects to, some of which charge for API use.

We adapt templates to your systems, add approval steps where customers are involved, host n8n in Australia when the data calls for it and hand it over documented.

Book a free call→