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.
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 if the PayPal and Google Sheets connection is working.
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, one per row. 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.
To attach files to your digital product, highlight the cell in 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.
The invoice template can include place markers, 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.
