General

  • Q: How to install the Shopify add-on and connect my Shopify store to the spreadsheet?
    A:
    • First, install the "G-Integrator for Shopify" add-on from the Google Marketplace (link coming soon).
    • In your spreadsheet, open Extensions → G-Integrator for Shopify → Shopify Sign In.
    • Enter your store domain, for example my-store.myshopify.com. The add-on remembers the domain, so next time it will be pre-filled.
    • A Shopify page opens asking you to install the G-Integrator app for your store. Review the requested (read-only) scopes and click Install.
    • Return to the spreadsheet and click "I have installed the app" to finish the connection.
  • Q: How to disconnect the G-Integrator app from my Shopify store?
    A:

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

    To uninstall:
    1. Log in to your Shopify admin (admin.shopify.com).
    2. In the left sidebar, click Settings → Apps and sales channels.
    3. Find the G-Integrator app in the list.
    4. Click Uninstall and confirm.
    This immediately revokes the add-on's access token, so no further data can be read from your store.
  • Q: What Shopify scopes (permissions) does the add-on require?
    A: The add-on requests read-only scopes — it never modifies your store data:
    Scope Description
    read_productsRead products, variants, images and collections.
    read_ordersRead orders, line items, tax lines, discount codes and shipping lines.
    read_draft_ordersRead draft orders.
    read_customersRead customer records.
    read_locationsRead store locations.
    read_price_rulesRead price rules and discounts.
    Your Shopify account must have permission to install apps. If you don't, please contact your store owner to install the app or grant you the necessary staff permissions.
  • Q: Which Shopify objects (modules) can I download?
    A: The following modules are available in the "Get Data" sidebar:
    • Products — including variants, images and options as dot-path columns (e.g. variants.price)
    • Orders — all statuses, including nested line items, tax lines, discount codes and shipping lines
    • Draft Orders
    • Customers
    • Custom Collections, Smart Collections and Collects
    • Locations
    • Price Rules
    • Line Items, Tax Lines, Discount Codes, Shipping Lines — the order children flattened into standalone tables, each row enriched with its parent order id and name
  • Q: What Google Account permissions does G-Integrator for Shopify require and why?
    A: The list below:
    • See, edit, create, and delete your spreadsheets in Google Drive™: we need this to insert content from Shopify into your spreadsheet.
    • Connect to an external service: This is obvious: Shopify 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 Shopify → Get Modules Records" or "G-Integrator for Shopify → Modify/Delete templates", click on tab "3. Select the fields to filter by". You can combine several conditions with AND/OR, e.g. financial_status equals "paid" AND total_price greater than 100.
  • Q: How are nested objects like line items shown in the spreadsheet?
    A: Nested fields become dot-path columns, e.g. line_items.name or customer.email. When a selected column crosses a child array (like line items of an order), the order is expanded into one row per array element — an outer join where the order's own fields are repeated on every row. This matches the format of Shopify's own CSV exports.
    If you prefer to work with the children as standalone tables, use the dedicated Line Items, Tax Lines, Discount Codes and Shipping Lines modules: each row there carries its parent order_id and order_name.
  • A: Yes. The id column of every module with an admin page (Orders, Draft Orders, Products, Customers, Collections, ...) is rendered as a clickable link that opens the record directly in your Shopify admin, e.g. https://admin.shopify.com/store/my-store/draft_orders/1296864411940. You can turn this off with the "Link to record" checkbox in the template settings.
  • Q: I've changed data in Shopify 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 Shopify 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 Shopify → 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 Shopify. 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 Module records" 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 Module records" 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 updated_at or created_at 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 Module records" 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: I see my open orders, but where are the draft orders?
    A: In Shopify, draft orders are a separate resource from orders. Use the dedicated Draft Orders module to download them. Similarly, the Orders module downloads orders with any status (open, closed and cancelled) by default.
  • Q: Is it possible to use G-Integrator for Shopify on my smartphone?
    A: The G-Integrator for Shopify 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 Shopify → 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 Shopify 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:
    • Log into your ChargeBee account using your Google email address and change subscription/un-subscribe
    • Send us an email at [email protected] and we will do the required action.