Flutter Tutorial - Google Sheets API 2/3 - Read & Fetch Data & SpreadSheets CRUD
ฝัง
- เผยแพร่เมื่อ 9 มิ.ย. 2024
- Use the Flutter Google Sheets API to read and fetch data from 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
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:23 Fetch Single Row From Spreadsheet
5:44 Display Single Fetched User In UI
8:06 Fetch Multiple Rows From Spreadsheet
10:50 Display Multiple Fetched Users In UI
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_read_example
Source code chahiye
I have looked at a lot of Flutter channels, the quality of frequency on your channel is by far the best!
Johannas your flutter tutorials are the best, and it’s great to see a developer with such strong design skills. Thank you.
This is what I was looking for.
Thank you :)
The best Flutter channel
very difficult for me! because i am beginner. but i can understand slowly slowly what your are explaining. i have small business and i used google sheets on computer but now i want everything in my flutter app. by the great video!
This is Amazing
Thank you very very much
nice. pls make a tutorial on how to store question banks via google sheets for your quiz app. thank you
Hi Thank you so much for this helpful tutorial. Can you guide about how to update this data on daily basis and keeping previous records intact. such as creating a new sheet dynamically based on day. Is that possible to create a sheet on daily basis and first adding existing data of previous sheets and then modify it.
@@HeyFlutter thank you for replying I will definitely check this out
What can do for uploading my project to different google play console ?
Bcoz i have to impliment in app purchase in that project !
Hi, Johannes. Look, I'm trying to read a date value that I saved in sheets, but the problem is that, when getting this value, I don't get the date as a string but as a number. For example, I save 2021/12/21 but I get something like 444351. How do I get the date just a it is on the sheets? Thanks a lot!
Johannes top work my friend thanks heaps instant subscriber of your work, 1 issue i'm having with this tutorial is the insert method isn't working for me any ideas as i've tried stack overflow with no luck, on my vs code editor the red squiggly line of death is telling me that insert needs 'Instance member 'insert' can't be accessed using static access' any idea what this means please got me stumped after hours of my own debugging. Thanks in advance. Keep up the brilliant coding !
Nice 👍
please how do you download the google sheet as an excel file in flutter app
Awesome tutorial!!! I have one question. I am working on an app where I insert some data in google sheets and it gets updated in google sheets and displays in the list in the application and everything is working fine. I was curious about how to fetch the data in real-time when the data is inserted directly into google sheets. If the data is entered in the app itself, the value is getting updated in real-time in google sheets and the app list is updated(which is what I want), but the problem is that when the data is inserted directly into google sheets, it is not displaying in real-time rather the app should be hot reloaded every time in order to display the data. Is there any way to listen for constant changes in google sheets and display the data whenever there is a change in the google sheets?
@@HeyFlutter The blog was great but it didn't solve the realtime list updates in the application whenever there is any changes in the google sheet itself. I have been trying to figure out a way to do it. There is no tutorial on it , so maybe you could make one. :)
Can i use the different google play console account for uploading my project on playstore
I have to impliment in app purchase in my project
But i have a different google play console account with different email address ?
@@HeyFlutter what can i do for that ?
Hello i have a question ..
when i try to output the data in the app interface it shows only the name in every textfield
waiting for your answer and thank you
Thank you, @IssamKada-tz5st! 🙂. Please try to provide enough details with your question.
for those getting "Null check operator used on a null value' 4:34 ..instead of this "print(user!.toJson());"
use this:
if(user != null){
print(user.toJson());
}
i only able to insert data in app and i cans see bottom two buttons google sheet delete and google sheet modify what is a prblm ? please reply
Hey 😊, @vrushilvp4122! Check out this video first for initial set-up: th-cam.com/video/3UJ6RnWTGIY/w-d-xo.html
make a advanced reminder or todo app
Sir, please dart keyboard Late, As, assert, await, Async,sync, export, factory, Interface, Yield, Typedef, Mixin, Rethrow, Part, Covariant, Deffered, EXTENSION, EXTERNAL
Flutter is really complex just to display 3 fields it's a pain in the ass .. in powerapps it takes 3 seconds to retrieve data from excel
Hey, @TheAmazeer 🙂 It's not like flutter is the best solution to read excel data, but this video is more about that it's possible using flutter. If you are finding it difficult you can come up with something better and make your contribution to the community👍
@@HeyFlutter powerapps is better but I already said it 😉
you arrange the code on separate files instead of merging like that, it is difficult to imagine for a beginner
@@HeyFlutter thanks you :)
onm mansilayiila sir :(
adipoli
nannayi