Create spreadsheets & documents with Power Automate

In Microsoft Power Automate, use the built-in HTTP action to turn any trigger — a new SharePoint item, a form response, a scheduled run — into a shareable OpenOfficeAI spreadsheet. No premium connector required beyond HTTP; map your data into rows and use the returned URL downstream.

// Action: HTTP
Method:  POST
URI:     https://openofficeai.com/api/v1/sheets
Headers:
  Authorization: Bearer YOUR_API_KEY
  Content-Type:  application/json
Body:
{
  "title": "@{triggerBody()?['title']}",
  "sheets": [{
    "rows": [
      ["Name", "Email"],
      ["@{items('Apply_to_each')?['Name']}",
       "@{items('Apply_to_each')?['Email']}"]
    ]
  }]
}

// Then: Parse JSON -> use body('Parse_JSON')?['url']

How to create a spreadsheet with Power Automate

1. 1Add an HTTP action after your trigger (the HTTP action is a premium connector).
2. 2Set POST, the URI, and the Authorization header.
3. 3Build the JSON body, mapping dynamic content into rows.
4. 4Add a Parse JSON action and reference the url in later steps.

Why use OpenOfficeAI with Power Automate

• Works with the whole Microsoft 365 + Dataverse trigger ecosystem.
• Output a public link instead of a permissioned SharePoint file.
• Email the link or post it to Teams in the same flow.

Frequently asked questions