Flutter Tutorial - Google Sheets API 3/3 - Update & Delete Data & SpreadSheets CRUD
ฝัง
- เผยแพร่เมื่อ 1 มิ.ย. 2024
- Use the Flutter Google Sheets API to update and delete data within the rows and columns of the Google Spreadsheets in Flutter.
Click here to Subscribe to Johannes Milke: th-cam.com/users/JohannesMilke...
👉 12 Week Flutter Training | heyflutter.com
👉 Flutter Masterclass Courses | heyflutter.com/masterclass
Source Code | github.com/JohannesMilke/goog...
My Courses | heyflutter.com
Follow Newsletter | johannesmilke.com/#/newsletter
SUBSCRIBE HERE
bit.ly/JohannesMilke
SUPPORT & SPONSOR ME
github.com/sponsors/JohannesM...
RESOURCES
Read & Fetch Data From Google Spreadsheet Tutorial: • Flutter Tutorial - Goo...
Create & Save Data In Google Spreadsheet Tutorial: • Flutter Tutorial - Goo...
SQFlite SQL Database Tutorial: • Flutter Tutorial - SQL...
Hive NoSQL Database Tutorial: • Flutter Tutorial - Hiv...
Shared Preferences Tutorial: • Flutter Tutorial - Sha...
Upload File To Firebase Storage Tutorial: • Flutter Tutorial - Upl...
Download File From Firebase Storage Tutorial: • Flutter Tutorial - Dow...
Share Text, Images, Files Tutorial: • Flutter Tutorial - Sha...
Calendar Events App Tutorial: • Flutter Tutorial - Cal...
In-App Rating Tutorial: • Flutter Tutorial - In ...
QR Code Scanner Tutorial: • Flutter Tutorial - QR ...
Create PDF Invoice Document Tutorial: • Flutter Tutorial - Cre...
PDF Viewer Tutorial: • Flutter Tutorial - PDF...
Sortable DataTable Tutorial: • Flutter Tutorial - Sor...
Selectable DataTable Tutorial: • Flutter Tutorial - Sel...
Editable DataTable Tutorial: • Flutter Tutorial - Edi...
Syncfusion DataTable Tutorial: • Flutter Tutorial - Cry...
Firebase Hosting Deploy Flutter Web App Tutorial: • Flutter Tutorial - Fir...
App Internationalization Tutorial: • Flutter Tutorial - Loc...
Search App Bar Tutorial: • Flutter Tutorial - Sea...
TIMELINE
0:00 Introduction Google Sheets API
0:36 Save & Update Row In Google Spreadsheet
4:45 Save & Update Cell In Google Spreadsheet
7:53 Remove Row In Google Spreadsheet
SHARE | SUBSCRIBE | LIKE FOR MORE VIDEOS LIKE THIS
*********
SOCIAL MEDIA: Follow Us :-)
Twitter | / heyflutter_
Linkedin | / heyflutter
LEARN MORE
SOURCE CODE | github.com/JohannesMilke
ARTICLES | / johannesmilke
PLAYLISTS
All Flutter Videos | • Flutter Tutorial - Flu...
Widgets - Flutter | • Flutter Tutorial - Flu...
Plugins - Flutter | • Flutter Tutorial - Flu...
Animations - Flutter | • Flutter Tutorial - Tra...
Designs - Flutter | • Flutter Tutorial - Flu...
Firebase - Flutter | • Flutter Tutorial - Pag...
State Management - Flutter | • Flutter Tutorial - Riv...
CREDITS
Copyright song "Corporate Technology" by scottholmesmusic.com
#Flutter #Tutorial #JohannesMilke
LIKE & SHARE & ACTIVATE THE BELL
Thanks For Watching :-)
bit.ly/JohannesMilke - วิทยาศาสตร์และเทคโนโลยี
This might help you :)
👉 12 Week Flutter Training from Newbie to Expert: heyflutter.com
Source Code: github.com/JohannesMilke/google_sheets_update_example
Read & Fetch Data From Google Spreadsheet Tutorial: th-cam.com/video/qAEb7VytWP8/w-d-xo.html
Create & Save Data In Google Spreadsheet Tutorial: th-cam.com/video/3UJ6RnWTGIY/w-d-xo.html
SQFlite SQL Database Tutorial: th-cam.com/video/UpKrhZ0Hppk/w-d-xo.html
Hive NoSQL Database Tutorial: th-cam.com/video/w8cZKm9s228/w-d-xo.html
Shared Preferences Tutorial: th-cam.com/video/szOllHT1S7Y/w-d-xo.html
Upload File To Firebase Storage Tutorial: th-cam.com/video/dmZ9Tg9k13U/w-d-xo.html
Download File From Firebase Storage Tutorial: th-cam.com/video/YA_fHCF_EYc/w-d-xo.html
Share Text, Images, Files Tutorial: th-cam.com/video/-PmUFbbA-Fs/w-d-xo.html
Calendar Events App Tutorial: th-cam.com/video/LoDtxRkGDTw/w-d-xo.html
In-App Rating Tutorial: th-cam.com/video/zquHzDk7auE/w-d-xo.html
QR Code Scanner Tutorial: th-cam.com/video/hHehIGfX_yU/w-d-xo.html
Create PDF Invoice Document Tutorial: th-cam.com/video/z_5xkhEkc5Y/w-d-xo.html
PDF Viewer Tutorial: th-cam.com/video/uizZbJWziEg/w-d-xo.html
Sortable DataTable Tutorial: th-cam.com/video/SJxByHLs72k/w-d-xo.html
Selectable DataTable Tutorial: th-cam.com/video/HZD-0zgpuak/w-d-xo.html
Editable DataTable Tutorial: th-cam.com/video/D6yndJ_lk14/w-d-xo.html
Syncfusion DataTable Tutorial: th-cam.com/video/DkZC9o2fat4/w-d-xo.html
Firebase Hosting Deploy Flutter Web App Tutorial: th-cam.com/video/xJo7Mqse960/w-d-xo.html
App Internationalization Tutorial: th-cam.com/video/Zw4KoorVxgg/w-d-xo.html
Search App Bar Tutorial: th-cam.com/video/RaACAwvZ61E/w-d-xo.html
this Google Sheets API tutorials is just what i was looking for
This is Awesome!!
This is really cool
Thanks for making such a great video. It helped me a lot. Can you please show how to connect google sheets data with line chart in flutter?
This is great.
Can i use the different google play console account for uploading my project on playstore
I have to impliment in app purchase and ads in my project
But i have a google play console account with different gmail address and my project is with different gmail account with firebase ?
Ur amazing ♥️
So how i can make searching bar to search or data by name or id
Thanks for the tutorial series :) is there anyway to save the added row index or reference to a specific row in a variable right after appending the row ? the idea is i want to update a specific rows dynamically with no static Id number.
@@HeyFlutter Thanks for the response
Thank you, Care in Turkey!😊, This is not possible with this package. Simply file an issue here: github.com/a-marenkov/gsheets/issues
Very good tutorial! I have one question tho and that is: Is there any way that I can get a whole column from the sheet like A1:A200 and add it to a list in dart?
Thank You TINIAXED f! Follow this link: medium.com/mindorks/storing-data-from-the-flutter-app-google-sheets-e4498e9cda5d
I hope you will get your answer 🙂
Thank you very much for the video! I have a doubt how could I mark the borders and merge the cells
Thank you, Ronald Ramirez! 🙂. You could learn more about google sheets package here: pub.dev/packages/gsheets
show ! tks !
Thanks bro.. I have gone throgh all the 3 parts of video and it's awesome videos.. in this video I have little error at time stamp 11:06 where you called getUsers methods with arguments (index: newIndex ) . I know the necessity of it but at we have not defined any parameter while creating the getUsers method ( i mean it just getUsers() ).. what to do?
Hey, @satdevlpr 🙂 A unique identifier is required to update or delete data, if you have not included it yet then you should as it's a good practice.
is this sheet is central for all users or userwise sheet ?
i mean, if i want to maintain sheet userwise in their own google drive account then its possible with this tutorial ?
Thank You Bharavi wrteam! Follow this link: medium.com/mindorks/storing-data-from-the-flutter-app-google-sheets-e4498e9cda5d
I hope you will get your answer 🙂
Hi Johannes im a currently contributor on your Git. i have a Question. is there anyway to get the users data on a list and then update the FIelds?
Thank You alejandro lozoya amaro! Follow this link: stackoverflow.com/questions/68220695/how-to-update-the-amount-value-when-the-user-add-data-and-store-it-to-list-view
I hope you will get your answer 🙂
I have a field in my google spreadSheet that was saved as hour and I define in my user.dart as string. When I get data from spreadsheet that field did not came as an correct hour. How can I solve this? Tks for your amazing videos :D
Thank You Denise Munchen! Follow this link: stackoverflow.com/questions/65051937/how-to-get-date-and-time-string-from-google-spreadsheet-as-string
I hope you will get your answer 🙂
Hello, I have a question. How can I listen to events in Google Sheets so that data sent through Google Form is read automatically in my project? Without using a step-by-step query in Google Sheets.
Thank You @arturkorol2216! Follow this link: medium.com/scalereal/getting-data-from-google-sheets-flutter-app-part-2-d6e689fdbbed
I hope you will get your answer 🙂
@@HeyFlutter I am developing an application where a list is displayed according to the user input. The list is loading and getting displayed when the application is loaded and whenever the user inputs the data through the text fields(in the app) and the cells (in the google sheet) gets appended too ( which is what I want). But I would like to be able to get realtime list append in the application whenever any new data is inserted in the google sheet itself. So how do I listen for changes in google sheet everytime there is any change and update/append the list (in the application) according to it? Currently, whenever the data is inserted in the google sheet itself, the data only gets loaded when I hot restart the application.
How'd you add *index* to getAllUsers( ) 11:09 . There is no such property when you make the getAllUsers( ) method
Thank you AbhijatyaRitzDev, make sure to follow the tutorial step by step 🙂
hi johannes, may I know what specs you use? is it mac pro?
@@HeyFlutter awesome
Thanks, XarbyX JourneY! 🙂 Yep, it is a mac book pro, 2,4 GHz 8-Core Intel Core i9, 32 GB 2400 MHz DDR4
I install apk on android but it s not fetching data. Any permission have to make on google sheets or what? In Android Studio works very well..
Hello, Denise Munchen! Follow this link: www.appsloveworld.com/flutter/200/257/google-sheets-not-working-for-release-apk-flutter
I hope it will solve your problem. Thank You 🙂
need help ; how i can resolve this problem ??
I/flutter ( 3672): Failed to obtain access credentials. Error: invalid_grant Invalid JWT: Token must be a short-lived token (60 minutes) and in a reasonable timeframe. Check your iat and exp values in the JWT claim. Status code: 400
I/flutter ( 3672): Failed to obtain access credentials. Error: invalid_grant Invalid JWT: Token must be a short-lived token (60 minutes) and in a reasonable timeframe. Check your iat and exp values in the JWT claim. Status code: 400
Thank You العبد المجهول! Follow this link: stackoverflow.com/questions/70147837/googlesheet-with-flutter-invalid-grant-invalid-jwt
I hope you will get your answer 🙂
Need help, can't access source code even after 1st request.
sir how to use gmail api ,plze teach me sir
you didn't show how to make modify_sheets_page.dart
Thanks for the idea, Abhijatya Ritz! 🙂 I have added it to my list of ideas for future videos!
update is not working
Hey @sanketkudale7606, make sure to follow the tutorial step by step 🙂. If problem still persists, please list the error that you are having.