Free Make workflow · Gmail → Google Sheets

Record a reply against the right quote

Quote Reply Signal is designed to match a Gmail reply containing your unique [FPQ:ID] tag to one row in your Quotes sheet. The sender must match the stored contact. A match records Replied, the message ID and time. It sends no email.

This page contains a Make affiliate link, marked below.

Verification scope. Tested in Make on 6 Oct 2026 against a real Gmail inbox: we sent one tagged test quote and one reply from our own mailbox to itself and used a fictional Quotes sheet. The reply marked its one matching row and changed nothing else (3 credits). The same reply changed nothing when no row or two rows had the ID, or when the row was already marked, and the quote itself (no reply header) was skipped. Test your own connection with one quote before using real ones.

Keep the matching rule narrow

Use one unique quote ID per Quotes row and include its [FPQ:ID] tag in the quote email subject.

1 · Match

Find the quote

The Gmail reply needs the unique tag and a sender address matching the stored quote contact. Missing tags and other addresses do not qualify.

2 · Check

Require exactly one row

Search Rows looks for up to two rows with the ID, and a router reads its Total number of bundles: 0 means no match and nothing is written, 1 updates that row, and 2 stops and flags the duplicate ID in the run’s history. Keep quote IDs unique and review flagged messages yourself.

3 · Record

Save the reply signal

Record Replied with the matching message ID and time. The message is a signal for your review, not an accepted order or a payment.

You need your own Make, Gmail and Google Sheets accounts. Configure the intended Quotes sheet and test with fictional contacts before allowing updates to your real quote list. Make plan limits, checks and app activity affect usage; no fixed credit cost or setup time is promised.

Before you turn it on

  • Pick a slow schedule. Gmail Watch Emails checks your inbox on a schedule, and each check uses at least 1 credit, even when no email has arrived. Every 15 minutes is about 2,880 checks a month (96 a day × 30), while Make’s Free plan has 1,000 credits a month. Use a longer interval, such as hourly (about 720 checks) or daily, or leave it on demand and click Run once. Each run handles one email, so with a long interval replies wait for later runs.
  • Tag the quote you send. Put the tag in the subject of your outgoing quote, for example [FPQ:QUOTE_001], with the same ID in column A. The client’s reply must keep that tag in its subject. Quotes sent without a tag are never matched.
  • Personal Gmail needs renewing. Make’s Gmail docs say that with a personal @gmail.com account you have to reauthorize the connection every six months (Connections › Reauthorize).
  • Test with one quote first. We tested it by sending a tagged quote and a reply from our mailbox to itself, so both landed in INBOX. In your setup the quote stays in Sent and only the client’s reply lands in INBOX, which is the folder the workflow watches (if a Gmail filter skips the inbox, choose that label instead). Add one test row with an address you control as the contact, send it a tagged quote, reply from that address, click Run once and check that only that row changed.

What a reply signal means

A record that helps you review the conversation.

  • No sending. This workflow does not send email or create follow-up drafts.
  • No acceptance or payment inference. A reply can be a question, a rejection or an automatic response. Read it before changing any business decision.
  • Headers are not identity proof. A matching sender address and reply header do not authenticate the person who wrote the message.
  • Limited coverage. Replies without the tag, replies from another address, phone calls and messages outside Gmail need manual handling.
  • Separate setup. This free signal marks a Replied checkbox. The paid Quote Follow-Up Assistant uses a Status column. Map and check those fields separately; this download does not automatically connect the two workflows.