(5/5)

Automated Research Report Generation with OpenAI, Wikipedia, Google Search, and Gmail/Telegram

Automated workflow: Automated Research Report Generation with OpenAI, Wikipedia, Google Search, and Gmail/Telegram. This workflow integrates 18 different services: stickyNote, httpRequest, telegram, toolHttpRequest, code. It contains 43 nodes and follows best practices for error handling and security.

Integrations Used (6)

Workflow Structure (25 nodes)

100%

Execute Workflow Trigger

Executed by Main AI Agent

Google Sheets

Store Research Metadata

Google Drive

Search Folder

If Node

Manual Trigger

When clicking ‘Test workflow’

Code

Input Validation

No Op

OpenAI Chat Model1

No Op

Query Refiner

No Op

Structured Output Parser

No Op

OpenAI Chat Model

No Op

Simple Memory

No Op

Research AI Agent

No Op

Search News

No Op

Wikipedia

No Op

Google Search Web

Code

Parse Research Output

No Op

SerpApi

Split Out

Code

Merge Split Items

Aggregate

Code

Generate PDF HTML

Http Request

Convert HTML to PDF

Http Request

Download PDF

Send PDF

Gmail

Send Research to Gmail

Node Types:

default

logic

code

action

http

transform

trigger

Requires credentials

Prerequisites

Required Credentials (6)

Gmail

Used by: Send Research to Gmail

Docs

Google Drive

Used by: Search Folder

Docs

Google Sheets

Used by: Store Research Metadata

Docs

OpenAI

Used by: OpenAI Chat Model, OpenAI Chat Model1

Docs

Serp

Used by: SerpApi

Docs

Used by: Send PDF

Docs

Multiple services required

This workflow needs 6 different credentials. Make sure you have accounts for all services before importing.

Complexity

Advanced

Expert level. Custom code, complex logic, many integrations.

Setup time: ~1 hour

Score: 90/100

Custom Code

Conditional Logic

9 Integrations

When to Use This Workflow

Automated Reporting

Automatically collect and organize data into spreadsheets for analysis.

Spend less time on data entry and more time on insights.

Email Automation

Automate email responses, forwarding, or organization based on rules.

Handle routine email tasks automatically and focus on what matters.

Real-time Response

React instantly when events happen - new orders, form submissions, or API calls.

Zero delay between trigger and action for time-sensitive workflows.

workflow.json

{
  "id": "EOJfPcM9PPWI1Rmp",
  "meta": {
    "instanceId": "workflow-f03d0ee1",
    "versionId": "1.0.0",
    "createdAt": "2025-09-29T07:07:56.960705",
    "updatedAt": "2025-09-29T07:07:56.960717",
    "owner": "n8n-user",
    "license": "MIT",
    "category": "automation",
    "status": "active",
    "priority": "high",
    "environment": "production"
  },
  "name": "Automated Research Report Generation with OpenAI, Wikipedia, Google Search, and Gmail/Telegram",
  "tags": [
    "automation",
    "n8n",
    "production-ready",
    "excellent",
...