Automation library · Documents and files

Find weak local Google Business profiles with Bright Data

Started by a clock, and works across Google Sheets and Slack. It hands the judgement calls to OpenAI. 24 steps, 2 branches, 1 loop or waits: large, and worth reading before you trust it with anything live.

LargeCalls a model: OpenAI

Download free
24 stepsLarge: read it before trusting it with anything live
2Branches: places the flow splits
1Loop or waits
2Services it connects to

The flow

Starts it 1Model 4Logic 13Service 6

The steps in the order they run, from what starts it.

  1. 1Weekly Prospect ScanSchedule triggerStarts it
  2. 2OpenAI Review ReaderLm Chat Open AiModel
  3. 3OpenAI Brief WriterLm Chat Open AiModel
  4. 4Set Search ConfigSetLogic
  5. 5Read Complaint ThemesInformation ExtractorModel
  6. 6Write Prospect BriefChain LlmModel
  7. 7Build Discovery InputCodeLogic
  8. 8Rank ProspectsCodeLogic
  9. 9Build ReportCodeLogic
  10. 10Discover Businesses With Bright DataHttp RequestService
  11. 11Split Out Prospect RowsSplit OutLogic
  12. 12Check Discovery AcceptedCodeLogic
  13. 13Log Prospects To SheetGoogle SheetsService
  14. 14Wait For SnapshotWaitLogic
  15. 15Post Digest To SlackSlackService
  16. 16Check Snapshot ProgressHttp RequestService
  17. 17Evaluate Scrape ProgressCodeLogic
  18. 18Profiles Ready?IfLogic
  19. 19Download Business ProfilesHttp RequestService
  20. 20Score Profile GapsCodeLogic
  21. 21Read Reported BusinessesGoogle SheetsService
  22. 22Select New ProspectsCodeLogic
  23. 23Any New Prospects?IfLogic
  24. 24Nothing New This WeekNo OpLogic

How it's built

Starts on
A clock
Steps
24, with 2 branches, 1 loop or waits
Size
Large: read it before trusting it with anything live
Connects to
Google Sheets, Slack
Model
OpenAI

Questions

What does it need to run?

An n8n account, plus your own Google Sheets and Slack accounts, and a key for OpenAI. You connect your own accounts after importing it; none are included.

What starts it?

It starts on a clock.

Does it use AI?

Yes. It calls OpenAI. Model calls are billed by the provider, not by n8n.

How long does it take to set up?

Take your time. At 24 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 24 steps before you point it at anything that matters.