How to see your HubSpot email events

Dear customers, today we have added a new login type to our G-Accon for HubSpot add-on. So, at this moment, we have following login types:

  • Hubspot basic (content only) customer
  • Hubspot reports (content + reports)
  • Hubspot premium (all Hubspot data)

You may be confused: why there are so many login types and what type should you use? To answer this question, let me give you very brief and informal description of the HubSpot authentication.

HubSpot uses the industry standard, called OAuth (Open Authorization). The idea is following:

  1. When you open G-Accon for HubSpot menu and click on any “Sign In” item, our application will connect HubSpot and say: “Hey, I have a customer who wants me to get some data from his HubSpot account. And here is a list of HubSpot tables I need to get access to”.
  2. HubSpot will redirect you to the login page for authorization. Please pay attention: we never will see your password! This is the main idea of the OAuth.
  3. After the successful authorization, HubSpot will check, if it can provide access to the requested data. And here is the explanation, why we need three different login types: because of HubSpot has different access types. So, if you have access only to basic content, HubSpot will show an error, if our application will request access to reports or workflows.

So, here is the set of different types of HubSpot data:

  1. Contacts
  2. Content
  3. Files
  4. Forms
  5. Reports
  6. HubDB
  7. Social
  8. Workflows

And, now, please have a look, what each login type will request:

  • Hubspot basic (content only)
    • Contacts
    • Forms
  • Hubspot reports (content + reports)
    • Contacts
    • Forms
    • Content
    • Reports
  • Hubspot premium (all Hubspot data)
    • Contacts
    • Forms
    • Content
    • Reports
    • HubDB
    • Social
    • Workflows

As a rule of thumb, you always can start with more premium type and, if you get a Hubspot error after login, switch to the less premium.

Hope, this will make your choice less confusing.

Automatic generation and emailing of Xero reports

G-Accon development team just finished a new release and added new features for beta testing:

1. Automatic Refresh – Data Operation Scheduler – Beta Test

Refresh your reports & dashboards automatically using a flexible schedule.

2.  Automatic Refresh – Notifications – Beta Test

Send real-time reports to your clients automatically.

3.  Automatic Refresh – Alerts – Beta Test

Data Monitoring & Alerts, create alerts and receive notifications if certain criteria is met.

Backup Your Reports, save reports snapshots to Google Drive to keep historical data.

5. “Refresh Current For All Organizations” – Beta Test – Refreshes all reports and queries in the current active sheet. Refresh works for multiple organizations.

6. “Refresh All For All Organizations”- Beta Test – Goes through all sheets in the current Google Spreadsheet and refreshes all reports and queries. Refresh works for multiple organizations.

Read more: G-Accon for Xero Documentation

G-Accon for Xero Release Notes 4/18/18

G-Accon development team just finished a new release and added new features. Check them out!

1. Now you can modify, update or delete query or report metadata.

Click on query/report name to modify request metadata or press delete  button to remove created pull mapping.

2. Added dynamic date range – To and From dates will be dynamically calculated based on the selected period.

3. Date range dates can now be populated from Google Sheet cells.

4. Queries ids can be set as a Google sheet range.

5. A new pull settings have been added:
Display only account codes will omit account names and will display only account codes.
Freeze Data Table Header will freeze header row.
Mapping Name (optional) – use it to assign custom name to the report or query mappings.

6. Refresh Current and Refresh All added status screens.

7. Added multi organization support.

8. Fiscal and calendar years are now supported

Get G-Accon for Xero Now

Happy Accounting!

G-Accon Team

G-Accon for Hubspot

Dear friends!
We are happy to announce, that, since February 2018, we have added one more integration product to our family: G-Accon for Hubspot.

Currently it is in early proof-of-concept status, with improvements and additions made almost every day. At this moment, following tables are available to download into Google spreadsheet:

  • Blogs
  • Broadcast Messages
  • Calendar Events
  • Companies
  • Contact Lists
  • Contacts
  • Deal Pipelines
  • Deal Properties
  • Deals
  • Email Events
  • Owners
  • PublishingChannels
  • Subscriptions
  • Workflows

As always, we are eager for your feedback. Please contact us – by emailing to, or leaving comment in this blog, with any concerns or suggestions.