Laravel | Google Sheets Integration | Realtime Update

[@entertainmentexpedition]

Thank you for this tutorial. I have been stuck for three days on exporting data to google Sheets. Now I have done this. Thanks again.❤❤❤

[@Marie-ClemenceArrighi-er2zc]

Thank you for sharing this video. I have question how to pull the last 10 records to the spreadsheet, and the records contain hasMany relationship?

[@exploreworkfromhome3462]

This worked great for me. Excellent step by step. I have subscribed to your KZbin Channel. I have been working on this for 9 days by reviewing the Google PHP Api and other github like Revolution. It just wouldn't work. I'll be watching all your videos over time. My main focus is to get going on Laravel 8 from Laravel 6. And then C# & Unity Game programming, Python, Java, etc. Wow, thank you! Thank you!! very much!!

[@WebDevWithArtisan]

Thanks a lot for subscribing and for the kind words. I am very happy to know that it was helpful to you. Your learning journey seems exciting. All the best :)

[@hawadota2]

can check exist id if exist to update else to append

[@WebDevWithArtisan]

There are various ways to update a row using api. One way is to use updatesheet api which takes in the range to update Other method is bit low performance where you can read the entire sheet then modify that array as per you want and then write the sheet back with the new modified array. Please note that this is useful only when one or two people are handing spreadsheet using api. If its for multiple users then there are heavy chances of data loss. If the dataset is huge or/and lots of querying is required then SQL is best preferred as querying is more easy and performance efficient.

[@talhachugtai2509]

I write your code for adding data in sheet but it shows me error of Request had insufficient authentication scopes.", "errors"" can you tell me how can i fix this?

[@mohamedelbagir6038]

Hi, thanks for the video. what if i want to get the data and autocomplete a form in my website using google sheets data?

[@bamswisnu4823]

Error Class 'App\Http\Services\GoogleSheetsService' not found, please problem solving ?

[@Rohit-ie4cu]

Great

[@julzorinion]

hello , Thank you for this helpful video :-) more videos about laravel sheet api... do you have tutorial on how to update record in sheet?

[@WebDevWithArtisan]

Hi, thanks for the kind words. I don't have a tutorial to update record in a sheet yet. It is a great idea for a video I will try my best to make a video on it in the future.

[@seemahallepurge6012]

Hi, Thanks for your video , Please tell me how you redirection of server is working. Its not working for me . Please help.

[@WebDevWithArtisan]

Thanks for the comment. Make sure you have added the route in your web.php. So in my case I have added the route Route::get('/googlesheets', [GoogleSheetsController::class, 'sheetOperation']); I am using this route just to show the data entered once we have successful entry in the google sheets. So this route is entering the data and then showing us what we entered.

[@seemahallepurge6012]

@@WebDevWithArtisan Thanks i have add this route to my web page but i am still getting the 404 error

[@seemahallepurge6012]

Well, now it is showing error class Google\client not found

[@WebDevWithArtisan]

Have you installed google php sdk. Also make sure to use capital C in Google\Client

[@seemahallepurge6012]

@@WebDevWithArtisan Thank You so much

[@carlosmindsetv]

are you get me url this project code ?

[@GraWebTecnologia]

Awesome! Thank you for this.

[@Hasithac2]

Thank you You Save my day

[@furious_ar]

Thank you brother i hope this works for me

[@imranyousuf3678]

CODE LINK: developers.google.com/sheets/api/quickstart/php

[@marwanbukhori90]

why its bring to Javascript quickstart? Or they did remove the old one

[@bamswisnu4823]

Udah ga ada PHP bro