charmaine

charmaine

Notion_GCal_Sync

Syncs my Google Calendar with Notion to generate meeting prep

Public

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.

/

Viewing readonly version of main branch: v4

View latest version

Calendar to Notion Meeting Prep

This project automatically:

Checks your Google Calendar every morning for upcoming user meetings
Identifies meetings with external users (non-@val.town email addresses)
Creates a meeting prep page in Notion for each user meeting
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