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.

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.

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.

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.