Flatly Flatly Flatly
Sources Destinations FAQ Pricing
Log in Free Trial
Payments Spreadsheet Apps

Sync Stripe to Google Sheets

Stripe Google Sheets

Automatically sync your Stripe data into Google Sheets with Flatly's no-code, triggerless, turnkey integration service.

Historical & Dynamic Data
One-way Sync
For Non-technical Users
Connect Stripe to Google Sheets Which Stripe API does Flatly use?

Source: Stripe

Stripe is a global online payment processor that is trusted by thousands of businesses across the globe.

Auth: OAuth

Available datasets

  • ApplicationFees-All
  • ApplicationFees-Last365days
  • Balance
  • BalanceTransactions-All
  • BalanceTransactions-Last X days Date-ranged
  • Charges-All
  • Charges-Last X days Date-ranged
  • Coupons
  • Credit Notes
  • Customers-All
  • Customers-Last X days Date-ranged
  • Customers+Charges-All Combo
  • Customers+Charges-Last X days Combo Date-ranged
  • Customers+Invoices-All Combo
  • Customers+Invoices-Last X days Combo Date-ranged
  • Disputes-All
  • Disputes-Last X days Date-ranged
  • EarlyFraudWarnings
  • Events-All
  • Events-Last X days Date-ranged
  • File Uploads
  • Invoices-All
  • Invoices-Last X days Date-ranged
  • Invoices-ChargeAutoOnly
  • Invoices-ChargeAutoOnly-Last X Date-ranged
  • Invoices-SendInvoiceOnly
  • Invoices-SendInvoiceOnly-Last X Date-ranged
  • Invoices+LineItems Alltime Combo
  • Invoices+LineItems Last X days Combo Date-ranged
  • InvoiceItems-All
  • IssuingAuthorizations
  • IssuingCards
  • IssuingCardholders
  • IssuingDisputes
  • IssuingTransactions
  • Orders
  • Orders-Last X days Date-ranged
  • Order Returns
  • PaymentIntents-All
  • PaymentIntents-Last X days Date-ranged
  • Payouts-All
  • Payouts-Last X days Date-ranged
  • Plans-All
  • Plans-ActiveOnly
  • Plans-InactiveOnly
  • Products-All
  • Products-ActiveOnly
  • Products-PhysicalOnly
  • Refunds-All
  • Refunds-Last X days Date-ranged
  • SetupIntents-All
  • SetupIntents-Last X days Date-ranged
  • SKUs
  • Subscriptions-All
  • Subscriptions-Last X days Date-ranged
  • Subscriptions-ChargeAutoOnly
  • Subscriptions-ChargeAutoOnly-Last X Date-ranged
  • Subscriptions-SendInvoiceOnly
  • Subscriptions-SendInvoiceOnly-Last X Date-ranged
  • Transfers-All

Destination: Google Sheets

Multiple Sheet Tabs in the same Sheet are supported. Google Sheets is an alias for Google Drive which supports multiple formats.

Auth: OAuth

Supported file formats

  • Google Sheets (Parsed)
  • Google Sheets (Raw)
  • XLSX (Parsed)
  • XLSX (Raw)
  • CSV (Parsed)
  • CSV (Raw)
  • NDJSON
  • Markdown (Table)
  • Markdown (Key-Value)

How it works

  1. 1

    Connect Stripe

    Authenticate Stripe (OAuth) and Google Sheets (OAuth) in the Flatly dashboard. You only have to do this once.

  2. 2

    Choose your datasets

    Pick which Stripe datasets to sync and set your sync frequency. The frequencies available to you depend on your Flatly plan.

  3. 3

    Data lands in Google Sheets

    Flatly uploads your Stripe data to Google Sheets automatically and refreshes it based on your sync frequency.

What Stripe Charges look like in Google Sheets

Flatly writes a header row to Google Sheets, then one row per record. Nested Stripe fields are flattened into their own columns, so the Charges-All dataset arrives as 130 columns.

