General

• Q: How to install HubSpot add-on and connect the HubSpot Account to the spreadsheet?
  A:

  • First, install the add-on from the Google Marketplace
  • Then, click the menu HubSpot Sign In. Please see the screenshot with the HubSpot scopes required by the G-Integrator add-on. Please click the "Approve" button at the bottom when prompted.
  See How It Works
• Q: How to disconnect G-Integrator app from my HubSpot Account?
  A:

  ⚠️ After disconnecting the G-Inregrator app, all active workflows will stop working, but your HubSpot data will remain unaffected.

  To uninstall, you have two ways:

  1. From G-Integrator app: open menu "About" → "Disconnect G-Integrator from my HubSpot account"
  2. From HubSpot account
     • Log in to HubSpot
     • Access your settings:
       • In the top-right corner, click your profile picture or account name.
       • From the dropdown menu, select Settings ⚙️.
     • Navigate to Connected Apps:
       • In the left sidebar menu, click Integrations → Connected Apps.
         (In some accounts, it may appear as Apps → Connected Apps.)
     • Uninstall G-Integrator app
       • You’ll see a list of all the apps connected to your HubSpot account.
       • From here, click the Actions menu for the "G-Integrator" app and select "Uninstall".
• Q: What HubSpot scopes are required for the add-on?
  A:

  This screenshot shows all HubSpot scopes required by the G-Integrator add-on. Please click the "Approve" button at the bottom when prompted.

  Your HubSpot account must have access to these scopes. If you don’t, please contact your HubSpot administrator to grant the necessary permissions.

  Mandatory:

  Scope	Description
  crm.schemas.deals.read	Read deal object schema and properties.
  crm.schemas.line_items.read	Read line item object schema and properties.
  oauth	Authorize via OAuth and manage authentication tokens.
  crm.objects.owners.read	Read CRM owner records (users who own objects).
  crm.objects.contacts.write	Create, update, or delete contact records.
  crm.objects.companies.write	Create, update, or delete company records.
  crm.objects.companies.read	Read company records.
  crm.objects.deals.read	Read deal records.
  crm.schemas.contacts.read	Read contact object schema and properties.
  crm.objects.deals.write	Create, update, or delete deal records.
  crm.objects.contacts.read	Read contact records.
  crm.schemas.companies.read	Read company object schema and properties.

  Optional:

  Scope	Description
  crm.objects.line_items.read	Read line item records.
  content	Access CMS content and website tools.
  crm.objects.line_items.write	Create, update, or delete line item records.
  crm.objects.carts.read	Read cart records.
  social	Access social media tools and data.
  automation	Access automation and workflows.
  business-intelligence	Access analytics, reports, and BI tools.
  forms	Access Forms and form submissions.
  crm.schemas.invoices.read	Read invoice object schema and properties.
  hubdb	Access HubDB tables and rows.
  tickets	Access ticket records.
  e-commerce	Access e-commerce features like orders and products.
  crm.schemas.custom.read	Read custom object schema and properties.
  marketing.campaigns.read	Read marketing campaign data.
  crm.objects.feedback_submissions.read	Read feedback submission records.
  crm.objects.custom.read	Read custom object records.
  crm.objects.custom.write	Create, update, or delete custom object records.
  sales-email-read	Read sales email engagement data.
  crm.objects.goals.read	Read goals records.
  crm.lists.read	Read contact lists.
  crm.objects.quotes.read	Read quote records.
  crm.schemas.carts.read	Read cart object schema and properties.

• Q: What Google Account permissions does G-Integrator for HubSpot require and why?
  A: Please check the screenshot and the list below:
  • See, edit, create, and delete your spreadsheets in Google Drive™: we need this to insert content from HubSpot to your spreadsheet, make a backup copy of the spreadsheet (under development right now), etc.
  • Connect to an external service: This is obvious: HubSpot is an external service.
  • Allow this application to run when you are not present: we need this to run your 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.
• Q: I get "This app hasn't been granted all required scopes to make this call" (MISSING_SCOPES) — for example when clicking "Get HubSpot DB Data".
  A: The error comes from HubSpot: the HubSpot user you signed in with does not have the scope required by that query (e.g. hubdb for HubDB tables, crm.objects.subscriptions.read for Subscriptions, e-commerce for Products). Some scopes are only available on higher HubSpot tiers (for example, HubDB works on an Enterprise account but not on a Regular one). Ask your HubSpot administrator to grant the permission, then sign out via "HubSpot Sign Out From…" and sign back in so the add-on refreshes its permissions. See the full scope list in "What HubSpot scopes are required for the add-on?".
• Q: I signed in to HubSpot from a new spreadsheet, the window closed without an error, but the add-on still isn't connected.
  A: After signing in, click the menu "Refresh Menu after Sign In". The add-on menu is built when the spreadsheet opens, so it needs to be refreshed once before the connected account appears.
