Back to Templates

Automatic Invoice Due Date Reminders from Stripe to Google Calendar

Created by

Created by: Rahul Joshi || rahul08

Rahul Joshi

Last update

Last update 4 days ago

Share


Description

Automatically track Stripe invoices and create Google Calendar reminders for upcoming due dates. This workflow ensures you never miss a payment deadline by running daily checks, filtering invoices due within the next 7 days, and adding them to your calendar with invoice details. ⏰💳📅

What This Template Does

  • Runs daily at 8:00 AM using a scheduled trigger. ⏰
  • Fetches draft invoices from Stripe. 💳
  • Splits invoice data into individual records for processing. 🔎
  • Filters invoices due within the next 7 days. 📆
  • Prevents duplicates by checking against existing calendar events. 🔄
  • Creates Google Calendar events for valid invoices with details (ID, customer, amount). 📅

Key Benefits

  • Automated invoice due date reminders with no manual effort. ⚡
  • Avoids duplicate entries in Google Calendar. 🛡️
  • Provides a clear overview of pending payments. 👀
  • Saves time for freelancers, agencies, and finance teams. ⏱️
  • Keeps all payment reminders in one central place. 📲

Features

  • Daily schedule with cron expression (0 8 * * *).
  • Stripe API integration to fetch draft invoices.
  • Smart filtering: only invoices with due dates within 7 days are selected.
  • Google Calendar integration to check existing events and avoid duplicates.
  • Detailed calendar events with invoice ID, amount due, and customer email.
  • Customizable reminders — add customer name, invoice link, or change times.

Requirements

  • n8n instance (cloud or self-hosted).
  • Stripe API credentials with invoice read access.
  • Google Calendar OAuth2 credentials with event write permissions.
  • Access to the target Google Calendar (replace placeholder with your own).

Target Audience

  • Freelancers and solopreneurs managing invoices. 👩‍💻
  • Agencies tracking multiple client invoices. 🏢
  • Finance and accounting teams requiring automated reminders. 📊
  • Businesses wanting to automate payment follow-ups. 💼
  • Remote teams centralizing billing schedules. 🌍

Step-by-Step Setup Instructions

  • Configure Stripe API credentials in n8n.
  • Add Google Calendar OAuth2 credentials with access to your target calendar.
  • Replace the placeholder calendar ID ([email protected]) with your actual calendar.
  • Import this workflow into n8n.
  • Test the workflow by creating a test draft invoice in Stripe with a due date in the next 7 days.
  • Verify the Google Calendar event is created with the invoice details.
  • Enable the workflow to run daily and enjoy hands-free invoice tracking. ✅