How to Schedule Recurring SMS in Google Sheets

With Sheet SMS, you can easily schedule SMS messages to be sent every week (e.g., every Monday) for the next year. Here’s how to do it:

  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

MessagePhone NumberDateTimeFormula
Hello, it's Monday!+123456789001/09/202509:00=SCHEDULESMS(A2,B2,C2,D2)
Hello, it's Monday!+123456789008/09/202509:00=SCHEDULESMS(A3,B3,C3,D3)

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

Back to Setup