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.
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