# Fully automate blog creation with Google Sheets: n8n workflow > Started by an event in a connected app, and works across Google Sheets. 42 steps: large, and worth reading before you trust it with anything live. Source: https://millionrounds.com/workflow/fully-automate-blog-creation-with-google-sheets (Millionrounds; every figure on the page links to its filing or article) [Automation library](https://millionrounds.com/workflows) · [Content](https://millionrounds.com/workflows?category=Content#library) # Fully automate blog creation with Google Sheets Started by an event in a connected app, and works across Google Sheets. 42 steps: large, and worth reading before you trust it with anything live. Large [Download free](https://millionrounds.com/login?next=%2Fapp%2Fworkflow%2Ffully-automate-blog-creation-with-google-sheets) **42 steps** Large: read it before trusting it with anything live **0** Branches: places the flow splits **0** Loops or waits **1** Service it connects to ## The flow Starts it 1 Logic 19 Service 22 The steps in the order they run, from what starts it. - 1 **Manual Trigger** Manual trigger *Starts it* - 2 **Google Sheets** Google Sheets *Service* - 3 **HTTP Google SERP** Http Request *Service* - 4 **HTTP SearchVolume** Http Request *Service* - 5 **HTTP Keyword Suggestions** Http Request *Service* - 6 **HTTP Related Keywords** Http Request *Service* - 7 **HTTP Keyword Ideas** Http Request *Service* - 8 **HTTP Subtopics** Http Request *Service* - 9 **HTTP Screenshot** Http Request *Service* - 10 **HTTP Local Finder** Http Request *Service* - 11 **Extract Organic** Code *Logic* - 12 **Extract Snippet1** Code *Logic* - 13 **Detect SERP Features1** Code *Logic* - 14 **Extract Top Domain** Code *Logic* - 15 **Extract PAA/PAS** Code *Logic* - 16 **Extract Volume Trend** Code *Logic* - 17 **Extract Suggestions** Code *Logic* - 18 **Extract Related Keywords** Code *Logic* - 19 **Extract Keyword Ideas** Code *Logic* - 20 **Extract Subtopics** Code *Logic* - 21 **Merge** Merge *Logic* - 22 **Extract Local** Code *Logic* - 23 **Organic Results** Google Sheets *Service* - 24 **Featured Snippets** Google Sheets *Service* - 25 **SERP Features** Google Sheets *Service* - 26 **HTTP Backlinks** Http Request *Service* - 27 **PAA** Google Sheets *Service* - 28 **Search Volume Trend** Google Sheets *Service* - 29 **Suggestions** Google Sheets *Service* - 30 **Related Keywords** Google Sheets *Service* - 31 **Keywords Ideas** Google Sheets *Service* - 32 **Subtopics** Google Sheets *Service* - 33 **Restructure data** Code *Logic* - 34 **Local Results** Google Sheets *Service* - 35 **Yes or No** Code *Logic* - 36 **Wich features exist** Code *Logic* - 37 **Backlinks** Google Sheets *Service* - 38 **Code** Code *Logic* - 39 **average search volume and CPC** Code *Logic* - 40 **Average competition** Code *Logic* - 41 **Overview** Google Sheets *Service* - 42 **Code1** Code *Logic* ## How it's built - **Starts on:** An event in a connected app - **Steps:** 42 - **Size:** Large: read it before trusting it with anything live - **Connects to:** Google Sheets - **Model:** None. This is plumbing, not judgement ## Questions What does it need to run? An n8n account, plus your own Google Sheets account. You connect your own accounts after importing it; none are included. What starts it? It starts on an event in a connected app. Does it use AI? No. Every step is fixed logic or a call to a service, so it does the same thing every time. How long does it take to set up? Take your time. At 42 steps it is large: read it before trusting it with anything live. How do I import it? Copy the workflow, open a new workflow in n8n and paste. The steps appear on the canvas, ready for your own accounts. **Before you run it** Nothing here has been tested by us. It is somebody's working automation, read and described from its own steps. Treat the connections it wants as a list of accounts it will touch, and read the 42 steps before you point it at anything that matters. ## Run it in n8n - **Create your n8n account** Free to start. n8n is where the workflow runs. [Create an n8n account ↗](https://millionrounds.com/n8n) - **Download the workflow** Free with a Millionrounds account. [Download free](https://millionrounds.com/login?next=%2Fapp%2Fworkflow%2Ffully-automate-blog-creation-with-google-sheets) - **Paste it into n8n** Open a new workflow in n8n and paste. Then connect your own accounts. Stored with the author's traces removed: canvas notes, instance identifiers, saved credential names and any live document they had left behind. ## Connects to Each opens the other workflows that use it. [Google Sheets](https://millionrounds.com/workflows?service=Google+Sheets#library) ## Workflows like it Also content, with the same services where possible, closest in size first. - [**Generate Blog Posts on Autopilot with Tavily and WordPress** 42 steps · calls a model · Google Drive, Google Sheets](https://millionrounds.com/workflow/generate-blog-posts-on-autopilot-with-tavily-and-wordpress) - [**Generate a full startup plan from one sentence with Postgres** 43 steps · Gmail, Google Drive](https://millionrounds.com/workflow/generate-a-full-startup-plan-from-one-sentence-with-postgres) - [**Create & share AI videos with Telegram and Gemini** 41 steps · calls a model · Google Drive, Google Sheets](https://millionrounds.com/workflow/create-and-share-ai-videos-with-telegram-and-gemini) - [**Create and publish UGC social videos from Telegram with OpenAI** 41 steps · calls a model · Google Drive, Google Sheets](https://millionrounds.com/workflow/create-and-publish-ugc-social-videos-from-telegram-with-open) - [**Create blog posts from YouTube videos with a local model** 43 steps · calls a model · Google Sheets, RSS](https://millionrounds.com/workflow/create-blog-posts-from-youtube-videos-with-a-local-model) - [**Generate monthly SEO analytics reports with Search Console** 41 steps · calls a model · Discord, Google Sheets](https://millionrounds.com/workflow/generate-monthly-seo-analytics-reports-with-search-console)