• Q: I get a "Bandwidth quota exceeded" error.
  A: This is a Google Workspace limit, not a G-Integrator error: each Google account may transfer 2 GB per day, cumulatively across all add-ons, scripts and integrations. When the cap is reached, Google pauses transfers until the 24-hour cycle resets. To resolve and prevent it:

  • Wait 24 hours for the quota to reset.
  • Check for other add-ons or scripts sharing the same quota.
  • Change "Hourly" refreshes of large datasets to "Daily" or "Twice daily".
  • Filter at the source to import fewer rows and columns.
• Q: How do I share my template with support for troubleshooting?
  A: Use the cloud templates feature to share the template with [email protected]. Sharing a working and a non-working template side by side speeds up diagnosis. Please paste example records as text rather than screenshots.
• Q: All my automations failed at the same time with a server error (e.g. 504).
  A: This indicates a temporary problem on the G-Integrator server side, not in your templates. Retry after 15–20 minutes; if the error persists, email [email protected] — no changes to your templates are needed.

Download data

• Q: Some deals are missing from my download even though I have no filters excluding them. Which date does the Date Range filter use?
  A: The Date Range filter in G-Integrator for HubSpot filters records by their Create Date, not by their Close Date (or any other date field).

  A deal with a Close Date inside your range will still be excluded if it was created before the start of the range. For example, a deal closing in June 2026 that was created in 2024 will not appear when the Date Range starts in January 2025 — extend the start date back to 2023 and the deal is picked up.

  If deals are missing, check the following in order:

  1. Date Range — by default it covers the current month only. Extend the start date far enough back to include the creation date of the oldest record you need (it can go up to 10 years back).
  2. Template account — make sure both templates are connected to the same HubSpot account. Open "Update/Modify/Delete Templates" and compare the account shown for each template.
  3. If neither explains it, share the working and the non-working template with support via the cloud templates feature.

  To filter by Close Date instead, leave the Date Range wide and add a filter on the Close Date field in tab "3. Select the fields to filter by".
• Q: How can I edit an existing query template?
  A: menu "Modify/Delete Templates for Current Sheet" OR "Modify/Delete All Templates"
  See How It Works
• Q: How can I filter data to get only the records I need?
  A: In "G-Integrator for HubSpot → Get Modules Records" or "G-Integrator for HubSpot → Modify/Delete templates". Then click on tab "3. Select the fields to filter by"
  See How It Works
• Q: How can I re-order columns in the resulted data set?
  A: By default, columns sorted alphabetically. To use a custom order, please click on the button and the use the mouse to drag the columns into desired order.
  
