Automate Client Invoicing & Payments with Stripe, Google Sheets, Drive and Gmail

Google Sheets → Stripe Payment Automation Workflow

📌 Overview
This workflow automates the end-to-end process of generating and sending client payment links using Google Sheets and Stripe.

Whenever a new or updated entry is added to the Google Sheet, the workflow will:
Fetch client and invoice details.
Create a Stripe Product and Price.
Generate a Stripe Payment Link.
Store the link back in the Google Sheet.
Upload a copy of the invoice to Google Drive.
Send a professional, formatted email with the payment link to the client using Gmail.

🔗 Demo Video: Watch on YouTube

⚡️ Workflow Steps
Trigger – The workflow is triggered on any update in the Google Sheet.
Filter – Ensures only relevant rows (e.g., PENDING invoices) proceed.
Stripe Automation
Create Stripe Product
Create Stripe Price
Generate Stripe Payment Link
Google Drive – Store invoice files (if required).
Google Sheets – Update the sheet with the generated Stripe Payment Link and timestamp.
Gmail – Send a client-facing email with the invoice details and payment link.

🛠 Setup Guide

Prerequisites
n8n account**
Google Sheets & Google Drive credentials**
Gmail API credentials**
Stripe API Key**

Steps
Clone/Import Workflow
Import the workflow JSON file into your n8n instance.

Configure Google Sheets
Create a Google Sheet with columns:
Order ID, Client Name, Client Email, Items Description, Due Date, Amount, Currency, Invoice Status, Invoice Link, Stripe Payment Link, Last Updated
Connect your Google Sheets node to this sheet.

Set Up Stripe
Obtain your Stripe Secret Key from Stripe Dashboard.
Add it in the Stripe nodes for Product, Price, and Payment Link creation.

Google Drive
Configure to store invoice backups (optional).

Gmail
Authorize Gmail and set up the Send Email node.
Customize the email template with client details and the Stripe link.

Test the Workflow
Add a sample row in Google Sheets.
Run the workflow manually or update the sheet to trigger automatically.
Verify that the Stripe link is created, updated in the sheet, and emailed to the client.

✅ Now your workflow is ready to automatically manage client invoices and payments with Stripe + Google Sheets + Gmail + Google Drive.