Fax From Google Sheets — Using Apps Script and Our API

How it works

In the sheet's Apps Script editor you write a function that walks the rows, reads the recipient number and a document URL from each, and uses UrlFetchApp to POST to /v1/faxes with your key in the Authorization header. Store the key in Script Properties so it never sits in a visible cell. You can bind the function to a custom menu for on-demand sends, to a drawing used as a button, or to a time-driven trigger that sweeps new rows on a schedule. The function writes the returned fax id and a timestamp back into the row so the sheet doubles as a send log, and it skips any row that already has an id.

What you can do

• ✓Fax any row by reading its recipient number and a document link from the sheet
• ✓Call /v1/faxes with UrlFetchApp — no server beyond Apps Script itself
• ✓Run sends from a custom menu, an in-sheet button, or a time-based trigger
• ✓Write the fax id and sent-time back into the row as a built-in log
• ✓Skip already-sent rows so a repeated run never refaxes them
• ✓Keep the key in Script Properties instead of a visible cell

Setup steps

1. 1Put the account on Business or Enterprise and create a key at /dashboard/developers
2. 2Open Extensions to Apps Script and store the key in Script Properties
3. 3Write a function that reads each row's number and document URL
4. 4POST to /v1/faxes with UrlFetchApp and the Authorization header
5. 5Write the returned fax id and timestamp back into the row
6. 6Bind the function to a menu, a button, or a scheduled trigger

Example

// Google Apps Script bound to the sheet
function faxRow(number, docUrl) {
  const key = PropertiesService.getScriptProperties().getProperty("SFM_KEY");
  const res = UrlFetchApp.fetch("https://www.sendfaxmail.com/v1/faxes", {
    method: "post",
    contentType: "application/json",
    headers: { Authorization: "Bearer " + key },
    payload: JSON.stringify({ to: number, document_url: docUrl }),
  });
  return JSON.parse(res.getContentText()).id;
}

Google Sheets Fax — FAQ