Get Started
Screenshot of n8n workflow
PRO TEMPLATE
Automate Google Search Console SEO Insights
4
Views
0
Downloads
30
Nodes
Download Template
Pro required
Preview Template
Utility Rating
8 / 10
Business Function
Marketing
Automation Orchestrator
n8n
Integrations
PostgreSQL
OpenAI
Google Search Console
Trigger Type
Webhook
Other
Approx setup time ≈ 45 min
Need help setting up this template?
Ask in our Futurise Pro community
About
Community
Courses
Events
Members
Templates

How to Automate Google Search Console SEO Insights?

Leon Petrou
PRO TEMPLATE
Automate Google Search Console SEO Insights
4
Views
0
Downloads
30
Nodes
Download Template
Pro required
Preview Template
Utility Rating
8 / 10
Business Function
Marketing
Automation Orchestrator
n8n
Integrations
PostgreSQL
OpenAI
Google Search Console
Trigger Type
Webhook
Other
Approximate setup time ≈ 45 minutes
Need help setting up this template?
Ask in our Futurise Pro community

Description

Get SEO answers fast without opening Search Console. A simple chat input collects your question and returns data in a clear table. Marketing and SEO teams can check clicks, queries, and pages across many sites in minutes.

A secure webhook receives chatInput and sessionId. A set node adds a date hint for the agent. The AI agent uses an OpenAI chat model and Postgres memory to read your request, confirm the need, and choose the right tool. The tool calls a sub workflow that routes either to get the list of properties or to query custom insights. Set nodes build a request that follows the Search Console API. OAuth nodes pull the data. Array aggregation organizes the result for the agent. The final answer is sent back through the webhook.

You need OpenAI, Google Search Console access, and a Postgres database. Point the tool node to the tool trigger workflow, then activate and test with a POST request that includes chatInput and sessionId. Expect faster reports, fewer clicks, and clear answers to common SEO questions like top queries this week or pages losing clicks.

Copy link

Tools Required

PostgreSQL
Sign up
Free: $0 (open-source PostgreSQL License; self-hosted)
OpenAI
Sign up
Pay-as-you-go: GPT-5 at $1.25 per 1M input tokens and $10 per 1M output tokens
n8n
Sign up
$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.
Google Search Console
Sign up
Free: $0 (API usage is free; quotas apply)

What this workflow does?

  • Secure webhook with basic auth receives chatInput and sessionId
  • Set node adds chatInput, sessionId, and a formatted date message
  • AI agent uses an OpenAI chat model and Postgres chat memory with a context window of 5
  • Tool workflow links the agent to a sub workflow when a tool call is needed
  • Switch node routes between website list and custom insights paths
  • Set nodes build the Search Console API body including dates, dimensions, and filters
  • Google Search Console nodes fetch property lists and analytics data with OAuth 2
  • Array aggregation prepares raw data for tables or charts
  • Respond to webhook sends the final answer back to the caller

What are the benefits?

  • Cut report build time from 60 minutes to 5 minutes
  • Reduce manual Search Console clicks from 30 to 1 request
  • Automate 80 percent of recurring SEO questions
  • Improve data consistency by removing copy paste errors
  • Support multiple sessions at once using sessionId
  • Connect OpenAI, Search Console, and Postgres in one flow

How to set this up?

  1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
  2. You'll need accounts with OpenAI, PostgreSQL and Google Search Console. See the Tools Required section above for links to create accounts with these services.
  3. Open the Webhook node named ChatInput. Confirm the HTTP method is POST and set Basic Auth credentials. Copy the production webhook URL for later testing.
  4. Configure OpenAI: double click the OpenAI Chat Model node, choose the credential dropdown, click Create new credential, and paste your OpenAI API key from your OpenAI account. Select the model you prefer such as gpt 4o or gpt 4o mini.
  5. Configure PostgreSQL: double click the Postgres Chat Memory node, create a new Postgres credential, and enter host, port, database, user, password, and SSL if needed. Set the table name to insights_chat_histories and keep context window at 5.
  6. Connect Google Search Console: open either Search Console node, in Credential to connect with click Create new credential, then follow the on screen steps to sign in with the Google account that has Search Console access. Approve required scopes.
  7. Set up the tool workflow link: open the Call Search Console Tool node and select the workflow that contains the Tool calling trigger. Make sure that workflow is saved and active.
  8. Review Set fields nodes. Confirm chatInput and sessionId map from the webhook and that the date message format matches your time zone needs.
  9. Open Set fields - Construct API CALL and verify request_type values website_list and custom_insights. Check that dates, dimensions, and filters map to your Search Console needs.
  10. Test Google access: run the Get List of Properties node. If you see no sites, confirm Search Console permissions for your Google account and reauthenticate if needed.
  11. End to end test: send a POST to the webhook with JSON that includes chatInput and sessionId. Example chatInput could be Show top queries for the last 7 days for site X. Verify you receive a table in the response.
  12. Troubleshoot common issues: 401 or 403 from Google means credential or access problems, fix account permissions. Empty results often mean wrong date range or filters, adjust the Set fields node. Memory issues suggest database connectivity, check Postgres credentials and network rules.

