Let's build best accounting software with Google Sheets and Apps Script

Welcome,

Let's build the best accounting software with Google Sheets and Apps Script.

Why do you need to purchase an expensive accounting software when you can build it yourselves?

In this video, we are going to build an expenses and revenues tracker with Profit & Loss statement, and graphs and visualizations using Data Studio.

By the end of this video, you will be able to
1. Build websites and web apps using Apps Script
2. Build forms
3. Link Google Sheets to the web app
4. Submit form data to Google Sheets
5. Setup form drop downs with data from Google Sheets
6. Create multi-page web app with navigation using Apps Script
7. Setup custom HTML components with the include(filename) function
8. Use SpreadsheetApp service from Apps Script
9. Setup Google Auth and get users' email Ids
10. Create visualizations using Data Studio

Chapters
00:00 Introduction: Demo
04:23 Getting started: Setup the project and your first page
07:45 Making multi-page: Setting up your second page
10:57 Creating Header: Add Tailwind CSS and setup the navigation
17:06 Creating Header: Adding include(filename) function to add custom HTML components
19:47 Creating Header: Adding hyperlinks with short URLs for navigation
24:30 Building the form: Setting up the labels and input fields
31:57 Building the form: Styling with Tailwind CSS
47:42 Building the form: Setting up the submit and reset buttons
50:50 Building the form: Setting up the form validation
52:39 Preparing for form submission: Create and prepare a Google Sheet
58:36 Preparing for form submission: Linking the Google Sheet
59:10 Preparing for form submission: Creating drop downs based on the data from the Sheet
01:15:34 Preparing for form submission: Preventing page reload on form submission
01:18:18 Preparing for form submission: Submitting data to the sheet on form submission
01:34:15 Formatting the data: Applying VLOOKUP and Array formula for Amount calculations
01:47:04 Formatting the data: Adding VLOOKUP and Array formula formulas to the script
02:06:00 Data Studio: Setting up the project and linking the datasheet
02:07:00 Data Studio: Creating pie and area charts
02:13:14 Data Studio: Creating a Pivot table for Profit & Loss summary
02:18:14 Data Studio: Creating new page for pie chart and transactions table summary
02:30:48 Data Studio: Embedding the project to the dashboard page in the web app
02:37:24 Publishing the production version
02:39:38 Conclusion

You may try the web app here - https://rebrand.ly/fsythome and write to us if you need the source code.

Get our games and related assets
itch.io - https://shepherdgames.itch.io
Codester - https://www.codester.com/sudeep98/shop
Construct - https://www.construct.net/en/game-assets/users/shepherdgames-152200
Gamedevmarket - https://www.gamedevmarket.net/member/shepherd-games/

You may contact us for any game development requirements or support for any game of our assets or any help with Construct 3 game logics
Email - contact@shepherd.games
Discord - https://discord.gg/WrMwKKEaUn
Website - https://www.shepherd.games

Follow us
Facebook - https://www.facebook.com/shepherdgames
Twitter - https://twitter.com/_shepherdgames
Pinterest - https://in.pinterest.com/shepherdgames
Instagram - https://www.instagram.com/shepherdgames
Twitch - https://www.twitch.tv/shepherdgames1

Support us
Paypal - https://paypal.me/shepherdgame
Patreon - https://www.patreon.com/shepherdgames
BuyMeACoffee - https://www.buymeacoffee.com/shepherdgames

#accountingsoftware #appsscript #googlesheetstutorial