Premium Only Content

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
-
2:38:46
GamerGril
4 hours agoBingo With Doom Gal | Finishing The DLC | Doom Eternal
4411 -
LIVE
MDGgamin
8 hours ago🔴LIVE - Red Dead Redemption 2 - Wake Up Pray Up & Obama Treason? - #RumbleTakeover
72 watching -
1:07:58
Sarah Westall
2 hours agoThe Discipline of Remote Viewing: Shroud of Turin, Surface of Mars & the Unknown w/ Daz Smith & Team
13.1K3 -
17:37
Colion Noir
4 hours agoGavin Newsom Gifted A Gun On Shawn Ryan Podcast, Claims He's Not Anti-Gun
17.3K32 -
LIVE
yellow_1ron
1 hour agoALAN WAKE 2 | SCARY GAME TIME | JOIN!
21 watching -
LIVE
OhHiMark1776
4 hours ago🟢 07-20-25 ||||| Baldur's Gate 3 with the Skwaaa ||||| Baldur's Gate 3 (2023)
58 watching -
31:37
The Rad Factory
1 day ago $13.21 earnedTesting $300 Amazon Supercharger: Will It Blow??
43.7K13 -
22:02
Mrgunsngear
21 hours ago $11.65 earnedHeckler & Koch Full Size VP9A1 F Review: The Best Striker Fired Duty Handgun?
38.1K20 -
1:25:18
Jeff Ahern
4 hours ago $7.44 earnedThe Sunday Show with Jeff Ahern
29.1K7 -
LIVE
Spartan
5 hours agoSpartan - Pro Halo Player for OMiT | Scrims vs C9 then ranked
160 watching