Automation library · Research and reporting

Generate comprehensive business analysis reports with Gemini

Started by someone submitting a form, and works across Gmail, Google Docs, Google Drive and n8n data table. It hands the judgement calls to Gemini. 23 steps: large, and worth reading before you trust it with anything live.

LargeCalls a model: Gemini

23 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 5Logic 5Service 12

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

  1. 1Submit FormForm triggerStarts it
  2. 2URL_searchHttp Request ToolService
  3. 3insert_row_in_data_tableData Table ToolService
  4. 4online_SearchPerplexity ToolService
  5. 5serp_SearchTool WorkflowModel
  6. 6ai_ModeTool WorkflowModel
  7. 7Think_toolTool ThinkModel
  8. 8deep_researchPerplexity ToolService
  9. 9get_internal_linksTool WorkflowModel
  10. 10Get Country & Language CodeCodeLogic
  11. 11Business AnalystGoogle GeminiModel
  12. 12Session IDCodeLogic
  13. 13Get Business DataData TableService
  14. 14Get All DataSetLogic
  15. 15Make Copy of TemplateGoogle DriveService
  16. 16Change Variables in DocGoogle DocsService
  17. 17Generate DocGoogle DriveService
  18. 18Add Doc to DriveGoogle DriveService
  19. 19Generate PDFGoogle DriveService
  20. 20Add PDF To DriveGoogle DriveService
  21. 21Get LinksSetLogic
  22. 22Send emailGmailService
  23. 23Get Session DataSetLogic

How it's built

Starts on
Someone submitting a form
Steps
23
Size
Large: read it before trusting it with anything live
Connects to
Gmail, Google Docs, Google Drive, n8n data table
Model
Gemini

Questions

What does it need to run?

An n8n account, plus your own Gmail, Google Docs and Google Drive accounts, and a key for Gemini. You connect your own accounts after importing it; none are included.

What starts it?

It starts on someone submitting a form.

Does it use AI?

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

How long does it take to set up?

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