Create spreadsheets & documents with n8n
In n8n you can turn any trigger — a new row, a webhook, a schedule — into a shareable spreadsheet using a single HTTP Request node. There is no community node to install: point the node at the OpenOfficeAI API, map your data into rows, and the workflow outputs a live spreadsheet URL you can pass downstream.
// HTTP Request node settings
Method: POST
URL: https://openofficeai.com/api/v1/sheets
// Authentication: Generic Credential -> Header Auth
Name: Authorization
Value: Bearer YOUR_API_KEY
// Body: JSON
{
"title": "{{ $json.title }}",
"sheets": [{
"rows": {{ JSON.stringify($json.rows) }}
}]
}
// The node output contains {{ $json.url }} — pass it to
// a Slack, Gmail, or Notion node downstream.How to create a spreadsheet with n8n
- 1Add an HTTP Request node after your trigger (Webhook, Schedule, or a data node).
- 2Set method POST and URL https://openofficeai.com/api/v1/sheets.
- 3Add Header Auth credential: Authorization = Bearer YOUR_API_KEY.
- 4Map your items into sheets[].rows in the JSON body, then use {{ $json.url }} downstream.
Why use OpenOfficeAI with n8n
- No custom code or community node — just the built-in HTTP Request node.
- Great for turning form submissions, CRM updates, or scraped data into shareable sheets.
- Chain the output URL into Slack, email, or a database in the same workflow.
Frequently asked questions
Do I need to install an n8n community node?
No. The built-in HTTP Request node is all you need. Configure it with a Header Auth credential for your API key and a JSON body, and you can create spreadsheets or documents from any n8n workflow.
How do I turn rows from a previous node into a spreadsheet?
Aggregate your items into an array of arrays (one inner array per row), then reference it in the body as "rows": {{ JSON.stringify($json.rows) }}. An Item Lists or Code node is handy for shaping the data first.
Can I email the generated spreadsheet automatically?
Yes. The HTTP Request node returns a url field. Pass {{ $json.url }} into a Gmail/SMTP node to send the link, or call /api/v1/download/{id}?format=pdf and attach the PDF.
Start creating documents with n8n
Free tier includes 500 API calls per month — no card required.
Related integrations