Skip to main content
Best answer

How do I create a Google Sheet summary of weekly Stripe payouts with invoice and customer details?

  • February 8, 2024
  • 6 replies
  • 108 views

Forum|alt.badge.img

Hi all,

I use Stripe as my payment provider. For my accounting I need a summary of which sales were paid out with which payout.

I currently have Stripe pay out once a week. I would now need a summary of which payments are included in this payout, including invoice and customer name and amount.

I would like to create a Google Sheet for this. The form in which this is entered in Google doesn't matter for now. Whether each payment gets its own spreadsheet or its own table.

Does anyone have any suggestions on how I can realize this?

Best answer by Troy Tessalone

@Oliver21

You may have to explore using the Stripe API via one of these advanced actions:

 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

6 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • February 8, 2024

Hi @Oliver21 

Have you reviewed the available Zap triggers/actions for each app?

Stripe: https://zapier.com/apps/stripe/integrations#triggers-and-actions

GSheets: https://zapier.com/apps/google-sheets/integrations#triggers-and-actions


Forum|alt.badge.img
  • Author
  • Beginner
  • February 9, 2024

Hi @Troy Tessalone,

 

yes I have. 

Unfortunately, I couldn't find a suitable trigger. So I thought there might be other suggestions on how to implement this task.

I know that Stripe offers IDs for this. Do you know if you can trigger them with Zapier?


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Answer
  • February 9, 2024

@Oliver21

You may have to explore using the Stripe API via one of these advanced actions:

 


Forum|alt.badge.img
  • Author
  • Beginner
  • February 10, 2024

@Troy Tessalone,

wow. thanks a lot! That sounds good. Do you know somebody who can help me with that?
 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • February 10, 2024

@Oliver21 

If you need help, consider hiring a Certified Zapier Expert: https://zapier.com/experts


Forum|alt.badge.img
  • Author
  • Beginner
  • February 11, 2024

@Troy Tessalone 

 

Perfect! I will do this. Thanks a lot!