Automation Guide for ACBuy Link Tracking

Automation is the secret weapon of every efficient ACBuy link user. Instead of manually updating prices, sending reminders, and generating reports, you can let Google Apps Script handle these tasks in the background. In this guide, we show you how to set up powerful automations that save hours every week.

All examples in this guide are tested and ready to use. You can copy the scripts directly into your spreadsheet. We also explain what each script does so you can customize it for your specific workflow.

Script 1: Daily Price Update Alert

This script checks your Price column and compares it to a stored baseline. If the price drops by more than 10 percent, it sends you an email alert. This is perfect for catching flash sales and limited-time deals.

function checkPriceDrops() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Main");
  var data = sheet.getDataRange().getValues();
  var alerts = [];
  for (var i = 1; i < data.length; i++) {
    var current = data[i][4];
    var baseline = data[i][10];
    if (current < baseline * 0.9) {
      alerts.push(data[i][1] + " dropped to " + current);
    }
  }
  if (alerts.length > 0) {
    MailApp.sendEmail("your@email.com", "Price Drop Alert", alerts.join("
"));
  }
}

Script 2: Weekly Summary Report

This script generates a weekly email report with your total items tracked, total spending, orders delivered this week, and pending orders. It runs every Monday morning and gives you a snapshot of your ACBuy link activity.

function weeklyReport() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Main");
  var data = sheet.getDataRange().getValues();
  var total = data.length - 1;
  var pending = 0;
  var delivered = 0;
  for (var i = 1; i < data.length; i++) {
    if (data[i][5] === "Ordered" || data[i][5] === "Shipped") pending++;
    if (data[i][5] === "Delivered") delivered++;
  }
  var body = "ACBuy Link Weekly Report

Total Items: " + total +
    "
Pending Orders: " + pending + "
Delivered This Week: " + delivered;
  MailApp.sendEmail("your@email.com", "Weekly ACBuy Report", body);
}

Script 3: Auto-Archive Old Items

Over time, your ACBuy link sheet fills with delivered items from months ago. This script moves any row with status Delivered and a delivery date older than 60 days to an Archive sheet. This keeps your main sheet lean and fast.

How to Set Up Triggers

Scripts are useless unless they run automatically. To set up a trigger, open the Apps Script editor, click the clock icon on the left sidebar, and click Add Trigger. Choose the function you want to run, select the source (Time-driven), and pick your schedule. For daily alerts, choose Day timer. For weekly reports, choose Week timer.

Triggers run on Google servers, so your computer does not need to be on. The script executes at the scheduled time even if your spreadsheet is closed. This is what makes Apps Script automation so powerful for the ACBuy link system.