In this article, we'll use the Google Apps Script platform to get data from Stripe into Google Sheets, which you can then display using the Spreadsheets data source.
We recommend this option only if the pre-built data sources do not offer the data you're looking for.
Metrics available with this script
This method of fetching Stripe data provides access to the following metrics:
Total balance
Count of customers
Total charges
Total refunds
The above metrics can be granular to an hour, day, week, or month. You can also fetch one day, seven days, thirty days, sixty days, or 90 days' worth of data.
Set up your Google Sheet to fetch data from Stripe
To create a Stripe widget using data pulled from a Google Sheet, follow these steps:
Make a copy of this Google Sheet.
Head to Stripe and locate your Stripe API secret key.
Return to the Google Sheet, then click Extensions > Stripe Sync > Setup.
In the pop-up window that appears, paste the API Key.
Then configure the Granularity, Initial load, and Metrics as preferred and click Save.
Select a cell in your spreadsheet where you want the data to be written.
Click Extensions > Stripe Sync > Initial Load to initiate the first import of your data, which will appear momentarily.
Head to Geckoboard and add a widget for the Spreadsheets data source; then connect this sheet to visualize your data.
Syncing data
If you want to refresh the balances manually, click Extensions > Stripe Sync > Manual Sync. Alternatively, select Schedule Sync if you'd like them to automatically refresh every hour.