My client manages customer referrals and points with spreadsheets and a separate website login. This is too much overhead. How can I streamline it to just send email updates when points change? Would Zapier be sufficient, or do I need a different tool?
Question
How do I use Zapier to streamline customer referral updates and point changes with emails?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
Hi
Which spreadsheet app is being used?
What email app is being used?
Zap app available triggers/actions
GSheets: https://zapier.com/apps/google-calendar/integrations#triggers-and-actions
Gmail: https://zapier.com/apps/gmail/integrations#triggers-and-actions
Hi Troy , thanks for the response , the client is open to use whatever spreadsheet software or email. As long as they manage to update it and automatically notify the user via email. I can’t think of a system of the top of my head but was wondering whether you could suggest any?
Also , I want to ensure that only the customer that was updated will receive a email not everyone on the list.
+14- Zapier Orchestrator & Solution Partner
Try these Zap steps:
- Trigger: GSheets - New/Updated Row
- Action: Filter
- Make sure the desired data points are populated
- Action: Gmail - Send Email
Will try that, can the email sent be dynamic, for example only the row that the client information has changed be updated?
+14- Zapier Orchestrator & Solution Partner
Help article about how to configure Zap actions: https://zapier.com/help/create/basics/set-up-your-zap-action
The Zappy Awards are back
We're celebrating the Zapier builders making AI transformation happen. Winners get a published story on zapier.com, a trophy, $5,000 cash, and a feature at ZapConnect. Nominate yourself or a peer by July 24th, 2026.
Log in to the Community
No account yet? Create an account
Use your Zapier credentials
Log in with ZapierEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.