Automate your invoicing: connect Stripe, Notion and Gmail in one workflow

Managing invoices manually is often a significant time drain for business owners, freelancers, and operations managers. From tracking payments to updating records and sending confirmations, these repetitive tasks can take valuable hours away from core business activities. Mistakes are also common, leading to confusion and potential cash flow issues.

Imagine a system where a client pays you via Stripe, and automatically, that payment is recorded in Notion and a personalized confirmation email is sent via Gmail. This isn't futuristic tech; it's a practical automation you can set up today. This tutorial will guide you through connecting Stripe, Notion, and Gmail into one seamless workflow, freeing you to focus on growing your business.

Why this matters

Automating your invoicing workflow offers multiple benefits. Firstly, it saves you significant time. No more manual data entry, record updates, or drafting individual emails for each payment. Secondly, it drastically reduces human error, ensuring your records are accurate and up-to-date. This improves financial tracking and makes reconciliation much easier.

Beyond efficiency, automation provides a professional touch. Clients receive instant payment confirmations, enhancing their experience and building trust. For you, it means better cash flow visibility, peace of mind, and the ability to scale your operations without getting bogged down by administrative tasks. This setup helps you maintain clarity and control over your finances with minimal effort.

Step-by-step guide

To build this automation, we will use Make.com (formerly Integromat) as the integration platform. Make.com provides a visual builder to connect your apps without needing to write any code.

1. 1. Set up your accounts

   Before you begin, ensure you have active accounts for:

   • Stripe: Your payment processing platform.
   • Notion: For your invoice tracking database.
   • Gmail: For sending payment confirmations.
   • Make.com: Your automation platform. Sign up for a free account.

2. 2. Prepare your Notion database

   In Notion, create a new database (e.g., "Invoice Payments"). Set up the following properties (columns):

   • Invoice ID: Text property (or ID property if Notion allows).
   • Client Name: Text property.
   • Client Email: Email property.
   • Amount Paid: Number property.
   • Payment Date: Date property.
   • Stripe Receipt URL: URL property.
   • Status: Select property with options like "Paid".

   This database will serve as your central record for all automated payment confirmations.

3. 3. Create your workflow in Make.com

   Log in to Make.com and click "Create a new scenario". This is where you'll build your automation.

4. 4. Add Stripe as the Trigger

   Click the large "+" button and search for "Stripe". Choose the "Watch Events" module. Configure it as follows:

   • Connection: Connect your Stripe account. Make.com will guide you through authenticating.
   • Event type: Select "Payment Succeeded". This means the workflow will run every time a payment successfully goes through Stripe.
   • Limit: Set to "1" for testing, then adjust as needed.

   Save this module. Make.com will now listen for successful payments in your Stripe account.

5. 5. Connect Notion to record the payment

   Click the "Add another module" button next to your Stripe module and search for "Notion". Choose the "Create a Database Item" module. Configure it:

   • Connection: Connect your Notion account. You'll need to give Make.com access to your "Invoice Payments" database.
   • Database ID: Select your "Invoice Payments" database.
   • Map properties: This is where you link data from Stripe to your Notion columns.
   • Invoice ID: Map to Stripe's "Charge ID" or "Payment Intent ID".
   • Client Name: Map to Stripe's "Customer Name" or "Customer email" (if name isn't available, you can parse it from email or use the full email).
   • Client Email: Map to Stripe's "Customer Email".
   • Amount Paid: Map to Stripe's "Amount". Remember to convert from cents to dollars/rupees if necessary (e.g., divide by 100).
   • Payment Date: Map to Stripe's "Created" timestamp.
   • Stripe Receipt URL: Map to Stripe's "Receipt URL".
   • Status: Manually set this to "Paid" (since this workflow only triggers on successful payments).

   Save this module. Now, every successful Stripe payment will create a new entry in your Notion database.

6. 6. Send a payment confirmation email via Gmail

   Click "Add another module" after your Notion module and search for "Gmail". Choose the "Send an Email" module. Configure it:

   • Connection: Connect your Gmail account.
   • To: Map to the "Client Email" property from the previous Stripe module.
   • Subject: Create a clear subject line, e.g., "Payment Confirmation for Your Invoice [Map Stripe's Charge ID here]".
   • Content: Write a friendly, personalized email. Use variables mapped from Stripe to include details like the client's name, amount paid, and the Stripe receipt URL. Example:

     Dear [Stripe Customer Name],
     
     This is to confirm we have received your payment of [Stripe Amount] for invoice [Stripe Charge ID] on [Stripe Payment Date].
     
     You can view your full receipt here: [Stripe Receipt URL]
     
     Thank you for your business!
     
     Sincerely,
     [Your Name/Company Name]

   Save this module.

7. 7. Test and activate

   Before activating, thoroughly test your scenario. You can run the scenario once manually in Make.com and then make a test payment through Stripe to see if the Notion entry is created and the email is sent correctly. Once satisfied, click the "ON" toggle switch at the bottom of the Make.com scenario editor to activate your automation.

Pro tips

• Error Handling: Make.com allows you to set up error routes. Consider adding a module to send you an internal email if any step in the workflow fails, so you can investigate manually.
• Customization: Don't limit yourself to the basic fields. You could add more Notion properties for tax categories, project names, or add attachments to your Gmail emails (e.g., a branded PDF invoice if you generate one separately).
• Testing is Key: Always test with real (but small) transactions before activating a workflow fully. This helps catch any mapping errors or unexpected behaviors.
• Security: Be mindful of the data you're sharing between applications. Make.com uses secure OAuth 2.0 for connecting accounts, but always ensure your API keys and connections are handled responsibly.

FAQ

Q1: What if I don't use Notion? Can I use Google Sheets instead?

A: Absolutely! Make.com integrates with hundreds of apps, including Google Sheets. You can replace the Notion module with a Google Sheets module to "Add a Row" with similar payment data.

Q2: Can this workflow also send reminder emails for unpaid invoices?

A: This specific workflow triggers on *successful payments*. To send reminders for unpaid invoices, you would build a separate workflow. This typically starts with Notion (or Google Sheets) watching for invoices marked "Unpaid" and then uses a scheduled trigger to send Gmail reminders based on the due date.

Q3: Is my client's data secure with this automation?

A: Yes, when configured correctly. Stripe, Notion, Gmail, and Make.com are reputable platforms with strong security measures. Your data is passed securely between these services via encrypted connections (APIs). Always ensure you connect your accounts via the official authentication methods provided by Make.com.

Written by Vangari Sai Sampath, Automation Specialist · Integration Directory · Hyderabad, India