Import Google Keep Notes to Sheets with OpenAI & Drive

This n8n workflow streamlines the process of exporting unstructured Google Keep notes from Google Takeout JSON files into a searchable, filterable Google Sheet. It searches a specified 'Keep' folder in Google Drive for relevant JSON files, processes them in batches of 10, filters by extension, downloads and extracts note content, applies optional filters for non-archived notes, and uses OpenAI for AI-powered summarization or transformation before appending to Sheets.

Ideal for researchers, knowledge workers, and digital minimalists, it solves the pain of managing raw Keep exports by creating structured data with fields like title, content, labels, and AI insights. This enables easy searching, filtering, and analysis in Sheets, saving hours of manual data entry and organization.

Key benefits include batch processing for efficiency, customizable AI prompts for note enhancement, and seamless updates to your Sheet. Setup requires Google Takeout export to Drive and credentials for Drive, Sheets, and OpenAI. Perfect for ongoing note management or one-time migrations.