How to Sell Digital Products with Google Drive and PayPal

The online has made it extremely simple for anybody to promote digital merchandise on to clients by way of web sites, social media, and e mail newsletters. You possibly can promote PDF ebooks, MP3 music, pictures, software program apps, reward playing cards, license keys, coupon codes, web site templates, fonts, graphics, video programs, and plenty of extra downloadable recordsdata.

Whereas there are fairly a number of e-commerce platforms that assist you to promote digital merchandise – Gumroad, E-junkie, Paddle, FastSpring, Shopify, Instamojo and WooCommerce, to call a number of,  right here’s a do-it-yourself answer that can assist you to construct your personal digital retailer in below 5 minutes utilizing PayPal and your Google account.

How the workflow works?

Earlier than we get into the implementation, right here’s a big-picture view of how the fee and digital supply workflow works.

  1. Embed the “Purchase Now” buttons into your web site or weblog. Consumers pays with all main bank cards utilizing 1-step checkout.
  2. Purchaser clicks the button, enters the cardboard particulars and completes the fee. The shopper stays in your website and isn’t redirected wherever to finish the acquisition.
  3. The order is delivered to the shopper in a personalised e mail message. You can even connect a tax bill within the affirmation emails.

You possibly can head over to the dwell demo web page and expertise the 1-step checkout expertise in your desktop or cell phone.

Promote Digital Downloads with PayPal and Google Drive

The workflow makes use of Google Drive for securely internet hosting recordsdata, PayPal for processing funds, Google Sheets for producing skilled PDF invoices and Gmail for delivering the order to the client as file attachments.

There aren’t any limitations on the dimensions of recordsdata or the variety of merchandise that you could promote. There aren’t any bandwidth or storage restrictions. There’s no transaction payment apart from the fee processing charges which are charged by PayPal and Stripe.

Get Began Promoting Digital Items

Right here’s a step-by-step video tutorial that explains how one can simply promote digital merchandise with PayPal and Google Drive.

Step 1: Create a PayPal App

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

Inside your PayPal dashboard, go to My Apps & Credentials > Relaxation API Apps and create a brand new app. You can provide your app any title as it’s for inside use solely. PayPal will now create shopper credentials for testing and dwell transactions that we’ll want within the subsequent step.

Step 2: Create a PayPal Webhook

When a purchaser completes the acquisition and makes the fee, PayPal will ship your app a notification by calling a particular URL and this is called a webhook.

To create a webhook, go to digitalgoods.dev/copy and duplicate the Google Sheet to your Google Drive. Contained in the sheet, go to Instruments > Script Editor, the select Publish > Deploy As Net App and click on the Replace button to create your PayPal webhook. Copy the URL to the clipboard.

You’ll have to authorize the script as soon as because it has to do all of the operation – ship emails, connect Drive recordsdata, generate PDF invoices – in your behalf.

Step three: Configure App inside Google Sheet

Change to the “Configuration” sheet contained in the Google Spreadsheet and paste the webhook URL contained in the “webhook” discipline. Subsequent, copy-paste the Consumer ID and Secret generated in step 1 contained in the corresponding fields of the Google Sheet.

paypal-app-configuration.png

There are few different obligatory fields within the sheet. Select your default forex, the delivery desire (whether or not you need to seize the tackle on the client), specify your model title and the gentle descriptor (this may present within the bank card assertion of the client).

Go to the Digital Items menu within the sheet (it’s close to the Assist menu) and select Take a look at PayPal Configuration to confirm the PayPal-Google Sheets connection.

Step four: Add your Digital Merchandise

Change to the “Objects” sheet and enter the default tax charge within the cell E1. Subsequent, add a number of merchandise within the sheet. You solely have to specify the value of the merchandise in column D, the Tax and Whole Quantity is routinely calculated based mostly on the tax charge set in E1.

PayPal Digital Products

To connect recordsdata to your digital product, spotlight the Recordsdata column, then go to the Digital Items menu and select Connect Drive Recordsdata. It opens the Google File picker and you may choose a number of recordsdata out of your Google Drive that will probably be despatched to the client after they buy the corresponding product.

Step four: Create the Tax Bill Template

Change to the “Bill” sheet and customise the bill template. You should use formulation, add your logos, apply kinds to match your model and the template could be transformed to a PDF file and despatched as a file attachment within the order affirmation emails.paypal-pdf-invoice.png

