How to automate populating a Data Model in Builder.io from an Excel spreadsheet via API?

Technical Questions
1

Hi everyone!

I’m looking for a way to automate populating a Data Model in Builder.io using data from an Excel spreadsheet. The idea is to take the data from the spreadsheet and automatically send it to the Builder.io data model.

What are you trying to accomplish

  • Here are my questions:
  1. Is it possible to use the Builder.io API for this integration? If so, are there any examples or best practices for structuring the data before sending it via the API?
  2. Has anyone worked on a similar automation? Any tips on libraries or tools (like Node.js with axios and xlsx) that could help extract data from Excel and send it to Builder.io?
  3. What are the best practices for authentication and sending data to Builder.io via API? Are there any rate limits I should be aware of when making multiple requests?

Thank you in advance for any guidance or implementation examples!*

Code stack you are integrating Builder with

  • Reactjs, Nodejs*
2

Hi Tbathat,

Thank you for contacting Builder.io Support! I look forward to helping you with your request.

While I start looking into this, feel free to share any additional information you think might be relevant.

Thanks,

1 Like
3

Hello Tbathat,

  1. Is it possible to use the Builder.io API for this integration? If so, are there any examples or best practices for structuring the data before sending it via the API?

Yes. About the structure, this will depend on how you manage it in Builder.

  1. Has anyone worked on a similar automation? Any tips on libraries or tools (like Node.js with axios and xlsx) that could help extract data from Excel and send it to Builder.io?

I guess, other customers have done similar things.
You ready the Excel data, you will need to use a third-party library, like the examples you shared.

  1. What are the best practices for authentication and sending data to Builder.io via API? Are there any rate limits I should be aware of when making multiple requests?

For authentication, we provide a private key: Using the Builder API Key - Builder.io.
About rate limits, we do not have.

I hope the information above is helpful.

Thank you,

1 Like
4

Hello Fernando, thanks a lot!

I figured it would be possible, although I wanted to check if there was some specific feature on Builder so my squad wouldn’t have to direct too much effort and time for that solution.

Once again, thanks for your time! Your answer was really valuable.