Create spreadsheets & documents with Google Apps Script

From Google Apps Script you can create a shareable OpenOfficeAI spreadsheet with UrlFetchApp — useful when you want a public, no-signup link instead of a permissions-bound Google Sheet. Trigger it from a Sheet edit, a Gmail rule, or a time-based trigger and pass the resulting URL anywhere.

function createSheet() {
  const res = UrlFetchApp.fetch(
    "https://openofficeai.com/api/v1/sheets",
    {
      method: "post",
      contentType: "application/json",
      headers: { Authorization: "Bearer YOUR_API_KEY" },
      payload: JSON.stringify({
        title: "Q3 Revenue",
        sheets: [{ rows: [
          ["Month", "Revenue", "Growth"],
          ["July", 48200, "+12%"],
        ] }],
      }),
    }
  );

  const url = JSON.parse(res.getContentText()).url;
  Logger.log(url); // share this link with anyone
}

How to create a spreadsheet with Google Apps Script

1. 1In your Apps Script project, store your API key (Script Properties is best).
2. 2Call UrlFetchApp.fetch on /api/v1/sheets with method post and a JSON payload.
3. 3Parse res.getContentText() and read the url.
4. 4Attach the function to a trigger (onEdit, time-based, or a custom menu).

Why use OpenOfficeAI with Google Apps Script

• Produces a public, no-signup link — unlike a permissioned Google Sheet.
• Run it from Sheets, Gmail, Forms, or on a schedule.
• No OAuth scopes to manage for the recipient of the link.

Frequently asked questions