The bill template can embody placemarkers, just like those you’ve gotten used inside Doc Studio. As an example, the variable will probably be changed with the total title of the shopper as discovered within the PayPal order. The variable is changed with the client’s e mail tackle whereas the provides a singular bill quantity to your bill.

Step 5: Create the Order Affirmation E-mail

Change to the “E-mail” sheet and create the HTML template that will probably be despatched to clients after they full the fee. The e-mail will routinely embody the recordsdata and bill as attachments however you possibly can customise the e-mail message and topic.

The primary row within the sheet is the topic and every part else will go within the message physique. The emails, like Mail Merge, might be personalised and you can even use HTML tags so as to add photographs, hyperlinks and wealthy content material within the emails.

Step 6: Take a look at your PayPal buttons

Now that you’ve got added the merchandise to the Google Sheet, it’s time to take a look at the combination in sandbox mode earlier than you embed the buttons in your dwell web site.

Return to your PayPal dashboard, and select Credit score Card Generator in the appropriate sidebar. Right here you possibly can generate random bank card numbers with expiration date and CVV for testing your buttons in sandbox mode.

Contained in the Google Sheet, select Digital Instruments > Embed PayPal Buttons to generate the HTML embed code to your digital merchandise. The display screen gives embed codes in each the dwell mode and the sandbox mode.

embed-paypal-buttons.png

Click on the Strive button subsequent to the Sandbox mode and also you’ll have the ability to take a look at the buttons proper contained in the Google Sheet. Click on the bank card icon, enter the mock bank card quantity and click on “Pay Now” to finish the take a look at transaction.

PayPal invokes the Webhook and it triggers the order workflow. Change to the “Logs” sheet and also you’ll quickly discover a new entry for the transaction that you just simply accomplished. Open your Gmail Despatched objects folder and also you’ll discover a copy othe f e mail that was despatched the client’s e mail.

In case your integration is working as anticipated, go to the Embed PayPal menu within the sheet and this time copy the embed code for the “Dwell” mode and paste it in your web site. Your product is now dwell and anybody on the earth should purchase your product with a single-step checkout.

Right here’s a pattern e mail that can exit to clients after the acquisition.

order-confirmation-email.png

All of the incoming orders might be tracked in real-time contained in the “Gross sales” tab of the Google Sheet. The sheet consists of the shopper’s title, e mail tackle, the order abstract and the client’s postal tackle. The tackle is simply accessible you probably have set the delivery desire within the configuration sheet to “GET_FROM_FILE”.

You possibly can instantly run Mail Merge with Gmail inside this sheet to simply ship product updates to current clients. In case you have been utilizing PayPal previous to switching to Digital Items, put all of the PayPal emails below a brand new Gmail label, extract the e-mail addresses contained in the sheet and use that checklist to your merge.

Find out how to Promote Distinctive License Keys & Codes

In some companies, you could need to ship distinctive codes to the shopper. These could embody license numbers to unlock software program apps (like we do at Digital Inspiration),  passwords to entry streaming video programs, low cost coupons, reward playing cards, occasion registration numbers and extra.

software-license-codes.png

That is simple with Digital Items. Open the “Codes” sheet within the spreadsheet and the pregenerated checklist of codes in one of many columns. Give this column a title as proven within the screenshot above. Subsequent, embody the in your e mail mesage and a singular code will probably be added instead of the marker.

Internally, the app appears on the final row of the Sale sheet (the present order), fetches the codes from that very same row within the Codes sheet and provides them to your e mail / bill.

Troubleshooting Suggestions

The video tutorial explains your complete workflow in nice element however if you’re nonetheless dealing with any points, listed here are some suggestions:

  1. Go to the configuration sheet and set “sure” for the debug setting. Subsequent, do a take a look at transaction inside sandbox mode and test the Logs sheet for any errors.
  2. Go the Digital Items menu and run Take a look at Configuration once more to make sure that your PayPal sandbox and dwell credentials are appropriate.
  3. PayPal, in uncommon instances, could delay the supply of webhooks. Go to the PayPal dashboard and select Webhooks (hyperlink) to get an inventory of recently-processed webhook occasions and their standing. You possibly can open a case at paypal-techsupport.com for assist.
  4. Just remember to haven’t renamed or deleted any of the unique sheets in your copied Google Spreadsheet.
  5. Open your Chrome Dev Instruments, swap to the community tab and make it possible for your adblockers will not be blocking the PayPal script.

In case you are unable to resolve the problem, write to me at amit@labnol.org or tweet @labnol.