# Stripe Payment to Unlock Premium Access
**URL:** https://community.glideapps.com/t/stripe-payment-to-unlock-premium-access/26326
**Category:** Ask for Help
**Created:** [May 3, 2021, 3:25am UTC](https://community.glideapps.com/t/stripe-payment-to-unlock-premium-access/26326 "2021-05-03T03:25:03Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@Ratt2](https://community.glideapps.com/u/Ratt2)
#### Post date: [May 3, 2021, 3:25am UTC](https://community.glideapps.com/t/stripe-payment-to-unlock-premium-access/26326/1 "2021-05-03T03:25:03Z")
Like a few others on here, I’m trying to set up a system that when someone pays for premium content on Stripe, it automatically updates the user’s access to premium. As someone else mentioned this before, I’m assuming I can use Vlookup to pull something off the app sales sheet that will trigger the user sheet to fill with the word Premium. I’m wondering a few things.
Because I’m still in test mode with Stripe, it’s not populating sales to my ‘App Sales’ sheet (my headers are below). Can someone show me what information it populates with?
Also, if someone has used Vlookup for this, what was the formula you used? Which two fields do you use? I’d love as much details as possible. Thanks!
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [May 3, 2021, 7:29am UTC](https://community.glideapps.com/t/stripe-payment-to-unlock-premium-access/26326/2 "2021-05-03T07:29:06Z")
Hi, do you want to do this as a one time only payment or do you want a subscription type where people are automatically charged, let’s say, monthly or annually?
---
### Author:  [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)
#### Post date: [May 3, 2021, 12:39pm UTC](https://community.glideapps.com/t/stripe-payment-to-unlock-premium-access/26326/3 "2021-05-03T12:39:17Z")
Hi
As an alternative your could also consider payhere
> [@hugs Featured on Payhere apparently](https://community.glideapps.com/t/featured-on-payhere-apparently/21952):
>
> Complete tutorial:
---
### Author:  [@adriasoce](https://community.glideapps.com/u/adriasoce)
#### Post date: [May 3, 2021, 12:40pm UTC](https://community.glideapps.com/t/stripe-payment-to-unlock-premium-access/26326/4 "2021-05-03T12:40:55Z")
There is no way to update some column when a stripe payment is completed?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [May 3, 2021, 2:38pm UTC](https://community.glideapps.com/t/stripe-payment-to-unlock-premium-access/26326/5 "2021-05-03T14:38:38Z")
You can only do this either with a vlookup or a relation + lookup inside Glide, after duplicating the App: Sales sheet.
---
### Author:  [@Ratt2](https://community.glideapps.com/u/Ratt2)
#### Post date: [May 3, 2021, 3:28pm UTC](https://community.glideapps.com/t/stripe-payment-to-unlock-premium-access/26326/6 "2021-05-03T15:28:45Z")
One time payment
---
### Author:  [@adriasoce](https://community.glideapps.com/u/adriasoce)
#### Post date: [May 3, 2021, 4:00pm UTC](https://community.glideapps.com/t/stripe-payment-to-unlock-premium-access/26326/7 "2021-05-03T16:00:17Z")
How how?
---
### Author:  [@Ratt2](https://community.glideapps.com/u/Ratt2)
#### Post date: [May 3, 2021, 8:45pm UTC](https://community.glideapps.com/t/stripe-payment-to-unlock-premium-access/26326/8 "2021-05-03T20:45:15Z")
Why do I need to duplicate the App sales sheet?
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [May 3, 2021, 8:51pm UTC](https://community.glideapps.com/t/stripe-payment-to-unlock-premium-access/26326/9 "2021-05-03T20:51:37Z")
You need to duplicate it because that sheet isn’t visible within the Glide data editor. Basically you need to create a read only copy using a query/ArrayFormula
---
### Author:  [@Ratt2](https://community.glideapps.com/u/Ratt2)
#### Post date: [May 3, 2021, 10:31pm UTC](https://community.glideapps.com/t/stripe-payment-to-unlock-premium-access/26326/10 "2021-05-03T22:31:18Z")
I thought I could see it. I included a screenshot in my first post. Is that not what we’re talking about?
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [May 3, 2021, 10:40pm UTC](https://community.glideapps.com/t/stripe-payment-to-unlock-premium-access/26326/11 "2021-05-03T22:40:51Z")
Are you using only Glide tables? I was under the impression that the App: Sales sheet wasn’t available within the Glide Data Editor? @Mark @jason?
---
### Author:  [@Ratt2](https://community.glideapps.com/u/Ratt2)
#### Post date: [May 3, 2021, 10:54pm UTC](https://community.glideapps.com/t/stripe-payment-to-unlock-premium-access/26326/12 "2021-05-03T22:54:54Z")
I don’t remember if I created this sheet manually myself, or if it was done for me when I linked up Stripe. I would imagine that when I go live with Stripe, my transactions get recorded somewhere in my google sheets, correct? You’re saying they get recorded in a protected Glide Table and that’s why I have to duplicate it into an editable google sheet? Finally, can you show me an example of the type of data that Stripe records to Glide? Thank you!
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [May 3, 2021, 11:32pm UTC](https://community.glideapps.com/t/stripe-payment-to-unlock-premium-access/26326/13 "2021-05-03T23:32:37Z")
Since the Stripe - Glide connection became a thing, the App: Sales sheet is an automatically created sheet, which Glide writes to every time an order is created in your app, but does not affect your row count.
That App: Sales sheet is not available for viewing inside the editor, so Robert was asking if you are using a 100% Glide Tables app instead.
In the past, when Glide Tables were not available, we always have to “duplicate” that App: Sales sheet in order to use it inside the Editor, of course at the price of adding more rows to the count.
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [May 3, 2021, 11:42pm UTC](https://community.glideapps.com/t/stripe-payment-to-unlock-premium-access/26326/14 "2021-05-03T23:42:38Z")
Much clearer explanation…thanks 😉
---
### Author:  [@Ratt2](https://community.glideapps.com/u/Ratt2)
#### Post date: [May 4, 2021, 2:14am UTC](https://community.glideapps.com/t/stripe-payment-to-unlock-premium-access/26326/15 "2021-05-04T02:14:06Z")
Thank you for that! If I can view the App: Sales sheet inside the editor, how could I replicate it? Where does it live where I could see it?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [May 4, 2021, 2:50am UTC](https://community.glideapps.com/t/stripe-payment-to-unlock-premium-access/26326/16 "2021-05-04T02:50:27Z")
You can create a new Sheet inside your Google Sheets and use the formula below in cell A1.
```
={'App! Sales'!A:Z}
```
---
### Author:  [@adriasoce](https://community.glideapps.com/u/adriasoce)
#### Post date: [May 4, 2021, 6:47am UTC](https://community.glideapps.com/t/stripe-payment-to-unlock-premium-access/26326/17 "2021-05-04T06:47:24Z")
What it means the last space of the stripe payment? ‘Cremaller’?
---
### Author:  [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)
#### Post date: [May 4, 2021, 8:25am UTC](https://community.glideapps.com/t/stripe-payment-to-unlock-premium-access/26326/18 "2021-05-04T08:25:08Z")
Normally is the post code if I’m not wrong
---
### Author:  [@adriasoce](https://community.glideapps.com/u/adriasoce)
#### Post date: [May 4, 2021, 8:46am UTC](https://community.glideapps.com/t/stripe-payment-to-unlock-premium-access/26326/19 "2021-05-04T08:46:21Z")
Is there a way to modify this? I mean not asking the post code. Because its a digital product which do not need if shipment.
---
### Author:  [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)
#### Post date: [May 4, 2021, 9:14am UTC](https://community.glideapps.com/t/stripe-payment-to-unlock-premium-access/26326/20 "2021-05-04T09:14:02Z")
I believe it’s related to the postcode of the card, most payments require some sort of verification of this a part of their security checks. I could be wrong 😑
Not aware that you can modify this
[Next page](https://community.glideapps.com/t/stripe-payment-to-unlock-premium-access/26326.md?page=2)