Skip to main content

Hi there,

I am looking to create a Spreadsheet Pacing document that can track spend for the entire month but get email and SMS notification if there is no spend recorded for previous day - is this possible?

I have seen that there is an email notification available, which I am yet to test, however over the weekend I am not checking the pacing document and if there is an urgent issue, can an SMS be received through Supermetrics?

Thanks so much!

Hi ​@Roxana Hanea ,

Apologies for the delay in getting back to you we appreciate your patience! 🤗

That’s a great question for ensuring urgent issues don't get missed over the weekend. You are spot on about the email functionality. Here is the breakdown on notifications with Supermetrics and Google Sheets:

 

🛑 Quick Answer: No Direct SMS Alert

 

Supermetrics and Google Sheets natively support email alerts, but they do not have a built-in feature to send SMS (text message) notifications directly to your phone.

The alert feature is designed to send notifications to email inboxes or integrated chat platforms.

 

✅ What You Can Do Natively:

 

  • Email Alerts: You can easily set up a conditional alert within the Supermetrics sidebar in Google Sheets. If the cell showing yesterday's spend is $0 (or empty), it triggers an email to you (or multiple teammates).

  • Slack/Teams: You can also have the alert sent to a Slack or Microsoft Teams channel. This is often an excellent middle-ground for urgent, internal issues if you check those apps on your phone.

 

💡 The Solution: Bridging the Gap with Automation

 

To get a true SMS text alert, you need to use a third-party automation service to act as a bridge between your Google Sheet and your phone provider. This is a very common and reliable setup for marketers.

 

Option: Use an Automation Tool (Easiest)

 

Services like Zapier or IFTTT (If This Then That) are perfect for this. They watch your Google Sheet for changes and then perform an action.

  1. Set the Trigger: Your Supermetrics report refreshes, and the cell that checks for zero spend changes its value (e.g., from "OK" to "ALERT").

  2. The Automation Service: Zapier/IFTTT sees the cell change to "ALERT."

  3. Send the SMS: The service automatically connects to an SMS gateway (like Twilio, or sometimes a built-in feature) to send a text message to your phone.

I recommend testing the native Email or Slack alerts first, as they are the simplest to implement. If you absolutely need SMS for those weekend emergencies, setting up the automation bridge is the most streamlined way to go!

Terms & ConditionsCookie settingsAccessibility statement