Create spreadsheets & documents with Pipedream
In Pipedream you can create a shareable spreadsheet from any trigger using a Node.js code step or the HTTP request action. Pipedream is also the easiest place to add the Authorization header that other no-code tools can't — making it a great relay for webhooks.
export default defineComponent({
async run({ steps }) {
const res = await fetch("https://openofficeai.com/api/v1/sheets", {
method: "POST",
headers: {
"Authorization": `Bearer ${process.env.OPENOFFICEAI_KEY}`,
"Content-Type": "application/json",
},
body: JSON.stringify({
title: "Pipedream export",
sheets: [{ rows: steps.trigger.event.rows }],
}),
});
return await res.json(); // { url, id, ... }
},
});How to create a spreadsheet with Pipedream
- 1Store your API key as a Pipedream environment variable.
- 2Add a Node.js code step (or HTTP action) after your trigger.
- 3POST to /api/v1/sheets with the rows from previous steps.
- 4Return the response so later steps can use steps.this.$return_value.url.
Why use OpenOfficeAI with Pipedream
- Add the auth header any other no-code tool can't.
- Full Node.js when you need it, no server to host.
- Connect 2,000+ apps as triggers and destinations.
Frequently asked questions
Why use Pipedream as a relay?
Some tools send webhooks but can't add custom headers. Point them at a Pipedream HTTP trigger, then a code step forwards the data to OpenOfficeAI with the Authorization header attached.
Where do I keep the API key?
Use Pipedream environment variables (process.env) so the key isn't hardcoded in the workflow and isn't exposed in shared workflows.
Can I return the link to the caller?
Yes. If the workflow is triggered by an HTTP request, use $respond() to return the url to the caller synchronously.
Start creating documents with Pipedream
Free tier includes 500 API calls per month — no card required.
Related integrations