How do I auto-distribute Stripe payments into separate Google Sheets tables?

Yes, it is possible to automate organizing your Stripe payments into different tables in Google Sheets based on the product. This can be achieved through automation tools or scripts.

I think there isn't a direct native integration between Stripe and Google Sheets that allows you to automatically split payments into different tables based on the product.

Here's how you might approach this:

Stripe Webhooks: Use Stripe Webhooks to get real-time data about events in your Stripe account. You can set up a webhook to be notified when a payment is successful.

Google Apps Script: Write a Google Apps script that is triggered by the webhook notification. This script should parse the information about the payment, determine the product, and then append the data to the appropriate table in your Google Sheets.

Google Sheets: Organize your Google Sheet with separate tables for each product.

As for the plan needed, both Stripe and Google Sheets offer various plans, but the specific plan you need depends on your business.

Thank you for your reply. I am using payments links, directly shared with my clients by email, what endpoints URL should I put with Stripe Webhooks? thank you!

Hi @MDufort 

Here’s a different approach...use Airtable instead of GSheets.

Airtable has Views, which are segments of data. (sort, filter, etc.)

You can easily create 1 View per product all within the same Table.