Create an API for Wix Restaurant Orders

Question:
I am trying to create an API that connects to my websites restaurant orders so I can have Google Sheets pull the data

Product:
Restaurant Orders (new)

What are you trying to achieve:
I want to have google apps script pull the data. The google side I am fine with, I just cant work out how to create the API part on Wix

What have you already tried:
Help articles

Additional information:

You can create an API on your site using http functions Velo Wix Http Functions Introduction | Velo

Make sure to secure your API if only certain people should be able to access it.

An easier route may be to use Wix Automations - check that out here The New Automation Builder: Sending Data to Google Sheets | Help Center | Wix.com

and finally if you do decide you need to code a solution, we also have a velo package for connecting to google sheets you can start with Google Sheets Integration