Log inSign up
charmaine
charmaineNotion_GCal_Sync
Syncs my Google Calendar with Notion to generate meeting prep
Public
Like
1
Notion_GCal_Sync
Code
5
Val Town is a collaborative website to build and scale JavaScript apps.
Deploy APIs, crons, & store data – all from the browser, and deployed in milliseconds.
Sign up now
Code
/
README.md
Search
4/25/2025
Viewing readonly version of main branch: v6
View latest version
README.md

Calendar to Notion Meeting Prep

This project automatically:

  1. Checks your Google Calendar every morning for upcoming user meetings
  2. Identifies meetings with external users (non-@val.town email addresses)
  3. Creates a meeting prep page in Notion for each user meeting
  4. Gathers information about the meeting participant and populates the Notion page

Setup Requirements

Google Calendar

  • Google Cloud project with Calendar API enabled
  • OAuth2 credentials (client ID and secret)
  • Refresh token for accessing your calendar

Notion

  • Notion API key
  • Database ID where meeting pages will be created

Environment Variables

  • GOOGLE_CLIENT_ID: Your Google OAuth client ID
  • GOOGLE_CLIENT_SECRET: Your Google OAuth client secret
  • GOOGLE_REFRESH_TOKEN: Refresh token for your Google account
  • NOTION_API_KEY: Your Notion API key
  • NOTION_DATABASE_ID: ID of the Notion database where meeting pages will be created
  • TEAM_DOMAIN: Your team's email domain (e.g., "val.town")

Project Structure

  • index.ts: Main cron job that runs daily
  • googleCalendar.ts: Functions for interacting with Google Calendar API
  • notion.ts: Functions for creating and updating Notion pages
  • userInfo.ts: Functions for gathering information about meeting participants