Daily Google Trends to LinkedIn, Facebook & Bluesky (n8n)

Turn Daily Google Trends into Ready-to-Post Social Updates on LinkedIn, Facebook & Bluesky (n8n)

This n8n workflow automatically finds relevant Google Trends topics every weekday, researches them with Perplexity, and publishes tailored posts to LinkedIn, Facebook, and Bluesky—while logging everything to Google Sheets and emailing you if something fails.

What this workflow does

• Runs every weekday at 8:00 using an n8n schedule trigger.
• Pulls your country’s Google Trends RSS feed, skips trends already used in previous executions, and keeps the top 10 items.
• Uses Perplexity to select one brand-relevant trend based on your brand/niche context, returning a short explanation, facts, and `source citations`.
• Stops early if Perplexity finds no match, so no social posts are created for irrelevant trends.
• Generates and publishes native posts with PostWire for LinkedIn, Facebook, and Bluesky.
• Logs results to Google Sheets by appending a “published” row per network (including post URL and sources).
• Notifies you on failures by logging error details and sending a consolidated “fix request” email via Gmail.

Use cases

• Enable a weekday social content pipeline for SaaS and B2B brands using real trend data.
• Automate trend research + publishing without manually checking Google Trends.
• Ensure relevance filtering with Perplexity before posting to multiple networks.
• Maintain transparency with Google Sheets tracking and actionable failure emails via Gmail.

Technical details

• n8n nodes/integrations reflected in the workflow: if, set, gmail, limit, aggregate, perplexity (plus PostWire and Google Sheets setup).
• Requires: a Perplexity API credential, configured PostWire API credential, and connected LinkedIn/Facebook/Bluesky accounts in PostWire.
• Google Sheets columns: date, trend, network, status, link, sources, note.