Nowadays, we have access to an abundance of data that can aid us in decision-making. Website data is a particularly accessible and cost-effective source, provided that we utilize appropriate data collection techniques and tools. Google Sheets is one such tool that can be used for free. In this article, I will demonstrate how you can … Read more
In this blog, we have discussed several methods that you can use to create Google Maps from Google Sheets data. In this post, let’s see how we can generate Google Maps in Google Sheets. In this post, I am going to use Google Apps Script to create the map image inside the Google Sheets. You … Read more
Cryptocurrency prices are susceptible to news information. Therefore, getting the right news around the crypto world is particularly important for crypto traders. However, it is not possible for you to find and read all such news as soon as they are published. As such, it is more beneficial to create your own news feed that … Read more
We use data from various sources for our data analysis works. In previous posts, we discussed how to import data from one Google Sheets to another, one sheet (tab) to another sheet(tab), and Import CSV files to Google Sheets. In this post, I will show you several methods to import data from website to Google … Read more
This post will show you how to create a Crypto Portfolio Tracker in Google Sheets. With this Google Sheet, you can track your cryptocurrency purchases. And also, you can view a summary of your total assets with the Dollar Cost Average (DCA) for each cryptocurrency. In addition to that, you can get the present value … Read more
We have created a number of Google Apps Script Web Apps that can be used for data collection purposes in our previous blog posts. We included several types of form controls in those web apps, such as text fields, dropdowns, radio buttons, etc… This blog post will show you how to create a web app … Read more
In previous tutorials, we created some Web Apps with Google Apps Script and Google Sheets. This post will show you how to embed Google Apps Script Web Apps in Websites. In this post, I am not going to show how to build Webs Apps. I will show you how to embed an already made Web … Read more
You can create a button in Google Sheets to run Apps Script from its user interface. The button is essential when you design Google Sheets for others who do not know App Scripts. This post will show you how you can create a button in Google Sheets and attach the Google Apps Script function to … Read more
You can build several types of Web Apps using Google Sheets Apps Script. In previous posts, we discussed creating several types of online data entry forms using Google Apps Scripts. This post will show you how to pull data from Google Sheets to HTML table and display it in a Web app created with Google … Read more
In previous tutorials, we talked about building web apps to interact with Google Sheets using Google Apps Script. When you build those types of web apps, you may need to implement a search field to get data from Google Sheets back. This tutorial will show you how you can create a web form to search … Read more
