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 PDF 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 under the Mock section. Here you can generate random credit card numbers with expiration date and CVV for testing your PayPal checkout 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 and sandbox mode.
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 of the email that was just 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 on 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.
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 before 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.
You can easily send unique license code with Digital Goods. Open the “Codes” sheet in the spreadsheet and put the pre-generated 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 message 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 and 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:
- Go to the configuration sheet and set “yes” for the debug setting. Next, do a test transaction inside the sandbox mode and check the Logs sheet for any errors.
- Go the Digital Goods menu and run Test Configuration again to ensure that your PayPal sandbox and live credentials are correct.
- 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.
- Make sure that you have not renamed or deleted any of the original sheets in your copied Google Spreadsheet.
- 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, ask your question at digitalinspiration.support.
Sell Digital Goods
Title: How to Sell Digital Products Online with Google Drive and PayPal
Sourced From: https://www.labnol.org/internet/sell-digital-products-online/28554/
Published Date: 2019-03-13 12:56:15
