We are a small business and we currently use google sheets to monitor expiry dates for our customers. This is quite time consuming, however all our information is contained in google sheets and backed up daily. We use google sheets because of the real time function.
We were thinking of upgrading our process by creating a code in the spreadsheet to email customer and business owner with a generic text to remind them of their next safety inspection. Reminders will automatically send me an email when they are due and also the client. These email alerts are commonly sent 30 days prior to the inspection date in the spreadsheet.
Answer
There are plenty of ways to set this up that make it a little easier for you.
You could upload your customer data into a custom Podio app (free trial) and use the Globiflow add-on to trigger a personalised email using database info to be sent 30-day prior to an inspection.
You could load your contacts into Acuity and set up reminders to be sent 30-days prior to appointment.
You could add your contacts in Drip or Mailchimp and use their date triggers to send emails.
Further question details How can I build a web based system for health care note taking for primarily chiropractors and other complimentary health care practitioners. Things we would need: – Secure separate log in systems for different databases (so different clinics can use this system without seeing the other person’s database) – When using the …
There are quite a few tools in this space and they all offer access to clients in different ways. To take a step back, your options for communicating on projects with clients are: Email Phone Chat Weekly Reports Branded customer portal Access to your PM tool Access to a live project document Automated emails based …
With the rise of self-service booking platforms, like Acuity, people are able to automate their weekly sales meeting bookings but often not in the most efficient way. You might have a full calendar with appointments zig-zagging across town and no travel minimisation strategies in place. One strategy that we recommend to clients is to set …
I need to send reminder emails to my customers 30 days prior to expiry
Question Details
We are a small business and we currently use google sheets to monitor expiry dates for our customers. This is quite time consuming, however all our information is contained in google sheets and backed up daily. We use google sheets because of the real time function.
We were thinking of upgrading our process by creating a code in the spreadsheet to email customer and business owner with a generic text to remind them of their next safety inspection. Reminders will automatically send me an email when they are due and also the client. These email alerts are commonly sent 30 days prior to the inspection date in the spreadsheet.
Answer
There are plenty of ways to set this up that make it a little easier for you.
Related Posts
How do I develop a web-based notes system for chiropractors and other health professionals?
Further question details How can I build a web based system for health care note taking for primarily chiropractors and other complimentary health care practitioners. Things we would need: – Secure separate log in systems for different databases (so different clinics can use this system without seeing the other person’s database) – When using the …
What is the best project management tool that allows client access?
There are quite a few tools in this space and they all offer access to clients in different ways. To take a step back, your options for communicating on projects with clients are: Email Phone Chat Weekly Reports Branded customer portal Access to your PM tool Access to a live project document Automated emails based …
How do I plan out my weekly meetings to avoid traffic?
With the rise of self-service booking platforms, like Acuity, people are able to automate their weekly sales meeting bookings but often not in the most efficient way. You might have a full calendar with appointments zig-zagging across town and no travel minimisation strategies in place. One strategy that we recommend to clients is to set …