Learn a repeatable AI consulting workflow that cuts proposal time from hours to minutes using Make, OpenAI, and Google Sheets.
Last month I needed to deliver a custom lead‑scoring model for a boutique SaaS founder, and I realized my usual ad‑hoc ChatGPT prompts were eating up hours I didn’t have.
After a few late nights I built a tiny automation that turns a brief client brief into a full proposal, a prompt library, and a cost estimate — all in under fifteen minutes.
By the end of this article you’ll have a concrete system you can copy, plus the exact points where it tends to break and how to fix them.
The Real Bottleneck: Prompt Fatigue and Scope Creep
Most consultants start each project with a blank document and a fresh prompt. That feels creative, but it quickly becomes a time sink.
You end up rewriting the same background sections, re‑explaining the same constraints, and chasing down missing data because the AI hallucinated a metric.
The result is not just lost hours — it’s inconsistent deliverables that make clients question your process.
What you need is a repeatable front‑end that captures the client’s intent once, then feeds it into a trusted AI pipeline.
How do you keep the AI from hallucinating client data?
Hallucinations happen when the model tries to fill gaps with plausible‑sounding nonsense.
⚡
Recommended Reading
Prompt Engineering for Profit
50 Tested Templates
50 tested prompt templates for content, copywriting, and automation. Copy, paste, earn.
The fix is simple: give the model a structured data source and tell it to stick to it.
In my workflow I store every client fact — company size, target market, current tech stack — in a Google Sheet.
Then I use a Make scenario to pull that row, format it as JSON, and inject it into the system prompt.
The prompt explicitly says: “Use only the data provided in the JSON block. If a value is missing, respond with ‘data not provided’ and stop.”
Because the model can’t invent numbers outside the block, hallucinations drop to near zero.
Many tutorials treat the AI as a magic black box that you just point at a problem.
They skip the crucial step of validating the output before you send it to the client.
I’ve seen consultants send a proposal that contained a fabricated ROI figure because the model guessed a market size.
The guide’s advice — “just trust the model” — is dangerous.
Instead, add a deterministic validation step: after the AI generates the proposal, run a simple script that checks for required sections and numeric ranges.
If the script flags anything, the workflow pauses and you get a Slack alert to review.
That tiny gate keeps the automation honest without turning you into a copy‑editor.
How to debug when the automation breaks
When a Make scenario fails, the error log can look like a wall of red text.
First, check the module that failed — most often it’s the HTTP call to OpenAI.
If you see a 429, you’ve hit the rate limit; add a delay module or upgrade your OpenAI tier.
If the error is “invalid JSON” from the Google Sheets module, verify that the sheet hasn’t been edited to add extra commas or line breaks.
I keep a cheat sheet of the three most common failure points: (1) missing data in the sheet, (2) prompt length exceeding the model’s context window, (3) Make’s webhook timing out because the client’s firewall blocks the callback.
When you hit one of those, the fix is usually a five‑minute tweak rather than a rebuild.
A concrete named example: using Make, OpenAI, and Google Sheets to auto‑generate proposals
Here’s the exact flow I run for every new engagement.
- Client fills a short Typeform with fields: company name, industry, goal, budget range.
- Typeform triggers a Make webhook that adds a row to a Google Sheet called “Clients”.
- Make watches the sheet for new rows, pulls the latest entry, and builds a JSON payload.
- That payload is sent to OpenAI’s chat completions endpoint with a system prompt that instructs the model to write a proposal, a prompt library, and a cost estimate.
- OpenAI returns the generated text; Make splits it into three Google Docs (proposal, prompts, estimate) and stores the links back in the sheet.
- Finally, Make sends a Slack message to me with the doc links and a reminder to review.
The whole chain takes about twelve minutes from form submission to Slack notice.
I use the **Make** core plan at $29/mo, which gives me enough operations for roughly fifty proposals a month.
For the AI side I rely on the OpenAI API with the gpt‑4o model; at my usage level the cost is about $0.012 per 1k tokens, so each proposal runs me roughly $0.30.
Google Sheets is free for this volume, and Slack’s free tier handles the notifications.
Putting it together, the total variable cost per client is under fifty cents, while the fixed automation cost is $29/mo.
That’s a price I consider fair for the time saved.
Pricing and tools: what I actually pay and why it’s worth it
If you’re just starting, the free Make tier lets you run up to 1,000 operations a month — enough for ten to fifteen proposals.
Once you cross that line, the $29/mo plan unlocks unlimited operations and premium apps like the HTTP module with custom headers.
I tried the $99/mo Make team plan hoping for better error handling, but the extra features were just more seats I didn’t need.
Honestly, the free plan felt like a joke after I hit the operation limit mid‑campaign and had to pause deliveries.
The concrete love I have is the ability to trigger the entire workflow from a single webhook — no manual steps, no copying and pasting.
The concrete gripe is Make’s error messages: they tell you which module failed but rarely explain why, forcing you to dig into the execution history to find a missing field.
If you’ve tried Zapier, you know what I mean — Zapier’s logs are a bit clearer, but its pricing jumps steeply at higher volumes.
For a solo operator or a tiny agency, the Make.com+ OpenAI + Google Sheets combo gives you a repeatable, auditable pipeline without locking you into a costly enterprise suite.
Adjacent reading: AI meeting tools coverage.
If you’d rather skip the build and deploy a working version in an afternoon, we’ve packaged this workflow as a blueprint at deepusecase.com/vault.