How to automatically track HubSpot ticket status changes in Google Sheets

Relay.app is an automation tool that lets you automate actions across HubSpot, Google Sheets, and many other apps.
HubSpot logoGoogle Sheets logo
1

Set the HubSpot trigger as “Ticket status changed”

Once you have finished creating your playbook, the next step would be to begin with the first action. A playbook always starts with a trigger, which is responsible for detecting changes in your connected applications and responding accordingly.

Add the HubSpot trigger to initiate your playbook's actions each time the ticket status changes. Click "Add trigger" in your playbook and choose "Ticket status changed" from the dropdown menu under HubSpot. This will allow your playbook to automatically identify newly changed ticket status and trigger necessary actions.

If you still need to connect your HubSpot account to Relay.app yet, a prompt will guide you through the process.

2

Add the "Add row to sheet" step in Google Sheets

Integrate the Google Sheets automation into your playbook to ensure the prompt addition of rows in Google Sheets whenever HubSpot ticket status changes.

Click the "Add step" button, then locate the "Add row to sheet” automation for Google Sheets and input the mandatory and relevant details.

If your Google Sheets account still needs to be connected to Relay.app, you will be prompted to complete that connection. Make sure to allow the necessary permissions for Relay.app to sync with your Google Sheets account.

3

Activate your playbook

Activating your playbook is the last step in the process. Once you turn it on, it will automatically track HubSpot ticket status changes in Google Sheets without requiring manual intervention.

To activate your playbook, click the toggle button at the header. Before activating, we recommend performing a test run of your playbook to ensure all the steps work seamlessly together.

More how-to guides featuring HubSpot and Google Sheets

See all how-to guides ➔

What will you automate?

Sign up and get started with your first Relay.app workflow today.
Background imageBackground image