Google Sheets Stripe Integration

stripe google sheets integration

Analyze your Stripe data with Google Sheets

Connect Stripe to Google Sheets

It is very simple to connect Stripe to Google Sheets, it can be done in a fast and easy manner with Windsor.ai.

 

First Step:

You need to select Stripe as a Data Source and Grant Access to Windsor.ai.

stripe onboarding

 

Instructions to grant access


Create a secret API key in your Stripe Account and add it to the table above.

 

Second step:

Select Google Sheets as a data destination.

google sheets destination

 

Third Step:

You can choose between two options:

Option 1: Advanced and for large data volumes
  1. Click this link to install the Google Sheets add-on
  2. Go to Extension – Ad Data and Analytics by Windsor.ai – Login
  3. Enter your API key: [your API Key] and click Login
  4. Start using the add-on in Google Sheets from the Add-ons menu in Extension – Ad Data and Analytics by Windsor.ai – Get Data into Sheet in Google Sheets document and select your fields

 

Option 2: Quickstart
  • Copy the snippet below into your Google Sheet. Only works for fast queries below 60 seconds, use the add-on in case of issues.
  • The URL works as an API data feed and the fields can be adjusted with the parameters in the URL.
  • You can add any field that is available in the data sources you have added.

    =IMPORTDATA(“https://connectors.windsor.ai/stripe?api_key=[your API Key]&date_preset=last_28d&fields=account_name,clicks,date&_renderer=googlesheets")

    and replace  [your API Key] with your API key. The list of selected fields must contain a date field. The fields which are listed after &fields= are simply a set of standard fields which you can customise. A full list of metrics and dimensions can be found in our Stripe connector documentation. Customise the URL to your liking.

 

Try Windsor.ai today

Access all your data from your favorite sources in one place.
Get started for free with a 30 - day trial.

Start Free Trial

Extract Stripe data to Google Sheets with Windsor.ai

See the value and return on every marketing touchpoint

data warehouse

Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketers, whenever they want.

insights

Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.

Build your Stripe and Google Sheets Integrations