Create spreadsheets & documents with Airtable
Use an Airtable automation's "Run script" action to turn records into a shareable OpenOfficeAI spreadsheet — a public link anyone can open without an Airtable seat. Trigger it when a record matches a view or a button is clicked, and write the link back to a field.
// Automation > Run a script
let records = input.config().records; // pass from a previous step
let res = await fetch("https://openofficeai.com/api/v1/sheets", {
method: "POST",
headers: {
"Authorization": "Bearer YOUR_API_KEY",
"Content-Type": "application/json",
},
body: JSON.stringify({
title: "Airtable export",
sheets: [{ rows: records }], // [["Name","Email"], ["Ada","ada@..."]]
}),
});
let data = await res.json();
output.set("url", data.url);How to create a spreadsheet with Airtable
- 1Create an automation and add a "Run a script" action.
- 2Build a rows array from your records (header first).
- 3fetch() the /api/v1/sheets endpoint with your Bearer key.
- 4output.set the url and write it back to a field in the next step.
Why use OpenOfficeAI with Airtable
- Produces a public link — no Airtable seat needed to view.
- Trigger on record match, schedule, or a button field.
- Great for sending external clients a clean, read-only export.
Frequently asked questions
Why not just share the Airtable view?
Shared Airtable views expose your base structure and require Airtable. An OpenOfficeAI link is a standalone spreadsheet anyone can open and download as XLSX/PDF — better for external recipients.
How do I build the rows from records?
Map each record to an array of cell values in the order of your columns, and prepend a header array. Pass the result as sheets[0].rows.
Can I store the link back in Airtable?
Yes. output.set("url", data.url) in the script, then add an "Update record" step that writes that output into a URL field.
Start creating documents with Airtable
Free tier includes 500 API calls per month — no card required.
Related integrations