Skip to main content
  • Home
  • Get Help
  • How Do I
  • How do I create a Google Sheet summary of weekly Stripe payouts with invoice and customer details?

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?

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

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?

@Oliver21

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

 

@Troy Tessalone,

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

@Oliver21 

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

@Troy Tessalone 

 

Perfect! I will do this. Thanks a lot!

Terms & Conditions