Learn How to Save Data from Flutter App to Google Sheets | Flutter Tutorial For Beginners
Вставка
- Опубліковано 1 бер 2020
- Learn how to Save Data from Flutter App to Google Sheets, explained step by step.
source code: github.com/theindianappguy/flutter_google_sheets
If you found this helpful or you learned something from this and want to thank me, consider buying me a cup of ☕ (it helps & supports me to make more): paypal.me/iamsanskartiwari
📙 Join 5-Day Flutter Bootcamp for Beginners
flutternerd.com/free-training/
🎓More tutorials you may like
○ Build a Wallpaper App with Flutter: • Build a Wallpaper App ...
○ Build a Recipe App with Flutter: • Build a Recipe App wit...
○ Build a Flutter News App with NewsApi Org: • Build a Flutter News A...
○ Build a Flutter Firebase Blog App: • Build a Flutter Fireba...
○ Building a Travel App UI Design Tutorial: • Building a Travel App ...
If you like it make sure to 🔥 Subscribe for more: / @indianappguy
Have questions/queries? 💬 Comment below I will be happy to help
special thanks to Shreyas Patil: / storing-data-from-the-...
Flutter is Google’s UI toolkit for building beautiful, natively compiled applications for mobile, web, and desktop from a single codebase.
Say hi 👋 on Linkedin: linkedin.com/in/lamsanskar/
Follow me on 🐦 Twitter: Theindianappguy
🎵Music Credits :
JPB - High [NCS Release] • JPB - High | Trap | NC...
📱 Want to Learn building whole *Apps from Scratch* ?
bit.ly/FlutterAppsFromScratch
🤩 Want to watch more *UI Design with Flutter* ?
bit.ly/FlutterUiDesign
Please increase your console font size
I followed with no errors in either flutter or google sheets but my data is not showing up. I used my fields of choice. That's all i changed and the parts I was supposed to change. Any Ideas
Sorry, i fixed it. double quote around webapp link insted of single Fixed
@@tbcguy1030 im facing the same issue. ive replaced the single quotes with the double for webaap in URL part. still data is not being deisplayed on the sheet. can you help
I fixed it, the issue was I had not given access to "everyone and even anonymous". once I gave the access it began working. @Sanskar Tiwari thank you for such awesome tutorial
Thanks!!, how could I send my firestore data into a sheet (But this sheet isn't default, it is predesigned) each time user click in a button, download it with his design and his data by uid, if you make a video about that you'd help me a lot in my project! thanks again!
This was awesome !!!!!! Keep them coming !!!! Amazing flutter add on !!!!
Thank you! Will do!
Very beautiful, clean , neat ! Thanks !!! 👍🏿👏🏿👏🏿👏🏿
You are welcome
we can use microsoft excel for create table?
in flutter? like this ? if we can you can tell us ? thanks.
This is awsome! Thank you for your tutorials!
Welcome do share
Awesome tutorial for integrating to Email automation from Google Sheets data using google scripts.. Flutter app serves as front-end instead of Google forms... thanks for igniting such idea!!!!
Thanks a lot Aldwin I am glad you liked it, if it added any value consider sharing it so others can benefit too thanks
If you have 2 functions in the spreadsheet app script doGet and another one, how can you distinguish which one to execute from the flatter app?
Thank you very much for your time and kindness.
You are welcome, do share
🙂
You're awesome! Thank you very much.
Please guys be so careful while copying, one wrong letter in script editor code will run and show result success but won't work, every single letter should match the corresponding letter on Flutter/Dart.
Another tip: You may need to deploy one or two times in order to get it work (result : success).
thanks
Hello teacher!
How to export data from table into an excel online?
When I am using a virtual machine the app works 100%, but as soon as I install it on a phone it just can't submit data. I have set the access type to everyone including anonymous, is there something extra I need to do?
Great man, clean and clear video! You earned a subscriber.
Thanks Pratik
@@indianappguy The data I post will go to a single spreadsheet always. Is there any way, I can do it to send the data to the SpreadSheet for the Google Account the user logged in with in the app?
@@pratikjain3323 i will make video on that soon
waooo thanks , thanks for sharing your knowledge and more examples please.
No problem
bro Thank You
Hi, I have a problem and I don't know why
I/flutter (11135): FormatException: Unexpected character (at character 1)
I/flutter (11135):
Good work man!
Thankyou
How to export data table to CSV or Excel using Flutter?
Hey man, nice Tutorial!!!
Thanks
I need the source code of different projects based on flutter and dart .
Can I got it?
my app is not working, i am submitting the form but feedback not saved at Google Sheet. What's the problem?
Bro, wonderful presentation.
If possible then please share the controller code.
is there a limitations of using spreadsheet?
i have error
Response: FAILED
what i do ?
and iam very sure for code is clear and I make step by step
and I check the code more than 10
its working good but why getting error in console ?
I/flutter (29445): FormatException: Unexpected character (at character 1)
I/flutter (29445):
Excelente video 👌
Thanks
nice video. Thank you
I am Glad you liked it
Thanks a lot.! Quite helpful
How to do the reverse of it?
Like validating user inputs with google sheets for signup?
I know that's not the conventional way but I need it for my project.
I am getting un-authorized error on postman
you are awesome !!
Thanks a lot Nikhil
Awesome video
please make a video for get the data from sheets
Just checkout the #askfirebase solution is there..!!!
Please provide a video for flutter setup in MacBook
great sir
Thanks do share
How to fetch data with query parameter?
Awesome 😎
Thanks a lot, I am glad you liked it if it added any value do consider sharing it with friends and colleagues so they can Benefit too
Awesome Bro , a big THANK for you.
May I ask a question , is there a way to make first column for ID to be able to update or delete a specific row via this ID !? it will be awesome bro.
Yes you can will make a tutorial
A big THANKS from my side.
I just want to know how can I pass the data in both google sheets and on next page of app?
for next page just add arguments to the widget and accept it
Thanks for this Amazing tutorial :) But can i make for every data a own sheet ?
You are welcome, i didn't get the question?
Hello Sanskar, thanks for this amazing tut :D, but i got an error in the controller file, in the submitForm method, it says : "FormatException: Unexpected character (at line 2, character 1) "
Thanks in advance.
Hey! I got the same error, and here's how I solved it:
I logged the entire response and figured that it was asking me to sign in to my Google account. This happens when the settings of the Deployment have not been configured properly. Make sure that the "Execute as" option is set to your account (Found as "Me" in the dropdown), so that the script will always be executed with your account, and not ask another person to login to execute it.
Although this is late, hope it helps you, or anybody that reads this!
Thanks for this Amazing tutorial :) I want to implement the offline sync with google sheet so if there is no internet, user can still submit the feedback and when connection establish, data will automatically send to google sheet. Any suggestion would be great.
You can save user data to shared preference and check for connection once connected try again
@@indianappguy Thanks for the reply. I just implement that part using firebase. Firestore managing offline part then I created a custom function for Firebase and Google sheet Sync. So now it's working as expected but I'll definitely try your suggested way also.
@@ravihirani4182 Would you share what you did with firebase and sync. I am in the same situation, my users often work in remote area with no internet
If i wanted to add check box type data and drop down for male female and then if i select male how to see it on excel what changes i have to do ?? please help
well its pretty simple you just need to use drop down and then when user select something then call the function which we created to upload data to google sheets
error:
The argument type 'String' can't be assigned to the parameter type 'Uri'.dart(argument_type_not_assignable)
have you found the solution for this error?
@@namrivegeta yes sir
@@santamayengbam1430 how did you fix it?
@@namrivegeta any update on the fix?
@@Jifokwan I cant remember the solution mate. Sorry🙏🏻
please make video on offline spreadsheets too
great tut , thanks, how can we read the content of the file ?
Working on this tutorial next Sunday 👍
you should make a code zoom when you coding so we can see clear the code, the sheet code is soo far and unclear to see, thank you anyways
Hello sir, how to ridirect to new page after clicking on submit form
Code look like this
RaisedButton(
color: Color.blue,
onPressed:(){ _submitForm()
},
),
Use Navigator. pop(context: true)
In case of another submission, will this code add the new data to new row?
Yes
Hi Sanskar Tiwari, Great work was really helpful. Have a question though, I am trying to fetch data from Cloud Firestore (wanted to create a CVS file for Facebook product Catalogue) so when everything is working fine but only issue is that when I try to insert a Firebase storage download URL (which is stored as a string in Firestore), Google sheets would replace all %20 with space and also won't take the token at the end of the URL. Any idea ? what could help. FYI when I print that url in console it is fine and It also works on my app.
still facing the problem?
@@indianappguy well there were & and # in the url link which were conflicting with the API call but I figured out a way to replace the characters and replace them again once data is in google sheets
Hi, I used a for loop to upload a list of data to google sheets. But sometimes the rows are overwritten by the next row. any help? I tried giving delays but didn't work
i faced same problem when using with chrome extension i fixed it will see for this
@@indianappguy hi, I started using the gsheets plugin and now it works fine..
Thanks but how I update a certain row? in your video you just add a new row, I am checking if the row contain certain id, if so I needed to update that same row with new array of data, how can I achieve that?
Will make a video on that
@@indianappguy We are waiting ansiously
Sir I am not able to fetch feedback, also mobile no is being printed inside feedback column
i have made a video recently have you seen it?
hey man,
how u r taking string in place of url
where?
Sir will the data of all users will be stored in this sheet (of your account)or would their data be stored in their own gsheet account
in this sheet of my account
Nice Work brother ! Just wanted to know i wanted to save data in more than one sheets .
How can I do that?
Create multiple APIs
Can i make for every send a own data
Hey, did you get how to implement this? Could you please share? @Fahad Sultan
Hi, good Video. So, I create on example using the same code, updating only address "static const String URL =" a and I received this error on runing App:FormatException: Unexpected character (at line 2, character 1)
I/flutter ( 8437): Could you help-me. Thanks.
HI, I resolved the problem. The problem configuration on sharing. After realize on first e after that alter, this modify not running in my case. I removed the share and set again. This problem was on share, The code on Flutter running well.
@Riteek Raj Hi. in my case, the problem was on google security, when I created the code on javascript on sheet, in moment of the share. solution: I removed sharing old on google and set again. I used in parameter of share: "Who has access to the app: " for Anyone ", after that I copied the link to flutter and running same the video. If not success, my email is gercilisboa@gmail.com. thank's. ps: Im brazilian and I learn English, sorry for errors in language. :)
@@gercilisboa3456 ola gerci, tambem sou brasileiro, como faço pra corrigir o erro?
@@gercilisboa3456 Tried, but no success! abhimanyu.naikare@gmail.com
Hi Sanskar,
Awesome tutorial. Kindly share source code also. cheers!
Already shared mate please check the pinned comment
Great Content.
Can u pl share how to upload say a photo or pdf to google drive via flutter.
Will upload soon Swarup, meanwhile make sure to like and share if you find the video helpful
Can you make a tutorial on how to import and export list data to excel file in flutter app using moor library
i will check
Good work👌👌👍👍
Can I call data from this sheet?
What do you mean?
@@indianappguy How do you query into Gsheets? Fetch particular data and display in an app?
@@neelparekh3448 making a video on this today 😉
First of all, thank you so much for this tutorial! I did everything same, when i press save data, i saw "success" on flutter but it does not write anything to table. I could not find, where is my mistake? :(
have you found the solution for this error?
the same
Hey Bro, Can you make video on CRUD operation with google sheet
Sure will do
Did u do a crud on google sheets that would be awesommmeeeeeeee !!!!!!!! Please share video if u did !!!!! Abdel@ualberta.ca
@@TheUofastudent sure
@@indianappguy It would be great !
hello, i did everything same and infact cloned your code from the github as well, but i am getting an exception , can anyone help me.
and nothing is being shown in spreadsheet, i tried everything but can't solve it, help will be appreciated.
this is the exception :
I/flutter (23770): FormatException: Unexpected character (at character 1)
I/flutter (23770):
Hi Mir Faisal
I'm also facing the same issue as you highlighted, Please let me know if you find any solution..
I'll also try it from my side... Thanks
When I export the app
The app stops working
Can you please help me
what error is it showing, i will try and let you know
Please help me, the app send me an error:
" The argument type 'String' can't be assigned to the parameter type 'Uri' "
it's the http package. just change to Uri.parse(your string url)
Thanks a lot Yasmin for helping
How to enable script editor in Google sheet
no need to enable just visit it via menu option
I created another field. But it can not be entered. can someone please help?
what are you struggling with?
When Publish the code, in the Project Version select new and next Update, always when you do a change in the code is necessary to save the Project like a new version.
If you try to write data to a google table in this way at a fast pace, then the data overwrites the lines. Thus, the data is lost. Is there a way to avoid this?
Yes I faced this and fixed this for one of my chrome extension
Will check for flutter
can you do a video to download any file from google drive ?
I can try
how to make employee management system app in flutter using excel
just use this and you can what are you missing?
how to reset the all fields after submitting the data?
Use edittext controller and set value to ""
@@indianappguy sir after clicking the botton all the date still on the textfield so i want after clicking the botton and sending the data to the spreadsheet to remove all the data on the textfield, to clear the all textfield
Increíble
Thanks
Hi, how to add offline support?
how exactly you want offline support to work?
@@indianappguy basically, People could use the app to add entries without an internet connection and whenever the phone gets connected to internet the spp sends the entry to googlesheet in the background.
I cannot see the mobile number .Where it gone?
I had the same problem, change the name of the row for Mobile, in the code change the name of the variable
var mobile = request.parameter.mobile;
and Publish, in the popup window select in the project version New, is necessary always when you add a change in the code save a new version, if you don't do that, the new entry data in the flutter app, does not appear in the Sheet document.
Tiwari ji Flutter + Wordpress par Videos bana do yaar..
Thik hai Mayank ji Bana dege
FormatException: Unexpected character (at character 1)
I/flutter (31111):
I/flutter (31111): ^
i have same problem
hey bro! i love your tutorials!
i tried to build by myself but im getting a error XMLHttpRequest error, and then i copy your code from git, and i get a success message but the data dosent show on the google sheet,
please help me with that...
thanks man and keep uploading videos :)
Can we get data from Google sheets?
Yes
@@indianappguy Please, make a video on it.
this._mobileNo, this._feedback
YOU REVERSED this 2
now i fix it but still have phone number not showing in the sheet
Hi. I solved this problem.
You try to change mobileNo to something else,
The important thing is to change the part defined by ?mobileNo_$mobileNo as well.
For reference, I changed from mobileNo to tel.
1. var tel = request.parameter.tel; // (on the google website apps script)
2. # save it and re publish again
3. String _tel; // (on the feedback_form.dark)
3. String toParams() => "?name=$_name&email=$_email&tel=$_tel&feedback=$_feedback";
@@TV-dz2pz yes i figured out thank you so much
Can someone help me? I/flutter (26721): FormatException: Unexpected character (at line 2, character 1)
I/flutter (26721):
I/flutter (26721): ^
hey , exact same problem if you guys find the solution please share
Have you guys resolved the issue
I am facing same issue
It's pretty simple to solve the issue. Just go to sheets and publish the app again. On project version just select New and thats it. Issue will be resolved
@@rajubhai1796 Not working still !
Hi, Can you please share source code also.
Check pinned comment
@@indianappguy no pinned comment
@@RNMERIA please shared it
source code please
please check the pinned comment
@@indianappguy Thank you sir
Hey man it is not working at all
what happened? i am building production applications with this its 100% working.
@@indianappguy lib/controller.dart:19:26: Error: The argument type 'String' can't be assigned to the parameter type 'Uri'.
'Uri' is from 'dart:core'.
await http.get(URL + feedbackForm.toParams()).then(
^
Failed to compile application.