@zohairdilawar116
via YouTube
New idea , very good. Is it possible to pick questions from Google sheet and save answers in another sheet
A chat widget that sits on your website and walks a visitor through a conversation you wrote — asking their name, learning what they are after, collecting an email, and pointing them at the right page. No API key, no AI subscription, no monthly fee.
The conversation is a flow you define: each question, the answers offered, and what happens next. It is not a language model, so it will never invent a price, misquote your policy or wander off topic — the three ways an AI bot embarrasses a small business. For qualifying a visitor and capturing a contact, a predictable script does the job better than a clever one.
The web app is served with its frame options opened up, so it can be dropped into any page with an iframe snippet — a WordPress site, a Blogger post, a static landing page, a client's site you do not control the backend of. Width and height are yours to set. The walkthrough includes the embed code and shows it going live on a real page.
The styling is plain CSS in the file, the footer is editable, and the question flow is a block you rewrite for your own business — a clinic asking which service, a shop asking which category, an agency qualifying a project enquiry. Each path can end with a different link, which is how a visitor gets sent to the page that actually suits them.
This is a scripted assistant, not an AI one. If you want a bot that answers free-text questions from your own knowledge base, the Gemini-powered chatbot trained on a Google Sheet is the project to take instead.
| Version | v1.0 |
| Published | Jan 31, 2026 |
| Platform | Google Apps Script |
| Database | Google Sheets |
| Category | Automation & Integration, Chat & Messaging |
| Tags | |
| Video | Watch walkthrough |
| License | Regular License |
Subscribe on YouTube, then verify with one click. No payment, no card. Google is used only to confirm your subscription.
What you get
Not subscribed yet? Subscribe to our channel
Extra modules, your branding, integrations or reports built on top of this file. You get a clear quote and timeline before any work starts, and support after delivery.
What We Customize
20-30% advance to start • Clear quote before work begins • Support included after delivery
Paid picks from the same category
What buyers and viewers say about Chatbot in Appscript | Free Code.
@zohairdilawar116
via YouTube