No Code Wiki(BETA): Google Sheets Review
What You Need To Know
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
No Code "How To" Tutorials and Resources
☹️ No Templates have been added yet…👎🏼
Hi,. Have you used a bada$ helpful tutorial for Google Sheets? Our mission is Makers helping other Makers. Would you consider adding one to this wiki? Add it in the chat bubble and get your name and Twitter handle added to the wiki as a contributor.
No Code Templates
☹️ No Templates have been added yet…👎🏼
Do you have any templates that you have found insanely helpful? Would you consider helping our mission and adding one to this wiki? Drop it in the chat bubble .
Makers Using Google Sheets In Their Side Project Stack
See Full Stack
👀 Add Your Name
👩🏻💻Your No Code Stack
I’d like to invite you to add your stack and be featured on the wiki and newsletter. Contribute to the community if you’d like.
Do you want to be No Code Wiki famous? Open the chat to contribute your project to the no code wiki .
"In Their Words" No Code Maker Commentary and Reviews
+ 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.
+ 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.
+ It is the most convenient tool to use as a Database and you can share access with selected Database Administrators in a jiffy.
– An Airtable like “Lookup” field to link multiple tables would have made it even more powerful as a database.
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.)