Checking three apps every morning to see if the gold rate moved before your wedding shopping date wastes time and still leaves you guessing. Set up a gold rate alert notification workflow once, using tools you already have, and let the notification come to you the day the rate matches your budget.
- A gold rate alert notification workflow combines Google Alerts, a Gmail filter, and a Google Sheets threshold rule — no paid app needed.
- Spot rate alerts are directional signals only; your jeweller's counter rate always adds GST, making charges, and city premium on top.
- Kolkata counter rates for 22K gold can differ from the national digest number quoted in most alerts, so verify locally before you commit.
- Set the notification to trigger on a less-than threshold, not on every daily fluctuation, if your purchase date is fixed.
- Auram Jewellery's own buying workflow guide picks up where the rate check ends — from alert to final bill.
Why this matters
Gold in 2026 is bought against a date, not a mood — a wedding, a naming ceremony, an anniversary. Most buyers still track the rate the hard way: opening a bank app, a jeweller's website, and a news search separately, every single morning, for weeks before the actual purchase.
An automated alert removes that repetition. You set a target number once, and the notification lands in your inbox the day the rate crosses it — instead of you crossing your fingers every morning until your purchase date. That gap between checking manually and being alerted automatically is the entire point of this workflow.
Auram Jewellery ships handcrafted, BIS hallmarked gold and IGI-certified diamond pieces out of Kolkata, and buyers routinely ask when to lock in a rate before a bridal order goes into production. The workflow below is worth setting up whether you're buying a single ring or a full bridal set.
Before you start
- Decide your trigger number first — not today's rate, but the actual per-gram figure you're comfortable paying, in 22K or 18K depending on what you're buying.
- Know your city's counter rate, not just the national average — Kolkata rates can run off the Mumbai or Delhi figure most news alerts quote.
- The gotcha: Google Alerts and most rate-tracking apps show the spot or bullion association rate, not the final billed rate. Your jeweller's invoice adds GST, making charges, and hallmarking fees on top — so set your trigger number below your total budget, never at it, or the alert number and the bill number won't match.
Set up your Google Alerts trigger
- Go to google.com/alerts and sign in with the Google account you check daily.
- In the Create an alert about field, type a specific query such as 22K gold rate Kolkata today — a generic gold rate search returns too much noise.
- Click Show options and set How often to As-it-happens if your purchase date is close, or At most once a day if you're tracking over weeks.
- Set Sources to News, Language to English, and Region to India.
- Set How many to Only the best results and Deliver to your email address.
- Click Create Alert.
Expected result: within a day, alert emails start arriving with the subject line matching your query, carrying that day's published rate figures.
Configure your Gmail filter so alerts don't get buried
- In Gmail, click the search options arrow inside the search bar.
- In From, type the Google Alerts no-reply sender address.
- Click Create filter.
- Check Apply the label and create a new label called Gold Rate Alerts.
- Check Never send it to Spam and Also apply filter to matching conversations.
- Click Create filter.
Expected result: every alert lands under its own label instead of getting lost in Promotions or Updates — a five-second check each morning instead of a search.
Set your threshold rule in Google Sheets
This step turns a plain tracking sheet into something that visually flags the moment your number shows up.
- Open a new Google Sheet and label column A Date and column B 22K Rate (per gram).
- Each time an alert email arrives, enter that day's figure in column B — this stays manual, since Sheets can't pull a live INR gold ticker automatically.
- Select column B, then go to Format and click Conditional formatting.
- Under Format cells if, choose Less than and enter your trigger number.
- Set the fill color to green under Formatting style, then click Done.
Expected result: the day the rate drops below your number, that cell turns green the moment you type it in — your visual cue to act.
Sync the alert with your purchase date in Google Calendar
- Open Google Calendar and create an event on your target purchase date — a wedding shopping day, a ceremony, a festival.
- Click the event, then Add notification, and set a reminder for 7 days before.
- In the event description, paste your trigger number so it's visible the day the reminder fires.
Expected result: seven days out, a calendar notification reminds you to check the sheet and the alert label together, instead of relying on memory.
Variant: get notified only on rate drops, not daily noise
If your purchase date is fixed and you don't need daily updates, change two settings:
- In Google Alerts, set How often back to At most once a day — a daily digest is enough once you're just waiting for a drop.
- In the Sheets conditional formatting rule, use Less than or equal to so the green flag only fires on your actual target, not on every minor dip.
This cuts notification volume sharply compared with the as-it-happens setup, without you missing the number that matters.
Confirm your rate with a specialist
Book a video consultation before you finalize a bridal or bespoke order.
Troubleshooting
- Alert emails aren't showing up at all. Check the Gmail filter's From field for typos, and confirm the Google Alerts query isn't set to a region with no matching news sources.
- The rate in your sheet never matches the jeweller's quote. This is expected — spot and bullion-association rates exclude GST, making charges, and hallmarking fees, which can add a meaningful gap to the final bill.
- Conditional formatting turns green but nothing notifies you. Google Sheets conditional formatting only changes cell color; it doesn't send a push notification or email on its own, so you still need to open the sheet.
- Alerts quote a national average that's off from your city. Kolkata's counter rate can run different from the Mumbai or Delhi figure most digests use — treat the alert as a signal to check locally, not as the final number.
- Too many alert emails during a volatile week. Switch How often in Google Alerts from As-it-happens to At most once a day until the rate stabilizes.
Customize your workflow
Once the notification part is running, the harder question is what to do the day it fires — how much to buy, which purity, and how to lock a fair final price with making charges factored in. Auram Jewellery's full buying workflow guide covers that next stage, from the rate check straight through to the final purchase decision.
If you're buying for the first time and want purity, hallmarking, and certification explained before the rate becomes the deciding factor, read that alongside this setup.
FAQ
What is a gold rate alert notification?
It's an automated message — email or push notification — that tells you when the gold rate crosses a number you set in advance, instead of you checking manually every day. In 2026, most buyers build this using free tools like Google Alerts and Google Sheets rather than a dedicated app.
Is there a free way to get gold rate alerts?
Yes. Google Alerts combined with a Gmail filter and a Google Sheets conditional formatting rule covers the entire workflow at no cost. It takes about ten minutes to set up once.
Does the gold rate alert match my jeweller's final price?
No. Alerts show the spot or bullion-association rate, while your jeweller's invoice adds GST, making charges, and hallmarking fees on top. Treat the alert number as a starting point, not the billed figure.
How many days before my purchase date should I start tracking?
Start at least 2-3 weeks out if your purchase date is flexible, so you see the trend rather than a single day's snapshot. For a fixed wedding or ceremony date, a 7-day Google Calendar reminder is usually enough.
Why does the gold rate differ between cities like Kolkata and Mumbai?
Local premiums, association rates, and demand differences mean the counter rate quoted in Kolkata can vary from the national average most news alerts cite. Confirm your city's actual rate before finalizing a purchase.
Can Google Sheets email me automatically when the rate drops?
Not without a script. Plain conditional formatting only changes the cell's color, it doesn't send notifications on its own. Most buyers pair the visual flag with a daily check instead of building a script.
Should I set the alert for the spot rate or my total budget?
Set it below your total budget, not at it. Since GST, making charges, and hallmarking fees sit on top of the spot rate, an alert set at your exact budget number will already be over budget by the time you're billed.
One last thing
The number that actually matters isn't the spot rate in your alert email — it's the counter rate at the jeweller you're buying from, on the day you walk in. Treat every automated notification in 2026 as a cue to check, never as the final figure, and confirm the current 22K rate directly before you commit to a bridal or bespoke order.
