Free AI web copilot to create summaries, insights and extended knowledge, download it at here

1847

Abstract

easy to use. All of us saw excel sheets at some point in our lives. And here is the best part — any decent app offers an integration with Google products. So, maybe, just maybe, you don’t even need a developer to start collecting data from your vendors, or create a simple contacts database that can be embedded in your CRM.</p><h2 id="d797">Google Forms</h2><p id="f556">It all starts with <a href="https://www.google.com/forms/about/">Google Forms </a>where you can use a drag and drop builder to create a form for data entry or a survey. Those forms are easy to share and embed on almost any third-party website. They are lightweight, customizable, and just easy to work with.</p><figure id="5e65"><img src="https://cdn-images-1.readmedium.com/v2/resize:fit:800/1*4ByT335dOejVUI5G71tyMw.png"><figcaption></figcaption></figure><p id="b623">For this example, I chose the Contact Information template. My plan is to create a simple form for data entry and embed it on my hypothetical intranet website. The idea is to allow employees to enter the contact information of people they work with. But where do we store all this data? Here is where <a href="https://www.google.com/sheets/about/">Google Sheets</a> come into play.</p><h2 id="e1eb">Google Sheets</h2><p id="5c80">Once my form is ready, I move to the second tab called Responses and add a source for this form. I can connect a new spreadsheet that has all the columns defined automatically (they will match the names of the fields in my form). The sheet will be populated automatically.</p><figure id="17d9"><img src="https://cdn-images-1.readmedium.com/v2/resize:fit:800/1*3qsRhHD7hYWVs5VKC2yijw.png"><figcaption></figcaption></figure><figure id="4eb9"><img src="https://cdn-images-1.readmedium.com/v2/resize:fit:800/1*yOKcgU4J7y8J2Z5upwgpaQ.png"><figcaption></figcaption></figure><p id="

Options

e2ef">And just like that, I have a new spreadsheet that will keep all entered information from the form in one place. Now, everything is neatly organized and easily searchable. If I want, I can add more forms in the future that point to the same sheet or create a new sheet for each new form.</p><figure id="1482"><img src="https://cdn-images-1.readmedium.com/v2/resize:fit:800/1*naCwfvtuQc5WMpTNjirTLQ.png"><figcaption></figcaption></figure><p id="9b42">I can also share this spreadsheet with others or, to take it even further, use Sheets API to display this data in any way I like on my Intranet website. And my client-facing website. Anywhere, actually.</p><div id="658a" class="link-block"> <a href="https://developers.google.com/sheets/api"> <div> <div> <h2>Sheets API | Google Developers</h2> <div><h3>The Google Sheets API lets you read, write, and format Google Sheets data with your preferred programming language…</h3></div> <div><p>developers.google.com</p></div> </div> <div> <div style="background-image: url(https://miro.readmedium.com/v2/resize:fit:320/0*JfkvTo8HOGQPyxsY)"></div> </div> </div> </a> </div><h2 id="6517">Google Analytics</h2><p id="1afb"><a href="https://analytics.google.com/">Google Analytics</a> is the final and optional piece of this simple puzzle. In this example, I don’t really need to track who entered what, but I can think of many other use cases where analytics is needed. Google Analytics is a real powerhouse and it integrates with Google Forms easily. If you use Google Forms to collect feedback from your clients or to hire people, for example, you’ll benefit from having nice charts and more in-depth data.</p></article></body>