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.
With the recent Government lock-down rules, you might be in the position where your café, restaurant or retail store can only serve people through online orders or takeaway. What’s the quickest, easiest, least-techie way to move your retail store to online ordering? Let’s first look at your experience options: Customer visits your store and orders …
Further details of question: We are a online company that specializes in online culinary courses (cooking) and soon to be merchandise. However we are relatively new and need to move into a promising online presence. We really need to find out how we can benefit from opportunities to increase site traffic and sales. As of …
Question: Our company helps high school leavers transition to college and college students prepare and transition to the world of work. We intend to do this through self-evaluation assessments and short online courses. Could you give us advice on a simple LMS that can achieve this? Answer: The client asked for this to be answered …
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
What is a simple, cheap way to move my retail store online and take orders?
With the recent Government lock-down rules, you might be in the position where your café, restaurant or retail store can only serve people through online orders or takeaway. What’s the quickest, easiest, least-techie way to move your retail store to online ordering? Let’s first look at your experience options: Customer visits your store and orders …
How do I get more awareness & sales of my online course?
Further details of question: We are a online company that specializes in online culinary courses (cooking) and soon to be merchandise. However we are relatively new and need to move into a promising online presence. We really need to find out how we can benefit from opportunities to increase site traffic and sales. As of …
LMS career platform development help needed
Question: Our company helps high school leavers transition to college and college students prepare and transition to the world of work. We intend to do this through self-evaluation assessments and short online courses. Could you give us advice on a simple LMS that can achieve this? Answer: The client asked for this to be answered …