• Q: I've changed data in HubSpot 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 decrease the number of calls to HubSpot API (we have a daily limit and should pay if we exceed it). 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 HubSpot → Modify/Delete Pull templates" menu, change the query: add or remove column, change filter, etc. This will be considered as a new query.
• What is worklflow and how to use it?
  Workflow synchronizes your Spreadsheet with HubSpot automatically, by the schedule. Using the workflow, you can:

  • Add more than one template to be executed in the selected order
  • Turn the execution on and off without changing the schedule
  • Add or remove templates to the workflow
  • Pre-load the data to deal with the 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 data you want the workflow to refresh.
  • Repeat this operation for as many modules as you need.
  • Using the menu "Automation → Create Workflow", setup the workflow:
    • Enter the name and the description
    • Add the templates in the desired order
    • Setup the schedule
    • (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"

  See How It Works
• I have deleted the spreadsheet's tab with the workflow, but I continue to receive notifications about this tab. How to stop it?

  A: The correct way to stop the workflow will be to turn it "off" or delete it using the "Automation" → "Update/Modify/Delete Workflows" menu. If you delete the spreadsheet's tab, it would not stop the workflow because it's executed by the small script in your spreadsheet called "trigger". In this case, you will have to delete this trigger to stop the workflow.

  Please do the following:

  • In the spreadsheet, click the memu "Tools" → "Script editor"
  • Save the project by clicking Ctrl → S (Command→S on Mac)
  • Click menu "Edit" → "All your triggers"
  • Locate the the Project's name "G-Integrator for HubSpot"
  • Click 3-sdots menu on the right → "Delete trigger"
  • You will need to setup the workflow again if you used it in other tabs with HubSpot data

  See How It Works
• 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 "Modified Time" or "Created Time" field ( screenshot).
    
  • Attention: by default, each new download will erase the previous data. To avoid this, please use "Add to the previous output" option (see below).
• 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 ( screenshot).
    
  • 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.
• How can I use my own format for the Currency fields?
  A: By default, we will format all HubSpot fields with type "Currency" using an ISO 4217 for the location settings in your Google Spreadsheet. If you want to change this format, you can do the following:

  • In the tab "2. Change Pull Settings (optional)", uncheck the "Format currency fields using Organization's currency" checkbox ( screenshot).
    
  • Using the Google Spreadsheet "Format" menu, change the column's format to desired one.
• Q: Is it possible to use G-Integrator for HubSpot on my smartphone?
  A: The G-Integrator for HubSpot Add-on 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 the automatic data synchronization using "G-Integrator for HubSpot → Get Automation" menu. After this, you will be able to see updated data from the "Google Sheets™" app on your smartphone.
• Q: Number and currency fields (e.g. Amount) arrive as text in my sheet.
  A: HubSpot sends these fields with dataType "number"; how they display is controlled by the Google Sheets column format. Select the column → Format → Number and choose the format — it is preserved on later refreshes. If values still look like text, check the spreadsheet locale (File → Settings) first, then refresh, then apply the format. See also "How can I use my own format for the Currency fields?".
• Q: Which field tells me when a contact or deal was last contacted?
  A: Use "Last Contacted" (HubSpot API name notes_last_contacted, "the last time a call, email or meeting was logged"). It exists on both the Contact and the Deal object, so you can report at either level. Related fields: "Last Activity Date", "Next Activity Date", "Number of times contacted".
• Q: My upsert / filter template stopped working after I changed fields in HubSpot.
  A: Open the template in "Modify/Delete Templates" and re-map the columns; a renamed or deleted HubSpot property breaks the saved mapping. If a filter on a picklist (e.g. Contact Type IN Child) returns an empty result, share the template with support via the cloud templates feature.
• Q: My scheduled workflow stopped refreshing / shows stale totals.
  A: Two common causes seen in support:

  1. File ownership. Scheduled scripts can behave unpredictably when the user who created the workflow is not the owner of the spreadsheet. Transfer ownership of the file to the user who owns the G-Integrator license (Google Drive → Share → transfer ownership), then re-create the workflow.
  2. Hard-coded values. Totals in a dashboard tab that were pasted as values (not formulas) will never change. Check the "Automatic Operations Events Log" tab — if the data refresh succeeded, the issue is in the dashboard formulas, not in the sync.

Upload data

• Q: How to upload a Deal with Deal Pipeline and Deal Stage?
  A: You will have to provide both pipeline ID and stage ID. For this, you can:

  • Download a "Deal Pipeline" object with the following fields: "Label", "Deal Pipeline Id", "DealStage.Label", "DealStage.Stage Id"
  • For the Deal object you want to upload, add desired "Deal Pipeline Id" and corresponding "DealStage.Stage Id" values.
  • Map "Deal Pipeline Id" to the "pipeline" and "DealStage.Stage Id" to the "dealstage" in the upload template
  • Upload and verify
  See How It Works

Subscriptions

• Q: Where I can see the available subscriptions?
  A: We provide 4 types of subscriptions: Lite yearly/monthly and Premium yearly/monthly. Please see our price page for the comparison and details.
• 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 subscribe?
  A: Click "Go Premium" menu in the "G-Integrator for HubSpot" add-on.
• Q: How can I be sure that my credit card number I provide will be safe?
  A: We use well-known and respected PCI Level 1 certified billing platform ChargeBee. All payment processing made by them, we cannot see your credit card's number at all - ChargeBee will show us only the last 4 digits.
• Q: I've paid for the subscription, but clicking on "Go Premium" still shows me "Trial Premium" status.
  A: We cache the premium subscription's status for a few hours, this is why you still see the "Trial Premium". This status gives you full access to all services, so you should not be worried.
• Q: How can I subscribe?
  A: Click "Go Premium" menu in the "G-Integrator for HubSpot" add-on.
• Q: How can I change subscription or unsubscribe?
  A: There are two options:

  • Log into G-Integrator Subscription Manager using your Google email address and change subscription/un-subscribe
  • Send us an email on [email protected] and we will do the required action.
• Q: How can I apply the coupon?
  A: Click "Apply Coupon" in the first screen during the subscription. Please see the screenshot .

  
• Q: Can I use one G-Integrator subscription with several HubSpot portals?
  A: Yes. Premium subscribers can connect multiple HubSpot portals; sign out and sign in to each portal from the add-on. Templates you saved keep working after you sign out. A license can also be re-assigned to another user by emailing [email protected].
• Q: Where can I see and download my invoices?
  A: Log in to the Subscription Manager with the Google account used for the subscription. It lists all invoices for download, your active plan(s) and team seats. See the Help Center for details.
• Q: How do I add licenses / seats for colleagues?
  A: Either add team seats yourself in the Subscription Manager, or email [email protected] the addresses of the new users and we will add them to your existing subscription so everything stays on one invoice. Additional seats on an existing subscription get a discounted price.
• Q: I am charged twice — a yearly and a monthly invoice.
  A: Two subscriptions exist under two different Google accounts (for example, a yearly one under a shared mailbox and a monthly one under a personal address). In the Subscription Manager, sign in with each account to see which subscription it holds; cancel the one you don't need via the "Chargebee portal ↗" link, or email [email protected] with the invoice numbers and we will consolidate them.
• Q: Which user is my Customer ID linked to?
  A: The Customer ID on the invoice is tied to the Google email that created the subscription. Email [email protected] with the Customer ID or invoice number and we will confirm the account.
• Q: What happens after I cancel?
  A: The subscription remains active until the end of the paid term; you keep full access until then. Within the first 30 days you can request a full refund; after that a pro-rated credit is generated. Cancellation can be done from the Subscription Manager or by emailing [email protected].
• Q: My card payment failed — what happens to my subscription?
  A: You will receive a payment-due email with a link to update the payment method. Unpaid invoices lead to automatic cancellation; once payment is received, support reactivates the subscription. If you believe an amount due is wrong, reply to the email with a screenshot of the invoice.