How to Authenticate/Re-authenticate PayPal in Google Sheets & Microsoft Excel

This guide gives instructions on how to successfully authenticate PayPal with Supermetrics. Please note that this data source is in early access and available with Google Sheets and Microsoft Excel, and not yet with Google Data Studio.


Quick links to specific sections: 

Google Sheets

"If everything fails..." 

Data Source Access Requirements:

To enable Supermetrics for Stripe, you must have an Admin user role level. To learn more, please refer to this guide:

Authenticating with Google Sheets

To authenticate PayPal in Google Sheets, please do the following steps:

1. Open up the Supermetrics sidebar in your Google Sheets.

2. Select PayPal in the sidebar, under data source.

3. Click on Continue to PayPal login


4. Insert your username and password and click on log in.


5. You have completed all the steps. You can now go back to the sidebar and select your PayPal account under data source.

Re-authenticating with Google Sheets:

To re-authenticate PayPal in Google Sheets, please go to this guide.


Authenticating with Excel:

To authenticate PayPal in Excel, please do the following steps:

1. Click on data and open up the Supermetrics sidebar in Excel.

2. Select PayPal in the sidebar under data source.

3. An automatic login page will open, click on start.


4. Insert your username and password and click on log in.


5. You have completed all the steps. You can now go back to the sidebar and select your PayPal account under data source.

Re-authenticating with Excel:

To re-authenticate PayPal in Excel, please go to this guide.


"If everything fails..." 

Common errors:

  • Error: "Authentication failed" & "You need to re-authenticate at X and then run the query again.", please see this guide.
  • Error: "This was a reauthorization request for user X but logged in as user Y", please see this guide
  • Error: "You're not allowed to run queries with this license #12345. This is because you have not been assigned to the license as a valid user." please see this guide.
  • Error: "This action is not supported when you are signed into multiple accounts". please see this guide.
  • If you no longer see a specific account/page/etc. when logging in, please see this guide
  • If you haven't managed to authenticate you might be affected by an issue at Google account management. For more information, please see this guide.

Forcing a refresh per account data & removing a data source:

To force a refresh per data source, please see this guide.

To remove a data source from Google Sheets, please see this guide.

To remove a data source from Data Studio, please see this guide.

To remove a data source from Excel, please see this guide.


Further assistance 

If you followed all the above steps and you still encounter an authentication error, please create a new support request with the details of the issue and we will assist you.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.