Step 2: Connect Google Sheets

Retrieve the next pending LinkedIn post request from your spreadsheet and later update its status.

1. Open Retrieve Sheet Entry and select the spreadsheet with Document set to [YOUR_ID] and Sheet set to gid=0.
2. In Retrieve Sheet Entry, confirm the filter where lookupColumn is Status and lookupValue is Pending, and enable Return First Match.
3. Credential Required: Connect your googleSheetsOAuth2Api credentials in Retrieve Sheet Entry.
4. Open Update Sheet Status, set Operation to update, and keep Document as [YOUR_ID] with Sheet gid=0.
5. In Update Sheet Status field mappings, set Status to Completed, Output to {{ $json.urn }}, Post Link to {{ $json.urn }}, and row_number to {{ $('Retrieve Sheet Entry').item.json.row_number }}.
6. Credential Required: Connect your googleSheetsOAuth2Api credentials in Update Sheet Status.

Step 3: Set Up the AI Drafting and Field Formatting

Generate the initial LinkedIn post with AI, then normalize fields for approval and publishing.

1. Open OpenAI Chat Engine and choose model gpt-4o-mini.
2. Credential Required: Connect your openAiApi credentials in OpenAI Chat Engine.
3. Open Compose Post Draft and ensure Text contains the full prompt with expressions like {{ $json["Post Description"] }} and {{ $json["Instructions"] }}.
4. Note that OpenAI Chat Engine is connected as the language model for Compose Post Draft and Revise Post Draft — add credentials to OpenAI Chat Engine (not the chain nodes).
5. In Format Post Fields, set Post Content to {{ $json.text }}, Post Description to {{ $('Retrieve Sheet Entry').item.json['Post Description'] }}, and Instructions to {{ $('Retrieve Sheet Entry').item.json.Instructions }}.

Step 4: Configure Email Approval and Decision Routing

Send the AI-generated draft for approval and route the workflow based on the response.

1. Open Email Approval Request and set Send To to [YOUR_EMAIL].
2. Set Subject to Approval for LinkedIn Post and Message to Generated Post: {{ $json['Post Content'] }} ---------- Post Description: {{ $json['Post Description'] }} ---------- Instructions: {{ $json.Instructions }}.
3. Keep Operation as sendAndWait and Response Type as customForm with fields Confirm Content? and Any Changes?.
4. Credential Required: Connect your gmailOAuth2 credentials in Email Approval Request.
5. Open Approval Decision Router and confirm it routes based on {{ $json.data['Confirm Content?'] }} to Yes, No, and Cancel.
6. Connect Approval Decision Router to Image Availability Check (Yes path), Revise Post Draft (No path), and Update Sheet Status (Cancel path).

Step 5: Handle Revisions and Image-Based Publishing

Apply requested edits, check for an image URL, and publish to LinkedIn with or without media.

1. In Revise Post Draft, keep the prompt referencing {{ $('Format Post Fields').item.json['Post Content'] }} and {{ $('Email Approval Request').item.json.data['Any Changes?'] }} so updates reflect feedback.
2. In Image Availability Check, ensure the condition uses {{ $('Retrieve Sheet Entry').item.json.Image }} with Operation set to notEmpty.
3. Image Availability Check outputs to both Fetch Post Image and Publish Without Image in parallel, depending on whether the image URL exists.
4. In Fetch Post Image, set URL to {{ $('Retrieve Sheet Entry').item.json.Image }}.
5. In Publish With Image, set Text to {{ $('Format Post Fields').item.json['Post Content'] }}, Person to [YOUR_ID], and Share Media Category to IMAGE.
6. In Publish Without Image, set Text to {{ $('Format Post Fields').item.json['Post Content'] }} and Person to [YOUR_ID].
7. Credential Required: Connect your linkedInOAuth2Api credentials in both Publish With Image and Publish Without Image.
8. Confirm both LinkedIn nodes connect to Update Sheet Status to log completion and the post URN.

Step 6: Test & Activate Your Workflow

Validate the full approval and publishing cycle before enabling the schedule.

1. Click Execute Workflow and verify Retrieve Sheet Entry pulls a row with Status = Pending.
2. Confirm Compose Post Draft creates Post Content and that Email Approval Request sends a form email with the generated content.
3. Submit the approval form with Yes, No, or Cancel and confirm Approval Decision Router routes to the expected path.
4. On approval, confirm either Publish With Image or Publish Without Image runs and Update Sheet Status writes Completed and the URN fields.
5. Enable the workflow by switching Active to on for production use.