---
title: "Discussion on \"How I Built a Quotation App for Small Businesses with Google Apps Script\" | Hashnode"
description: "Discussion on \"How I Built a Quotation App for Small Businesses with Google Apps Script\". The problem\nMany small service businesses still send quotes the slow way: typed into a chat, copied from an old message, or written up in a document every single time. Once the quote is sent, it disap"
url: "https://hashnode.com/posts/how-i-built-a-quotation-app-for-small-businesses-with-google-apps-script/6aea5e013bfbba0f1ed2695d"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [How I Built a Quotation App for Small Businesses with Google Apps Script](https://roseannong.hashnode.dev/how-i-built-a-quotation-app-for-small-businesses-with-google-apps-script?utm_source=hashnode&utm_medium=feed)

The problem Many small service businesses still send quotes the slow way: typed into a chat, copied from an old message, or written up in a document every single time. Once the quote is sent, it disap

6d ago · 4 min read · roseannong.hashnode.dev  
Read the article

-   [#google-apps-script](https://hashnode.com/tag/google-apps-script)
-   [#small-business](https://hashnode.com/tag/small-business)
-   [#automation](https://hashnode.com/tag/automation)

## Written by

[Rose Ann Ong](https://hashnode.com/@ennanne)

@ennanne · Doha, Qatar

  
[View profile](https://hashnode.com/@ennanne)

Administration Manager in Doha · Founder, Marca Studio · Practical systems, automation and web apps for small businesses

I'm Rose Ann, an administration and operations professional based in Doha, Qatar. My experience includes establishing service operations, coordinating teams and schedules, managing client bookings, and developing SOPs, reports, and trackers. I use tools such as Odoo, Google Workspace, Notion, and Slack to organize information and support daily operations. I also run Marca Studio, where I build simple web apps on Google Apps Script for small businesses. Here, I share practical insights on workplace systems, digital tools, and automation that help teams work more efficiently.

## Responses 2

Markdown supported · ⌘↵ to post

[Hayrullah Kar](https://hashnode.com/@magesheet)

[5d ago](https://hashnode.com/posts/how-i-built-a-quotation-app-for-small-businesses-with-google-apps-script/6aea5e013bfbba0f1ed2695d/comment/6aeb197c62e01d957af396fb)

Putting the follow-up list on the Home screen, with the 3-day no-answer rule, is the part I'd copy. One thing to check on the Viewed status: if the quote page records a view whenever the link is requested, WhatsApp may fetch the link to build its preview when the owner pastes it, and the owner opening their own link counts too. Quotes can then show Viewed before the client has seen them. Recording the view from a small script that runs in the browser after the page loads (a google.script.run call), and giving the owner a separate preview link that doesn't log anything, keeps the status honest. Since the follow-up list relies on that status, a false Viewed can hide the quotes that most need chasing.

[Rose Ann Ong](https://hashnode.com/@ennanne)

[2d ago](https://hashnode.com/posts/how-i-built-a-quotation-app-for-small-businesses-with-google-apps-script/6aea5e013bfbba0f1ed2695d/comment/6aeb197c62e01d957af396fb#reply-6aeeebe539c2da280895fa8b)

Thank you for reading it so closely. You’re right that the follow-up list is only as good as the Viewed status behind it, and the WhatsApp preview fetch is an easy one to miss. I’m going to check how QuoteDesk records views against both cases you mentioned: the link preview, and the owner opening their own link. Logging the view from a google.script.run call after the page loads, with a separate preview link for the owner, sounds like a clean fix. I’ll share an update once I’ve tested it.