General

  • Q: How to install the Stripe add-on and connect my Stripe account to the spreadsheet?
    A:
    • First, install the "G-Integrator for Stripe" add-on from the Google Marketplace (link coming soon).
    • In your spreadsheet, open Extensions → G-Integrator for Stripe → Sign in to Stripe.
    • A Stripe-hosted page opens asking you to connect your Stripe account to G-Integrator. Review the requested (read-only) permissions and click Connect.
    • You are returned to the spreadsheet already signed in — the add-on menu refreshes to show your connected Stripe account.
  • Q: How to disconnect the G-Integrator app from my Stripe account?
    A:

    ⚠️ After disconnecting, all active workflows will stop working, but your Stripe data will remain unaffected — the add-on only reads data.

    To disconnect, you have two options:
    1. In the spreadsheet, open Extensions → G-Integrator for Stripe → Sign Out.
    2. Or, from your Stripe Dashboard, go to Settings → Connected applications, find G-Integrator and click Revoke access.
    Either option immediately revokes the add-on's access token, so no further data can be read from your account.
  • Q: What Stripe permissions does the add-on require?
    A: The add-on requests read-only access — it never creates, modifies, captures or refunds anything in your Stripe account:
    Scope Description
    Customers (read)Read customer records and their billing/shipping details.
    Charges & Payment Intents (read)Read charges, payment intents and balance transactions.
    Invoices (read)Read invoices and invoice line items.
    Subscriptions (read)Read subscriptions and subscription items.
    Products & Prices (read)Read your product catalog and price definitions.
    Payouts & Refunds (read)Read payouts and refunds.
    Coupons & Disputes (read)Read coupons and disputes.
    Your Stripe account must have permission to connect third-party apps. If you don't, please contact your Stripe account owner or administrator.
  • Q: Which Stripe objects (modules) can I download?
    A: The following modules are available in the "Get Stripe Data" sidebar:
    • Customers — including addresses and shipping/billing details as dot-path columns
    • Charges and Payment Intents
    • Invoices, with nested Invoice Line Items
    • Subscriptions, with nested Subscription Items
    • Products and Prices
    • Payouts and Refunds
    • Coupons and Disputes
    • Balance Transactions
  • Q: What Google Account permissions does G-Integrator for Stripe require and why?
    A: The list below:
    • See, edit, create, and delete your spreadsheets in Google Drive™: we need this to insert content from Stripe into your spreadsheet.
    • Connect to an external service: This is obvious: Stripe is an external service.
    • Allow this application to run when you are not present: we need this for the scheduled workflows.
    • Display and run third-party web content in prompts and sidebars inside Google applications: All our UI part will be shown to you in prompts and sidebars.

