No-Code Wiki (
BETA):
Google Sheets Review
Get Real, Honest Maker Commentary
Google Sheets is my go to for any no-code project. Because it is a spreadsheet with an API hooked in, it is super simple to connect forms, other tools as well as serve as a conduit back to whatever output you are generating to the user. I use it as a database. However, it is not as functional as Airtable and below in the Pros and Cons I highlight why.
Google Sheets is free, easy to use, most familiar to use, friendly API, most responsive API that cannot be beat (when connecting to Zapier it responds the fastest between Zaps/workflows). For what google sheets lacks in what Airtable can do, it provides faster workflows.
One critical area that Google Sheets lacks in is the ability to update an existing row with a formula in it. To my knowledge it is not possible to set up several different formulas in google sheets in a column prior to adding information from a form. Airtable is superior in this regard. Depending on what you need done, I’d recommend google sheets. When I created a the no code tool generator I failed to create it with google sheets and used Airtable successfully.Â
Below are some of the best no code actual applications created by some insanely talented Makers who launched using Google Sheets as part of the side project stack.
Pros and Cons of Google Sheets
Positives
- Familiarity because its a spreadsheet at its core
- Allows the more complex type of formulas like a spreadsheet. Compared to Airtable which is quite limited on complex formulas.
- Easy to plug into Zapier and connect to other applications
- Insane fast responsiveness for most workflows. When plugging into Zapier, what I learned that is most interesting is that google sheets will usually automatically trigger to send and receive information that I have had a Zap connected to. Many other apps don’t do this and this in fact is where Zapier up-sells you into higher price range so that the triggers happen faster.
- Some apps like Typeform connect automatically to Google Sheets without cost. Take advantage of this so that you do not take up limited amount of Zaps within your Zapier account
Negatives
- Really is a poor mans database. What I dislike most about google sheets compared to Airtable is that it is very limiting for adding any type of formulas to incoming data rows. Meaning say if you connected Zapier to send some type of information. When that information gets inserted into a google sheet row, the formula you may have in that row will not get applied. That is the value of Airtable, and a key functionality that google sheets is missing.
Where to Start?
If you want to build a project without code, what tools should use? I've created a free tool to save you days and weeks by not building with the wrong tools.
Each recommendation is based off the hundreds of data points from actual projects made with no-code. Try for free. Save your time and effort by not building with the wrong tools.
No-Code "How To" Tutorials and Resources
Google Sheets No-code Templates
Templates coming soon…
Google Sheets Experts
Makers and Their Products Using Google Sheets
Use this list of Makers to find project inspiration and see what they used to make something without using code.
Would you like to add your no-code project?
Add it here and we will highlight to our growing community of 1500+ Makers.
Web App
What advantage will this stack give you? There is no quicker way to launch an mobile-optimized app idea than using Glide. Insanely low learning curve and has a well-integrated mapping and form feature.
Side Project Stack
Job Board
What advantage will this stack give you? This stack enables you to have the flexibility to build a customized web page through Webflow but also a dynamic filtering job board within the page.Â
Side Project Stack
Web AppÂ
What advantage will this stack give you? Recommended stack to quickly build an eCommerce solution that may be unique to a standard online store.
Side Project Stack
Web App
What advantage will this stack give you? Uses a less common feature of copy this app so that users can have their own personal working application.Â
Side Project Stack
Web App
What advantage will this stack give you? Perfect list feature and functionality on display.
Side Project Stack
Web App
What advantage will this stack give you? Uses the map feature to create impact and greater engagement for the user. Easily allows a user to add to the movement.
Side Project Stack
Web App
What advantage will this stack give you? Great example of creating a habit forming product that repeatedly engages users to return. Excellent app to learn from how Robert thought about integrating this into the core function of his app.
Side Project Stack
Web App
What advantage will this stack give you? Check out this example of integrating with a calendar into the Glide app.
Side Project Stack
Web App
What advantage will this stack give you? The simplicity of this stack used for reducing the time from concept to actual working product. But also the innovation to incorporate Glide on the desktop view of the homepage helps the user engage deeper.Â
Side Project Stack
Web App
What advantage will this stack give you? There is no quicker way to launch an mobile-optimized app idea than using Glide. Insanely low learning curve and has a well-integrated mapping and form feature.
Side Project Stack
Web App
What advantage will this stack give you? Check out this example of using the Glide map feature to engage and help the user find something local.
Side Project Stack
Web App
What advantage will this stack give you? There is no quicker way to launch an mobile-optimized app idea than using Glide. Insanely low learning curve and has a well-integrated mapping and form feature.
Side Project Stack
Makers and Their Products Using Google Sheets
Use this list of Makers to find project inspiration and see what they used to make something without using code.
Would you like to add your no-code project?
Add it here and we will highlight to our growing community of 1500+ Makers.
"In Their Words" No Code Maker Commentary and Reviews
Use this list of Makers to find how this tool helped them make something without code. In their words.
Web App
Side Project Stack
Web AppÂ
What advantage will this stack give you?
+Google Sheets – Default that typeform sends to. I like it. Free.
+Don’t get to fancy with databases if you don’t have to
Web AppÂ
What advantage will this stack give you?
+Â I mean, much better than Excel. Can build pretty fun things on top of it.Â
+Â I prefer Airtable but had to learn how to fully leverage it. Sheets was my go-to just as it was very user friendly. But ultimately Airtable wins because of their forms and API friendly-ness.
–Â Not many really. Could be awesome like Airtable and add a bit of visual elements to the tables.Â
Web AppÂ
What advantage will this stack give you?
+ I used sheets when I’m working on Glide. I used it for macro formula while building OneDial. (Advice) Learn a lot of shortcuts that boosts your productivity. Â
– It’s still not intuitive. I need to learn all the shortcut via google. It would be nice to have them in the platform.Â
–Â Not many really. Could be awesome like Airtable and add a bit of visual elements to the tables.Â
Web AppÂ
What advantage will this stack give you?
Corey’s project is an online job board for marketers.Â
+ Corey used Google Sheets as the back end which means it acts as a database for all the job posts submitted to HeyMarketers.com. Corey has Typeform send to Google Sheets (Typeform does have some API integrations like this) and then using Zapier to send from Google Sheets to Webflow CMS which acts as a second backend database. Webflow CMS then displays this automatically into the display for the user. (Notes are translated from interview.)
+ Google sheets is free, and is very familiar for most folks to work with. If you have not used Airtable, for a project like this go with what you are familiar with. Google sheets has a lower learning curve. (Notes are translated from interview.)
