Google form followed by Stripe payment check

Hi ​@Jonboywill 

Perhaps consider this approach instead…

Use a Stripe Payment Link.

With Stripe Payment Links you can collect some additional data points.

https://docs.stripe.com/payment-links/customize#add-custom-fields

Then log the completed payments into a GSheet using a Zap.

e.g. Stripe > GSheets

Hi Troy,

I think you’ve misread my problem. 

I have a google form set up for users to complete which is effectively their membership application for the club. After they submit the google form, they then have to click a link to make a payment using Stripe. However, I want to automate the process that checks if people have actually made the payment after completing the google form. The results of the google form are saved into a google sheets so I essentially want to check when a new row is added to the sheet (a user has filled in the form), and see if they have also made their corresponding payment (using the Stripe link).

I already have a customised payment link set up, but when payments hit my Stripe account, they show up under the ‘Transactions’ tab, not payments tab and this is not an option when configuring my Zap.

Any other advice?

​@Jonboywill 

It’s unlikely that when a new GSheet row is added to that the user will have made their Stripe Payment yet.

You’ll want to have a Zap like this:

• Trigger: Stripe - Checkout Session Completed 
• Action: GSheets - Lookup Row
• Action: GSheets - Update Row
  • Used to mark a row for payment completed in a column

Is it possible to delay the Zapp unti say after 30 mins of the google sheet new row being added? that way people are likely to have had time to make the payment before the zapp checks?

​@Jonboywill 

Info about adding a Delay: https://zapier.com/apps/delay/integrations#help

Thanks Troy, that’s really helpful.

In a previous post you mentioned a stripe trigger ‘Trigger: Stripe - Checkout Session Completed’ but I can’t find this in the drop down list for actions. Would I need to create this?

Appreciating your help with this.

Jon

Hi ​@Jonboywill,

Great question, and glad Troy's reply helped! Just a heads-up: "Checkout Session Completed" is a trigger, not an action, so that you won't find it in the actions dropdown. Instead, set it in the trigger step when you choose Stripe as your app, then select "Checkout Session Completed" from the event list. This will fire whenever a Stripe Checkout Session finishes—great for post-purchase automations.

Thanks for this James. Still not having any luck, either I’m being thick or it’s not as straightforward as it seems.

I’ve connected my google sheets and entered the data I need to lookup using the input from stripe (email), however the lookup Value is asking for data that shows as blank in my Stipe e.g. when a customer completes a transaction in Stripe, their email gets saved as their ‘name’, but when I search Name on the stripe input fields, they all show as ‘blank’. I’ve included some screenshots below to help, as well as a screenshot from my stripe transactions page.

Hi ​@Jonboywill,

Thanks for sharing the details and screenshots—you're close! The issue is that your Stripe trigger's "Customer Email" field returns no data, so your Google Sheets lookup isn't working. Try switching your Stripe trigger to "New Payment" or "Checkout Session Completed," which usually includes the customer's email. After re-testing the trigger, look for fields like customer_email or billing_details.email, and use that for your lookup value. Also, ensure your Google Sheet column is labeled exactly "Email address" with no extra spaces. If email still isn't coming through, consider adding a "Find Customer in Stripe" step using the customer ID to retrieve the email before the lookup.

Let me know if you need help connecting it to other actions, like creating an invoice.