Nightly Fathom call filing to OneDrive client folders and a Notion CRM log

By General Input

Every weekday at 7pm, sort the day's Fathom call summaries into the right OneDrive client folders and log them in a Notion customer call database.

Integrations

  • Fathom
  • Microsoft OneDrive
  • Notion

Type

Agentic Task

Categories

  • Sales
  • Operations

Every weekday at 7pm in my local time zone, run an agent that files the day's Fathom call summaries into the right OneDrive client folders and logs each call in my Notion customer call database. Trigger: cron at 19:00 Monday through Friday.

Step 1. Pull today's calls from Fathom. Use Fathom's List Meetings operation, filtered to meetings that ended in the last 24 hours, and request summaries, action items, and attendee details (including external attendee emails) in the response. Page through all results.

Step 2. Skip internal-only meetings. If every attendee's email address is on our company domain (configurable, default to the domain on the connected Fathom account), drop the meeting and move on. Only process calls that have at least one external attendee.

Step 3. For each remaining meeting, infer the client account. Use the meeting title plus the email domains of external attendees as the strongest signals (for example, two attendees from acme.com means the client is Acme). Normalize the client name into a clean folder label.

Step 4. Place the recap in OneDrive. There is a configured parent folder called Customer Calls. Use Microsoft OneDrive Search Items to find an existing client subfolder under that parent that matches the inferred client name. If none exists, use Create Folder to make one named after the client. Then format the meeting summary plus action items as a single markdown document (sections: Summary, Top Takeaways, Action Items, Attendees, Fathom Link) and upload it with Upload File (Simple). Name the file YYYY-MM-DD - <Topic>.md using the meeting date and a short topic taken from the meeting title. Before uploading, check the target folder; if a file with that exact name is already there, skip the upload and reuse the existing file instead of creating a duplicate.

Step 5. Get a shareable link. Run Create Sharing Link on the uploaded (or already-existing) OneDrive file with a view-only scope so it can be opened from Notion.

Step 6. Log it in Notion. Append one row per meeting to the Notion database titled Customer Call Log using Create a Page. The database has these columns: Client (title), Meeting Date (date), Attendees (multi-select or rich text with names and companies), Top Three Takeaways (rich text, bullet list), Action Items (rich text, bullet list with owners when Fathom provides them), and OneDrive Doc (URL pointing at the sharing link from step 5). Only create the row after the OneDrive file is in place so the link always resolves.

Reliability rules. Process meetings one at a time so a single failure does not block the rest. If Fathom returns no meetings, exit cleanly without writing to OneDrive or Notion. Respect Fathom's 60-requests-per-minute limit and Microsoft Graph throttling (honor any Retry-After headers). At the end of the run, log how many calls were filed, how many were skipped as internal-only, and how many were skipped as duplicates.

Related prompts

Explore more prompts
Screen chartered vessels for AIS gaps and sanctions red flagsCompare candidate store locations with drive time trade areasBrowse every competitor ad and build a Notion swipe fileAudience persona studio for brand and product marketersArtwork desk for the Notion posts still missing an imageShare of voice dashboard for your brand and competitorsInfluencer campaign roster board with AI creator briefsSmart home entity health cockpit for Home AssistantOpen model approval desk for your production AI stackBid board that watches every procurement portal for you