WeirdGeek

Data Science | Machine Learning | Automation

  • Data Analytics
  • Python
  • Data Science
  • Google Apps Script
  • Machine Learning
  • Artificial Intelligence
  • SQL Server

13/03/2021 By WeirdGeek Leave a Comment

Get Latitude and Longitude using Google Apps script

In this we will see how we can get latitude and longitude of a location using Google Apps Script. I was working on a use case where i was trying to link Charts created in Google sheet with Google slide such that the charts gets updated automatically when the data in the sheet changed. But […]

Filed Under: Google Apps Script Tagged With: Google Apps Script

05/05/2020 By WeirdGeek 2 Comments

Find and Replace in Google Apps Script

Here in this post we will see how we can create a find and replace function in Google apps script. This function will find a particular searched string or value and replace it with the desired value. Google Apps Script code : Let’ see how code for Find and Replace works in Google Apps Script. […]

Filed Under: Google Apps Script Tagged With: Google, Google Apps Script, Google Sheets

10/03/2020 By WeirdGeek Leave a Comment

Getting Spreadsheet creation and modification date using GAS

When you are working as an Analyst, your main part of the job is to create reports with important KPI which help business to understand in detail about how their business is performing. Also performing automation or creating automated reports are one more task. While working and automating Google Spreadsheet, you have come across a […]

Filed Under: Google Apps Script Tagged With: GAS, Google, Google Apps Script, Google Drive, Google Sheets

08/03/2020 By WeirdGeek Leave a Comment

Navigate from one Google Sheet to another using GAS

When you are building a toolkit or a dashboard in Google sheets you have came across a situation where you want to navigate from one google sheet to another on a button click. Here in this post we will see how you can navigate or move from one google sheet to another using Google Apps […]

Filed Under: Google Apps Script Tagged With: GAS, Google Apps Script, Google Sheets

14/01/2020 By WeirdGeek Leave a Comment

Google Apps Script to search a string in Google Sheet [Part II]

In our last post we have seen how we can use Google Apps Script to search a string in Google Sheet and add n number of rows just after the row in which the string was found. But there is one issues : which is that it won’t loop over all the items that matches […]

Filed Under: Artificial Intelligence Tagged With: Automation, Google, Google Apps Script, Google Sheets

12/01/2020 By WeirdGeek Leave a Comment

Google Apps Script to search a string in a column in Google Sheet [Part 1]

Searching a string in a google sheet is easy when you search it manually using Ctrl+F and enter the string. But what if you want to automate the task and search the string to perform dependent task, the Google Apps Script is there for your rescue. I came across a situation where i have to […]

Filed Under: Google Apps Script Tagged With: Automation, Google, Google Apps Script

Next Page »

Subscribe to my Blog !!

Enter your email below to subscribe my blog and get the latest post right in your inbox.

  • Home
  • Terms
  • Privacy
  • Contact Us

Copyright © 2023 · WeirdGeek · All trademarks mentioned are the property of their respective owners.