Automation library · Research and reporting

Automated Google Business reports with OpenAI

Started by a clock, and works across Gmail, Google Business Profile, Google Sheets and Slack. It hands the judgement calls to OpenAI. 56 steps: large, and worth reading before you trust it with anything live.

LargeCalls a model: OpenAI

Download free
56 stepsLarge: read it before trusting it with anything live
0Branches: places the flow splits
0Loops or waits
4Services it connects to

The flow

Starts it 1Model 9Logic 28Service 18

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

  1. 1OpenAI Chat Model4Lm Chat Open AiModel
  2. 2OpenAI Chat Model2Lm Chat Open AiModel
  3. 3Review ParserOutput Parser StructuredModel
  4. 4Impression parserOutput Parser StructuredModel
  5. 5Schedule TriggerSchedule triggerStarts it
  6. 6OpenAI Chat ModelLm Chat Open AiModel
  7. 7overall parserOutput Parser StructuredModel
  8. 8Reviews one-linerAgentModel
  9. 9Impressions one-linerAgentModel
  10. 10Read CompaniesGoogle SheetsService
  11. 11Overall one-linerAgentModel
  12. 12Merge One LinersMergeLogic
  13. 13Build Week Window2CodeLogic
  14. 14Build Week Window (reviews)CodeLogic
  15. 15Build 12-Week WindowCodeLogic
  16. 16Set Company (total reviews)CodeLogic
  17. 17Build last week windowCodeLogic
  18. 18Build 12-week window (reviews)CodeLogic
  19. 19Normalize KeysCodeLogic
  20. 20Read RecipientsGoogle SheetsService
  21. 21Get Impression dataHttp RequestService
  22. 22Get Impressions (last week)Http RequestService
  23. 23Set Company (reviews)CodeLogic
  24. 2412 week impressionsHttp RequestService
  25. 25Get all reviewsGoogle Business ProfileService
  26. 26Set Company last week reviewsCodeLogic
  27. 27Set Company last 12 week reviewsCodeLogic
  28. 28Attach recipientsMergeLogic
  29. 29Normalize recipientsCodeLogic
  30. 30FlattenCodeLogic
  31. 31Flatten (last week)CodeLogic
  32. 32Get Many ReviewsGoogle Business ProfileService
  33. 33Flatten 12-weekCodeLogic
  34. 34All-time Reviews → KPIs (no LLM)CodeLogic
  35. 35Get last week reviewsGoogle Business ProfileService
  36. 36Get last 12 week reviewsGoogle Business ProfileService
  37. 37Group Three Lines Per CompanyCodeLogic
  38. 38Add Impressions to SheetGoogle SheetsService
  39. 39Append row in sheetGoogle SheetsService
  40. 40Map weekly reviewsCodeLogic
  41. 41Add 12 week Impressions to SheetGoogle SheetsService
  42. 42Add all time SummaryGoogle SheetsService
  43. 43Map + categorize reviews (last week, single node)CodeLogic
  44. 44map and summarize last 12 weeks reviewsCodeLogic
  45. 45All-companies SlackSlackService
  46. 46Per Company SlackSlackService
  47. 47Create EmailCodeLogic
  48. 48Merge2MergeLogic
  49. 49Add Reviews to SheetGoogle SheetsService
  50. 50Summarize Weekly Reviews (last week)CodeLogic
  51. 51Summarize 12-week reviews (totals + weekly average)CodeLogic
  52. 52Per company emailGmailService
  53. 53Join AllCodeLogic
  54. 54Summarize Weekly ReviewsCodeLogic
  55. 55formatCodeLogic
  56. 56Add Weekly SummaryGoogle SheetsService

How it's built

Starts on
A clock
Steps
56
Size
Large: read it before trusting it with anything live
Connects to
Gmail, Google Business Profile, Google Sheets, Slack
Model
OpenAI

Questions

What does it need to run?

An n8n account, plus your own Gmail, Google Business Profile, 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 56 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 56 steps before you point it at anything that matters.