<- All use cases

Send SMS text messages based on dates in a Google Sheet

Never miss an important deadline, expiration, or follow up again. Trigger text messages through Twilio based on dates in a Google Sheet to remind yourself about upcoming deadlines, follow up on late invoices, and more.

Try this in Lido for free ->Schedule an onboarding call
Watch demo video
Lido is trusted by sales, marketing, and operations teams at:
and 100s of other companies

Why you should use this

This automation sends SMS messages directly from date-triggered events in Google Sheets, ensuring timely and efficient communication with customers or team members. It enhances engagement by delivering key information right when it's needed, streamlines outreach efforts, and reduces the manual workload associated with managing schedules and notifications.

How it Works

This automation checks to see if today's date matches a date specified in a spreadsheet and automatically sends an SMS text message.

Schedule an onboarding callTry this in Lido for free ->

Once per day pull the latest Sheets records

Lido connects directly to your Google Sheet and pulls in the latest records once per day.

Check if today’s date is equal to the date in the Google Sheet

IF(TODAY() = C2,SENDSMS(<your-number>,B2,”Reminder, task due”….)

Send an email

Send a personalized SMS text message for each row where today's date is equal to the date in the Google Sheet.

SENDSMS(<your-number>,B2,"Deadline in 3 days","[Task] is coming due in 3 days")

Tutorials to help you get started

Step-by-step instructions to guide you through setting up this automation in Lido.
Instructions from the Lido blog ->
Youtube video ->
Talk to a product specialistTry this in Lido for free ->

Who should use this

Ideal for marketing professionals, event organizers, and customer service managers who use Google Sheets and need to automate communication based on specific dates. This tool is particularly useful for sending timely reminders, promotional messages, or event updates.
Talk to a product specialistTry this in Lido for free ->

Related Use Cases

Discover more workflows you can automate with Lido.

Automatic Slack messages based on expiration dates

Automate Google Slides from a Google Sheet

Convert PDF Invoices to Google Sheets

Send emails based on dates in a Google Sheet

Contract management software

Get notified when a Google Sheets cell exceeds a value

View all