A Demo application📱 which stores User feedback from 💙Flutter application into Google Sheets🗎 using Google AppScript.

Last update: Dec 28, 2022

Overview

📱 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 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.
In other screen, we'll show feedback responses fetched from Google sheets into the List.

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 submit button is pressed, HTTP POST 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. When GET request is sent to the same URL, it returns the List of feedback responses.

⚡️ Results

You can run this app on web here

Main Feedback Form	Feedback Responses List

Google Sheet Preview::

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.

❤️ Found this project useful?

If you found this project useful, then please consider giving it a ⭐ on Github and sharing it with your friends via social media.

Sharing is Caring!

Connect With Me

If you want to contact me, feel free to reach me… Visit My Profile.

Comments

Changed HTTP GET to be HTTP POST

Hi Team, I see in your code that's you used HTTP GET for save data to Google Sheet. So, I think it's better if you used HTTP POST. Please check my code and test it.

Thanks.

opened by CoderJava 8
Insert data used HTTP POST

Hi Team, I see in your Flutter code you used HTTP GET for send data to Google Sheet. Can you tell me why you use it and why you not used HTTP POST for send data?

https://github.com/PatilShreyas/Flutter2GoogleSheets-Demo/blob/15a2dad7842d2b5ededfc200b70b51d787ec303c/lib/controller/form_controller.dart#L24

Thanks.

opened by CoderJava 4
exec script

first thank you so much for sharing this useful Flutter2GoogleSheet, it's really interesting and i have learn new tool from this. However, in form_controller.dart there is a string of URL "https://script.google.com/macros/s/AKfycbyAaNh-1JK5pSrUnJ34Scp3889mTMuFI86DkDp42EkWiSOOycE/exec"; and i am not sure where can we define it in google script? thanks in advance

opened by sovathchhinh 1
[ImgBot] Optimize images

Beep boop. Your images are optimized!

Your image file size has been reduced by 23% 🎉

Details

| File | Before | After | Percent reduction | |:--|:--|:--|:--| | /images/banner.png | 32.07kb | 24.83kb | 22.58% |

📝docs | :octocat: repo | 🙋issues | 🏅swag | 🏪marketplace

opened by imgbot[bot] 0

"Login Demo" app which shows how to use google sign in Android and iOS using Flutter.

⚠️ ARCHIVED: This repository is using Flutter 1.7 for the sample app. You can find the latest version of the similar implementation on this new repo.

Dec 2, 2022

Tasawq App — Flutter framework and Firebase An application that objectives to display all nearby stores of all kinds and real estate.

Tasawq App — Flutter framework and Firebase An application that objectives to display all nearby stores of all kinds and real estate. Multi-vendor, standard user login to view nearby products and stores for rating, follow-up, messaging and more

Nov 10, 2022

WooCommerce App template that uses Flutter. Integrated to work with WooCommerce stores, connect and create an IOS and Android app from Flutter for IOS and Android

WooCommerce App: Label StoreMax Label StoreMax - v5.3.1 Official WooSignal WooCommerce App About Label StoreMax Label StoreMax is an App Template for

Jan 9, 2023

[Flutter package] An easy and quick way to check if the local app is updated with the same version in their respective stores (Play Store / Apple Store ).

Retrieve version and url for local app update against store app Android and iOS Features Using as reference packages like in_app_update , version_chec

Nov 9, 2022

Cell-phone - App to offer cell phone stores, operation with static data, login, registration, cell phone list, add to cart, cart counter

cell_phone App to offer cell phone stores, operation with static data, login, re

Feb 13, 2022

A Demo application📱 which stores User feedback from 💙Flutter application into Google Sheets🗎 using Google AppScript.

Related tags

Overview

📱 Flutter 💙 to Google Sheets 📊

You can try Web version of this app here.

💡 Introduction

Show some ❤️ and star the repo to support the project

⚡️ Project Files

What's Happening? 🤔

⚡️ Results

❤️ Found this project useful?

Connect With Me

You might also like...

"Login Demo" app which shows how to use google sign in Android and iOS using Flutter.

Tasawq App — Flutter framework and Firebase An application that objectives to display all nearby stores of all kinds and real estate.

WooCommerce App template that uses Flutter. Integrated to work with WooCommerce stores, connect and create an IOS and Android app from Flutter for IOS and Android

[Flutter package] An easy and quick way to check if the local app is updated with the same version in their respective stores (Play Store / Apple Store ).

Cell-phone - App to offer cell phone stores, operation with static data, login, registration, cell phone list, add to cart, cart counter

Web3-demo-flutter - A demo for the flutter web3 library.

Flutter RSS feed parsing - A demo application of flutter which parse RSS XML contents to the flutter application

Easy to use text widget for Flutter apps, which converts inlined urls into working, clickable links

A Flutter ListView in which items can be grouped into sections.

Comments

Changed HTTP GET to be HTTP POST

Insert data used HTTP POST

exec script

[ImgBot] Optimize images

Beep boop. Your images are optimized!

Owner

Shreyas Patil

Demo app with continuous integration setup for auto across android/iOS app stores

Its a food delivery application that user can buy food , using this application user can see the restaurants near to there location and far from them also. And this application provides easy interface that user can easily use this application for purchases.

ToDo App made with flutter which stores your todos based on their categories. The data is stored in external application storage in your device in JSON file.

A Very Flexible Widget that can Implement Material Sheets on all Directions, both modal and persistent, and consequently a Material Navigation Drawer

Functioning Doctor/Healthcare Catalog App created using Dart with Flutter. Stores and loads data from Firebase Firestore DB.

Gaimon - A Flutter plugin to fully support Haptic feedback with custom pattern

A flutter plugin about qr code or bar code scan , it can scan from file、url、memory and camera qr code or bar code .Welcome to feedback your issue.

A flutter plugin for device vibration and haptic feedback.

A simple widget for getting better feedback.

Generate secure passwords, check for exposed passwords, get visual feedback for password strength or get form validation with a minimum password strength required.