Skip to content
FlowHubFluxonLab
Google Sheets
AI Writing & Generationfree

Automated Content Strategy with Google Trends, News, Firecrawl & Claude AI

by Allan VaccariziUpdated Aug 2026
RequiresGoogle SheetsGoogle SheetsAnthropic
Share Post Share
Get QueryAdd datasOPStructured Output ParserStructured Outp…SILoop Over ItemsAnthropic Chat ModelAnthropic Chat …SASearch trendCoClassing queryCLSorting queriesCoSorting output > tableSorting output …ScSchedule TriggerIfTrends OK ?Create sheetsCoSort related querySort related qu…SASearch GNews query 1Search GNews qu…SASearch GNews query 2Search GNews qu…SASearch GNews query 3Search GNews qu…CoReturn URL only query 1Return URL only…CLArticle analysis query 1Article analysi…CLArticle analysis query 2Article analysi…CLArticle analysis query 3Article analysi…Add article datas query 1Add article dat…MeMerge queriesSwSwitchFiScrape query 1CoReturn URL only query 2Return URL only…CoReturn URL only query 3Return URL only…FiScrape query 3FiScrape query 2CoClean markdown for AI Query 1Clean markdown …CoClean markdown for AI Query 2Clean markdown …CoClean markdown for AI Query 3Clean markdown …Sonnet 4.6Add article datas query 2Add article dat…Add article datas query 3Add article dat…Article error google sheets query 1Article error g…Article error google sheets query 2Article error g…Article error google sheets query 3Article error g…
1/5
STEPS · 45
Runs on a schedule

On a schedule, pulls trends and news via SerpApi and Firecrawl, analyzes them with Claude, and writes content ideas to Google Sheets.

Tags

cronadvancedGoogle SheetsAnthropicMarket ResearchMultimodal AIdiscoveredpending-review
Connects
sheetsGoogle SheetsAnthropic
CategoryAI Writing & Generation
Triggercron
Complexityadvanced
Nodes37
AddedJun 27, 2026