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.
We love the aesthetics, design, pricing and branding of Mailchimp but sometimes our time and money-poor clients are looking for simple Mailchimp alternatives that will make their newsletter creation & content creation easy. A quick list of simple alternatives are: ⭐ Revue – a simple link curation style email newsletter that starts on a free …
Question: I’m looking for a good Webflow compliance plugin to ensure my site meets legal standards (like GDPR and accessibility), but I don’t know which one to choose. Can you help me compare the top options and recommend the best one? When it comes to ensuring compliance with legal standards such as GDPR, cookie consent, …
A reader recently asked, “I run a Shopify store and I’m looking for a way to display low stock notifications to customers. I want to create a sense of urgency and help drive sales when products are running out. Are there any tools or settings within Shopify that allow me to show low stock alerts, …
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
A simple alternative to Mailchimp
We love the aesthetics, design, pricing and branding of Mailchimp but sometimes our time and money-poor clients are looking for simple Mailchimp alternatives that will make their newsletter creation & content creation easy. A quick list of simple alternatives are: ⭐ Revue – a simple link curation style email newsletter that starts on a free …
Best Webflow Compliance Plugin: Which One Should You Choose?
Question: I’m looking for a good Webflow compliance plugin to ensure my site meets legal standards (like GDPR and accessibility), but I don’t know which one to choose. Can you help me compare the top options and recommend the best one? When it comes to ensuring compliance with legal standards such as GDPR, cookie consent, …
How Can I Display Low Stock Notifications on Shopify?
A reader recently asked, “I run a Shopify store and I’m looking for a way to display low stock notifications to customers. I want to create a sense of urgency and help drive sales when products are running out. Are there any tools or settings within Shopify that allow me to show low stock alerts, …