How to Create a Customer Database Using Google Forms and Google Sheets

This is a short video showing small business owners how to use Google Forms and Google Sheets to create an easy customer database to track client information. Visit blog.staylisted... for more helpful articles for local SEO and small business marketing.
Google Forms: www.google.com...
Original Video: • How to create a custom...

[@gwarbot]

I've been searching for 6 months for a more robust way to use Google Sheets, and you COMPLETELY solved the problem! Thank you so much - this is absolutely invaluable.

[@itsmejt9283]

Thank you so much! I've familiar with Google Sheets but I've never used it as CRM. The last thing you said encouraged me to use this instead of paying $100/mo for the CRM.

[@beckywaters1219]

You have made my day!! Been searching for a contact database that simple and customizable for quite awhile. Thank you so much for doing this.

[@michaelheffron3320]

Me too. Im setting an entry form /database for our local food pantry.

[@hveseli8743]

surprised how this quick and informative video hasn't reached millions of views yet

[@purnamalevlev2107]

You have made my day!! Been searching for a contact database that simple and customizable for quite awhile. Thank you so much

[@tammyv5319]

Perfect - thank you! As a Mac user we are limited on some of the popular database softwares and even paying $50 or less doesn't make sense if we just need a basic customer listing that we can sort and share with other gmail users for input too. Thank you!

[@heathercalder7222]

OMG, thank you soooo much for this video. The audio was very helpful. You just made my night. I have searched and searched for the right basic app for my small company with zero luck. I had no idea you could do this with google!

[@rrkajen]

here nothing talk about Database as what in Title..... This is normal Excel sheet link... you can see much about Database functions... thats totally different

[@ifunanyaonwuka3008]

The best video that explained it well🥰. Love from Nigeria 🇳🇬

[@nirakfaet]

I'm a virtual assistant and this is a blessing for me. It helped me. Thank you

[@wewon5795]

what a big help.this is just what i was looking for step by step. thank you very much

[@Staylisted]

I'm so happy our video was helpful!

[@ttamammi]

Thank you so much! This has been very helpful to me. I made 2 forms for a client while watching your video, step by step! Stay well Sarah :)

[@somethingbunting2799]

5:35 "Just Kidding" what a prankster.

[@gloriajanewren]

This is perfect. A new skill learnt. How do you add a follow on question to an existing question rather than add a whole new question? If customer ticks YES to question in Tick Box format and I want to add "if yes, please give details" - how do I do that?

[@on-pointmediatv838]

It can't be any easier than this. Thank you so very much

[@meganhanson9402]

Thanks for the video. I actually ended up getting someka's customer database tool for google sheets but It's been helpful nonetheless.

[@kaustavroy6623]

THANKS ALOT FOR THIS VIDEO.
You've made my life easier

[@evergladestours]

Thanks for this! Your video was clear and concise, unlike some other RUclipsrs 😒. 👍🏽👍🏽

[@OrlandoHomesToGo]

Thank you so much!!! You were extremely helpful and now I am just about done with my book keeping work book! Happy Thanksgiving!

[@PatrickSipperly]

Excellent video! I'll need to watch it again and do the steps, but you did a great job explaining things. Thank You!

[@devildogpete]

Very helpful and informative. Just what I was looking for. Thank you.

[@cheriehebert9134]

Thank you. I found this video to be extremely helpful:)

[@cotswoldsafety5749]

Excellent just what a small business needs. Many Thanks.

[@brujeriadiosa]

jhmfc wish i'd found this yesterday...happy day today. thank you!!

[@hslegacylogisticsllc3295]

Thank you . This was a big help for my small business

[@airiell1]

Great video. Thanks!

[@chiragdave6605]

Very Good Informative video

[@BustedLeaf]

Extremely useful information.

[@rissandthekids]

You explained it well and made it super easy for me . Thank you!

[@junktrunk6146]

super helpful thank you

[@MontyKReed]

NICE. thank you

