How to use Google Sheets to generate Stripe payment links and request payments in any currency from customers anywhere in the world!
Stripe payment links make it easy for you to accept credit card payments from customers anywhere in the world without even having a website. You can use the Stripe dashboard to generate payment links and then send the links over email, WhatsApp, SMS, or share them on your social media pages.
A limitation of Stripe Payment links is that you can only generate them manually. Stripe has a feature-rich API but it doesn’t allow you to generate payment links automatically.
Stripe Payment Link Generator
If you are looking to generate custom payment links for Stripe in bulk and send them to your customers, you can consider using Stripe Checkout. These are payment forms hosted on the Stripe website and allow you to collect only payments your customers.
It is important to note that Stripe Checkout sessions will automatically expire after 24 hours. As an alternative, you can use the Stripe API to generate invoices and email the invoice link to your customers.
Generate Stripe Checkout Links with Google Sheets
To get started, open your Stripe dashboard, go to Developers > API Keys > Created restricted API key.
Give your key a descriptive name, choose the
Write permission under
Checkout Sessions and click
Next, make a copy of the Stripe Google Sheet in your Google Drive. Go to Tools > Script Editor and replace the
Stripe API Key with the key generated in the previous step. Then, click on the
Run menu once to authorize the script with your Google Account.
Switch to the Google Sheet and you can now use the custom Google Sheets function
STRIPE() to generate Stripe Checkout sessions for accepting online payments.
If you would like to generate payment links for multiple rows in the Google Sheet, just write the formula in the first row and drag the crosshairs to the other rows as show in the demo below. Array Formulas are not supported yet.
How Stripe Checkout Works with Google Sheets
If you are curious to know how integration of Google Sheets and Stripe works, the answer is Google Apps Script. The underlying code invokes the Stripe API with …….