Tag: hubspot

Posted on

HubSpot Webhooks: Refresh Google Sheets the Moment a Deal Changes

Your HubSpot pipeline moves all day, but a spreadsheet only knows what happened at its last refresh. With webhooks in G-Integrator for HubSpot, a change in HubSpot can tell Google Sheets to update itself right away. Each spreadsheet gets a secret, token-protected webhook URL. Call it, and G-Integrator re-runs your saved query templates and writes fresh HubSpot data into the sheet within seconds.

What HubSpot webhooks add

Before webhooks, a sheet refreshed when you clicked the add-on menu or when a scheduled workflow ran. Now there is an event-driven option: the moment a contact, company or deal changes, HubSpot (or any tool watching it) can trigger the refresh.

  • Instant updates. Your sheet changes when HubSpot data changes, not on the next hourly run.
  • Runs on our servers. The refresh works even while the spreadsheet is closed.
  • Your layout stays intact. Saved templates are re-run exactly as you built them.
  • Any trigger works. HubSpot workflows, Zapier, Make, a cron job or a simple browser bookmark.

A webhook refreshes anything the HubSpot add-on can pull, including contacts, companies, deals, and the 35+ built-in analytics reports.

Set up a HubSpot webhook for Google Sheets

  1. In the add-on menu, open Automation… → Manage Webhooks.
  2. Click Generate / Rotate Token to create your webhook URL.
  3. Click Authorize Google once per spreadsheet so G-Integrator can write the refreshed data.
  4. Choose a Run target: all templates or a single workflow.
  5. Click Copy URL and paste it wherever the refresh should be triggered.

The URL accepts both GET and POST requests. To refresh only one workflow’s templates, add ?workflow=<workflow-uuid> to the URL; the dialog builds it for you.

Trigger the refresh from a HubSpot workflow

In HubSpot, create a workflow with the enrollment trigger you care about, such as a deal moving to Closed Won. Add a Send a webhook action, choose GET or POST, and paste your G-Integrator URL. Webhook actions in HubSpot workflows depend on your HubSpot subscription. If yours does not include them, Zapier or Make can watch HubSpot and call the URL instead.

Ideas for HubSpot teams

  • Closed won, sheet updated. A deal stage change calls the webhook, and your sales dashboard shows the win in seconds.
  • Fresh lead lists. New form submissions trigger a refresh of the contacts sheet your sales reps work from.
  • Ready for the pipeline review. Save the URL as a bookmark and click it before the weekly sales meeting.
  • Always-current dashboards. Call the webhook before Looker Studio reads the sheet, so reports never show stale numbers.

Logged, secured and rate-limited

Every webhook run appears in the Automatic Operations Events Log tab, next to your scheduled workflows, so you can confirm a trigger fired and see which sheets changed. If a URL leaks, rotate the token in Manage Webhooks and the old URL stops working at once, or revoke the token entirely. By default each webhook runs at most once per hour. Extra calls are rejected without touching your data, and the JSON response tells you when to retry.

Try HubSpot webhooks today

Webhooks come with the Premium subscription at no extra cost, and LITE users get a two-week trial. Open Automation… → Manage Webhooks in G-Integrator for HubSpot to connect your first trigger. Using Zoho too? See our Zoho webhooks guide.

Posted on

New Feature: Easily Disconnect G-Integrator from Your HubSpot Account

Dear clients,

As part of our ongoing commitment to making the G-Integrator app safer and more transparent, we’ve added a small but important new feature – a menu option that allows you to disconnect G-Integrator from your HubSpot account.

To understand why this might be useful, let’s briefly go over how the connection works.

When you first sign in to your HubSpot account through G-Integrator, HubSpot displays the app authorization screen. By clicking “Connect app”, you grant G-Integrator permission to read and write specific data in your HubSpot account – exactly as described on that screen.

We deeply value your trust and will never misuse these permissions. However, we recognize that you may sometimes wish to revoke access.

You can always do this directly in your HubSpot account by navigating to Integrations → Connected Apps, then selecting Uninstall (see our FAQ for detailed steps). But in the spirit of full transparency, we wanted to make it even simpler – just one click away.

That’s why we’ve introduced a new menu option:
About → Disconnect G-Integrator from my HubSpot account

Selecting this option will send a secure API call to HubSpot to disconnect G-Integrator from your account. None of your HubSpot data will be affected, and you can reconnect anytime by choosing HubSpot Sign In menu again.

We hope you’ll never need to use this option – but it’s there for your peace of mind.

Posted on

Upload to multiple tables

Attention all HubSpot users! We have some exciting news for you. The G-Integrator for HubSpot just got even better. We have added new functionality that will allow you to upload data to multiple tables at once. This means that you can now create new deals and simultaneously add associated contacts and line items with ease.

To use this new functionality, you will need to open the menu “Upload” → “Upload to HubSpot multiple tables”. From there, you can select the master table, which in this case would be “Deals”. Then you will need to add field mapping for it. Once that is done, you can select the detailed table, which could be “Contacts”. Again, add the field mapping for this table. If you have another detail table, you can add that as well.

With this new functionality, you no longer need to upload data to each table separately, which can be time-consuming and prone to errors. Instead, you can upload all the necessary data in one go, saving you time and effort. This is especially useful for those who have complex data structures in HubSpot, where multiple tables are linked together.

The G-Integrator for HubSpot has always been a great tool for managing sales data, but with this new functionality, it has become even more powerful. You can now upload data to multiple tables with ease, without having to worry about errors or missing information.

Let’s have a look at it. In our example, we will upload to HubSpot five deals. Each deal row in the spreadsheet will also have a first name, last name, and email of the associated contact and name, price, and SKU of the line item.

In summary, the G-Integrator for HubSpot now supports uploading data to multiple tables, making it easier and more efficient to manage your sales data in HubSpot. To use this new functionality, simply open the menu “Upload” → “Upload to HubSpot multiple tables”, select the master table, add the field mapping for it, and then select the detailed tables and add field mapping for them as well. If you have any questions about this new functionality or need help setting up your integration, please don’t hesitate to contact our support team.

Posted on

Service Spreadsheets timed out error

Dear clients, sometimes you will see the “Service Spreadsheets timed out” error while using G-Integrator to update the spreadsheet.

This is a known issue in the Google Script engine. We have a workaround for this. While it can’t give 100% reliability, it still works quite well, despite it will slow down the execution.

S, if you have got this error, please check the “Deal with timed out while accessing document” checkbox in the “Change Pull Settings” tab. We hope, that this will solve the problem.