🔬 Summarize text with RapidAPI and log results to Google Sheets
⚡ 407 views · 🔬 Document Extraction & Analysis
Description
✨ AI Text Summarizer with Google Sheets Logging
Summarize large blocks of text into concise outputs using the Text Summarizer AI API and automatically log results in Google Sheets. This automation is ideal for content creators, marketers, researchers, and teams who need efficient summarization and record-keeping—without writing a single line of code.
🚀 Features
| Feature | Description |
|---|---|
| Web Form Trigger | Collects title, content, mode (Paragraph/Bullet), and length preferences. |
| API Integration | Sends content to Text Summarizer AI API via RapidAPI. |
| Conditional Logic | Routes success and error cases appropriately. |
| Google Sheets Logging | Stores summaries or error messages into Google Sheets. |
| Error Handling | Captures failed summaries and ensures no data is lost. |
🧠 Problem Solved
Manually summarizing long-form content is time-consuming and repetitive. Storing this output in structured logs (like Google Sheets) adds an extra layer of manual effort.
This workflow solves that by:
- 🔁 Automating AI-driven summarization using Text Summarizer AI API.
- 📊 Storing results (or fallback errors) directly into a Google Sheet.
- ✅ Ensuring no request goes unlogged—even on API failure.
🎯 Use Cases
- 📝 Blog Writers: Quickly convert articles into summaries for social captions.
- 📚 Students: Break down textbook or lecture content.
- 🧠 Knowledge Management: Turn raw meeting notes into concise summaries.
- 📢 SEO Teams: Use bullet-point output for schema markup or meta descriptions.
🧩 Nodes in the Flow
| Node Name | Purpose |
|---|---|
| On form submission | Captures user input via form (title, content, mode, length). |
| Mapping | Formats input to match Text Summarizer AI API specs. |
| HTTP Request | Sends POST request to the summarization API on RapidAPI. |
| If | Validates whether a summary was returned. |
| Wait | Adds short delay before writing to spreadsheet (success). |
| Google Sheets | Appends summary data to Google Sheet. |
| Wait1 | Adds delay for error handling path. |
| Google Sheets1 | Logs failure with an “Error occurred” message. |
✅ Benefits
- 🧠 AI-Powered: Uses Text Summarizer AI API for fast and contextual summaries.
- 📁 Organized Logs: Google Sheets integration ensures easy tracking and auditing.
- 🔐 Reliable: Captures all submissions, including failed ones.
- 🧩 Customizable: Easily adapt inputs or connect to other tools like Notion, Slack, or Airtable.
🛠️ Requirements
- ✅ n8n account (Cloud or Self-Hosted)
- ✅ Access to Text Summarizer AI API
- ✅ Google account (for Sheets integration)
- 🔑 API key from RapidAPI (used in the HTTP Request node)
🔄 Workflow Overview
- User submits text and preferences (mode, length) via a form.
- Workflow triggers and transforms the input.
- Formatted data is sent to the Text Summarizer AI API.
- If a valid summary is returned:
- Log it into Google Sheets.
- If the API fails:
- Log the error message instead.
📥 Import Instructions
- Open n8n and import the workflow JSON.
- Replace the
x-rapidapi-keyin the HTTP node with your personal RapidAPI key. - Configure your Google Sheets credentials.
- Deploy and test. ✅
🔗 Suggested Extensions
- 🟢 Notion database logging
- 🟣 Slack/Discord notification for each summary
- 🔵 CSV download or Airtable sync
🏷 Tags
ai summarization text-processing rapidapi google-sheets automation markdown n8n Text Summarizer AI API
Create your free n8n account and set up the workflow in just a few minutes using the link below:
Save time, stay consistent, and grow your LinkedIn presence effortlessly!
🔗 Nodes Used
Google Sheets, HTTP Request, n8n Form Trigger
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File