Search code examples
google-apps-scriptgoogle-sheetsgoogle-forms

Create an interface to edit a Google Sheet externally


I have a Ggoogle Sheet for a company that recieves orders and displays them in a chart along with information like price, date recieved, order ID etc. I need to make an interface that allows me to both send orders to the sheet remotely, and edit them remotely. I thought of using Google Forms for this, but as far as I can tell there's no way to edit sheets like this, merely send the orders. What would be the best way to do this?


Solution

  • To make changes to a Google Sheet's spreadsheet you will need to use either Apps Script or Google Sheets API.

    If you want an easy implementation and you are not very experienced with the use of APIs I strongly recommend using Apps Script. As @TheMaster metioned, you can use the UI Service of Apps Script to create an interface inside the spreadsheet or externally through the use of a remote web app.

    If however, you are looking for a more tailored function without the need of using a web app or an interface in the spreadsheet, you could get and modify all the data using Google Sheets API which would allow you to integrate these functionallities within any application (web, desktop, mobile app, etc).

    I hope this has helped you. Let me know if you need anything else or if you did not understood something. :)