AI-Powered Social Media Content Generator with Google Sheets Logging

Overview

This workflow automatically generates and publishes social media content using AI, then logs everything to Google Sheets. It's perfect for content creators, marketers, or anyone who wants to maintain a consistent social media presence without spending hours brainstorming and writing posts. The workflow runs on a schedule, creates a topic using GPT-4, generates a tweet about that topic, creates an anime-style image, and posts the content to Twitter, LinkedIn, and Facebook simultaneously.

Workflow Steps

1. Schedule Trigger (No auth) — Runs the workflow daily at 10 PM (22:00). This is the starting point that activates the entire automation on a recurring basis.

2. Message a model (OpenAI API Key auth) — Uses GPT-4 to generate a 50-character title about a specific problem related to n8n or automation. This creates the core topic that will be used throughout the workflow.

3. Message a model1 (OpenAI API Key auth) — Takes the title from the previous step and generates a complete tweet that breaks down the topic in a solution-oriented, easy-to-read way with hashtags. Uses the ChatGPT-4o-latest model.

4. Generate an image (OpenAI API Key auth) — Creates a Japanese anime-style image based on the same title. This uses OpenAI's image generation capabilities (DALL-E) to produce visual content for social media posts.

5. Append or update row in sheet1 (Google OAuth2) — Logs the generated title, description, and image URL to a Google Sheet named "Automation inbound content". Uses the appendOrUpdate operation to add new rows or update existing ones based on the Title column.

6. Create Tweet (Twitter OAuth2) — Posts the generated description as a tweet on Twitter.

7. Create a post (LinkedIn OAuth2) — Creates a LinkedIn post with the generated content.

8. Facebook Graph API (Facebook OAuth2) — Posts the content to Facebook using the Facebook Graph API.

Setup Instructions

To use this workflow, you'll need accounts and credentials for the following services:

• OpenAI: Create an account at platform.openai.com and generate an API key. You'll need access to GPT-4 and DALL-E image generation.
• Google Sheets: A Google account with access to Google Sheets. Create a new spreadsheet or use an existing one. You'll need to set up Google OAuth2 credentials in n8n.
• Twitter: A Twitter Developer account with API keys and access tokens. Set up OAuth2 authentication in n8n.
• LinkedIn: A LinkedIn account with API access. Create a LinkedIn app and configure OAuth2 credentials.
• Facebook: A Facebook Developer account with a Facebook app and Page Access Token for the Facebook Graph API.

Configuration Steps:

1. Import this workflow into your n8n instance
2. Configure each credential by clicking on the node and selecting "Create New" or "Select Existing"
3. Update the Google Sheet ID in the "Append or update row in sheet1" node to point to your spreadsheet
4. Adjust the schedule trigger time if needed (currently set to 10 PM daily)
5. Activate the workflow

Use Cases and Variations

Primary Use Case

Automated social media content creation for n8n/automation enthusiasts who want to share tips, tricks, and solutions daily without manual effort.

Adaptation Ideas

• Change the topic: Modify the prompt in "Message a model" to generate content about any niche (e.g., marketing tips, coding tutorials, fitness advice)
• Add more platforms: Include Instagram, TikTok, or Pinterest by adding additional nodes
• Customize the image style: Change the prompt in "Generate an image" to produce different visual styles (realistic, cartoon, minimalist, etc.)
• Add content curation: Include an RSS feed or web scraper to find trending topics before generating content
• Implement approval workflow: Add a manual approval step before posting to review AI-generated content
• Schedule different times: Create multiple schedule triggers for different time zones or posting frequencies
• Track performance: Add analytics nodes to monitor engagement metrics from each platform

{
  "id": "59a8WDMIKKo9faYP",
  "meta": {
    "instanceId": "c87a766eb8ed4a39121cf119a5038250a8ca0a11ed90cdd244f6beb7336758b3",
    "templateCredsSetupCompleted": true
  },
  "name": "Posting",
  "tags": [],
  "nodes": [
    {
      "id": "81d2b01a-b0a6-4361-9eb5-00251031a289",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        0,
        135
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "triggerAtHour": 22
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "5551acd6-a6d7-4c89-b7b8-104163d2c7a7",
      "name": "Message a model",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        220,
        135
      ],
      "parameters": {
        "modelId": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4",
          "cachedResultName": "GPT-4"
        },
        "options": {},
        "messages": {
          "values": [
            {
              "content": "Create a 50 character title of a topic related to very specific problem related to n8n or automation."
            }
          ]
// ... truncated (copy to see full JSON)