Generate Study Notes in Notion
Reads topics from a Google Sheet, researches each one online, writes detailed study notes with examples and analogies, and saves them as formatted Notion pages.
Ever sat down to study a new topic and spent more time finding good resources than actually learning? You open ten tabs, skim through articles, copy-paste bits into a doc, and somehow your "notes" end up being a mess of half-written bullet points.
That's exactly why this workflow exists. It takes a topic you want to learn, researches it across the internet, writes detailed and well-structured notes (with examples and analogies), and saves everything as a clean Notion page. All you have to do is type a topic into a Google Sheet.
What It Does
- Reads your list of topics and concepts from a Google Sheet.
- Filters out topics you've already processed, so nothing runs twice.
- Searches the internet for each topic to find quality articles and resources.
- Writes detailed, structured learning notes using an AI agent, complete with examples and analogies.
- Creates a new Notion page for each topic with all the formatted content.
- Extracts metadata to keep things tidy.
- Marks each topic as "Done" in your Google Sheet so it gets skipped on the next run.
What You Need
- A Google account with access to Google Sheets.
- A Notion account (connected via the Notion MCP connector in Needle).
- A Google Sheet set up with at least the columns described below. Leave the Status column blank for new topics.
| Column | Header | Description |
|---|---|---|
| A | Topic | The subject you want to learn about |
| B | Concepts to cover in that topic | Specific concepts or subtopics to include |
| C | Status | Left blank for new topics; automatically set to "Done" after processing |
How the Flow Works
Manual Trigger kicks off the workflow whenever you're ready. Just hit "Test" or run it manually. You can also swap this out for a scheduled trigger if you want it to run daily or weekly on its own.
Read Google Sheet pulls all the rows from your sheet, including the topic name, the concepts you want covered, and the current status. This is your master list of everything you want to learn.
Filter New Topics is a code node that looks at the Status column and filters out any row already marked "Done." Only fresh topics get processed. You can keep adding new rows to the same sheet and re-run the workflow without worrying about duplicates.
Research & Write Notes is where the real work happens. For each topic, an AI agent searches the internet to find detailed articles, tutorials, and examples. Then it writes comprehensive learning notes covering all the concepts you listed. Think of it like having a tutor who reads everything online and hands you a perfectly organized summary with real-world analogies, code examples (if relevant), and clear explanations. It runs in parallel for each topic, so multiple topics get processed at the same time.
Save to Notion takes the notes generated in the previous step and creates a brand-new Notion page for each topic. The page title matches your topic, and the full content is saved right there in Notion — formatted and ready to read. No more copying and pasting between apps.
Clean Data is a small utility step that extracts the topic name and Notion URL so the next step knows exactly which row to update in your sheet.
Mark as Done goes back to your Google Sheet, finds the row for the topic that was just processed, and updates the Status column to "Done." This closes the loop so the topic won't be picked up again on future runs.
Workflow Summary
| Step | Node | What It Does |
|---|---|---|
| 1 | Manual Trigger | Starts the workflow on demand |
| 2 | Read Google Sheet | Pulls all topics and their statuses |
| 3 | Filter New Topics | Removes already-processed rows |
| 4 | Research & Write Notes | Searches the web and writes detailed notes |
| 5 | Save to Notion | Creates a formatted Notion page per topic |
| 6 | Clean Data | Extracts topic name and Notion URL |
| 7 | Mark as Done | Updates the Google Sheet status to "Done" |
Output
For every topic in your Google Sheet, you get a fully written Notion page with detailed notes, examples, and explanations covering all the concepts you specified. Your Google Sheet also gets updated automatically so you always know which topics have been completed.
Tips
- You can keep adding rows to the Google Sheet at any time. The workflow only picks up rows where the Status column is empty.
- The AI agent uses internet search to pull in current and relevant information, so your notes will include up-to-date resources.
- If you want this to run on a schedule (say, every morning), just swap the Manual Trigger for a Scheduled Trigger and you'll have fresh notes waiting for you without lifting a finger.
- The quality of your notes depends on how specific you are in the "Concepts to cover" column. Instead of just writing "React," try something like "React hooks, useEffect lifecycle, custom hooks with examples." The more detail you give, the better your notes will be.
Want to showcase your own workflows?
Become a Needle workflow partner and turn your expertise into recurring revenue.