[@danielalade9259]

Thank you so much!
If you have more thank one person that works at a company with different emails, phone etc is there a way to properly filter?

[@christiancambaya2294]

Very simple and helpful. I love it!

[@smeacraptor6641]

Very awesome video! The only problem i had is that when i wanted to move around the questions in the form in order they dont move in the spreadsheet! Any hints?

[@sblaize21]

When I use link it asks to login to Google. What if customer doesn't have Google account? If I use embed to website, will it also ask customers to sign in?

[@malulekeforget7274]

OMG this is amazing thanks for video

[@on-pointmediatv838]

Hi Staylisted, my question is can you save the form on your desktop without going online to use the form

[@bengkelhardware578]

Thank's it help acctually

[@lacee4839]

Thank you so much! This is just what I was looking for! You rock!

[@graghoul]

thank you so much

[@mdezuanahmed8735]

Thank You so much.This video is very helpful and easy to learn...

[@w0mblemania]

This was very useful. Thank you.

[@michaelheffron3320]

How do I add a counter at the top that shows how many entries?

[@limitlesstutorsa7477]

This is so great- Thank you!

[@jasmenmerida8838]

Thank you for this video. This was just what i was looking for!

[@Gizmomedia1]

Thank you for a great tutorial, very simple and informative!

[@oscarornelasvelasco4512]

Gracias

[@matthieuperring]

Exactly what I was looking for, thanks !

[@Staylisted]

You're welcome! I'm glad you found the video helpful :)

[@pedropicapiedras8471]

Thanks!

[@kigwahonz6339]

Thank you so much, it's really a big help for me. :) Your instructions was very clear

[@devanshuvaria1089]

If I have 100s of customer data. When I take followup to them in certain interval I want to record multiple discussion points at each interval. Kindly suggest how to create that kind of form

[@chrissykay3590]

Thank you Sarah! Very helpful!!

[@bharathigandhi8337]

Excellent video, helps to create database as we think...

[@404marc]

Awesome!

[@glowupquotes]

couldnt I just skip "forms" and go straight into sheets for adding?

[@user-bo8wj7lt1t]

Thanks ! Easy to understand n useful tips.

[@thomasrice8174]

Is this extension still around? This is exactly what I want to do.

[@guuday2all]

excellent! great help. Thanks

[@JunaidAhmed-ox2xd]

excellent, i just want to add validation on input, can we ? like DOB can't be of current year or name must not contain numeric values

[@AkinaMedia]

So helpful! Thank you!

[@Minkykiwi]

thank you for this, might be just what I'm looking for. I'd like to be able to add time stamped notes after each conversation with a customer, can I do this?

[@bloggermaheshwer6365]

EXCELLENT. BUT HOW TO RETRIEVE DATA OR SEARCH DATA WITH GOOGLE SHEETS FRONTEND?

[@icebucketchallenge881]

Thats possible with a web app. If you still interested please let me know to show how.

[@VishalGupta-mb3sp]

After submit . How can I get "another add data"

[@carmencbs1959]

Great question

[@aishwarya7412]

It is very helpful. Thank You!

[@marshallrapp452]

Awesome vid, thanks a lot!

[@zeninafarmsinc]

Is there a way for someone to use a query to see if they are already on the list?

[@staninjapan07]

Thank you.
Presumably I could use this to store information about my English teaching materials in order to run searches / queries when I want to use a specific worksheet, etc.?
I guess I might have to start with inputting data directly into a Google Sheet (the back-end / databse, as it were) first and then create a form later.
If I were able to, say, run a search for theme, content, activity style and level, I / a student would be able to check whether I have anything for numbers practice in the form of a money bingo game that is printable and suitable for 10-year-old.
If you (anyone) could give me a quick heads-up on where to begin, I could figure it out as I went along.
Thank you once again.

[@lindaclark1330]

This looks great, thankyou. Is there a way you can create something which other staff could use to search for a record that doesnt involve them seeing the whole spreadsheet it just returns the record(s) based on their search criteria

