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

Use the Flutter Google Sheets API to create and save data to the rows and columns of the Google Spreadsheets in Flutter.
Click here to Subscribe to Johannes Milke: kzbin.info...
👉 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
Fetch Data From Google Sheet Tutorial: • Flutter Tutorial - Goo...
Delete Data From Google Sheet 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 GSheets Package
0:33 Create Google Spreadsheet
0:53 Extract Google Spreadsheet Identifer
1:22 Give Access Rights To Flutter App / Enable Google Sheets API
3:09 Share Spreadsheet With Google Service Account
3:32 Setup & Initialize GSheets Package
6:42 Introduction Create Spreadsheet Header Row
7:27 Create Spreadsheet Header Row
9:11 Create Single Spreadsheet Row By JSON
11:55 Create Multiple Spreadsheet Rows By JSON
12:19 Create Single Spreadsheet Row By Object
13:33 Create Multiple Spreadsheet Rows By Objects
14:25 Create Form UI To Save To Google Spreadsheet
21:54 Create IDs for Spreadsheet Rows
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

[@HeyFlutter]

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

[@user-xz6uq9tq1o]

is there a cost implication for using google sheets api?

[@m.k9305]

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

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

[@vishalmakam7291]

What a clear explanation sir, superbbb

[@sumittiware9382]

Much needed video thank you so much!!!

[@LemonSensei]

I wanted to say thank you for a million times.

[@HeyFlutter]

You’re most welcome, Lemon! 🙂

[@carlospijanowski]

you are the best ! ! ! from Brazil

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

[@JosueHerrera021]

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

[@nasrulsetiawan]

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

[@monasaad8807]

Nice idea, is it stable like other DBs?

[@janammaharjan2699]

very Nice tutorial . Thank you very much

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

[@samwise2529]

Thank you so much!

[@chandansharma8658]

Amigo you are amazing as always

[@HeyFlutter]

Thank you, Chandan Sharma! 🙂

[@LuisFernandez-cz7gb]

Me encanto saludos desde argentina!!!

[@AmBigRyan]

Thanks for the knowledge shared, still waiting for audio player

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

[@programingtales7514]

Amazing ❤

[@aminelahrim8142]

Thanks a lot

[@minhpianore]

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

[@reginaldodejesusoliveirasi4930]

very good, tks!

[@markmaher-9712]

Thanks bro

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

[@janammaharjan2699]

Thank you once again

[@HeyFlutter]

You are welcome, Janam Maharjan!

[@viniciusgalileu1584]

Thank so very big much thanks thanks thanks🙏

[@HeyFlutter]

You’re most welcome, Vinicius Galileu! 🙂

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

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

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

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

[@dhrubrawat9316]

Great.

[@kevin_pabst]

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

[@kevin_pabst]

@@HeyFlutter Hah a also doch ein Landsmann, XD

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

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

[@gal1leo532]

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

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

[@movie_explainer_free]

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

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

[@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!

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

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

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

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

[@lakshminarayananm8764]

Can we download the particular sheets in the app?

[@jubayerjb8072]

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

[@vpraneeth554]

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

[@alabeb8455]

Gooooood

[@aboalwajeeh9471]

رائع

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

[@waseurarpon8352]

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

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

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

[@prifysports7654]

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

[@heesungjin8554]

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

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

[@sathishkumar5377]

how do we can download XL file after

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

[@user-xe4ei9oe5k]

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

[@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 🙏

[@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! 🙂👍

[@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);

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

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

[@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 🙂

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

[@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 🙂

[@movie_explainer_free]

PIP mode in Flutter

[@movie_explainer_free]

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

[@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 🙂

[@s-sugoi835]

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

[@HeyFlutter]

Glad you liked it, @s-sugoi835 😀

[@musicstories9723]

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

[@user-it2lw4ys7b]

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!

[@juninhobacker]

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

[@juninhobacker]

@@HeyFlutter Thanks!!!

[@nuggy99]

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

[@HeyFlutter]

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

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

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

[@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 🙂

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

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

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

[@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 🙂

[@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 :(

[@markmaher-9712]

waiting for audio player

[@vishalmakam7291]

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

[@vishalmakam7291]

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

[@VirtualEducationLYF-dd1lh]

i can able to read the data

[@HeyFlutter]

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

[@sathishkumar5377]

hey i am facing permission err

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

[@malbashaco]

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

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

[@actionscript3661]

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

[@deepakswatistar]

Gedharing code hai

[@HeyFlutter]

Thank you, @deepakswatistar! 🙂