Notion to Pinecone Sync Workflow for Vapi Assistants (n8n)

Keep Your Vapi Assistants’ Knowledge in Lockstep with Notion (Automated Daily Sync)

This n8n workflow automatically pulls your knowledge base content from Notion, generates OpenAI embeddings, upserts vectors into Pinecone, and uploads refreshed, language-specific knowledge files to Vapi—so your assistant’s query tool and configuration stay synchronized.

What this workflow does

• Runs daily at 2:00 AM using a schedule trigger.
• Clears existing Pinecone vectors for the configured namespace and waits briefly for deletion to complete.
• Fetches pages from multiple Notion databases (services, FAQ, scripts, dialogue tree, objections, and disclaimers), then merges them into tagged, language-aware text records.
• Splits text into chunks, generates OpenAI embeddings, and upserts the vectors into your specified Pinecone index.
• Builds two consolidated knowledge base files—one per language—using the Notion content.
• Updates Vapi knowledge assets: deletes the previous Vapi knowledge file (if configured), uploads the new file, and creates a Vapi query tool referencing it.
• Resyncs each Vapi assistant: retrieves assistants, replaces their tool list with the newly created query tool, and logs the sync result.

Use cases

• Update a voice assistant’s answers whenever your team edits Notion FAQs, scripts, or objection handling.
• Keep multi-language assistant behavior aligned by regenerating language-specific Vapi knowledge files.
• Maintain consistent retrieval performance by refreshing Pinecone vector indexes from a single source of truth.

Technical details

• n8n nodes / components: Code, Wait, Notion, Sticky Note, HTTP Request, Schedule Trigger.
• Integrations: Notion (integration + shared pages/databases), Pinecone (HTTP header auth + vector store credentials), OpenAI embeddings, and Vapi (knowledge file + query tool + assistant tool replacement).
• Setup required: Add Notion credentials and replace database ID placeholders; add Pinecone API credentials, create/select the index name, and replace the Pinecone host URL placeholder used for vector deletion.