Stripe Charges-All
Sample Stripe Charges-All rows in Google Sheets, showing 8 of 130 columns
amountamount_capturedamount_refundedbilling_details_namecreatedcurrencyidpayment_method_details_card_extended_authorization_status
10000Jenny Rosen1234567890usdch_1PgafuB7WZ01zgkWXYmPNZs8disabled
20000Priya Patel1234567890usdch_1PgafuB7WZ01zgkWXYmPNZs9disabled
30000Marcus Okafor1234567890usdch_1PgafuB7WZ01zgkWXYmPNZs0disabled
Charges
Example data. Showing 8 of 130 columns.
All 130 Stripe Charges-All columns
  • amount
  • amount_captured
  • amount_refunded
  • application
  • application_fee
  • application_fee_amount
  • balance_transaction
  • billing_details_address_city
  • billing_details_address_country
  • billing_details_address_line1
  • billing_details_address_line2
  • billing_details_address_postal_code
  • billing_details_address_state
  • billing_details_email
  • billing_details_name
  • billing_details_phone
  • billing_details_tax_id
  • calculated_statement_descriptor
  • captured
  • created
  • currency
  • customer
  • description
  • disputed
  • failure_balance_transaction
  • failure_code
  • failure_message
  • fraud_details
  • id
  • livemode
  • metadata
  • object
  • on_behalf_of
  • outcome_advice_code
  • outcome_network_advice_code
  • outcome_network_decline_code
  • outcome_network_status
  • outcome_reason
  • outcome_seller_message
  • outcome_type
  • paid
  • payment_intent
  • payment_method
  • payment_method_details_card_amount_authorized
  • payment_method_details_card_brand
  • payment_method_details_card_checks_address_line1_check
  • payment_method_details_card_checks_address_postal_code_check
  • payment_method_details_card_checks_cvc_check
  • payment_method_details_card_country
  • payment_method_details_card_exp_month
  • payment_method_details_card_exp_year
  • payment_method_details_card_extended_authorization_status
  • payment_method_details_card_fingerprint
  • payment_method_details_card_funding
  • payment_method_details_card_incremental_authorization_status
  • payment_method_details_card_installments_plan_count
  • payment_method_details_card_installments_plan_interval
  • payment_method_details_card_installments_plan_type
  • payment_method_details_card_last4
  • payment_method_details_card_mandate
  • payment_method_details_card_multicapture_status
  • payment_method_details_card_network
  • payment_method_details_card_network_token_used
  • payment_method_details_card_overcapture_maximum_amount_capturable
  • payment_method_details_card_overcapture_status
  • payment_method_details_card_three_d_secure_authentication_flow
  • payment_method_details_card_three_d_secure_electronic_commerce_indicator
  • payment_method_details_card_three_d_secure_exemption_indicator
  • payment_method_details_card_three_d_secure_result
  • payment_method_details_card_three_d_secure_result_reason
  • payment_method_details_card_three_d_secure_transaction_id
  • payment_method_details_card_three_d_secure_version
  • payment_method_details_card_wallet_dynamic_last4
  • payment_method_details_card_wallet_type
  • payment_method_details_card_authorization_code
  • payment_method_details_card_regulated_status
  • payment_method_details_card_network_transaction_id
  • payment_method_details_card_transaction_link_id
  • payment_method_details_card_electronic_commerce_indicator
  • payment_method_details_type
  • receipt_email
  • receipt_number
  • receipt_url
  • refunded
  • refunds_data
  • refunds_has_more
  • refunds_object
  • refunds_url
  • review
  • shipping
  • source_transfer
  • statement_descriptor
  • statement_descriptor_suffix
  • status
  • transfer_data_amount
  • transfer_data_destination_id
  • transfer_data_destination_object
  • transfer_group
  • source_allow_redisplay
  • source_amount
  • source_client_secret
  • source_created
  • source_currency
  • source_flow
  • source_id
  • source_livemode
  • source_metadata
  • source_object
  • source_owner_address_city
  • source_owner_address_country
  • source_owner_address_line1
  • source_owner_address_line2
  • source_owner_address_postal_code
  • source_owner_address_state
  • source_owner_email
  • source_owner_name
  • source_owner_phone
  • source_owner_verified_address_city
  • source_owner_verified_address_country
  • source_owner_verified_address_line1
  • source_owner_verified_address_line2
  • source_owner_verified_address_postal_code
  • source_owner_verified_address_state
  • source_owner_verified_email
  • source_owner_verified_name
  • source_owner_verified_phone
  • source_statement_descriptor
  • source_status
  • source_type
  • source_usage

