About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Recording new Stripe Invoice in google sheets

  • 13 September 2023
  • 6 replies
  • 42 views
B
Userlevel 1

Hi there, I am new to Zapier and am working on creating a google sheet database for all of the Stripe Invoices I’ve sent out. I have a Zap in place that creates a new row in a spreadsheet ever time a new invoice is created in Stripe. 

 

The trouble I am having is that my zap is pulling in a draft of the invoice to google sheets before I’ve inputted the amount we are charging and sent it to our customer. The record then shows an amount of zero instead of what is actually be charged to the customer. I believe this may have something to do with the Trigger being instantaneous but am unsure. Any help would be appreciate! 

icon

Best answer by Troy Tessalone 13 September 2023, 21:26

View original

6 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @BillyM 

Good question.

One option would be to configure these Zap steps:

  1. Trigger: Stripe - New Invoice
  2. Action: Delay - For
    1. e.g. 5 minutes
  3. Action: Stripe - Find Invoice
  4. Action: GSheets - Add Row

 

Or you may have to use Stripe Webhooks: https://dashboard.stripe.com/webhooks

Zap trigger: Webhook - Catch Hook

This will generate a unique webhook URL to configure in Stripe.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
B
Userlevel 1

@Troy Tessalone Thanks for the response. 

 

I tried option 1 and am still seeing the same result. Is there anything I need to update on the google sheets action?

Troy Tessalone
Userlevel 7
Badge +14

@BillyM 

We would need to see detailed screenshots with how your Zap steps are configured.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
B
Userlevel 1

@Troy Tessalone detailing the steps for the find invoice and create row. 

 

Troy Tessalone
Userlevel 7
Badge +14

@BillyM 

You need to map the variables from Step 3.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
B
Userlevel 1

@Troy Tessalone Thank you, that worked!

Reply


Terms & Conditions