No-Code Wiki (🚧BETA):
Google Sheets Review

Google Sheets how to use no code

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.

michael novotny and no code to make and launch a side project

Forward by Maker: Michael Novotny

Pros and Cons of Google Sheets

Positives

Negatives

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 nocode

Google Sheets Tutorials

Getting started: starting with the basics

Coming Soon
google sheets nocode

Google Sheets Tutorials

Getting started: starting with the basics

Coming Soon

Google Sheets No-code Templates

Templates coming soon…

Google Sheets Experts

Glide Expert Amit

Amit Sarda

Google Sheets Expert

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.

ryann.ashers

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

hey marketers a no-code job board

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

no code maker whit

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

Sharath of requestforproduct uses no code to make and launch a project

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

jesus no code

Web App

What advantage will this stack give you? Perfect list feature and functionality on display.

Side Project Stack

michael novotny and no code to make and launch a side project

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

robert petitto glide nocode expert

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

no code maker kurty kurt

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

no code maker naz

Web App 

What advantage will this stack give you? A complex stack that integrates with Twitter. This stack is unique. Connect with this Maker on twitter to get insights on building with Twitter.

Side Project Stack

modernday jobs

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

david ceo glide apps

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

no code maker kurty kurt

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

julia lipton nocode

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.

Mohammad Naz of argumeter uses no code to make and launch a project

Web App

Side Project Stack

Best place to find this Maker:

Twitter  

What can you do with this?

Use Twitter as a service to provide an easier search experience. This is a prototype done with Twitter.

Twitter Argumeter is a tool that lets you find out how much Twitter users like to argue and creates a Argumetere profile.  

Project link: Twitter ArguMeter

Read Mohammad’s Full Interview

Stack Notes Using Google Sheets

Why this tool helped

1. It is the most convenient tool to use as a Database and you can share access with selected Database Administrators in a jiffy.

What was challenging

An Airtable like “Lookup” field to link multiple tables would have made it even more powerful as a database. 

no code maker whit

Web App 

What advantage will this stack give you?

Read Whit’s Full Interview

+Google Sheets – Default that typeform sends to. I like it. Free.

+Don’t get to fancy with databases if you don’t have to

kp maker of cuppa

Web App 

What advantage will this stack give you?

Read KP’s Full Interview

+ 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. 

no code maker sharath

Web App 

What advantage will this stack give you?

Read Sharath’s Full Interview

+ 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. 

no code maker corey haines

Web App 

What advantage will this stack give you?

Read Corey’s Full Interview

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.)