Google Sheets

Your data, live in Google Sheets

Flatly refreshes multiple sheets in your Google Drive using isolated folder permissions while still allowing custom naming, moving and sharing.

Multiple Sheet Tabs Supported.
Each synced data set gets its own named tab inside a single Google Sheet, so everything stays organized and easy to reference from formulas or Looker Studio.
Minimal Drive permissions.
Flatly only has access to its own App Folder — it cannot read or modify anything else in your Google Drive. It also requests your account email to track which Drive is connected to each job.
Looker Studio ready.
Google Looker Studio reads Google Sheets files directly from Google Drive, making it easy to build dashboards on top of your synced data without any additional connectors.

FAQ: Stripe

Is this integration with Stripe or Stripe Connect?

Both. Flatly offers a conventional Stripe integration for merchants, labeled in the data source selection drop-down as Stripe. This integration uses conventional OAuth authorization and is designed to power analytics for non-technical merchants who want to track revenue, invoices, transactions and customer records, etc.

Separately, Flatly offers an integration for Stripe developers and platforms, labeled Stripe Connect, which uses API Key based authorization. This integration is for developers who want to analyze data related to transfers and connections, as opposed to conventional commerce. As of today, API Key based authorization is the only available option for Stripe Connect in the ETL analytics context.

FAQ: Stripe to Google Sheets

How frequently can I sync data from Stripe to Google Sheets?
Flatly allows you to set custom sync frequencies ranging from every 10 minutes to once daily, depending on your Flatly pricing plan.
Does Flatly modify my Stripe data during the sync?
No. Flatly provides a strict one-way sync. It extracts your historical and dynamic data from Stripe and securely loads it into Google Sheets without altering your original source data.
Do I need to write code to connect Stripe to Google Sheets?
No code is required. Flatly is a turnkey, no-code integration platform designed for non-technical users to securely connect their data sources and destinations in minutes.

“The interface is unbelievable. Flatly is so easy to use. After years of struggling with Zapier this is life changing.”

Melissa Cable
Project Manager, Aeolidia

Full data refresh

Maintain up-to-date flat files when any nested or bundled data changes in your source app.

Connection Management

Manage multiple tenants, with connection health monitoring.

Bulk Job Management

Control multiple jobs at the same time, with live progress monitoring.

Merged datasets

Export left-joined combo objects like deals+products.

Write options

Refresh one flat file or create a stack of timestamped versions.

Filterability

Include only the columns or views essential for your reporting.

Notifications

Get alerts about your syncs via email, webhooks or Slack notifications.

Logging

Access up to one thousand log entries for your sync operations.

Custom Field Enrichment

Get useful values in your data instead of identifiers or definitions.

Metadata Attachment

See file statistics alongside your flat files to keep track of their origins.

Dark UI Mode

Reduce eye strain and save energy by using our built in dark mode.

Programmatic Jobs

Queue jobs by making API calls or agent requests.

Time Stamp Enrichment

Get human-readable dates and times from UNIX timestamps.

High frequency

10-minute refresh cycles mean your data store is near real-time.

High capacity

Reliably flatten billions of cells to CSV files without hiccups.

Advanced Security

Two-factor authentication and Destination Lock controls.

Stripe-powered Billing

Reliable payments provider with automatic, familiar invoicing and 1% of Sales to Stripe Climate.

Mobile access

Manage your sync operations from your phone if you are traveling.

Connect Stripe to Google Sheets

Get started today with a 14-day free trial. No credit card required. Both human and AI support are available.

Get started Compare pricing

Sync Stripe to other destinations

Sync other sources to Google Sheets