Turn Google Sheets into a REST API - React Tutorials

#react #googlesheets #restAPI

Posting data to APIs has never been easy. But have you ever used React to post form data to Google Sheets? If not, then this tutorial is for you.

Today, we are going to talk about how to POST and GET form data from React to Google Sheets like REST APIs.

⌨️ 0:00 - Part 1: Introduction
⌨️ 0:45 - Part 2: Setting up the Project
⌨️ 1:14 - Part 3: Installing Semantic UI
⌨️ 1:46 - Part 4: Creating the Form
⌨️ 4:03 - Part 5: Creating states for the Form Fields
⌨️ 6:36 - Part 6: Installing Axios
⌨️ 7:14 - Part 7: Sending the Data to Google Sheets
⌨️ 9:20 - Part 8: Fetching the Data from the Google Sheets
⌨️ 13:40 - Part 9: Final Touch
⌨️ 14:55 - Part 21: Conclusion

If you enjoyed this piece, please do show some love with a like, comment, or just click on subscribe button. Every bit matters :)

[arafatmannan]

Man you are so underrated, pls keep going🙏🙏🙏🙏🙏

[davisvilums]

Amazing Tutorial! Thank you! *Subscribed

[bahrenLM]

Thanks for the lesson mr, now i can connect my sheet into my website

[suryas]

If we edit some datas in Google sheet whether it'll be reflected on react app?

[muhammadharis]

If someone enters the data and post to the sheet and then he realized that he had some mistake and wants to change the data by again posting to the sheet. Does a row is created or it will be posted to the same row? How we handle this situation?

[Lotpite]

easy and cool. But do you know better solution than sheet best ?

[rai-osrs]

Thanks for this! Am wondering if there is a delete option as well? Tried it in my project and was getting a 'request failed status code 400'' after replacing 'post' with 'delete'. thanks

[tonmoitanvi]

Great one! today I have learned something new to appreciate! though I am using an API tool of Sheet Best. I don't have to code or anything like that. it is a ready-made tool for turning google sheets into API.

[shubhamjha]

few more limitations with google sheet, like updation of field is not possible😬, filtering as well, by the way, helpful knowledge provided

[joredawal]

hello.. can i get all my spreedsheet data withouth creating tables in react or creating fields to place it?

[hiratlt]

Can't install semantic because of the updates, which makes this video trash from the start, dissappointed

[rarblack]

This is not a correct way to use Google sheet data. You are just giving access to the 3rd party software. Google has its own Rest Api to be used.

[akarshanmishra]

bhai yeh paid hai, free solution hoga koi ?