Download data

  • Q: How can I edit an existing query template?
    A: menu "Modify/Delete Templates for Current Sheet" OR "Modify/Delete All Templates"
  • Q: How can I filter data to get only the records I need?
    A: In "G-Integrator for Stripe → Get Stripe Data" or "G-Integrator for Stripe → Modify/Delete templates", click on tab "3. Select the fields to filter by". You can combine several conditions with AND/OR, e.g. status equals "paid" AND amount_due greater than 100.
  • Q: How are nested objects like invoice line items shown in the spreadsheet?
    A: Nested fields become dot-path columns, e.g. customer.email or subscription.current_period_end. When a selected column crosses a child array (like the line items of an invoice), the invoice is expanded into one row per array element — an outer join where the invoice's own fields are repeated on every row.
    If you prefer to work with the children as standalone tables, use the dedicated Invoice Line Items and Subscription Items modules: each row there carries its parent invoice id or subscription id.
  • A: Yes. The id column of every module with a Dashboard page (Customers, Charges, Invoices, Subscriptions, Payouts, ...) is rendered as a clickable link that opens the record directly in your Stripe Dashboard, e.g. https://dashboard.stripe.com/customers/cus_NfJyOTgg5nkTQz. You can turn this off with the "Link to record" checkbox in the template settings.
  • Q: I've changed data in Stripe and refreshed the spreadsheet. However, I do not see changes in the spreadsheet.
    A: We use cache to keep downloaded data for 30 min., both for performance and to respect the Stripe API rate limits. This explains why you do not see changes immediately. You have the following options:
    1. Wait for 30 min. since the refresh.
    2. Using "G-Integrator for Stripe → Modify/Delete Pull templates" menu, change the query: add or remove a column, change a filter, etc. This will be considered as a new query.
    3. Check the "Clear cache" option in the template settings before refreshing.
  • Q: What is a workflow and how to use it?
    A workflow is the automation engine of G-Integrator for Stripe. Using a workflow, you can:
    • Add more than one template to be executed in the selected order
    • Run it manually, hourly, daily, weekly or monthly
    • Turn the execution on and off without changing the schedule
    • Add or remove templates at any time
    • Pre-load the data to deal with extremely long queries
    To use it, please do the following:
    • Using the menu: "Get Stripe Data" or "Modify/Delete Pull templates", create/modify the templates to download the data you want to be refreshed.
    • Repeat this operation for as many modules as you need.
    • Using the menu "Automation → Create Workflow", set up the workflow:
      • Enter the name and the description
      • Add the templates in the desired order
      • Set up the schedule (new workflows default to "Manually" — pick a frequency to automate)
      • (Optional) Check the "Pre-load long queries" if it will take more than 6 min to execute the workflow
      • If you want, turn on email notifications
      • You can click "Execute immediately" to check how it works
    • By default, the results of each execution will be written to tab "Automatic Operations Events Log"
  • Q: How can I download only the new data?
    A: If you have many records, the full download can take a lot of time. To resolve this, you have the option to download only data created or modified since the last download. To achieve this, please do the following:
    • Using the menu: "Get Stripe Data" or "Modify/Delete Pull templates", create/modify the query.
    • In the tab "3. Select the field to filter by (optional)", add filter "Since last execution" for the created field.
    • Attention: by default, each new download will erase the previous data. To avoid this, please use "Add to the previous output" option (see below).
  • Q: How can I add downloaded data at the end of the existing data?
    A: Please do the following:
    • Using the menu: "Get Stripe Data" or "Modify/Delete Pull templates", create/modify the query.
    • In the tab "2. Change Pull Settings (optional)", select the "Add to the previous output" checkbox.
    • This is an experimental feature. The query results will be added to the end of the existing data in the spreadsheet.
    • If you have one or more "Order By" criteria, the WHOLE dataset will be re-sorted, so the most recent data may become located not at the bottom.
    • Please do not modify any existing data or change columns: the result can be unpredictable.
    • Please be careful because it can generate duplicates. We recommend using the "Since last execution" date filter to avoid duplicates.
  • Q: Can I connect a Stripe test-mode account?
    A: Yes. If your Stripe account is in test mode when you sign in, the add-on connects to that test account and every module (Customers, Charges, Invoices, Subscriptions, ...) will return your test data instead of live data. This is a convenient way to try out queries and workflows before switching to your live Stripe account.
  • Q: Is it possible to use G-Integrator for Stripe on my smartphone?
    A: The G-Integrator for Stripe Add-on is not designed to work on mobile devices: first of all, the "Google Sheets™" app does not support Extensions. However you can open your spreadsheet from a mobile browser using "Desktop" mode, and from it, you will be able to use some restricted functionality, like refreshing.
    Also, while working on the PC, you can set up automatic data synchronization using the "G-Integrator for Stripe → Automation" menu. After this, you will be able to see updated data from the "Google Sheets™" app on your smartphone.

Subscriptions

  • Q: Where can I see the available subscriptions?
    A: G-Integrator for Stripe is currently in free trial for all users. Paid plans and a price page will be announced later.
  • Q: What is your money-back policy?
    A: We offer a full money-back guarantee for the first 30 days and pro-rated return after.
  • Q: How can I be sure that the credit card number I provide will be safe?
    A: We use the well-known and respected PCI Level 1 certified billing platform ChargeBee. All payment processing is made by them, we cannot see your credit card's number at all - ChargeBee will show us only the last 4 digits.
  • Q: How can I change my subscription or unsubscribe?
    A: There are two options: