Flutter Tutorial - Google Sheets API 1/3 - Create & Save Data & Google SpreadSheets CRUD

[@HeyFlutter]

This might help you :) 👉 12 Week Flutter Training from Newbie to Expert: heyflutter.com Source Code: github.com/JohannesMilke/google_sheets_create_example

[@FullStackDeveloper-q2o]

is there a cost implication for using google sheets api?

[@paulorodrigolimafigueiredo1252]

Definitely you're a very good teacher - please keep with that thing! We need you!

[@HeyFlutter]

Great, thank you Paulo Rodrigo! Sure I will do 👍🙂

[@createdbykoko]

You are a legend man! I LOVE YOU. keep creating good content like this

[@vivekjunghamal5730]

You too are aspiring legend man! your vids are amazing and some are on my to-do list. haha

[@LemonSensei]

I wanted to say thank you for a million times.

[@HeyFlutter]

You’re most welcome, Lemon! 🙂

[@lesptitsoiseaux]

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]

Thank you, LesPtitsOiseaux! 🙂 you can help our channel by joining our membership program on youtube

[@lesptitsoiseaux]

@@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.

[@nasrulsetiawan]

Woah, thanks. Now, i can use google sheet as database. Waiting for another videos

[@monasaad8807]

Nice idea, is it stable like other DBs?

[@AmBigRyan]

Thanks for the knowledge shared, still waiting for audio player

[@SirChatur]

Thanku for sharing this tutorial .. Also can you make a tutorial on how to clean code .. or code efficiently or how to manage code

[@m.k9305]

Johannes, your videos are very helpful :) Thank you for such an amazing content.

[@vishalmakam7291]

What a clear explanation sir, superbbb

[@snehaltandel9667]

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.

[@suryadivakarla9988]

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?!

[@HeyFlutter]

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 🙂

[@suryadivakarla9988]

@@HeyFlutter that actually didn't solve the problem, but thank you so much for the help 🤗.lots of support👍

[@Dreamdog2]

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! :)

[@ZefromXD]

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

[@minhpianore]

Thank you, Johannes. Would you make a video about how to manipulate Google docs and slides?

[@shashwat_dubey_]

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.

[@andresrestrepo823]

try changing this: _userSheet!.values.map.appendRows(rowList);

[@shashanksm6327]

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 :)

[@james007anu]

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

[@pedrorafaelperalta6176]

Hello. Did you manage to make it work?

[@JosueHerrera021]

Awesome! Thanks for sharing, a new suscriptor and regards from Mexico.

[@FreeFall73]

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.

[@vpraneeth554]

Is it possible to do without service account , does gsheets work with oauth2 .

[@baqirhemani]

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?

[@RonaldIgnacio-u3w]

Can you modify this code if there is no record yet but the columnheaders on the sheet? Its giving an error.

[@HeyFlutter]

Thanks for the idea, @user-it2lw4ys7b! 🙂 I have added it to my list of ideas for future videos!

[@addinannas7909]

Hello.. i watch you tutorial., but i need to know how we put the starting id at column C1 for starting id?

[@HeyFlutter]

Thank You ADDIN ANNAS! Follow this link: medium.flutterdevs.com/flutter-with-gsheets-93affffb802 I hope you will get your answer 🙂

[@chandansharma8658]

Amigo you are amazing as always

[@HeyFlutter]

Thank you, Chandan Sharma! 🙂

[@appmaker617]

How can i config each USER TO EACH SHEET, i want all data saved by User001 to sheet001, and send sheet for another User002

[@TheLunack]

Nice video. I want to know if you think it's possible to work with dynamic cell with multiple value?

[@HeyFlutter]

Thanks for the idea @TheLunack 😀, i have added it in my list of future videos

[@meetpanchal8809]

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?

[@OmarHamouda-iq3mu]

ty :) i have questions why when i make Release mode app doesn't work ?

[@HeyFlutter]

Hey 😊, @user-bn4vk1kk3w! Check out this video: kzbin.info/www/bejne/nWGqf6ileLSnl7M I hope this may help

[@sumittiware9382]

Much needed video thank you so much!!!

[@sfdsfdsgfgsfsgfsgfsgf2768]

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

[@janammaharjan2699]

very Nice tutorial . Thank you very much

[@simgc3245]

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!

[@fluttermakers]

very good tutorial , i subscribed for channel and thanks May I ask if it can hold images too?

[@HeyFlutter]

Thanks, Apps Maker! 🙂 it can hold image urls

[@ricardoorganista9861]

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!

[@HeyFlutter]

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 🙂

[@shashwat_dubey_]

man, this was hard...

[@MohMoh-mw9ml]

this seems to be for professionals. at minute 8 I was lost and stopped the vedio, it is just too complicated

[@gal1leo532]

Johannes, Please do a video on google Drive api too :)

[@hamzaarshid7274]

Such amazing app wow🥰🥰🥰 i really like it 🥰

[@HeyFlutter]

Glad you liked it, Hamza Arshid 😀

[@hamzaarshid7274]

@@HeyFlutter I want to get startup learning flutter but i m confused where from i start with sequence kindly hlep me?

[@thanh-binhnguyen5603]

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?

[@HeyFlutter]

Thank You Thanh-Bình Nguyễn! Follow this link: medium.flutterdevs.com/flutter-with-gsheets-93affffb802 I hope you will get your answer 🙂

[@lakshminarayananm8764]

Can we download the particular sheets in the app?

[@janammaharjan2699]

Thank you once again

[@HeyFlutter]

You are welcome, Janam Maharjan!

[@excellencemichel4875]

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.

[@excellencemichel4875]

@@HeyFlutter Thank you bro

[@TechnophileLad]

@@HeyFlutter where to write this line exactly?

[@prajwalsugandhi7293]

how to do this?

[@viniciusgalileu1584]

Thank so very big much thanks thanks thanks🙏

[@HeyFlutter]

You’re most welcome, Vinicius Galileu! 🙂

[@richelbacot]

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

[@vishalmakam7291]

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

[@jubayerjb8072]

is it suitable to add gsheets package to a bigger flutter app or should i ignore ? #help_needed

[@RoseDeWittWish]

Thanks bro, Create an video For PIP Mode in Flutter,

[@waseurarpon8352]

Is there any way to create a new google sheet from flutter app??

[@nuggy99]

Is gsheet good as a database? I have a 800-1000 members project.

[@HeyFlutter]

Thank you, 張鋒石! 🙂.No database is something else.

[@العبدالمجهول]

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

[@opinionMe]

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); }

[@seongwonkong905]

Nice video! I have one question. Is there any security issue if flutter code contains _credential variable as a plain text?

[@HeyFlutter]

Thank you, SeongWon Kong! 🙂. No there is no issue.

[@mohanpremathilake915]

Can we do the same project in FlutterFlow? Thank you for the nice video tutorial

[@HeyFlutter]

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 🙂

[@mohanpremathilake915]

@@HeyFlutter thank you very much

[@AboutThings]

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]

Thank you, @AboutThings! 🙂. Every user will have its own sheet

[@AboutThings]

@@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?

[@juninhobacker]

How can I get response(confirmation) to be sure that data was write on the sheet?

[@juninhobacker]

@@HeyFlutter Thanks!!!

[@gnrslashsp6501]

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

[@19boss16]

need it to :D

[@hdcutz2936]

bro whenever i use loops to insert values in spread sheet it end up in error . What should i do for that

[@HeyFlutter]

Thank you, HD Cutz! 🙂. Try to paste the error message with your question whenever you face any issue or error.

[@rudyfolden585]

I get "Connection failed" when running as a MacOS desktop app. Any ideas?

[@HeyFlutter]

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 🙂

[@SamiKhan-yq4nh]

flutter: Init Error: GSheetsException: Invalid requests[0].addSheet: A sheet with the name "Users" already exists. Please enter another name.

[@HeyFlutter]

Thank you @SamiKhan-yq4nh, make sure to follow the tutorial step by step 🙂

[@D3_Business_Analytics]

Its Outdated "WorkSheet" class is not used anymore in gsheets package. Unfortunately this make / break / remake disruption is a legacy of google

[@HeyFlutter]

Thanks for the feedback, @saudfruits! 🙂 I have added tutorial update to my list of future videos!

[@VirtualEducationLYF-dd1lh]

it not works?? for read and create data in sheet using flutter

[@samwise2529]

Thank you so much!

[@LuisFernandez-cz7gb]

Me encanto saludos desde argentina!!!

[@sathishkumar5377]

how do we can download XL file after

[@jeswinalex8418]

id value not getting incremented. Did you miss to show on the vedio. Thankyou like always unique and very usefull vedio........

[@jeswinalex8418]

Solved Thankyou

[@HeyFlutter]

Great, Jeswin Alex! 🙂👍

[@programingtales7514]

Amazing ❤

[@prasaddhend5500]

How we can generate multiple spread sheet dynamically ?

[@prasaddhend5500]

@@HeyFlutter every time all KZbinr show only particular topic not a detail explaination about the topic

[@__mothership__8475]

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

[@__mothership__8475]

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 ?

[@musicstories9723]

I'm getting erreor that The method 'GSheets' isn't defined for the type 'UsersSheetApi'.

[@aminelahrim8142]

Thanks a lot

[@vishalmakam7291]

button widget code please, your some of code hidden with android emulator, please help

[@vishalmakam7291]

@@HeyFlutter i m not getting your buildSubmit() code,

[@careinturkey]

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.

[@petruschkii]

Danke für dieses Videoerzeugniss, only suppose that you would understand that lol

[@petruschkii]

@@HeyFlutter Hah a also doch ein Landsmann, XD

[@markmaher-9712]

Thanks bro

[@RoseDeWittWish]

PIP mode in Flutter

[@RoseDeWittWish]

@@HeyFlutter really thanks! Will be waiting for that Also

[@musicstories9723]

hi sir can u pls share source code Im getting errorrs while doing it .Pls share the source code thank you

[@musicstories9723]

@@HeyFlutter can I get it free I dont have that much to pay u sir :(

[@ZefromXD]

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

[@mattihna]

wow . realy usefull , if you have a course for google sheets with flutter?? please just mention me, and thank you for this video

[@mattihna]

I really want to buy a course of yours but now I just need the flutter google sheets 🙏

[@s-sugoi835]

I thought this could make in-app spreadsheets as well, good vid tho.

[@HeyFlutter]

Glad you liked it, @s-sugoi835 😀

[@dhrubrawat9316]

Great.

[@sathishkumar5377]

hey i am facing permission err

[@markmaher-9712]

waiting for audio player

[@aboalwajeeh9471]

رائع

[@heesungjin8554]

I sent you an email. Thank you for your help!

[@VirtualEducationLYF-dd1lh]

i can able to read the data

[@HeyFlutter]

Thank you @VirtualEducationLYF-dd1lh, make sure to follow the tutorial step by step 🙂

[@alabeb8455]

Gooooood

[@luisfelipemurguiaramos659]

A free database lol

[@appmaker617]

Hello, after i watch this tut, i got a job, i will to share you a gift, how can i send you

[@becomeplayer1]

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

[@malbashaco]

hi pro for the source code you need 9 $ :( i cant bay this :(

[@ssadeepak]

Gedharing code hai

[@HeyFlutter]

Thank you, @deepakswatistar! 🙂

[@actionscript3661]

hope you explain programing this app kzbin.info/www/bejne/a6Spk2uLdrOiirs