How to Add PayPal Payment Links in Emails and Documents

Published in: Document Studio - paypal

PayPal offers two methods for including payment request links in your emails and documents.

  1. (simple)
  2. (detailed)

If you wish to request money from a client, you can send them a link with the amount and currency code. They can click the link, log in to their PayPal account and send you the money.

The link format is

For instance, if I were to request 10 USD from a client, the link would be In British Pound, the link would change to

The other format for PayPal link is slightly more column but lets you include the item name in the URL so you know what the customer is paying you form. You can also include a return URL that that customer would be redirected to after they have paid the invoice.

Here’s the second PayPal link format (live example):

Document Studio includes built-in function that will help you easily include either of these PayPal links in your merged documents and email notifications.

Let’s see a live example that uses the second detailed PayPal link format. First include a few columns like Product Name, Invoice Amount, and PayPal Link.


=PAYPAL(K2:K, L2:L, "USD", "")

Next, add the PayPal formula in the first empty cell of the PayPal column. Remember to include your own PayPal email address in the last parameter as that is where you would like the payments to arrive.

The Google sheets formula will expand, like an ARRAYFORMULA, and automatically fill all the cells where the product name and item price are not empty.

Next, you can include the variable {{PayPal Link}} in your document template and it will be replaced with the actual link.

If you using Google Sheets template, you can use the built-in HYPERLINK function to create a clickable hyperlink that points to PayPal.

=HYPERLINK("{{PayPal Link}}", "Click here to pay invoice via PayPal")

In the case of email templates, select some text in the email body, click the hyperlink button in the toolbar and add {{PayPal link}} as the hyper. See below.


When people click the PayPal link, they can either pay via their PayPal accounts or pay via Debit and Credit cards.

📮  Subscribe to our Email Newsletter for Google tips and tutorials!
Published in: Document Studio - paypal

Looking for something? Find here!

Meet the Author

Web Geek, Google Developer Expert
Amit Agarwal

Amit Agarwal is a Google Developer Expert in Google Workspace and Google Apps Script. He holds an engineering degree in Computer Science (I.I.T.) and is the first professional blogger in India. He is the developer of Mail Merge for Gmail and Document Studio. Read more on Lifehacker and YourStory

Get in touch

Google Add-ons

Do more with your Gmail and GSuite account

We build bespoke solutions that use the capabilities and the features of Google Workspace for automating business processes and driving work productivity.

  1. Mail Merge with Attachments
    Send personalized email to your Google Contact with a Google Sheet and Gmail
  2. Save Emails and Attachments
    Download email messages and file attachments from Gmail to your Google Drive
  3. Google Forms Email Notifications
    Send email notifications to multiple people when a new Google Form is submitted
  4. Document Studio
    Create beautiful pixel perfect documents merging data from Google Sheets and Google Forms
  5. Creator Studio for Google Slides
    Turn your Google Slides presentations into animated GIFs and videos for uploading to YouTube