Generate content ideas with Gemini Pro and store in Google Sheets
Automated Content Idea Generation and Expansion with Google Gemini and Google Sheets This n8n workflow automates the process of generating content ideas based on a user-defined topic, then expands each idea into a mor...
Template notes
Automated Content Idea Generation and Expansion with Google Gemini and Google Sheets
This n8n workflow automates the process of generating content ideas based on a user-defined topic, then expands each idea into a more detailed content piece (like a blog post) using Google Gemini, and finally saves all the generated data (idea title, description, and full content) into a Google Sheet. It's a powerful tool for streamlining content creation workflows.
This workflow includes: Generation of multiple content ideas from a single topic. Expansion of each idea into detailed content using AI. Storage of ideas and generated content in a structured Google Sheet. Sticky Notes within the workflow for inline documentation and setup guidance.
Prerequisites
1. n8n Instance: You need a running n8n instance (self-hosted or cloud). 2. Google AI Account: Access to Google AI (Gemini). You will need an API key. 3. Google Account: Access to Google Sheets. You will need to create or use an existing spreadsheet with specific column headers.
Installation and Setup
1. Import the Workflow: Copy the entire JSON code provided. In your n8n instance, go to "Workflows". Click "New" -> "Import from JSON". Paste the JSON code and click "Import".
2. Configure Credentials: Google AI (Gemini): Find the "Google Gemini Chat Model for Content Idea Generator" node and the "Google Gemini Chat Model for Content Generation" node. Click on the "Credentials" field in both nodes (it will likely show a placeholder name like "Google Gemini(PaLM) Api account"). Click "Create New". Select "Google AI API". Enter your Google AI API Key. Save the credential. (You can reuse the same credential for both nodes). Google Sheets: Find the "Google Sheets" node. Click on the "Credentials" field (it will likely show a placeholder name like "Google Sheets account"). Click "Create New". Select "Google Sheets OAuth2 API". Follow the steps to connect your Google Account and grant n8n access to Google Sheets. Save the credential.