This might help you :) 👉 12 Week Flutter Training from Newbie to Expert: heyflutter.com Source Code: github.com/JohannesMilke/google_sheets_create_example
Truly a beautiful, useful and inspired youtuber. Thank you, I'll be using this knowledge at work. I wish you were in Vancouver, I'd buy you a coffee if I could!
@@HeyFlutter I personally disagree with not having the github plainly in sight and would bet that it actually hurts your growth. Thank you for your videos.
I'm making a diary in flutter to test myself, I'm going to publish it on the play store and I've decided to store the data online. I have a few questions. 1- google sheets or google drive to store data? 2-Are these paid? 3- For example, can I convert an audio file to utf8 and save it in google sheets? 4-What kind of error will I encounter if the user has no storage space in google drive? Thank you very much if you reply, your videos help me a lot
subscribed! first time i am visited your channel and so happy to see this video, i am beginner so i have to watch again and again but i found this video help full.
Hi Johannes or anyone reading this comment For 4:45, is there a way to be able to CRUD from multiple sheets in the same Google Sheet Workbook? Looking forward to all your answers 🙏 Thanks for your videos. It has been very effective and informative, I will highly recommend you to my friends who are learning Flutter
Hey Johannes I am building an expense tracker app and I have integrated it to google sheets with the help of your video. But I also want to integrate it with GOOGLE MESSAGE API so that it listens to my message and automatically updates the sheets Can you make similar video for GOOGLE MESSAGES API. And Thank you for this amazing content :)
Hello, Surya Divakarla! Follow this link: stackoverflow.com/questions/67395364/the-getter-preferredsize-isnt-defined-for-the-type-widget I hope it will solve your problem. Thank You 🙂
If you're still interested a whole year later I may have found a solution. I ended up deleting the contents of the UserFormWidget and didn't replace them with the version shown at 21:13 until after I'd watched the whole video. Spent a good while struggling with the same error you got. Hope it helps you or anyone else who happens upon this error! :)
i followed the video and created an app with google sheets support and i can see its working in simulator but when i publish APP to production its not work. Any idea how to debug this issue and what could be potential reason for not working
Bro Can you teach us, how we can make functional blogs and websites with flutter. There are very few tutorials for flutter web on youtube and most of them are either UI only or old ones.
Hey, i follow your tutorial, but when I run the app, I have a white screen, and I can not understand why. It does not appear nothing on the screen. Any Suggestion? Thank you so much!
Thank You Ricardo Organista! Follow this link: stackoverflow.com/questions/56168832/flutter-app-on-start-it-is-showing-white-screen-for-few-second I hope you will get your answer 🙂
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
Can I make multiple Google Sheets as per users? Like different clients have access to different Google Sheets where they can CRUD their data and only that can be seen by them?
So good. Thank you for all the knowledge you share. One question, is it possible to automate the creation of Google sheet files in case we want to create files per user for example? Thanks a lot for everything.
i needed this in one of my project , Excellent tutorial . Since the credentials are not to be uploaded on github , i used the dotenv package. But im not able to undersand how to put raw string in .env file. Any idea how to do this?
at 11:00...you have have passed a List as an argument, but when i am trying it, it's only allowing a Map and not a list of maps...could you please tell if this package has been updated after this video creation or i am doing something wrong.
So, I can edit any sheet that I'm invited to with the gserviceaccount email, and not necessarily sheets that I created, right? How about sheets that are available to anyone with the link?
What if I use the user log-in credential made by firebase authentication. And I will just add the name of that user to the spreadsheet? Thanks in advance
Thank You Rudy Folden! Follow this link: stackoverflow.com/questions/57797728/flutter-handling-error-socketexception-connection-failed-os-error-network-i I hope you will get your answer 🙂
wonderful video, instead of inserting users one by one how can you insert a list of users at once. I making a project where I will have to insert all the keywords at once .please can you help me do this is my code for inserting it but it is not working. Future insertWords() async { WordFlow item = WordFlow( id: 1, keyWord: newDataList.toList(), ); List itemJson = item.toJson();
Hi. Thanks for the video. I want to be able to switch between worksheets within a google sheet by toggling a dropdownmenu. I.e. when i select 'A" from a dropdown menu, it will save to worksheet A and if i select "B", it will save to worksheet B. Is there a way to do this? I am unable to make the "title" in "_getWorkSheet(spreadsheet, title: '1')" a variable. And because the variable from the dropdownfield widget is in the user_form_widget.dart file. How do I get user_sheets_api to recognise it? I'm not too sure what to type for the "onSavedUser" when I try to get it recognised in the user_sheets_api.dart file. Thanks!
Thank You Mohan Premathilake! Follow this link: tomicriedel.medium.com/flutter-apps-flutter-vs-flutterflow-ed57cb99bb6d#:~:text=Flutter%20of%20course%20also%20has,because%20Flutter%20is%20open%20source. I hope you will get your answer 🙂
Hey Milke, do you have a video with a editable grid example? I want to start trying develop an app and I'll need an editable grid, something easy to build and access cells, background color, font, etc. Is this so difficult? Do you think this is a good idea for a new tutorial? Thanks
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.
Can anyone use this app? I mean, if I install app on my friend phone, he will use his own google sheet or we use the same google sheet? I ask this because I want to use my own database, let's say. I want to store medical data, for example. But I want to use maybe same cloud storage, but different access. Is there a way to use google login in order to each user use their own google sheets and not only one?
@@HeyFlutter thanks for answer. So, even if I hardcoded my own sheet id from url, another user when use this app, the app will creata automatically a sheet for that person in his own google account, and not mine?
after releasing the apk, not saving anything in gsheet... please anybody there to correct me if anything wrong, i m added internet permission too. but still not working
How to authenticate using google sheets . Suppose I sign up and my data is stored in excel . Now Next time I’ll login , so how can I authenticate at that time using google sheets data only like generating a unique token or something for authentication . Please make a video on this . Urgent
Hi Johannes, like your videos about storing data from Ui to excel and fetching data from excel and call it in our app UI . Similarly if we store email I’d, password etc from Ui to excel when user first register in app, then when that user login again then we can authenticate him on the basis of email , password user given earlier. I know you have videos about authentication using Firebase but with excel stored data can we do that ? One more thing , in excel we can store network image by giving Url . What if I want to store downloaded image or screen shot in excel , so then how to call that in app UI ?
Hi Johannes or anyone watching. How do you add a row or a line that splits different entries? So it’s like this Person A $2 4 Apr Person B $3 4 Apr ---------- ⬅️⬅️ Person A $4 6 Apr Person B $2 6 Apr
This code caused a ton of Syntax errors between using Final and const... no guidance on which packages to import... and the code on GitHub requires a payment after subscribing to his spam. Find a better tutorial without a paywall
This might help you :)
👉 12 Week Flutter Training from Newbie to Expert: heyflutter.com
Source Code: github.com/JohannesMilke/google_sheets_create_example
is there a cost implication for using google sheets api?
Definitely you're a very good teacher - please keep with that thing! We need you!
Great, thank you Paulo Rodrigo! Sure I will do 👍🙂
You are a legend man! I LOVE YOU. keep creating good content like this
You too are aspiring legend man! your vids are amazing and some are on my to-do list. haha
Thanks for the knowledge shared, still waiting for audio player
Johannes, your videos are very helpful :) Thank you for such an amazing content.
Woah, thanks. Now, i can use google sheet as database. Waiting for another videos
Nice idea, is it stable like other DBs?
you are the best ! ! !
from Brazil
Thanku for sharing this tutorial ..
Also can you make a tutorial on how to clean code .. or code efficiently or how to manage code
I wanted to say thank you for a million times.
You’re most welcome, Lemon! 🙂
Truly a beautiful, useful and inspired youtuber. Thank you, I'll be using this knowledge at work. I wish you were in Vancouver, I'd buy you a coffee if I could!
Thank you, LesPtitsOiseaux! 🙂 you can help our channel by joining our membership program on youtube
@@HeyFlutter I personally disagree with not having the github plainly in sight and would bet that it actually hurts your growth. Thank you for your videos.
man, this was hard...
this seems to be for professionals. at minute 8 I was lost and stopped the vedio, it is just too complicated
I'm making a diary in flutter to test myself, I'm going to publish it on the play store and I've decided to store the data online. I have a few questions.
1- google sheets or google drive to store data?
2-Are these paid?
3- For example, can I convert an audio file to utf8 and save it in google sheets?
4-What kind of error will I encounter if the user has no storage space in google drive?
Thank you very much if you reply, your videos help me a lot
What a clear explanation sir, superbbb
subscribed! first time i am visited your channel and so happy to see this video, i am beginner so i have to watch again and again but i found this video help full.
Awesome! Thanks for sharing, a new suscriptor and regards from Mexico.
Thank you, Johannes. Would you make a video about how to manipulate Google docs and slides?
Much needed video thank you so much!!!
very Nice tutorial . Thank you very much
Johannes, Please do a video on google Drive api too :)
Amigo you are amazing as always
Thank you, Chandan Sharma! 🙂
Thanks bro, Create an video For PIP Mode in Flutter,
Hi Johannes or anyone reading this comment
For 4:45, is there a way to be able to CRUD from multiple sheets in the same Google Sheet Workbook? Looking forward to all your answers 🙏
Thanks for your videos. It has been very effective and informative, I will highly recommend you to my friends who are learning Flutter
Danke für dieses Videoerzeugniss, only suppose that you would understand that lol
@@HeyFlutter Hah a also doch ein Landsmann, XD
Hey Johannes
I am building an expense tracker app and I have integrated it to google sheets with the help of your video.
But I also want to integrate it with GOOGLE MESSAGE API so that it listens to my message and automatically updates the sheets
Can you make similar video for GOOGLE MESSAGES API.
And Thank you for this amazing content :)
hello, thanks for the Tutorial.
I'm getting an error " 'onSavedUser' isn't defined for the type widget", is there any solution to fix this?!
Hello, Surya Divakarla! Follow this link: stackoverflow.com/questions/67395364/the-getter-preferredsize-isnt-defined-for-the-type-widget
I hope it will solve your problem. Thank You 🙂
@@HeyFlutter that actually didn't solve the problem, but thank you so much for the help 🤗.lots of support👍
If you're still interested a whole year later I may have found a solution. I ended up deleting the contents of the UserFormWidget and didn't replace them with the version shown at 21:13 until after I'd watched the whole video. Spent a good while struggling with the same error you got. Hope it helps you or anyone else who happens upon this error! :)
i followed the video and created an app with google sheets support and i can see its working in simulator but when i publish APP to production its not work. Any idea how to debug this issue and what could be potential reason for not working
Hello. Did you manage to make it work?
Thank you once again
You are welcome, Janam Maharjan!
very good tutorial , i subscribed for channel and thanks May I ask if it can hold images too?
Thanks, Apps Maker! 🙂 it can hold image urls
Thank you so much!
Bro Can you teach us, how we can make functional blogs and websites with flutter. There are very few tutorials for flutter web on youtube and most of them are either UI only or old ones.
Thank so very big much thanks thanks thanks🙏
You’re most welcome, Vinicius Galileu! 🙂
Hello.. i watch you tutorial., but i need to know how we put the starting id at column C1 for starting id?
Thank You ADDIN ANNAS! Follow this link: medium.flutterdevs.com/flutter-with-gsheets-93affffb802
I hope you will get your answer 🙂
Hey, i follow your tutorial, but when I run the app, I have a white screen, and I can not understand why. It does not appear nothing on the screen.
Any Suggestion?
Thank you so much!
Thank You Ricardo Organista! Follow this link: stackoverflow.com/questions/56168832/flutter-app-on-start-it-is-showing-white-screen-for-few-second
I hope you will get your answer 🙂
Can you modify this code if there is no record yet but the columnheaders on the sheet? Its giving an error.
Thanks for the idea, @user-it2lw4ys7b! 🙂 I have added it to my list of ideas for future videos!
Me encanto saludos desde argentina!!!
Nice video. I want to know if you think it's possible to work with dynamic cell with multiple value?
Thanks for the idea @TheLunack 😀, i have added it in my list of future videos
Such amazing app wow🥰🥰🥰 i really like it 🥰
Glad you liked it, Hamza Arshid 😀
@@HeyFlutter I want to get startup learning flutter but i m confused where from i start with sequence kindly hlep me?
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
Can I make multiple Google Sheets as per users? Like different clients have access to different Google Sheets where they can CRUD their data and only that can be seen by them?
So good. Thank you for all the knowledge you share. One question, is it possible to automate the creation of Google sheet files in case we want to create files per user for example? Thanks a lot for everything.
@@HeyFlutter Thank you bro
@@HeyFlutter where to write this line exactly?
how to do this?
Thanks bro
Thanks a lot
ty :) i have questions why when i make Release mode app doesn't work ?
Hey 😊, @user-bn4vk1kk3w! Check out this video: th-cam.com/video/g0GNuoCOtaQ/w-d-xo.html I hope this may help
i needed this in one of my project , Excellent tutorial . Since the credentials are not to be uploaded on github , i used the dotenv package. But im not able to undersand how to put raw string in .env file. Any idea how to do this?
at 11:00...you have have passed a List as an argument, but when i am trying it, it's only allowing a Map and not a list of maps...could you please tell if this package has been updated after this video creation or i am doing something wrong.
try changing this: _userSheet!.values.map.appendRows(rowList);
So, I can edit any sheet that I'm invited to with the gserviceaccount email, and not necessarily sheets that I created, right? How about sheets that are available to anyone with the link?
Thank You Thanh-Bình Nguyễn! Follow this link: medium.flutterdevs.com/flutter-with-gsheets-93affffb802
I hope you will get your answer 🙂
What if I use the user log-in credential made by firebase authentication. And I will just add the name of that user to the spreadsheet? Thanks in advance
Amazing ❤
is it suitable to add gsheets package to a bigger flutter app or should i ignore ?
#help_needed
Is it possible to do without service account , does gsheets work with oauth2 .
Its Outdated "WorkSheet" class is not used anymore in gsheets package. Unfortunately this make / break / remake disruption is a legacy of google
Thanks for the feedback, @saudfruits! 🙂 I have added tutorial update to my list of future videos!
it not works?? for read and create data in sheet using flutter
I get "Connection failed" when running as a MacOS desktop app. Any ideas?
Thank You Rudy Folden! Follow this link: stackoverflow.com/questions/57797728/flutter-handling-error-socketexception-connection-failed-os-error-network-i
I hope you will get your answer 🙂
wonderful video, instead of inserting users one by one how can you insert a list of users at once. I making a project where I will have to insert all the keywords at once .please can you help me do this is my code for inserting it but it is not working.
Future insertWords() async {
WordFlow item = WordFlow(
id: 1,
keyWord: newDataList.toList(),
);
List itemJson = item.toJson();
print(itemJson.toString());
await GApi.insert(itemJson);
}
id value not getting incremented.
Did you miss to show on the vedio.
Thankyou like always unique and very usefull vedio........
Solved Thankyou
Great, Jeswin Alex! 🙂👍
Hi. Thanks for the video. I want to be able to switch between worksheets within a google sheet by toggling a dropdownmenu. I.e. when i select 'A" from a dropdown menu, it will save to worksheet A and if i select "B", it will save to worksheet B. Is there a way to do this? I am unable to make the "title" in "_getWorkSheet(spreadsheet, title: '1')" a variable.
And because the variable from the dropdownfield widget is in the user_form_widget.dart file. How do I get user_sheets_api to recognise it? I'm not too sure what to type for the "onSavedUser" when I try to get it recognised in the user_sheets_api.dart file. Thanks!
Can we download the particular sheets in the app?
Can we do the same project in FlutterFlow? Thank you for the nice video tutorial
Thank You Mohan Premathilake! Follow this link: tomicriedel.medium.com/flutter-apps-flutter-vs-flutterflow-ed57cb99bb6d#:~:text=Flutter%20of%20course%20also%20has,because%20Flutter%20is%20open%20source.
I hope you will get your answer 🙂
@@HeyFlutter thank you very much
bro whenever i use loops to insert values in spread sheet it end up in error . What should i do for that
Thank you, HD Cutz! 🙂. Try to paste the error message with your question whenever you face any issue or error.
Nice video! I have one question. Is there any security issue if flutter code contains _credential variable as a plain text?
Thank you, SeongWon Kong! 🙂. No there is no issue.
How can I get response(confirmation) to be sure that data was write on the sheet?
@@HeyFlutter Thanks!!!
How can i config each USER TO EACH SHEET, i want all data saved by User001 to sheet001, and send sheet for another User002
Is gsheet good as a database? I have a 800-1000 members project.
Thank you, 張鋒石! 🙂.No database is something else.
PIP mode in Flutter
@@HeyFlutter really thanks! Will be waiting for that Also
I'm getting erreor that The method 'GSheets' isn't defined for the type 'UsersSheetApi'.
Hey Milke, do you have a video with a editable grid example? I want to start trying develop an app and I'll need an editable grid, something easy to build and access cells, background color, font, etc. Is this so difficult? Do you think this is a good idea for a new tutorial?
Thanks
need it to :D
flutter: Init Error: GSheetsException: Invalid requests[0].addSheet: A sheet with the name "Users" already exists. Please enter another name.
Thank you @SamiKhan-yq4nh, make sure to follow the tutorial step by step 🙂
Is there any way to create a new google sheet from flutter app??
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.
Can anyone use this app? I mean, if I install app on my friend phone, he will use his own google sheet or we use the same google sheet? I ask this because I want to use my own database, let's say. I want to store medical data, for example. But I want to use maybe same cloud storage, but different access. Is there a way to use google login in order to each user use their own google sheets and not only one?
Thank you, @AboutThings! 🙂. Every user will have its own sheet
@@HeyFlutter thanks for answer. So, even if I hardcoded my own sheet id from url, another user when use this app, the app will creata automatically a sheet for that person in his own google account, and not mine?
after releasing the apk, not saving anything in gsheet... please anybody there to correct me if anything wrong, i m added internet permission too. but still not working
How to authenticate using google sheets . Suppose I sign up and my data is stored in excel . Now Next time I’ll login , so how can I authenticate at that time using google sheets data only like generating a unique token or something for authentication . Please make a video on this . Urgent
Hi Johannes, like your videos about storing data from Ui to excel and fetching data from excel and call it in our app UI . Similarly if we store email I’d, password etc from Ui to excel when user first register in app, then when that user login again then we can authenticate him on the basis of email , password user given earlier. I know you have videos about authentication using Firebase but with excel stored data can we do that ?
One more thing , in excel we can store network image by giving Url . What if I want to store downloaded image or screen shot in excel , so then how to call that in app UI ?
Hi Johannes or anyone watching.
How do you add a row or a line that splits different entries? So it’s like this
Person A $2 4 Apr
Person B $3 4 Apr
---------- ⬅️⬅️
Person A $4 6 Apr
Person B $2 6 Apr
I thought this could make in-app spreadsheets as well, good vid tho.
Glad you liked it, @s-sugoi835 😀
How we can generate multiple spread sheet dynamically ?
@@HeyFlutter every time all TH-camr show only particular topic not a detail explaination about the topic
how do we can download XL file after
Great.
button widget code please, your some of code hidden with android emulator, please help
@@HeyFlutter i m not getting your buildSubmit() code,
wow . realy usefull ,
if you have a course for google sheets with flutter?? please just mention me,
and thank you for this video
I really want to buy a course of yours but now I just need the flutter google sheets 🙏
I sent you an email. Thank you for your help!
رائع
hi sir can u pls share source code Im getting errorrs while doing it .Pls share the source code thank you
@@HeyFlutter can I get it free I dont have that much to pay u sir :(
i can able to read the data
Thank you @VirtualEducationLYF-dd1lh, make sure to follow the tutorial step by step 🙂
A free database lol
hey i am facing permission err
waiting for audio player
This code caused a ton of Syntax errors between using Final and const... no guidance on which packages to import... and the code on GitHub requires a payment after subscribing to his spam. Find a better tutorial without a paywall
Gooooood
Hello, after i watch this tut, i got a job, i will to share you a gift, how can i send you
hope you explain programing this app
th-cam.com/video/5sFb8UANoTY/w-d-xo.html
hi pro for the source code you need 9 $ :( i cant bay this :(
Gedharing code hai
Thank you, @deepakswatistar! 🙂