This workflow automates the process of creating, approving, and optionally posting LinkedIn content from a Google Sheet. Here's a high-level overview:
You’ll need the following before you start:
Google Sheet Preparation:
Create a new Google Sheet with the mentioned columns (Post Description, Instructions, Image, Status, Output, Post Link).
Add a row with test data and set Status to Pending.
Credentials:
In n8n, create OAuth2 credentials for:
a. Google Sheets
b. Gmail
c. OpenAI (API Key)
Assign these credentials to the respective nodes in the JSON.
OpenAI Model:
Choose a model like gpt-4o-mini (used here) or any other available in your plan.
Adjust the prompt in the "Generate Post Content" node if needed.
Email Configuration:
In the Gmail node, set the recipient email to your own or your team’s address.
Customize the email message template if necessary.
Schedule the Workflow:
Set the trigger interval (e.g., every morning at 9 AM).
Testing:
Run the workflow manually first to confirm everything works.
Check Gmail for the approval form, respond, and verify the results.