Ship an internal tool with Lovable (no engineers required)
Go from a spreadsheet-and-email process to a working, logged-in internal web app with Lovable: prompt, iterate, add a database and auth with Lovable Cloud or Supabase, test, and publish.
Who it's for: Operations managers, team leads and founders who run a process on spreadsheets and email and want a real app. Developers who want a fast first version they can export and extend.
Time: 2 to 3 hours for a first useful version · Cost: Lovable free plan to start; paid plans for more credits and private projects. Publishing to a lovable.app address is included on every plan.
Tools: Lovable, Bolt.new, v0, Replit, Cursor, Airtable
Prerequisites:
- A Lovable account
- A clear description of the current process (who does what, what data moves)
- Sample data, such as a CSV export of your spreadsheet
- Optional: a Supabase account if you want to own the backend
Every company has a process that lives in a spreadsheet, three email threads and someone’s head: equipment requests, client onboarding checklists, PTO approvals, inventory counts. Lovable turns a plain-English description into a working web app with a real backend. This playbook builds a typical example, an equipment request tracker (employees request gear, managers approve, ops fulfills), using flows from the Lovable docs.
Step 1: Write a one-page spec
AI app builders are only as good as the brief. Spend 15 minutes writing:
- Users and roles: Employees (submit, see their own requests), Managers (approve/reject their team’s requests), Ops (see all approved requests, mark fulfilled).
- Data: Request = item, reason, cost estimate, requester, manager, status (Submitted → Approved/Rejected → Ordered → Delivered), dates.
- Screens: “New request” form, “My requests” list, “Approvals” queue, “Fulfillment” board, simple dashboard with counts.
- Rules: requests over $1,000 need a second approver; only Ops can mark Delivered.
- Out of scope for v1: integrations, email notifications, purchasing.
The out-of-scope list is the most important line. Small first versions ship.
Step 2: Create the project from a prompt
On the Lovable dashboard, paste a condensed version of your spec into the prompt box. Example:
Build an internal equipment request app for a 60-person company. Employees submit requests (item, reason, estimated cost). Managers approve or reject requests from their team. Ops sees approved requests on a board with columns Ordered and Delivered. Include a dashboard with counts by status. Clean, professional design.
Lovable builds the first version and shows it in the preview on the right, with the chat on the left. Click around. Lovable’s docs note every change is saved as a version you can restore, so experiments can’t permanently break anything.
Step 3: Iterate one change at a time
The single best habit, straight from Lovable’s own guidance: ask for one change at a time and check the preview after each. Good prompts are specific about where and what:
- “On the New request form, make Estimated cost a currency field and require a reason of at least 20 characters.”
- “Add a status filter to My requests.”
- “In the Approvals queue, clicking Reject should require a short comment.”
Plain-language feel prompts work too (“make it feel less cluttered”). When something breaks, describe what you did, what you expected and what happened, as precisely as a bug report.
Step 4: Add data, sign-in and roles
A real internal tool needs persistent data and logins. You have two backends:
- Lovable Cloud (default): built in, no extra account, managed from the Cloud view in Lovable, billed through workspace credits. Best for most projects.
- Your own Supabase project: for teams that want their own Supabase billing, dashboard access, or to reuse an existing project. In the editor open More → Cloud and choose Already have a Supabase project? Connect it here. A workspace owner or admin must first link the Supabase organization.
Decide now: Lovable’s docs are explicit that there is no one-click migration between the two later.
Then prompt for the backend features, one at a time:
- “Store requests in the database instead of local state.”
- “Add email and password sign-in. Only signed-in users can see the app.”
- “Add roles: employee, manager, ops. Employees only see their own requests; managers see their team’s; ops sees everything approved.”
Ask Lovable to explain the access rules it created and test them (Step 6). Access control is where internal tools leak data.
To import existing data, upload your spreadsheet as CSV in the chat and ask Lovable to seed the requests table with it, or ask for an admin-only CSV import page.
Step 5: Point-and-edit the details
For small visual changes, pointing beats describing. Open the preview toolbar, select an element and say what should change, or use Edit text inline to change labels and headlines directly with no prompt. This is also cheaper, since you’re not spending a full AI request on a typo.
Step 6: Test like a real user
Before anyone sees it:
- Click every button and link.
- Create three test accounts (one per role) and verify each sees only what it should. Try visiting another user’s request URL directly.
- Toggle the preview to Mobile view: people will open the link on phones.
- Try bad input: empty fields, a $1,000,000 request, emoji.
Report problems precisely: “In Approvals, clicking Approve on a request over $1,000 marks it approved; it should require a second approver.”
Step 7: Publish and share
Click Publish (top right), edit the suggested lovable.app address if you like, and click Publish again. The app is live on that address on every plan; paid plans support custom domains.
Remember the most common surprise: the live site is a snapshot. Later edits appear in the preview immediately but only reach users after Publish → Publish changes. Make that part of your routine.
Step 8: Hand off and maintain
- Write a half-page “how this works” doc: roles, statuses, who owns the app.
- Keep a changelog in the project chat or a doc, since prompts are your source code now.
- If the tool becomes critical, sync it to a repository so a developer can review security and continue in Cursor or another editor.
Pitfalls
- Giant first prompts. Ten features at once produce ten half-working features.
- Skipping access-control tests. The UI hiding a button is not the same as the database refusing the request.
- Secrets in front-end code. API keys belong in the backend (Lovable Cloud or Supabase secrets), never in the page.
- Two Lovable projects on one Supabase project. The docs warn they overwrite each other’s secrets.
- Forgetting to publish changes. Users see the old snapshot until you do.
- Regulated data. Don’t put patient, payment card or similar regulated data into a prototype without a proper review.
Alternatives
Bolt and v0 are close competitors (see Lovable vs Bolt); Replit suits people who want an IDE and hosting together. If your “app” is really a shared table with forms, Airtable may be enough.
Prompts that worked well for this build
- “Before changing anything, list the database tables and access rules you plan to create for roles employee, manager and ops.”
- “Add an audit log: every status change records who made it and when, visible to ops only.”
- “Show me which pages a user with role employee can reach and what data each page loads.”
Asking Lovable to explain its plan before it builds is the cheapest way to catch misunderstandings.
FAQ
Do I need Supabase to use Lovable?
No. Lovable's built-in backend (Lovable Cloud) is enabled by default and provides database, auth, storage and edge functions on Supabase's open-source foundation. Connect your own Supabase project if you want direct ownership and dashboard access.
Can I move from Lovable Cloud to my own Supabase later?
Not with one click. Lovable's docs say there is no automatic migration between the built-in backend and Supabase in either direction, so decide early.
Why don't my changes show up on the live site?
The published site is a snapshot. Changes appear in the preview immediately but only go live when you click Publish, then Publish changes.
Do I own the code?
Lovable says the code behind your app is yours. You can export it or sync it to a repository and continue in a code editor.
Is Lovable secure enough for internal data?
It can be, if you set up authentication, row-level access rules and keep secrets in the backend rather than the front-end code. Review what the app exposes before sharing it, and avoid regulated data until a technical reviewer has checked it.
Last checked against official docs: October 2026 (Lovable docs: getting started, Supabase integration, publishing). Prices and UI labels change; confirm on each vendor's site.