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.

SUBSCRIBE HERE

SUPPORT & SPONSOR ME

RESOURCES

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

LEARN MORE

PLAYLISTS

CREDITS

#Flutter #Tutorial #JohannesMilke

LIKE & SHARE & ACTIVATE THE BELL
Thanks For Watching :-)

[m.k]

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

[paulorodrigolimafigueiredo]

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

[createdbykoko]

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

[vishalmakam]

What a clear explanation sir, superbbb

[sumittiware]

Much needed video thank you so much!!!

[snehaltandel]

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.

[JosueHerrera]

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

[LemonSensei]

I wanted to say thank you for a million times.

[janammaharjan]

very Nice tutorial . Thank you very much

[meetpanchal]

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?

[minhpianore]

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

[nasrulsetiawan]

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

[simgc]

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!

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

[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

[FreeFall]

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.

[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

[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