How to Sell Digital Products Online with Google Drive and PayPal

The web has made it incredibly easy for anyone to sell digital products directly to customers through websites, social media, and email newsletters. You can sell PDF ebooks, MP3 music, photos, software apps, gift cards, license keys, coupon codes, website templates, fonts, graphics, video courses, and many more downloadable files.

While there are quite a few e-commerce platforms that help you sell digital products – Gumroad, E-junkie, Paddle, FastSpring, Shopify, Instamojo and WooCommerce, to name a few,  here’s a do-it-yourself solution that will help you build your own digital store in under 5 minutes using PayPal and your Google account.

How the workflow works?

Before we get into the implementation, here’s a big-picture view of how the payment and digital delivery workflow works.

  1. Embed the “Buy Now” buttons into your website or blog. Buyers can pay with all major credit cards using 1-step checkout.
  2. Buyer clicks the button, enters the card details and completes the payment. The customer stays on your site and isn’t redirected anywhere to complete the purchase.
  3. The order is delivered to the customer in a personalized email message. You can also attach a tax invoice in the confirmation emails.

You can head over to the live demo page and experience the 1-step checkout experience on your desktop or mobile phone.

Sell Digital Downloads with PayPal and Google Drive

The workflow uses Google Drive for securely hosting files, PayPal for processing payments, Google Sheets for generating professional PDF invoices and Gmail for delivering the order to the buyer as file attachments.

There are no limitations on the size of files or the number of products that you can sell. There are no bandwidth or storage restrictions. There’s no transaction fee except for the payment processing fees that are charged by PayPal and Stripe.

Get Started Selling Digital Goods

Here’s a step-by-step video tutorial that explains how you can easily sell digital products with PayPal and Google Drive.

Step 1: Create a PayPal App

Go to developer.paypal.com and sign-in with your PayPal account. If you don’t have one, sign-up here for a new Business account.

Inside your PayPal dashboard, go to My Apps & Credentials > Rest API Apps and create a new app. You can give your app any name as it is for internal use only. PayPal will now create client credentials for testing and live transactions that we’ll need in the next step.

Step 2: Create a PayPal Webhook

When a buyer completes the purchase and makes the payment, PayPal will send your app a notification by calling a specific URL and this is known as a webhook.

To create a webhook, go to digitalgoods.dev/copy and copy the Google Sheet to your Google Drive. Inside the sheet, go to Tools > Script Editor, the choose Publish > Deploy As Web App and click the Update button to create your PayPal webhook. Copy the URL to the clipboard.

You will have to authorize the script once since it has to do all the operation – send emails, attach Drive files, generate PDF invoices – on your behalf.

Step 3: Configure App inside Google Sheet

Switch to the “Configuration” sheet inside the Google Spreadsheet and paste the webhook URL inside the “webhook” field. Next, copy-paste the Client ID and Secret generated in step 1 inside the corresponding fields of the Google Sheet.

paypal-app-configuration.png

There are few other mandatory fields in the sheet. Choose your default currency, the shipping preference (whether you want to capture the address on the buyer), specify your brand name and the soft descriptor (this will show in the credit card statement of the buyer).

Go to the Digital Goods menu in the sheet (it is near the Help menu) and choose Test PayPal Configuration to verify the PayPal-Google Sheets connection.

Step 4: Add your Digital Products

Switch to the “Items” sheet and enter the default tax rate in the cell E1. Next, add one or more products in the sheet. You only need to specify the price of the item in column D, the Tax and Total Amount is automatically calculated based on the tax rate set in E1.

PayPal Digital Products

To attach files to your digital product, highlight the Files column, then go to the Digital Goods menu and choose Attach Drive Files. It opens the Google File picker and you can select one or more files from your Google Drive that will be sent to the buyer after they purchase the corresponding product.

Step 4: Create the Tax Invoice Template

Switch to the “Invoice” sheet and customize the invoice template. You can use formulas, add your logos, apply styles to match your brand and the template would be converted to a PDF file and sent as a file attachment in the order confirmation emails.paypal-pdf-invoice.png

