Import Google Keep notes to Google Sheets using OpenAI and Google Drive

This n8n workflow automates the import of your Google Keep notes into a structured Google Sheet, using Google Drive, OpenAI for AI-powered processing, and JSON file extraction. It's perfect for users who want to turn exported Keep notes into a searchable, filterable spreadsheet – optionally enhanced by AI summarization or transformation.

Who is this for? - Researchers, knowledge workers, and digital minimalists who rely on Google Keep and want to better organize or analyze their notes.

- Anyone who regularly exports Google Keep notes and wants a clean, automated workflow to store them in Google Sheets.

- Users looking to apply AI to process, summarize, or extract insights from raw notes.

What problem is this workflow solving?

Exporting Google Keep notes via Google Takeout gives you unstructured .json files that are hard to read and manage. This workflow solves that by: - Filtering relevant .json files - Extracting note content - (Optionally) applying AI to analyze or summarize each note - Writing the result into a structured Google Sheet

What this workflow does

1. Google Drive Search: Looks for .json files inside a specified "Keep" folder.