Video unavailable? Watch on YouTube or read the written breakdown.
Sales and solutions work is full of small, repeated tasks: entering a new contact from a business card, researching an account before a call, finding a free slot, writing an agenda, logging the deal, drafting the follow-up. None of them is hard. Together they eat hours every week, and the ones that get skipped are the ones that lose deals.
This article breaks down five Zapier zaps Charley built for his own solutions-architect workflow, working alongside account executives. They connect Slack, Google Drive, Google Forms, Google Calendar, Google Sheets, Gmail, HubSpot and OpenAI, and use Zapier's AI agents for research. It follows the video walkthrough. The same design rules apply when we automate construction systems, so they're worth spelling out.
The building blocks
| Zapier feature | What it does in these zaps |
|---|---|
| Triggers (Slack, Google Forms) | Start a zap when a card photo is posted or an intake form is submitted |
| Filter | Decides whether a zap should run for this form submission |
| HubSpot actions | Find or create companies and contacts, add notes, add to lists, create tasks and deals, update deals |
| Formatter | Splits full names into first and last, cleans numbers |
| Code by Zapier | Small Python or JavaScript steps: pull the domain from an email address, extract a meeting link, convert times between time zones |
| AI agents | Research a person or company using web search, the CRM and documentation |
| AI by Zapier | Calls a large language model (OpenAI in the video) with a fixed prompt to write agendas, emails and subject lines |
| Approvals | Pauses the zap until a person approves or rejects a draft |
Zap 1: business card to HubSpot lead
At a conference, you want a new contact in the CRM before you forget the conversation.
- Post the card. A photo of the business card goes into a Slack channel.
- Store it. The zap saves the image to Google Drive.
- Read it. Nanonets OCR extracts the text: name, title, email, phone.
- Find the company. A code step takes the domain from the email address, and the zap searches HubSpot for a company with that domain, creating it only if none exists.
- Find the contact. Formatter splits the name into first and last; the zap searches HubSpot for the contact and creates it only if missing.
- Research. An AI agent looks up the person and the company: what the company does and what it is likely to care about.
- Write it back. The research goes into a HubSpot note, and the contact is added to a lead list for the account executive or a business development rep to follow up.
Zap 2: discovery call prep and scheduling
Account executives fill in one Google Form for every request. For a discovery call they enter the company, the point of contact, the call time and any notes.
- Filter to discovery requests only.
- Find or create the company and contact in HubSpot, the same way as zap 1.
- Research the organization with an agent, using what the account executive wrote, and save the findings as a HubSpot note.
- Work out the time. A code step turns the requested start into a start and end time in the right time zone.
- Check the calendar. If the slot is taken, the zap emails the account executive to pick another time. If it's free, it creates the calendar invite with a generated agenda attached.
Zap 3: demo intake, transcript and agenda
When the account executive brings in a solutions architect for a demo, the intake asks for more: the meeting link and what the team knows about the prospect's processes and software.
- Filter to demo requests.
- Pull context from HubSpot and research the company with an agent, focused on what the account executive entered.
- Transcribe the discovery call. In the video the recording is an audio file in Google Drive, transcribed with OpenAI. A Zoom or Gong recording works the same way.
- Analyze the call. An agent combines the research, the CRM record and the transcript into a discovery analysis.
- Check the calendar and either ask the account executive to reschedule or continue.
- Write the agenda. AI by Zapier turns the analysis into a demo agenda targeted at what the prospect said they need, and attaches it to the calendar invite.
- Open a deal. A scheduled demo is when an opportunity becomes worth tracking, so the zap creates a HubSpot deal.
- Notify. An email tells the solutions architect a demo has been booked.
Zap 4: demo follow-up and deal update
After the demo, the solutions architect submits the follow-up intake: expected deal size, expected close date, notes, and any links or resources the prospect asked for.
- Filter to follow-up submissions.
- Transcribe the demo from its recording.
- Gather context from HubSpot (company and deal) and a Google Sheet.
- Draft the follow-up with an agent.
- Clean the amount. The account executive typed a dollar sign and a comma; HubSpot's amount field expects a plain number, so Formatter and a code step strip both.
- Update the deal with the amount, the close date and the next step: send the contract.
Small data fixes like step 5 are where most automations break. Expect them, and put a cleanup step in front of every write to the CRM.
Zap 5: info requests with a human approval
Some prospects have questions before they sign. The account executive pastes the question into the info-request form.
- Create a HubSpot task right away, so the question can't fall through the cracks even if the rest of the zap fails.
- Research the answer. An agent searches Google, the CRM, and Zapier's documentation, help articles and community.
- Draft the email with AI by Zapier, then generate a subject line in a separate step.
- Ask a person. An approval step sends the draft for review. In the video the reviewer rejects it with "I need it to be more technical", and the zap loops back through the agent to produce a better draft.
- Save as a draft. The approved email lands in Gmail as a draft. A person still presses send.
Five rules that carry over to any automation
These are the same rules we follow when we connect Procore, accounting and scheduling systems:
- Capture the input once. One form with a type field beats five forms. Filters route each submission.
- Look up before you create. Search by a stable key (email domain, email address) before creating a record, or the CRM fills with duplicates.
- Write results back to the system of record. Research that lives in a chat window is lost. Research saved as a HubSpot note is there for the next person.
- Keep a person in the loop for anything a customer sees. Agents draft, people approve and send. Our guide to governing AI agents covers how to decide where approvals belong.
- Clean data at the boundary. Strip currency symbols, normalize names and convert time zones before writing to another system, not after it rejects the value.
When Zapier fits, and when to use something else
Zapier is quick to build in, has a very large catalog of app connections, and is a good fit for workflows like these where each step is a standard action on a SaaS tool. It gets harder when:
- You need to self-host or keep data in your own environment. n8n can be self-hosted; see our n8n construction nodes for a construction example.
- The workflow is really a data pipeline. Monthly reporting with history and quality checks belongs in a data platform, not a chain of zaps. See replacing the monthly Excel report.
- An agent needs many tools across systems with per-user permissions. That calls for MCP servers with governance; see what MCP is and why it matters for construction.
Where to go next
- Watch the walkthrough: AI sales automations with Zapier.
- Workflow automation for construction systems: custom n8n nodes for Procore, Autodesk, HCSS and Power BI.
- Put guardrails on agents: governing AI agents in construction.
- Automate your own handoffs: if your team re-types the same information between forms, CRM, calendar and email, tell us what you want to automate.
Frequently asked questions
Can Zapier add business card contacts to HubSpot?
Yes. In this build a card photo posted to Slack is saved to Google Drive, read with Nanonets OCR, and used to find or create the HubSpot company and contact. An AI agent then researches the person and company and the zap saves the findings as a HubSpot note.
What is the difference between Zapier AI agents and AI by Zapier?
In these zaps, AI agents do open-ended research using tools such as web search, the CRM and documentation. AI by Zapier is a single step that sends a fixed prompt and inputs to a language model, such as OpenAI, and returns one output like an agenda or an email.
How do you stop Zapier from double-booking meetings?
Convert the requested time to a start and end in the right time zone with a code step, then check Google Calendar before creating the event. If the slot is busy, email the requester to pick a new time instead of booking.
Why does HubSpot reject the deal amount from my zap?
HubSpot's amount field expects a plain number. If someone types a dollar sign or thousands separator into a form, strip both with Formatter or a code step before the update deal action runs.
Should AI send customer emails automatically?
We don't recommend it. In this build the agent drafts the email, a person approves or rejects it with feedback, and only the approved version is saved as a Gmail draft for a person to send.
Next step
Have a workflow in mind?
Start with a readiness review: the task, the data and tools it needs, the access boundaries, and how a pilot would be evaluated.
Prefer email? charley@buildflows.ai
Keep learning

AI agents & MCP · October 8, 2026
Governing AI Agents in Construction: A Checklist for IT and Leadership
A practical checklist for putting AI agents into construction systems safely, covering credentials, least privilege, read-first rollout, tool routing, telemetry, evaluation and human approval, drawn from our own builds.

Integrations · October 9, 2026
Custom n8n Nodes for Procore, Autodesk, HCSS and Power BI
A walkthrough of the n8n nodes we built for Procore, Autodesk, HCSS and Power BI, the read-only Procore financials MCP server behind an AI agent, and the dashboard that traces every request.

AI agents & MCP · October 9, 2026
n8n MCP Server Tutorial: Expose and Use MCP Tools in n8n
A step-by-step guide to MCP in n8n: turning workflows into MCP tools for Claude and Cursor, giving n8n agents tools from external MCP servers, and securing both.