πŸ—„οΈ Data & StorageIntermediate🧠 AI-powered

Business Analysis Workflow (20 Oct 2025)

A 34-step data & storage automation, triggered by form, connecting HTTP / REST API, Perplexity, Google Gemini, Google Drive, Google Sheets, Gmail and more, with built-in AI reasoning.

⬇ Download workflow JSON
πŸ’‘

What this does for your business

In plain terms: this keeps your systems in sync. It moves and updates information across Perplexity, Google Gemini, Google Drive, Google Sheets whenever it receives a request or form submission, so you never copy-paste between tools again.

34
Nodes
7
Integrations
33
Connections
Form
Trigger

πŸš€ Deploy this workflow

Deploy this automation in minutes

Log in and we'll walk you through every key step by step, then deploy it for you.

Get started free Log in

πŸ—οΈ Architecture diagram

The real node graph exported from n8n β€” triggers (green), AI nodes (violet), services and logic β€” laid out as they run.

β€’Get Country & Languag…codeβ–ΆSubmit FormformTrigger🌐URL_searchhttpRequestToolβ€’Insert Page Ranked Ke…dataTableβ€’Split OutsplitOutβ€’Session IDcodeβ€’insert_row_in_data_ta…dataTableToolπŸ”Žonline_SearchperplexityToolβ€’Prepare Ranked Keywor…setβ€’Aggregate Allaggregate🧠serp_SearchtoolWorkflow🧠ai_ModetoolWorkflow🧠Think_tooltoolThinkπŸ”Ždeep_researchperplexityTool🌐Get Page Ranked Keywo…httpRequest✨Business AnalystgoogleGeminiβ€’Prep keywordssetβ€’Get Session Dataset🧠get_internal_linkstoolWorkflowβ€’Get Business DatadataTableπŸ—‚οΈMake Copy of TemplategoogleDriveπŸ—‚οΈGenerate PDFgoogleDriveπŸ—‚οΈAdd PDF To DrivegoogleDriveβ€’Get Ranked keywordsdataTableβ€’Prepare Keywordssetβ€’Aggregate KeywordsaggregateπŸ“ŠAppend row in sheetgoogleSheetsπŸ“ŠCreate spreadsheetgoogleSheetsβ€’Get All DatasetπŸ—‚οΈGenerate DocgoogleDriveπŸ—‚οΈAdd Doc to DrivegoogleDriveβ€’Get LinkssetπŸ“§Send emailgmailπŸ“„Change Variables in D…googleDocs

βš™οΈ How it works

  1. Submit Form Β· formTrigger
  2. URL_search Β· httpRequestTool
  3. insert_row_in_data_table Β· dataTableTool
  4. online_Search Β· perplexityTool
  5. serp_Search Β· toolWorkflow
  6. ai_Mode Β· toolWorkflow
  7. Think_tool Β· toolThink
  8. deep_research Β· perplexityTool
  9. get_internal_links Β· toolWorkflow
  10. Get Country & Language Code Β· code
  11. Business Analyst Β· googleGemini
  12. Session ID Β· code
  13. Get Page Ranked Keywords Β· httpRequest
  14. Split Out Β· splitOut

πŸ’Ό Business analysis

🎯

Business use case

A data pipeline that moves, syncs and transforms records across HTTP / REST API, Perplexity, Google Gemini, Google Drive, Google Sheets, Gmail and more β€” the plumbing that keeps systems of record consistent without manual exports.

πŸ“ˆ

Market need

Disconnected tools create silos and manual re-entry. Reliable sync pipelines are foundational infrastructure every scaling company needs.

πŸ’°

Market value

Integration/ETL work bills $100–$200/hr bespoke; a reliable pipeline template saves days of engineering per deployment.

🧩 Integrations & stack

🌐HTTP / REST APIπŸ”ŽPerplexity✨Google GeminiπŸ—‚οΈGoogle DriveπŸ“ŠGoogle SheetsπŸ“§GmailπŸ“„Google Docs
Node typescode, formTrigger, httpRequestTool, dataTable, splitOut, dataTableTool, perplexityTool, set, aggregate, toolWorkflow, toolThink, httpRequest, googleGemini, googleDrive, googleSheets, gmail, googleDocsWorkflow IDYz71vR8wFxpGVCAD
⬇ Download workflow JSON ← Back to library