How to Schedule Recurring SMS in Google Sheets

With Sheet SMS, you can easily schedule SMS messages to be sent regularly. You can use the new automated formulas for daily and monthly messages, or manually schedule for custom intervals.

Automated Daily and Monthly SMS

We have introduced new formulas to make scheduling easier:

• SENDSMSDAILY(message, phone, start_date, time): Schedules a message to be sent every day for a year.
• SENDSMSMONTH(message, phone, start_date, time): Schedules a message to be sent every month for a year.

Example: =SENDSMSDAILY("Daily check-in", "+1234567890", "01/01/2025", "09:00")

Manual Scheduling (e.g., Weekly)

For other intervals like weekly messages, follow these steps:

1. Create a column in your Google Sheet for the message, phone number, date, and time.
2. Use Google Sheets formulas to generate a list of dates for every Monday for the next year. Example formula for the first Monday:
   =DATE(YEAR(TODAY()), MONTH(TODAY()), 1) + (8 - WEEKDAY(DATE(YEAR(TODAY()), MONTH(TODAY()), 1)))
3. Drag the formula down to fill all Mondays for the year.
4. In another column, set the time for each SMS (e.g., "09:00").
5. Use the SCHEDULESMS formula in each row:
   =SCHEDULESMS(A2, B2, C2, D2)
   Where A2 is your message, B2 is the phone number, C2 is the date, and D2 is the time.

This method lets you automate weekly reminders, notifications, or updates for an entire year.

Example Sheet Structure

Message	Phone Number	Date	Time	Formula
Hello, it's Monday!	+1234567890	01/09/2025	09:00	=SCHEDULESMS(A2,B2,C2,D2)
Hello, it's Monday!	+1234567890	08/09/2025	09:00	=SCHEDULESMS(A3,B3,C3,D3)

Tip: You can adjust the formula to schedule SMS for any day of the week.

Back to Setup