← All integrations
Spreadsheets · via Apps Script custom function
Veriastra in Google Sheets
A list that lives in a spreadsheet can be checked in the spreadsheet. This is a custom function written with Apps Script — about fifteen lines, pasted once — after which a cell formula returns the verdict for whatever is beside it.
01
Open Extensions → Apps Script
Delete the placeholder function and paste this.
const VERIASTRA_KEY = 'ol_live_your_key_here';
/**
* Verdict for a phone number.
* @customfunction
*/
function VERIASTRA(phone) {
if (!phone) return '';
const res = UrlFetchApp.fetch('https://veriastra.com/api/dial-check', {
method: 'post',
contentType: 'application/json',
headers: { Authorization: 'Bearer ' + VERIASTRA_KEY },
payload: JSON.stringify({ phone: String(phone) }),
muteHttpExceptions: true,
});
const body = JSON.parse(res.getContentText());
return body.decision || body.error || 'error';
}02
Use it in a cell
Save, go back to the sheet, and put this beside your first number. Fill down.
=VERIASTRA(A2)03
Want the reason too
Return the codes instead of the verdict by changing the last line.
return (body.reasons || []).map(function (r) { return r.code; }).join(' ');Before you rely on it
- The key sits in the script, so anyone who can edit the sheet can read it. Use a key with a small credit limit for shared sheets, and revoke it when the work is done.
- Sheets caches custom-function results and recalculates on edit. A recalculated cell is a new lookup and a new charge.
- Google limits Apps Script fetches per day. For lists in the thousands, upload the CSV to Clean a List in the dashboard instead — it is the same check without the per-cell overhead.