testxlog

testxlog

HomeArchives

Automatically transcribe new emails received in Outlook to Obsidian via Airtable.

31
AI Translation
This post is translated from Chinese into English through AI.View Original
AI-generated summary
The project "Xlog" involves automating the transcription of new Outlook emails into Obsidian using Airtable. ### Airtable Setup 1. Create a table named "Outlook" with fields: Title, Folder, and Content. 2. Set all Folder entries to "1-Inputs/Outlook." 3. Use Automations to create a trigger for when an email is received in Outlook. 4. Authorize your Outlook account and select the inbox for incoming emails. 5. Create a record in Airtable with the email's Subject and Body, ensuring to replace any special characters in the Title to comply with Obsidian's naming rules. ### Obsidian Setup 1. Use the Airtable2Obsidian sync script. 2. Create a new folder for syncing, e.g., "Outlook," and an empty note within it. 3. Press `alt+a` to check for new records in Airtable and download them into the designated Obsidian folder. ### Unresolved Issues - There are occasional emails with attachments, and it would be beneficial to download these attachments into Obsidian as well.

Automatically transcribe new emails received in Outlook to Obsidian via Airtable#

1. Airtable Setup#

  • Create a new table, temporarily named Outlook
  • Include fields Title, Folder, Content
  • Fill all Folder entries with 1-Inputs/Outlook
  • Click Automations to start Create automation
  • Give the automation a random name
  • Click Add trigger and select Outlook Email and When email is received
  • Initially, fill in the Outlook email account from CONFIGURATION and confirm authorization via email
  • After that, just select the Outlook Email account from Select account
  • Click Folder to choose a folder for received emails; I still choose the inbox
  • Click Add advanced logic or action and select Create record
  • Name it in Description, for example, Transcribe new email
  • Select the Outlook table created earlier in Table
  • Click Choose field in Fields
  • Choose Title and Content
  • In Title, select Subject
    • But to sort by received date in Obsidian later, you can first select Received
    • Note the following pitfalls!
    • The date and time will include special characters like English colons
    • Titles with these characters will be used as note names after downloading to Obsidian
    • These special characters do not comply with naming rules in Obsidian
    • There will be no error when syncing with Obsidian, but it will not succeed
    • Therefore, you need to handle special characters that are not allowed in naming rules in Airtable first
    • For example, English colons, slashes, etc., can be automatically replaced with hyphens that do not affect readability
  • In Content, sequentially select Body
  • Click Generate a preview to generate a preview and Run tests
  • Now try sending a new email to your Outlook account
  • If all goes well, a new record will be added to the Outlook table in Airtable

2. Obsidian Setup#

  • Use the Airtable2Obsidian sync script
  • Add a sync folder, such as Outlook
  • Create a new empty note in this folder
  • Open this note and press the alt+a shortcut key
  • It will first check the number of new records in Airtable
  • Then prompt to batch download the contents of the Airtable Outlook table to the Outlook folder in the Obsidian library
  • My folder is 1-Inputs/Outlook
  • Thus, you no longer need to log in to Outlook to check emails

3. Unresolved Issues#

  • Occasionally, there are emails with attachments
  • It would be even better if attachments could also be downloaded to Obsidian
  • photo by Mediamodifier(https://unsplash.com/@mediamodifier?utm_source=templater_proxy&utm_medium=referral&fit=crop&mask=corners) on Unsplash
Loading...
Ownership of this post data is guaranteed by blockchain and smart contracts to the creator alone.