The invoice template can include placemarkers, similar to the ones you have used inside Document Studio. For instance, the {{Name}} variable will be replaced with the full name of the customer as found in the PayPal order. The {{Email}} variable is replaced with the buyer’s email address while the {{Invoice Id}} adds a unique invoice number to your invoice.

Step 5: Create the Order Confirmation Email

Switch to the “Email” sheet and create the HTML template that will be sent to customers after they complete the payment. The email will automatically include the files and invoice as attachments but you can customize the email message and subject.

The first row in the sheet is the subject and everything else will go in the message body. The emails, like Mail Merge, can be personalized and you can also use HTML tags to add images, links and rich content in the emails.

Step 6: Test your PayPal buttons

Now that you have added the products to the Google Sheet, it is time to test the integration in sandbox mode before you embed the buttons on your live website.

Go back to your PayPal dashboard, and choose Credit Card Generator in the right sidebar. Here you can generate random credit card numbers with expiration date and CVV for testing your buttons in sandbox mode.

Inside the Google Sheet, choose Digital Tools > Embed PayPal Buttons to generate the HTML embed code for your digital products. The screen offers embed codes in both the live mode and the sandbox mode.

embed-paypal-buttons.png

Click the Try button next to the Sandbox mode and you’ll be able to test the buttons right inside the Google Sheet. Click the credit card icon, enter the mock credit card number and click “Pay Now” to complete the test transaction.

PayPal invokes the Webhook and it triggers the order workflow. Switch to the “Logs” sheet and you’ll soon find a new entry for the transaction that you just completed. Open your Gmail Sent items folder and you’ll find a copy othe f email that was sent the buyer’s email.

If your integration is working as expected, go to the Embed PayPal menu in the sheet and this time copy the embed code for the “Live” mode and paste it in your website. Your product is now live and anyone in the world can buy your product with a single-step checkout.

Here’s a sample email that will go out to customers after the purchase.

order-confirmation-email.png

All the incoming orders can be tracked in real-time inside the “Sales” tab of the Google Sheet. The sheet includes the customer’s name, email address, the order summary and the buyer’s postal address. The address is only available if you have set the shipping preference in the configuration sheet to “GET_FROM_FILE”.

You can directly run Mail Merge with Gmail inside this sheet to easily send product updates to existing customers. If you have been using PayPal prior to switching to Digital Goods, put all the PayPal emails under a new Gmail label, extract the email addresses inside the sheet and use that list for your merge.

How to Sell Unique License Keys & Codes

In some businesses, you may want to send unique codes to the customer. These may include license numbers to unlock software apps (like we do at Digital Inspiration),  passwords to access streaming video courses, discount coupons, gift cards, event registration numbers and more.

software-license-codes.png

This is easy with Digital Goods. Open the “Codes” sheet in the spreadsheet and the pregenerated list of codes in one of the columns. Give this column a title as shown in the screenshot above. Next, include the {{column title}} in your email mesage and a unique code will be added in place of the marker.

Internally, the app looks at the last row of the Sale sheet (the current order), fetches the codes from that same row in the Codes sheet and adds them to your email / invoice.

Troubleshooting Tips

The video tutorial explains the entire workflow in great detail but if you are still facing any issues, here are some tips:

  1. Go to the configuration sheet and set “yes” for the debug setting. Next, do a test transaction inside sandbox mode and check the Logs sheet for any errors.
  2. Go the Digital Goods menu and run Test Configuration again to ensure that your PayPal sandbox and live credentials are correct.
  3. PayPal, in rare cases, may delay the delivery of webhooks. Go to the PayPal dashboard and choose Webhooks (link) to get a list of recently-processed webhook events and their status. You can open a case at paypal-techsupport.com for help.
  4. Make sure that you have not renamed or deleted any of the original sheets in your copied Google Spreadsheet.
  5. Open your Chrome Dev Tools, switch to the network tab and make sure that your adblockers are not blocking the PayPal script.

If you are unable to resolve the issue, write to me at amit@labnol.org or tweet @labnol.

You’ll also like:

Leave a Reply

Your email address will not be published. Required fields are marked *