[@berchaunclark3967]

THANK YOU SO MUCH FOR THIS VIDEO!!!!

[@ThePcryns]

Nice video. Very helpfull.

[@Staylisted]

Thank you! I'm glad it helped :D

[@Red-Feather]

Can several devices i/p information?

[@shawntellwebb1336]

Hello, and thank you for this video. I have one question, How did you get the form to look like it's on one sheet or page? My "questions" are spaced from each other.

[@sophiemomanyi6610]

Thanks a lot. This was so helpful. am subscribing ASAP.

[@mohamedsobhi3739]

Thank you

[@soapandshinewindowcleaning39]

It does not work when I click responses the form comes up without the information in the boxes

[@zire79]

Really appreciate with the video. Was looking for something like that for awhile. One question, how do I link this to to another Google sheet? Sorry I'm quite new to Google sheet. Been using excel.

[@janetdeleorealtor3502]

Can you use this to make labels, as well? Thanks

[@arturogalindo261]

Mucha gracias.....thank you so much God Bless YOU!!

[@smaggies]

Thanks :)

[@donnadarcy489]

How did you add that spell check widget to your tool bar?

[@tmd52398]

how would I use this for a client data updateable form say to keep records everytime they visit?

[@Staylisted]

Hi TMD - Since this form is pretty simple, you'd have to update the Google Sheets directly for existing client updates.

[@jstudios1946]

How do you find a customer or sort them by name if you start populating hundreds of them in?

[@goingbacktoourroots]

Do you know how to add a formula that will identify duplicate phone numbers? I contact a HIGH level of home owners I'd love to be able to quickly see if I have already saved them on the leads form

[@pedrohenriquedacunhaferrei9243]

U are awesome, i wish u the best !!! it will help me a lot

[@Staylisted]

Thanks! I'm glad it was helpful :)

[@jessejames4444]

Good video, very usefull thank you.

[@akokohjoel9854]

Does it allow multiple users

[@andrewrabbetts8034]

Hi. I would like to use this form to enter data myself rather than asking my customers. Is this possible? I unchecked the "Limit to 1 response" box but after filling in the form and clicking "Edit your response" the new data I entered in the form had overwritten the previous entry

[@claudiologullo2879]

is there a way to receive a notification when someone fills out the sheet?

[@woodybernardi2505]

Hello thank you for your video. I wonder if you could answer a question for me. I'm with a small nonprofit and we host an annual convention. We have a website in which attendees can purchase their membership to our con. Could we provide a form for them to fill out directly which will put their info directly into our Google Docs database?

[@medmeed4590]

THANKS

[@TranquillityInFlames]

thanks for sharing sister

[@VenkatMadhesan]

Hi how to add shop working hours in this?

[@JoeMac1983]

YOU ROCK!

[@pankajjoshi8292]

hw to create user id passwrd using google sheet

[@Red-Feather]

How do you spell bu’n?

[@mohamedrefai559]

Thsnk u so much

[@jeanjamil7891]

Hi tnx a lot, but how can we know capacity of this database

[@Staylisted]

Because it's using Google Sheets, you can have an unlimited number of rows, however, it's limited to 5 million cells. So that'll include the columns as well.

[@milagrosmuniz-amill3511]

Exactly want I wanted

[@brentthailand5742]

Thanks 🕺🕺👍👍

[@rosbyduhart5884]

What about in Pet grooming someone with multible dogs?

[@Staylisted]

Hi Rosby - I'd suggest creating the client file by the dogs name, instead of the humans. That way you can have something like Fluffy Smith, Rocky Smith, Max Smith and then have the fields directly related to each animals cuts and preferences.
Otherwise you can do it by the human's name and then have additional pet fields. For example: Name, Phone, Address, Email, Pet 1 Name, Pet 1 Breed, Pet 2 Name, Pet 2 Breed, etc.