Complete
Documentation

// Using Google Apps Script
function generatePDF() {
  const sheet = SpreadsheetApp.getActiveSheet();
  const data = sheet.getDataRange().getValues();
  
  data.forEach((row, index) => {
    if (index === 0) return; // Skip header
    
    const payload = {
      template: {
        type: 'gdoc',
        id: 'YOUR_GOOGLE_DOC_ID'
      },
      data: {
        name: row[0],
        amount: row[1],
        date: row[2]
      },
      pdfName: `Invoice_${row[0]}_${index}`
    };
    
    const response = UrlFetchApp.fetch('https://api.swishdocs.com/generate', {
      method: 'POST',
      headers: {
        'Authorization': 'Bearer YOUR_API_KEY',
        'Content-Type': 'application/json'
      },
      payload: JSON.stringify(payload)
    });
    
    const result = JSON.parse(response.getContentText());
    sheet.getRange(index + 1, 4).setValue(result.link);
  });
}

import requests
import json

def generate_pdf(template_id, data, pdf_name):
    url = "https://api.swishdocs.com/generate"
    headers = {
        "Authorization": "Bearer YOUR_API_KEY",
        "Content-Type": "application/json"
    }
    
    payload = {
        "template": {
            "type": "gdoc",
            "id": template_id
        },
        "data": data,
        "pdfName": pdf_name
    }
    
    response = requests.post(url, headers=headers, json=payload)
    return response.json()

# Example usage
result = generate_pdf(
    template_id="1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms",
    data={
        "name": "John Doe",
        "amount": "$1,500.00",
        "due_date": "2024-01-15"
    },
    pdf_name="Invoice_John_Doe"
)

print(f"PDF Link: {result['link']}")

{
  "trigger": "New Row in Google Sheets",
  "action": "Webhooks by Zapier",
  "url": "https://api.swishdocs.com/generate",
  "method": "POST",
  "headers": {
    "Authorization": "Bearer YOUR_API_KEY",
    "Content-Type": "application/json"
  },
  "data": {
    "template": {
      "type": "gdoc",
      "id": "{{Google Sheets:Document ID}}"
    },
    "data": {
      "name": "{{Google Sheets:Name}}",
      "amount": "{{Google Sheets:Amount}}",
      "date": "{{Google Sheets:Date}}"
    },
    "pdfName": "Invoice_{{Google Sheets:Name}}_{{Google Sheets:Row Number}}"
  }
}