Sheet rows to PDFs, in one script.

Prerequisites

• An ASHDOCS account — the free tier includes 100 monthly credits, no card required.
• An API key from the dashboard (Keys page). Sandbox keys (prefix ash_test_) run everything without consuming credits.
• Edit access to the spreadsheet (Extensions → Apps Script must be available).

Test the key before building anything:

curl https://www.ashdocs.com/api/v1/me -H "X-API-Key: ash_live_..."

Setup, step by step

1. 1

   Open the script editor

   In your spreadsheet: Extensions → Apps Script. A bound project opens — no add-on, no deployment.

2. 2

   Paste the function

   The API returns JSON with a signed URL; a second UrlFetchApp call downloads the PDF and files it in Drive.

   var ASHDOCS_API = "https://www.ashdocs.com";
   
   function generatePdfFromActiveRow() {
     var sheet = SpreadsheetApp.getActiveSheet();
     var row = sheet.getActiveRange().getRow();
     var values = sheet.getRange(row, 1, 1, 3).getValues()[0];
     var invoiceNo = values[0], client = values[1], amount = values[2];
   
     var res = UrlFetchApp.fetch(ASHDOCS_API + "/api/v1/tools/html-to-pdf", {
       method: "post",
       contentType: "application/json",
       headers: { "X-API-Key": "ash_live_..." },
       payload: JSON.stringify({
         html: "<h1>Invoice " + invoiceNo + "</h1><p>" + client + " — $" + amount + "</p>",
         options: { format: "A4", output: "url" }
       }),
       muteHttpExceptions: true
     });
     if (res.getResponseCode() !== 200) throw new Error(res.getContentText());
   
     var fileUrl = JSON.parse(res.getContentText()).file_url;
     var blob = UrlFetchApp.fetch(fileUrl).getBlob().setName("invoice-" + invoiceNo + ".pdf");
     var file = DriveApp.createFile(blob);
     sheet.getRange(row, 4).setValue(file.getUrl());
   }

3. 3

   Authorize and run

   Run the function once from the editor — approve the Drive and external-request scopes when prompted. Then wire it to a custom menu (onOpen) or an onFormSubmit trigger so non-technical teammates can use it.

Three ready-made recipes

Troubleshooting

Frequently asked questions