Publish weekly Google Business Profile posts using Perplexity and Supabase
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 12 nodes and runs on a schedule (every week at 09:00). Along the way it connects Anthropic Chat Model, Google Business Profile and Microsoft Outlook.
How it runs
Trigger: On a schedule (every week at 09:00).
- Fetch Recent Posts (HTTP Request): calls an HTTP API
- Build Post Prompt (Code): runs custom JavaScript code
- Research Trending Topics (Perplexity): uses Perplexity
- Log Cost: Research Trending Topics (Execute Sub-workflow): calls another n8n workflow
- Merge Prompt + History (Code): runs custom JavaScript code
- Generate GBP Post (AI Agent): runs an AI agent, with model: Claude Sonnet
- Extract Post Content (Code): runs custom JavaScript code
- Publish to GBP (Google Business Profile): uses Google Business Profile
- Log Post to Supabase (HTTP Request): calls an HTTP API (POST)
- Notify Me Post Live (Microsoft Outlook): uses Microsoft Outlook
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (9)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Perplexity
n8n-nodes-base.perplexity - AI Agent
@n8n/n8n-nodes-langchain.agent - Anthropic Chat Model
@n8n/n8n-nodes-langchain.lmChatAnthropic - Google Business Profile
n8n-nodes-base.googleBusinessProfile - Microsoft Outlook
n8n-nodes-base.microsoftOutlook - Execute Sub-workflow
n8n-nodes-base.executeWorkflow
From the author
Quick overview This workflow runs every Monday at 9AM ET to research recent automation topics with Perplexity, generate a Google Business Profile post with Anthropic Claude, publish it to Google Business Profile, log the published post to Supabase, and send a…