???? flutter ???? to google sheets ????
a demo application which stores user feedback from flutter application into google sheets using google appscript.
you can try web version of this google sheets app here.
???? introduction
- google sheets is a very powerful tool ???? if we look into deep in it.
- it provides us interface using google appscript so that we can do various types of operations on google spreadsheet.
- we can perform all types of operations like reading/inserting/updating/deleting using appscript on google sheets. it’s so much powerful and capable that we can even use google sheets as a backend of our application ????.
- here we’ll develop a sample flutter application, which simply takes user user feedback, makes http request to google appscript and appscript then stores that feedback in google sheets.
this project is a starting point for a flutter application.
a few resources to get you started if this is your first flutter project:
for help getting started with flutter, view our online documentation, which offers tutorials, samples, guidance on mobile development, and a full api reference.
show some ❤️ and star the repo to support the project
⚡️ project files
- flutter application – flutter application code.
- appscript code – google appscript code to deploy as web app for interface between flutter app and google sheet.
what’s happening? ????
in flutter, when button is pressed, http get request is called on appscript url which retireves parameter from request and then appends row data in google sheets. thus, data from flutter in inserted into google sheets.
⚡️ results
you can run this app on web here
as you can see, in first image, when submit feedback button is clicked then that feedback is stored in google sheet as in second image. hurrah!???? thus we have successfully implemented google sheets with flutter.
