Quick Overview
This workflow opens an n8n chat interface where an AI agent powered by Anthropic Claude answers questions by reading a connected Google Doc and/or Google Sheet on demand, using short-term conversation memory for follow-up questions.
How it works
- Receives a user question through n8n’s built-in chat trigger.
- Uses an AI agent powered by Anthropic Claude to decide whether it needs to consult Google Docs, Google Sheets, or both.
- Reads the full text of the configured Google Doc when the question is about document content.
- Fetches rows from the configured Google Sheet tab when the question is about spreadsheet data.
- Answers in the chat based only on the retrieved Doc/Sheet content (or states the information isn’t present), while keeping the last 10 messages in memory for contextual follow-ups.
Setup
- Add credentials for Anthropic (Claude), Google Docs, and Google Sheets.
- Replace
YOUR_GOOGLE_DOC_ID_OR_URL with your target Google Doc URL or ID.
- Set the Google Sheet document ID and choose the tab (sheet name) to read in the Google Sheets tool.
- Confirm the connected Google account has access to both the Doc and the Sheet, then open the workflow chat and start asking questions.