Skip to content
Create account
or
Sign in
The Stripe Docs logo
/
Ask AI
Create account
Sign in
Get started
Payments
Finance automation
Platforms and marketplaces
Money management
Developer tools
Get started
Payments
Finance automation
Get started
Payments
Finance automation
Platforms and marketplaces
Money management
Overview
Billing
Tax
Reporting
Data
    Overview
    Schema
    Custom reports
    Sigma API
    Create custom reports
    Write queries using Sigma
    Query data across an organization
    Sync Stripe data
    Access data within a data warehouse
    Export data to a data warehouse
    Export data to cloud storage
      Export data to Google cloud storage
      Export data to AWS S3 storage
      Export data Azure Blob storage
      Diagnose connection issues with cloud storage
      Cloud storage file organization
    Data management
    Data freshness
    Business and product data use cases
    Import external data
Startup incorporation
HomeFinance automationDataExport data to cloud storage

Export data to Google Cloud Storage

Automate recurring data exports from Stripe to your Google Cloud Storage.

Copy page

Google Cloud Storage destination

Data pipeline can deliver copies of all your Stripe data as Parquet files into your Google Cloud Storage (GCS) bucket. It includes a directory of files for each table, delivered, and updated every 6 hours.

Prerequisites

Before starting the integration, make sure you have access and permission to:

  1. Create a Google Cloud Storage bucket.
  2. Create a service account enabling Stripe to create objects in the provisioned bucket.
  3. Access the Stripe Dashboard as an admin.

Select Your Google Cloud Project

  1. Navigate to the Google Cloud Console.
  2. Select the project that you want to send your Stripe data to.

Create a new Service Account and generate a JSON key

  1. On the Service Accounts page, make sure you’re in the correct Google Cloud Project.
  2. Click + CREATE SERVICE ACCOUNT.
  3. Enter a name for the service account, for example, “<name>-stripe-data-pipeline.”
  4. Add a description—for example, “This role gives Stripe access to upload data files to our bucket.”
  5. Click CREATE AND CONTINUE.
  6. In the Select a Role dropdown, add three roles: Storage Object User, Storage Object Creator, and Storage Insights Collector Service.
  7. Click DONE.
  8. For your new Service Account, click Manage keys in the Actions menu.
  9. Click ADD KEY ▾ and select Create new key.
  10. Choose Key type JSON and click CREATE. The JSON file downloads to your device.

Create a New Bucket

  1. Make sure you’re in the correct Google Cloud project by navigating to Cloud Storage > Buckets in the Google Cloud console.
  2. Click + CREATE.
  3. In the Name field, we recommend a name including “stripe,” such as “<name>-stripe-data.”
  4. For the Location type, we recommend Multi-Regional US.
  5. For the Storage class, we recommend Set a default class - Standard.
  6. For the Access Control, choose Prevent public access with Uniform access control.
  7. Click CREATE button to create the bucket.
  8. Select the PERMISSIONS tab for your newly created bucket.
  9. Under Permissions in the VIEW BY PRINCIPAL tab, select the box next to the Service Account you created in the previous step.

OptionalGenerate encryption keys

Establishing your Google Cloud Storage connection

  1. Visit the Data Pipeline Dashboard.
  2. Click Get started.
  3. Select the Google Cloud Storage logo and click Continue ->. This step generates a bucket name.
  4. Enter the bucket name generated in the previous step.
  5. Upload your Service Account .json file generated earlier.
  6. Select your data encryption option. If you chose to use a customer managed key, upload your public key.
  7. Click the Next button. Clicking this button sends test data to the bucket you provided, but not production data.
  8. When you confirm test data delivery, go to your Cloud Storage bucket.
  9. Open the bucket, navigate to the penny_test directory, and open the acct_ or org_ prefixed sub-directory to locate the delivered account_validation.csv test file.
  10. Click the account_validation.csv file.
  11. Click DOWNLOAD.
  12. Click the Upload the test value file and upload the downloaded account_validation.csv.
  13. Click Confirm value.
  14. When you confirm the test value, click Subscribe. This subscribes you to the product and schedules the initial full load of data for delivery to your Google Cloud Storage bucket, a process that can take 6-12 hours.

*Google Cloud Storage is a trademark of Google LLC.

Was this page helpful?
YesNo
Need help? Contact Support.
Join our early access program.
Check out our changelog.
Questions? Contact Sales.
LLM? Read llms.txt.
Powered by Markdoc