File labelled email into a Notion database
Turns mail carrying a Gmail label you choose into pages in a Notion database, and never files the same message twice.
What it does
The integration steps this workflow runs, in the order it first runs them.
- 1GmailCreate label
- 2GmailList emails
- 3GmailGet message headers
- 4NotionCreate page
- 5GmailAdd label to message
How it works
Everything the template sets up, and what to fill in before the first run.
Nominate a Gmail label and a Notion database. Every hour this workflow collects the mail carrying that label and creates one Notion page per message: the subject becomes the page title, and the page itself holds who sent it, when it was sent, a link that opens the original in Gmail, and the message body. Mail that has been filed once is left alone - each message picks up a second label ('Filed to Notion' by default) the moment its page exists, and the search that finds work deliberately excludes that label, so a message is never filed twice however often the workflow runs.
Everything goes into the page's content rather than into database columns, so it works with any database whatever its columns are named. The one column it does write is the title: set 'titleProperty' if yours is not called 'Name'.
Nothing is lost when something goes wrong. A message that cannot be read or filed keeps its label, is reported in the run, and is tried again on the next sweep. Long messages are shortened to fit Notion's limit on a block of text.
To set it up, name your label in the 'gmailLabel' step and paste your database ID into the 'notionDatabaseId' step. Run Notion's 'List databases' action once if you need to find the ID, and remember to share the database with your Notion integration.
You May Also Be Interested In
Turn emails into AI-enhanced tasks in NotionEvery new Gmail email becomes a Notion task, with Claude's action items and summary already on the page.
Save matching emails to a spreadsheetSaves each new Gmail message that matches your search as a row in your spreadsheet, and never saves the same message twice.Smart email draft generatorWhen a new email arrives, Claude writes the reply you would have written and leaves it in your Gmail drafts for you to send.
Gmail alerts in SlackPosts the emails that match your subject, sender or label filters into a Slack channel as they arrive.
Start from a workflow that already works.
Add "File labelled email into a Notion database" to your workspace, connect its apps, and make it yours. No credit card required.
Free plan available · No credit card required