Customer Reminder

Provides an MCP server that reads customer reminders from Google Sheets and sends scheduled email reminders via Gmail SMTP.

python

GitHub Stars

python

Language

7 months ago

First Indexed

3 months ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "preshlele-reminder-mcp": {
      "command": "python",
      "args": [
        "mcp_reminder_server.py"
      ],
      "env": {
        "EMAIL_HOST": "smtp.gmail.com",
        "EMAIL_PORT": "587",
        "EMAIL_PASSWORD": "YOUR_APP_PASSWORD",
        "EMAIL_USERNAME": "YOUR_EMAIL@gmail.com"
      }
    }
  }
}

You can run a dedicated MCP server that reads customer reminders from Google Sheets and sends personalized email reminders on schedule. It exposes tools to check reminders, send them, and view data and history, all accessible through an MCP client for automated workflows and integrations.

How to use

Use an MCP client to connect to the reminder MCP server and invoke its tools to manage customer reminders. Start by running the MCP server in normal mode to expose the available endpoints, then call tools like check_due_reminders, send_reminder, and get_customer_reminders as part of your automation flow. You can also run the server in test mode to verify Google Sheets access and see which tools are available.

How to install

Prerequisites: Install Python 3.8 or newer and ensure you have internet access to install dependencies.

# 1) Install dependencies
pip install -r requirements.txt

# Or install individually
pip install python-dotenv gspread oauth2client apscheduler

Set up Google Sheets API credentials by copying and configuring the credentials file.

cp credentials.example.json credentials.json

Place your actual Google service account credentials in credentials.json. Never share this file publicly.


3) Create and configure the environment file with your Gmail, Google Sheets, and scheduler settings.

cp .env.example .env


Edit the .env file to include your actual values. Example values are shown here for reference.

# Email Configuration (Gmail)
EMAIL_HOST=smtp.gmail.com
EMAIL_PORT=587
EMAIL_USERNAME=your_email@gmail.com
EMAIL_PASSWORD=your_app_password

# Google Sheets Configuration
GOOGLE_CREDENTIALS_FILE=credentials.json
GOOGLE_SPREADSHEET_NAME=Customer_reminder

# Scheduler Configuration
DEFAULT_INTERVAL_MINUTES=6

Run and test the server

Start the MCP server in normal mode to expose the MCP tools and resources.

python mcp_reminder_server.py

Test the server configuration and Google Sheets connection to ensure everything is wired correctly.

python mcp_reminder_server.py --test

Available tools

send_reminder

Sends a single reminder to a customer using the configured Google Sheet data and message template.

check_due_reminders

Checks for reminders that are due today or overdue and sends them in batch.

get_customer_reminders

Retrieves customer reminder data from Google Sheets.

get_sent_reminders

Retrieves the history of reminders that have been sent.

get_sheet_status

Checks the connection and status of the Google Sheets integration.

Built by

VeilStrat

AI signals for GTM teams