Convert Google Sheets into a REST API

How to use Google Sheets as a database by turning it into a REST API with Google Apps Script. This makes Google Sheets a powerful tool for managing data online, allowing for easy data entry and retrieval without manual sharing or updating.
This allows you to add and get data from the sheet over the internet without sharing the sheet. It shows how to:
Write code in Google Sheets that listens for web requests.
Use doGet and doPost functions to handle these requests.
Insert data into the sheet and fetch a summary of this data through the web.
Deploy the script as a web app to get a URL for accessing the API.
Test the API with tools like Postman or embed it in a web form.

[@1lllllllll1]

Fantastic! After over an hour watching useless redundant other videos, finally I found yours. Useful, technical, concise, clear. Thank you!

[@BetterSheets]

Glad you enjoyed!

[@1lllllllll1]

Watching it again and waiting two minutes until you realize the get function is supposed to be a post, phew! I was worried I’m not understanding this. Would have been good to edit that. But I appreciate the real-time and the debugging, makes this a lot more useful.
Now why does google have a method for insertRows and another for insertRow? Why can’t the plural method handle a single row insert. Seems weird.

[@polgomezroyo5233]

This is amazing!! Thanks a lot for the very clear explanation!

[@polgomezroyo5233]

Is there anything I should change to make it work with the keys being defined in the API Call body? I'm such a noob with this lmao

[@cgc2300]

hello I'm creating a new message because I just noticed that the replies to my first message are all deleted I think TH-cam deletes them automatically otherwise I wanted to ask you if you use the APIs ? If so then I don't know at all how to do it and I wanted to ask you if the ideas I had are feasible and how I could make them come true

[@BetterSheets]

Which api?

[@cgc2300]

@BetterSheets to start I would have liked to read examples to understand what I can do by connecting 2 APIs that of Google sheet and Google drag for example, what result could I obtain
then I would like to understand what I could do if I connect Google sheet with the chatgpt API when I create a custom GPT
and finally I would like to know the other way to use the GPT chat API, in The Playground, as a gpt agent, what result I could obtain if I connect it with different applications including that of Google sheets

[@AlaskaFuture]

Halo,
why di Rest API cannot fetch in PHP
something wrong or this cannot use in PHP?

[@BetterSheets]

Cannot use PHP

[@AlaskaFuture]

@@BetterSheets it's work and have tried, now i can use in PHP, Thankyou

[@cgc2300]

hello

[@BetterSheets]

Hi