Libre Office

Questions
1

Hello

I want to generate Libre office calc documents from a template file.

How can I do that in N8N ?

thank you for your help

2

There is no direct support for ODS docs by n8n. However, xlsx is something that both LibreOffice and n8n can work with.

So you could have an xlsx as a template, do things in n8n and save a copy of xlsx with data.

My personal preference would be Google Sheets as a base for all operations due to its versatility, native network-based and well developed API, enabled online collaboration etc.

Why LibreOffice? What are the restrictions that make you stick to ODS file format?

If the reasoning above helps you to resolve your question, please mark this post as a :white_check_mark: Solution.

3

Libre Office because I want the most resilient and least invasive solution possible.
So as far away from google as possible.

I’ll have a look at xlsx.
And maybe I can also do it with free office api.

Thanks for your answer

4

How could i do that with google sheet

5

With the amount of information at hand, I could suggest the following approach.

  1. Create a Google Sheet with all the structure you need that will serve as a template. Take a note of the file ID, you will need it later.
  2. Create an n8n workflow:
    (a) Create a new file from the template by its ID using Google Drive / Copy File node.
    (b) Read data from a relevant service (AirTable, MySQL, Supabase etc) or HTTP Request if the data source service is not among n8n integrations, or create data using Set or Code nodes
    (c) Save data into the file created earlier using Google Sheets / Insert or Update row node

If this resolves your question, please mark this post as a :white_check_mark: Solution.

2 Likes
6

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.