Automate Your Google Docs Wiki with Sheets & Gemini AI

Automate Your Google Docs Wiki with Sheets & Gemini AI

Elevate your documentation process effortlessly by transforming how you build and manage wikis using Google Docs and Google Sheets, seamlessly integrated with cutting-edge Google Gemini AI technology. With this n8n workflow, simplify the creation and maintenance of a Google Docs-based wiki, dynamically indexed in Google Sheets, and harness the power of AI for fast, precise search and content retrieval.

What this workflow does

• Receives form submissions that include a Markdown (.md) or text (.txt) file upload, extracting the content into plain text for processing.
• Utilizes a Google Gemini-powered agent to navigate the Google Sheets wiki index, intelligently segmenting the document into distinct topics.
• Automatically determines if the content requires the creation of new Google Docs pages or should be appended to existing documents.
• Forges new wiki pages via an HTTP webhook for newly detected topics, populating Google Docs with the auto-generated content.
• Seamlessly updates or augments existing topics with fresh information, engaging in thoughtful curation of content by updating specific passages within existing Google Docs pages.
• Refreshes and maintains the Google Sheets index by appending or updating metadata such as topic, doc_id, keywords, summary, and last_updated details.
• Enables a chat interface powered by Google Gemini, which scours the index to provide informed responses based on the most relevant Google Doc page content.

Use cases

• Organize staff onboarding materials into well-structured Google Doc pages, indexed for easy retrieval and updates.
• Manage technical documentation across teams by autonomously maintaining and updating a knowledge base, facilitating quick access to information.
• Simplify content management by automating the transition of document uploads into a dynamically evolving wiki format, ensuring up-to-date resources.

Technical details

• Tech Stack: n8n automation workflow, Google Docs Tool, Form Trigger, Google Sheets integration
• Nodes Used: Sticky Note, Form Trigger, Google Docs Tool, n8nn8n-nodes-langchainagent, Extract from File, HTTP Request Tool