Automatic invoice due date reminders from Stripe to Google Calendar

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