Turn a resume in Google Drive into a smart chat that answers questions and sends a daily email report. Ideal for personal sites, career pages, or portfolios that want simple Q&A and clear insights without manual updates.

When a file is added or changed in a chosen Google Drive folder, the text is split into chunks, embedded with Google Gemini, and stored in Pinecone. A public chat webhook lets visitors ask questions. The agent uses the vector store, a memory buffer, and the Gemini chat model to give grounded answers. A separate webhook can save conversation logs to NocoDB. Each day on schedule, the workflow pulls today’s conversations, groups them by session and email, formats them as HTML, and emails a summary from Gmail.

Setup needs Google Drive, Gmail, Pinecone, Google Gemini, and NocoDB credentials in n8n. Expect less manual work, faster updates when the resume changes, and one clear email summary at the end of the day. Use it for personal branding, HR portfolios, or team pages that need quick, accurate answers based on the latest resume content.

• Google Drive created and updated triggers watch a folder for new or changed resume files.
• Document loader and recursive text splitter prepare the resume for search and retrieval.
• Google Gemini embeddings model text-embedding-004 creates high quality vectors.
• Pinecone vector store saves and serves resume chunks for fast semantic search.
• Public chat webhook uses a Gemini chat model with memory to answer questions.
• Vector store tool lets the agent pull only relevant resume pieces for each answer.
• Optional webhook saves conversation logs to NocoDB with user, email, and session fields.
• Daily scheduler groups today’s chats by session and email, builds HTML, and sends a Gmail report.

• Reduce manual updates from hours to minutes by auto indexing new or changed resume files.
• Deliver fast and accurate answers grounded in the latest resume content.
• Connect Google Drive, Pinecone, Google Gemini, NocoDB, and Gmail in one flow.
• Handle many visitor chats at once without extra staff time.
• Get one daily email summary so you can review conversations in minutes.

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Drive, Gmail, Pinecone, Google Gemini and NocoDB. See the Tools Required section above for links to create accounts with these services.
3. In n8n, double click each integration node and in the 'Credential to connect with' dropdown, click 'Create new credential', then follow the on screen instructions to connect your Google Drive, Gmail, Pinecone, Google Gemini, and NocoDB accounts.
4. Google Drive: Open both Google Drive trigger nodes, choose your Drive and the folder that will store the resume. Save and activate the triggers.
5. Pinecone: In your Pinecone dashboard, create an index. Use a name you prefer and set dimensions compatible with text-embedding-004. Back in n8n, set the Pinecone credential on both vector store nodes and enter the same index name.
6. Google Gemini: In Google AI Studio, create an API key. In n8n, set this key on the embeddings and chat model nodes. Make sure the model names match the template settings.
7. NocoDB: Create a table with fields for user, email, ai, sessionid, date, and datetime. In n8n, set the NocoDB credential on the save and query nodes and map fields to your table.
8. Gmail: Connect your Gmail account with OAuth2 on the send email node. Choose the sender, subject, and recipients for the daily summary.
9. Schedule: Open the schedule trigger and pick the hour you want the daily report sent. Save the change.
10. Test indexing: Upload or update a resume file in the watched Drive folder. Confirm the download, split, and Pinecone index steps run without errors.
11. Test chat: Send a POST request to the chat webhook with a chatInput field. Confirm you receive a grounded answer. Optionally POST to the save conversation webhook and check NocoDB for a new record.
12. Troubleshooting: If Gmail fails, check OAuth scopes and sender access. If Pinecone errors, verify index name and dimensions. If the chat is off topic, confirm the right folder is watched and the resume text is readable by the loader.