Customer operations · AI workflows · CRM automation

I build automation systems that reduce manual work and improve customer operations.

I help businesses connect CRMs, support tools, spreadsheets, email, Slack, Shopify, and AI workflows into reliable systems that save time, reduce missed follow-ups, and make operations easier to manage.

13+years in customer operations, support, and account management
80%manual work reduction tied to n8n operations automation
37%faster response times tied to Freshdesk workflow automation
25%repeat customer improvement tied to after-sales process improvements

Featured automation projects

Selected systems and tools I have built or worked on. Each project focuses on a real business workflow: reduce repetitive work, improve visibility, and make follow-through easier.

Internal tool

Shift Task Tracker

A self-developed time/task tracking tool designed to help team members document work with clear timestamps and improve transparency.

User starts taskTimestamp savedDaily work visible
What a walkthrough would show

Detailed view: task timing, task notes, and saved timestamps can be shown in a walkthrough once screenshots are approved for public use.

Problem
Task entries and hours were being documented inconsistently, making daily productivity harder to review.
Automation
Built a simple tool where users can start, save, and timestamp tasks independently of existing case software.
Result
Gave leadership a clearer view of task timing and was bookmarked for review as a stronger tracking workflow.
Time trackingTask loggingTeam operationsProductivity
Automation architecture

n8n Operations Automation

End-to-end low-code automation architecture connecting team tools and reducing repetitive cross-platform work.

Trigger eventn8n workflowSlack/Sheets/Shopify update
What a walkthrough would show

Detailed view: workflow canvas screenshots or a short screen recording can show trigger, processing, error handling, and output steps.

Problem
Teams were handling repeatable updates, notifications, and data movement manually across separate tools.
Automation
Designed workflows integrating Airtable, Slack, Shopify, Google Workspace, APIs, retries, and error handling.
Result
Reduced manual work by up to 80% while improving long-term maintainability.
n8nAirtableSlackShopifyGoogle Workspace
Customer support ops

Freshdesk Ticket Workflow Automation

Support workflow improvements for ticket routing, escalations, refunds, chargebacks, and faster customer response.

Ticket arrivesFreshdesk rules route workAgent resolves faster
What a walkthrough would show

Detailed view: connect the 37% response-time improvement to before/after ticket handling and permitted Freshdesk screenshots.

Problem
Support agents needed faster handling of repetitive ticket actions and escalations.
Automation
Implemented Freshdesk workflow automation to streamline ticket resolution processes.
Result
Reduced response times by 37% and supported higher customer satisfaction.
FreshdeskCustomer serviceEscalationsWorkflow rules
Knowledge system

Meeting Notes Knowledgebase

A local searchable knowledgebase that turns meeting-note emails and summaries into organized Markdown records.

Meeting notes arriveMarkdown record createdSearchable knowledgebase
What a walkthrough would show

Detailed view: show a safe sample note, folder structure, and how a prior action item can be retrieved quickly.

Problem
Important meeting takeaways, action items, and process decisions were scattered across notes and emails.
Automation
Built an ingest workflow to save meeting notes into a structured local knowledgebase with compact summaries and searchable files.
Result
Makes prior decisions, tasks, and discussions easier to retrieve without manually searching every email.
GmailGemini notesMarkdownKnowledgebaseSearch
Communication automation

Client Email Sender from Google Sheets

A structured email workflow that uses a Google Sheet as the control panel for client messages and send tracking.

Sheet row readyEmail template mergesStatus + Sent At logged
What a walkthrough would show

Detailed view: show the Google Sheet schema and one sample message with private client data removed.

Problem
Sending individualized client emails manually creates risk of missed status updates and inconsistent formatting.
Automation
Used columns for Email, Client Name, Clio Matter Number, Subject Text, Email Body, Status, and Sent At.
Result
Created a repeatable sender format with status tracking and client-specific message templates.
Google SheetsGmailClioTemplatesStatus tracking
Local productivity app

YouTube Transcript Tool

A local Windows-friendly transcript workflow for downloading and working with YouTube transcripts without relying on cloud hosting.

Paste video URLLocal tool fetches transcriptTranscript reused
What a walkthrough would show

Detailed view: show the Windows launcher and transcript output after replacing any private paths.

Problem
Cloud-hosted transcript tools can be blocked by YouTube or fail because of cloud IP restrictions.
Automation
Designed a local browser/desktop shortcut approach for transcript downloading and reuse.
Result
Improved reliability by keeping the workflow local and easy to launch from Windows.
YouTubeLocal toolWindows .batTranscript extraction
Daily ops automation

Slack Roll-Call Automation

A scheduled workday automation for consistent login/logout messaging and operational reminders.

Schedule firesSlack message postsSkip/unskip controls state
What a walkthrough would show

Detailed view: show the scheduled workflow logic and safe sample Slack output.

Problem
Daily status posts and routine schedule actions are easy to forget when handled manually.
Automation
Created scheduled Slack roll-call behavior for weekday login/logout workflows with skip/unskip controls.
Result
Improved consistency for repetitive daily team communication.
SlackSchedulingCronStatus updates
Automation assistant

HaloPSA Agent Workspace

A specialist automation workspace for HaloPSA/API workflows, testing, and workflow Q&A.

API question/workflowKnowledge source + testsReusable HaloPSA automation pattern
What a walkthrough would show

Detailed view: show test output and sanitized API workflow diagrams when ready.

Problem
Service management tools require repeatable API knowledge, testing, and SOP-aware workflow handling.
Automation
Set up a profile/workspace pattern with tests and a NotebookLM knowledge source for HaloPSA API and workflow questions.
Result
Creates a reusable foundation for future HaloPSA automations and troubleshooting.
HaloPSAAPI workflowsTestingKnowledge assistant

How I build automations

My background in customer support and account operations helps me design automations around the real workflow — not just the tools.

Map

Identify repetitive steps, handoffs, bottlenecks, owners, and failure points.

Design

Define triggers, tools, data flow, permissions, logs, and exception handling.

Build

Connect CRMs, sheets, APIs, webhooks, email/SMS, Slack, and AI workflows.

Test

Verify common cases, edge cases, retries, status tracking, and team usability.

Improve

Monitor failures, refine the workflow, document it, and expand the system.

Tools I work with

Grouped by the kind of business workflow they support.

Automation

  • n8n
  • Pabbly
  • GoHighLevel
  • APIs
  • Webhooks

CRM & support

  • Freshdesk
  • Zendesk
  • Gorgias
  • HubSpot
  • Clio

Business ops

  • Google Sheets
  • Excel
  • Google Workspace
  • Airtable
  • Slack
  • Shopify

Technical

  • MySQL
  • Data analysis
  • Workflow docs
  • Quality assurance
  • Process implementation

Business-first automation experience

My background includes customer service management, account management, technical support, technical training, CRM operations, and workflow automation. That means I build systems that are technically useful and practical for real teams.

  • Lead Automation Specialist — Scalewise Automation
  • Customer Service Manager — Protus Brand
  • Account Specialist — MNF Group / Symbio
  • Technical Trainer — Delivery Hero AU
  • Account Manager — More Telecom

Portfolio message

I do not just connect apps. I help turn messy recurring work into trackable, repeatable systems that support customer operations and team accountability.

Want to automate a workflow?

Tell me what repetitive process you want fixed. I can map the workflow, recommend the stack, and build a first version.

NameTristan Guanco
Websiteautomationsbytristan.site
Backup domainautomationsbytristan.xyz
FocusCustomer operations automation

Form fallback: if submission is blocked, email tristanguanco@gmail.com directly.