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 24 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. ✅