Generate SEO Blog Posts from Google Sheets with SerpAPI

## Try It Out! This n8n template helps you create SEO-optimized Blog Posts for your businesses website or for personal use. Whether you're managing a business or helping local restaurants improve their digital presence, this workflow helps you build SEO-Optimized Blog Posts in seconds using Google Autocomplete and People Also Ask (SerpAPI). Who Is It For? - This is helpful for people looking to SEO Optimize either another person's website or their own. How It Works? - You start with a list of blog inspirations in Google Sheets (e.g., “Best Photo Session Spots”). - The workflow only processes rows where the “Status” column is not marked as “done”, though you can remove this condition if you’d like to process all rows each time. - The workflow pulls Google Autocomplete suggestions and PAA questions using: A custom-built SEO API I deployed via Render (for Google Autocomplete + PAA), SerpAPI (for additional PAA data). - These search insights are merged. For example, if your blog idea is “Photo Session Spots,” the workflow gathers related Google search phrases and questions users are asking. - Then, GPT-4 is used to draft a full blog post based on this data. - The finished post is saved back into your Google Sheet. How To Use - Fill out the “Blog Inspiration” column in your Google Sheet with the topics you want to write about. - Update the OpenAI prompt in the ChatGPT node to match your tone or writing style. (Tip: Add a system prompt with context about your business or audience.) - You can trigger this manually, or replace it with a cron schedule, webhook, or other event. Requirements - A SerpAPI account to get PAA - An OpenAI account for ChatGPT - Access to Google Sheets and n8n How To Set-Up? - Your Google Sheet should have three columns: "Blog Inspiration", "Status" → set this to “done” when a post has been generated, "Blog Draft" → this is automatically filled by the workflow. - To use the SerpAPI HTTP Request node: 1. Drag in an HTTP Request node, 2. Set the Method and URL depending on how you're using SerpAPI: Use POST to run the actor live on each request. Use GET to fetch from a static dataset (cheaper if reusing the same data). 3. Add query parameters for your SerpAPI key and input values. 4. Test the node. Refer to this n8n documentation for more help! https://docs.n8n.io/integrations/builtin/cluster-nodes/sub-nodes/n8n-nodes-langchain.toolserpapi/. -