Creating a Flutter App with a Google Sheets Database

Are you looking to build a Flutter app with a simple, cost-effective, and easy-to-use database? Look no further than Google Sheets! In this tutorial, I will show you how to create a custom API to connect a Flutter app to a Google Sheets database, allowing you to store and retrieve data from your app.

I'll start by explaining the basics of using Google Sheets as a database for your Flutter app. Then, I'll walk you through how to set up a custom API using Google Apps Script and connect it to your Flutter app using HTTP requests.

By the end of this tutorial, you'll have a fully functional Flutter app connected to a Google Sheets database, giving you a powerful and flexible solution for storing and managing data for your app.

Whether you're a beginner or an experienced app developer, this tutorial is perfect for anyone looking to build a Flutter app with a simple and easy-to-use database solution. So, grab your favorite beverage and join us in this exciting journey of building a Flutter app with a Google Sheets database!

#FlutterAppDevelopment #GoogleSheetsAPI #CustomAPI

🕑Timestamps
________________
0:00 Introduction
0:10 Setting up Database
3:17 Writing Apps Script
6:33 Deploying our Web App (API)
7:48 Coding our App
14:47 Updating our Data
15:39 Outro

||||||||||||||| 233% ||||||||||||||| 4.66K/2K

Most recent subscriber: jtcdarkstar darkstar

[alessandroscimone]

yessss!! This is very useful! Thank you!

[adamen]

How did I not know about Apps Script before this video? Thanks so much this is gamechanger <3 <3

[mohamadalbakour]

Thank You very Match. شكرا جزيلا لك على كل المعلومات الرائعة

[tacowaco]

Thank you. This must have taken a lot of work to prepare.

[jrnight]

Hey i've just found your channel and this video is so useful and understandable, i'm in the middle of my project using data from microcontroller ESP to send into google sheet then into flutter app that like google map to show information from ESP but yeah i guess the map is kinda the hard part to me .Anyway thank you for your explaniation it helping me out.

[JoshComninellis]

Does this same or similar process work for using Google Sheets as a for Flutterflow

[jedas]

You find a better way than Google API v4

[b_rabbit]

What if the app has a lot of users how to set the app to save the data on users google sheets account?

[fedimakni]

Thank you very much for the video.
I have 2 questions if possible:
- i am a beginner to flutter, where's the function doGet you wrote in apps script mentioned in flutter code?
-Other than getting the data, can we also send data to google sheet?
May i ask if you can tell us the steps (no need to be in detail just the big lines) should i add a set function to apps script first and then call it in flutter but i return to my first question about the location of get function in flutter code.

[abdullahflutter]

hello can i send you something and you can tell me how to fix
it is an error but i don't know how to fix

[swatirawat]

Unfortunately google no longer allows the api to deploy
It blocks the deployment everytime showing 'This app tried to access sensitive info in your Google Account. To keep your account safe, Google blocked this access.'

[informativeinformations]

Block chain(from scratch) with flutter please

[naveensinghkhatri]

Can you not just prompt ChatGPT to give you step by step instructions on how to do what you want to do? 😂

[abdullahflutter]

this is a sign in screen but the erro is when i added the image the buttons are not in the bottom screen anymore :


import

class SigninScreen extends StatelessWidget {
const SigninScreen({Key? key}) : super(key: key);

@override
Widget build(BuildContext context) {
return Scaffold(
body: Stack(
alignment: Alignment.bottomCenter,
children: [
Image.asset(
'images/veg.png',
),
Positioned(
bottom: 130,
child: SizedBox(
width: 300,
height: 65,
child: ElevatedButton(
onPressed: () {},
child: Row(
mainAxisAlignment: MainAxisAlignment.center,
children: [
Icon(Icons.telegram, color: Colors.white),
SizedBox(width: 8),
Text('Sign in with Telegram', style: TextStyle(fontSize: 20)),
],
),
style: ElevatedButton.styleFrom(
backgroundColor: Colors.blue[700],
shape: RoundedRectangleBorder(
borderRadius: BorderRadius.circular(30),
),
),
),
),
),
Positioned(
bottom: 50,
child: SizedBox(
width: 300,
height: 65,
child: ElevatedButton(
onPressed: () {},
child: Row(
mainAxisAlignment: MainAxisAlignment.center,
children: [
Icon(Icons.facebook, color: Colors.white),
SizedBox(width: 8),
Text('Sign in with Facebook', style: TextStyle(fontSize: 20)),
],
),
style: ElevatedButton.styleFrom(
backgroundColor: Colors.blue[900],
shape: RoundedRectangleBorder(
borderRadius: BorderRadius.circular(30),
),
),
),
),
),
],
),
);
}
}