Need help or want to customize this?

Ask in the Futurise Pro Community.

Similar Templates

n8n
Marketing
Generate YouTube Shorts from Google Sheets
Create short videos for YouTube by pulling a quote and creative prompts from Google Sheets, building the background image and video with AI, adding ambient sound, and publishing the final clip to your channel. Great for social teams and creators who want steady content without manual editing. A manual start reads one row from Google Sheets with the quote, author, and scene prompts. The flow calls an image model to render a vertical image, waits, then writes the image link back to the sheet. It then sends that image to a video model to produce a cinematic vertical clip, waits again, downloads the file, and records the video link in the sheet. Audio is generated with a voice and sound service, stored to Google Drive, and the drive link is saved. A code node formats overlay text, then FFmpeg merges video, audio, and on screen text into a final MP4. The clip uploads to YouTube with a resumable upload, and the sheet is updated with status and the YouTube link. You will need API keys for the AI services, Google and YouTube OAuth, and FFmpeg installed on the n8n host. Expect one run to replace hours of editing with a repeatable system managed from a spreadsheet. Ideal for daily quotes, quick tips, or listicle shorts driven by your sheet.
13 views
view
n8n
Marketing
Automate Google Drive Resume Q&A
Turn a resume in Google Drive into a smart chat that answers questions and sends a daily email report. Ideal for personal sites, career pages, or portfolios that want simple Q&A and clear insights without manual updates. When a file is added or changed in a chosen Google Drive folder, the text is split into chunks, embedded with Google Gemini, and stored in Pinecone. A public chat webhook lets visitors ask questions. The agent uses the vector store, a memory buffer, and the Gemini chat model to give grounded answers. A separate webhook can save conversation logs to NocoDB. Each day on schedule, the workflow pulls today’s conversations, groups them by session and email, formats them as HTML, and emails a summary from Gmail. Setup needs Google Drive, Gmail, Pinecone, Google Gemini, and NocoDB credentials in n8n. Expect less manual work, faster updates when the resume changes, and one clear email summary at the end of the day. Use it for personal branding, HR portfolios, or team pages that need quick, accurate answers based on the latest resume content.
60 views
view
n8n
Marketing
Sync WordPress to Google Drive Content Reports
Content teams often need a fresh list of live posts for reports and audits. This setup pulls all published posts from WordPress and saves a clean CSV file straight to Google Drive. It is ideal for marketers, editors, and agencies that want quick exports without copy and paste. Under the hood, a manual trigger starts the run. The workflow fetches all published posts from WordPress, then uses a field mapping step to keep only the columns you want, like id and title. Next it turns the result into a CSV file and uploads it to your chosen Google Drive folder using a service account. You get a consistent file that is ready for Google Sheets, with only live content included, and the same format every time. You will need WordPress access and a Google Drive account with a service account set up. Connect both in n8n, select the fields you care about in the Adjust Fields step, and click Test to generate your first export. Expect a ready file in minutes and a big cut in manual work. This is great for monthly content reviews, SEO audits, campaign summaries, and client deliverables.
11 views
view
See More Templates

These templates were sourced from publicly available materials across the web, including n8n’s official website, YouTube and public GitHub repositories. We have consolidated and categorized them for easy search and filtering, and supplemented them with links to integrations, step-by-step setup instructions, and personalized support in the Futurise community. Content in this library is provided for education, evaluation and internal use. Users are responsible for checking and complying with the license terms with the author of the templates before commercial use or redistribution.Where an original author was identified, attribution has been provided. Some templates did not include author information. If you know who created this template, please let us know so we can add the appropriate credit and reference link. If you are the author and would like this template removed from the library, email us at info@futurise.com and we will remove it promptly.