QuackAPI with Google Sheets

There is no Sheets add-on. Google Apps Script can call any URL, so a few lines of script send a message per row.

The script

  • Open Extensions, then Apps Script, in your sheet.
  • Store the key under Project Settings, Script properties, as QUACKAPI_KEY.
  • Put the phone number (digits, country code first) in column A and the message in column B.
Apps Script
function sendRows() {
  const key = PropertiesService.getScriptProperties().getProperty('QUACKAPI_KEY');
  const sheet = SpreadsheetApp.getActiveSheet();
  const rows = sheet.getRange(2, 1, sheet.getLastRow() - 1, 3).getValues();
  rows.forEach((r, i) => {
    if (!r[0] || r[2] === 'sent') return;
    const res = UrlFetchApp.fetch('https://quackapi.com/v1/messages/chat', {
      method: 'post',
      contentType: 'application/json',
      headers: { 'x-api-key': key },
      payload: JSON.stringify({ deviceId: 1, to: String(r[0]), body: String(r[1]) }),
      muteHttpExceptions: true,
    });
    sheet.getRange(i + 2, 3).setValue(res.getResponseCode() === 200 ? 'sent' : 'error ' + res.getResponseCode());
    Utilities.sleep(3000);
  });
}

Run it

  • Run sendRows once and approve the permissions Google asks for.
  • Or add a trigger (time-driven, or on form submit) so new rows send themselves.
  • Column C records the result so a row is never sent twice.

Keep in mind

Pause between messages and only message people who expect it. Apps Script has its own daily quotas, and your QuackAPI plan has a daily message limit that answers 429 when reached.

FAQ

Do I need a paid Google account?

No. Apps Script is available with a standard Google account, subject to Google's own quotas.

Related

Last reviewed 2026-11-09. QuackAPI is an unofficial linked-device service. Acceptable use