{"product_id":"n8n-openai-linkedin-wordpress-automation-with-sheets","title":"n8n OpenAI LinkedIn \u0026 WordPress Automation with Sheets","description":"\u003ch3\u003eTurn one content request into an OpenAI-written LinkedIn post or WordPress draft—complete with an AI thumbnail and Sheets-tracked approval\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow collects your content brief, uses OpenAI to generate a LinkedIn post or a WordPress blog (plus a matching thumbnail), saves everything to Google Sheets\/Drive for tracking, and publishes on approval via a webhook.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCollects a brief via an n8n form\u003c\/strong\u003e with the chosen format, categories, tone, topic source, and thumbnail preferences.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates content with OpenAI (gpt-4o-mini)\u003c\/strong\u003e as structured JSON, including:\n    \u003cul\u003e\n      \u003cli\u003eTitle\u003c\/li\u003e\n      \u003cli\u003eHTML body\u003c\/li\u003e\n      \u003cli\u003ePlain-text copy\u003c\/li\u003e\n      \u003cli\u003eHashtags\/keywords\u003c\/li\u003e\n      \u003cli\u003eAn image prompt for the thumbnail\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates a thumbnail with OpenAI (gpt-image-1)\u003c\/strong\u003e, converts it to base64 for preview, and uploads the image to \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTracks the draft in Google Sheets\u003c\/strong\u003e by appending metadata such as a unique \u003cem\u003econtentId\u003c\/em\u003e, \u003cem\u003estatus\u003c\/em\u003e, and the \u003cem\u003eDrive file ID\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDisplays a styled preview page\u003c\/strong\u003e embedding the thumbnail and content, with a publish button that triggers a webhook.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePublishes on approval\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003eThe publish webhook checks Google Sheets; if the draft status isn’t \u003cstrong\u003eREADY\u003c\/strong\u003e, it stops with an “already processed\/invalid” response.\u003c\/li\u003e\n      \u003cli\u003eOtherwise, it downloads the thumbnail from Google Drive and:\n        \u003cul\u003e\n          \u003cli\u003e\n\u003cstrong\u003ePublishes to LinkedIn\u003c\/strong\u003e with the image, or\u003c\/li\u003e\n          \u003cli\u003e\n\u003cstrong\u003eCreates a WordPress draft\u003c\/strong\u003e using the WordPress REST API, uploading the media and setting it as the featured image.\u003c\/li\u003e\n        \u003c\/ul\u003e\n      \u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMarks the draft as PROCESSED\u003c\/strong\u003e in Google Sheets and returns a confirmation response.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS marketing teams generating consistent LinkedIn posts from standardized briefs.\u003c\/li\u003e\n  \u003cli\u003eOperators producing weekly WordPress drafts with an AI thumbnail and a human approval step.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers needing an n8n workflow that ties OpenAI, Google Sheets tracking, and publishing to LinkedIn\/WordPress.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/workflow logic:\u003c\/strong\u003e if, set, form, switch, webhook, and a workflow that calls LinkedIn-related publishing steps.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI integrations:\u003c\/strong\u003e gpt-4o-mini for structured JSON content generation; gpt-image-1 for thumbnail creation.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStorage \u0026amp; tracking:\u003c\/strong\u003e Google Sheets (status\/contentId\/Drive file ID) and Google Drive (thumbnail upload\/download).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePublishing targets:\u003c\/strong\u003e LinkedIn publishing with image, and WordPress via the \u003cstrong\u003eWordPress REST API\u003c\/strong\u003e to create draft posts with featured media.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45950114758835,"sku":"N8N-19154","price":77.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/XPH8gT3LTwXVafIrg95NR_clBZluTW.png?v=1788513435","url":"https:\/\/buyflowscripts.com\/products\/n8n-openai-linkedin-wordpress-automation-with-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}