Convert Google Sheets into a REST API
Vložit
- čas přidán 17. 03. 2024
- 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.
![Beginners Intro to Pulling API Data into Google Sheets [BONUS: Secret APIs]](http://i.ytimg.com/vi/9VBxRZgY8_4/mqdefault.jpg)
![Beginners Intro to Pulling API Data into Google Sheets [BONUS: Secret APIs]](/img/tr.png)
0:00 Introduction
0:40 API Overview and Benefits
1:01 Project Overview
2:00 Setting Up App Script
5:01 Testing the API
6:39 Debugging
7:34 Redeploying the Web App
8:43 Fetching Data with doGet
9:48 Using ImportData Function
10:30 Creating and Deploying an Online Form
12:55 Summary and Conclusion
Fantastic! After over an hour watching useless redundant other videos, finally I found yours. Useful, technical, concise, clear. Thank you!
Glad you enjoyed!
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.
This is amazing!! Thanks a lot for the very clear explanation!
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
I love this! Thank you so much for giving me a cool idea to utilize for my projects going forward!
glad it was helpful!
You can update your current deployment to the latest version. No need to redeploy every time.
WOOOW your genius! excellent tutorial... may i invite you a cofee on patreon or anything similar? excellent tutorial!
Become a member of better sheets. More awaits inside!
When I create an API with this and send a request from my next.js app, I get a CORS issue. Have you encountered or solved this?
Havent seen this yet.
hello I made a product catalog on Google sheet then I brought this catalog into WordPress
I was wondering if it would be possible thanks to the combination of Google Sheet APIs, WordPress and the use of n8n software
during the sequence that we are going to see and how many times would it be possible for all the keywords present in the description column of each of the products to be automatically replaced by good keywords?
and the same with the images
Anything is possible
Does each post/get request counts as one Google Sheets API request? And is possible to use Bearer token to prevent anyone with the link to just be able to manipulate the data?
You can set up a token system yes.
@@BetterSheets Awesome, do you know if each post/get request counts as one Google Sheets API request? Or they aren't sharing the quota?
@@tig4rx don't think they are sharing the quota.
My POST function works when testing it with postman, but I get CORS errors when implementing it with my react application. How do I fix this?!
React app? So not google sheets?
I guess the OP is making the call to the post endpoint from the react app while trying to read/write to the google sheets.
What workef fot me is setting the content type to be text/plain; charset=utf-8
hello I'm creating a new message because I just noticed that the replies to my first message are all deleted I think CZcams 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
Which api?
@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
@@BetterSheets To summarize, do you know if there is a site on which I could read examples, use cases, so that I can understand how to use the database function and the API function, so that I can understand why to use these two functions?
The tutorials give me the theory but don't explain it to me concretely
Halo,
why di Rest API cannot fetch in PHP
something wrong or this cannot use in PHP?
Cannot use PHP
@@BetterSheets it's work and have tried, now i can use in PHP, Thankyou
hello
Hi
could I write to you, the problem is that I am French and the translators are very bad and I thought that gpt could translate better but it is also bad
@@cgc2300 members can email me anytime.