🚀 Introducing the HubSpot Workflow Extraction Tool! 🚀

Inspired by Tyler Samani-Sprunk’s workflow audit table, I’ve created a HubSpot Workflow Audit tool that leverages the HubSpot API and OpenAI to extract, analyze, and create a comprehensive table of all your HubSpot workflows! – Say goodbye to excessive manual work.

🧠 The Rationale 🧠

Understanding the various workflow automations in a HubSpot instance is crucial for grasping its overall structure and HubSpot’s role in your stack, though it can be a complex process.

Recently, I came across Tyler’s HubSpot Audit table on LinkedIn, which emphasizes routine self-audits for HubSpot users. Ideally, instances would be well-documented and audits conducted regularly with business stakeholders; however, that’s often not the case.

Therefore – I’ve developed a straightforward tool to simplify the initial audit process, ideal for agency workers or new HubSpot admins who want to swiftly grasp the automations in their (likely) undocumented instance.

🔬 The Tool 🔬

The HubSpot Workflow Extractor is a simple Python script that connects to your HubSpot workflows via the HubSpot V3 and V4 APIs.

  • It does not read ANY data from your instance aside from the workflow structure.
  • It uses ChatGPT 3.5 by default, and moves to ChatGPT 4o only where needed (larger workflows) – thus saving time and costs.
  • It creates an Excel file with a list of workflows containing:
    • Workflow ID
    • Workflow Name
    • Link to the workflow in HubSpot
    • Whether the workflow is enabled or not
    • Created-At timestamp
    • Updated-At timestamp
    • Action count
    • Object type (Companies / Deals / Contacts / Tasks etc.)
    • Workflow-related properties (!!! – super useful)
    • Whether the workflow contains specific actions (change property, delay, send email etc.)
    • AI description of the workflow (if an OpenAI key is provided)
  • The tool is available to the public for free. You’re welcome to use, clone, and adapt it in any way that enhances your job performance 🙂

❓ How does the AI description differ from HubSpot’s? ❓

HubSpot AI descriptions (which also need to be applied manually per workflow) are basic and provide less data regarding the workflow. The HubSpot Workflow Extractor analyzes all of the workflows regardless of what is written in their existing description field.

❓ What do you need in order to run it? ❓

You need to create a Private HubSpot App and give it permission to read your workflows. That’s it!

If you wish to use the AI-assisted descriptions, you will also need an OpenAI key.

If you wish to run it on your own machine for maximum security, you’ll also need Python installed, alongside the Flask, requests, openpyxl, openai and APScheduler libraries.

🗃️ Where can I get it? 🗃️

Here: https://extract.itiszack.com

Or, alternatively, you can run the code yourself on your machine by downloading it here (and installing the required Python libraries).

Download, validate and use it on your own machine for maximum security.

Any questions? Feel free to contact me for further assistance or to share some thoughts.

Cheers,