Brendan O'Neillautomatedoffice.hashnode.dev·Jul 11, 2023Picking the Perfect Automation Tool: A Guide for Your Specific Use CaseAutomation tools have become indispensable in today's fast-paced world, allowing individuals and businesses to streamline repetitive tasks. Choosing the right automation tool can greatly enhance productivity and efficiency. In this blog, we will disc...Discuss·1 likeautomation
Surinder Bhomrahashnode.surinderbhomra.com·Jun 30, 2023Google Apps Script: Fetching Data From An External APIWhile manually importing data into a Google Sheet to complete the boring chore of data restructuring, I wondered if there was any way that the initial import might be automated. After all, it would be much more efficient to link directly to an extern...Discuss·40 readsGoogle
GreenFlux, LLCblog.greenflux.us·Jun 10, 2023Extract Images from a Google Doc and Save to Drive FolderRecently, I needed to export all the images from a Google Doc and upload them to another service. Seems like a simple job, right? You would think... but not so much. Google Docs blocks the standard right-click context menu and replaces it with a cust...Discussgoogle apps script
GreenFlux, LLCblog.greenflux.us·Jun 9, 2023Save files to Google Drive by POST-ing the URL to a web appI just found an old script I wrote that others might find useful, so I wanted to share. This script saves a file to Google Drive when you POST its URL to the webapp, using this format: { 'key': 'APIKEY', 'fileUrl': 'https://upload.wikimedia.org/w...Discuss·55 readsgoogle apps script
Nibesh Khadkakcl.hashnode.dev·Jun 5, 2023Find the Last Row In Google Sheets With Google Apps Script!Hello!, I wrote a blog on finding the last non-empty rows a couple of months ago. Since then, I have found a better, faster, and easier method, which works in most cases. Find the Last Row & Column You can copy and paste one of the following function...Discuss·291 readsGoogle Apps Scriptsgoogle apps script
Nibesh Khadkakcl.hashnode.dev·Apr 29, 2023How To Delete Empty Rows and Columns In Google Sheets?Welcome to this very short daily blog where I give a very simple script to automate Google Products. In this chapter, we'll custom menu that'll delete empty rows and columns in current active spreadsheets. Delete Empty/Extra Rows and Column The follo...Discuss·434 readsGoogle Apps Scriptsgoogle apps script
Nibesh Khadkakcl.hashnode.dev·Apr 28, 2023How Separate the First and Last Names in Spreadsheets?Would you like to separate the column in your spreadsheet that consists of the full names of people into first and last names? Well then stick this very simple script to your spreadsheets apps script editor and you'll be able to do just that. Split ...Discuss·152 readsGoogle Apps Scriptsgoogle apps script
Nibesh Khadkakcl.hashnode.dev·Apr 26, 2023How to Easily Copy a Column From One Sheet to Another in Google Sheets?In this blog, I will be sharing a script that allows you to easily select a column in a Google Sheets spreadsheet and copy it to another spreadsheet while ensuring that the values are aligned in the same rows. Whether you're a Google Apps Script Deve...Discuss·923 readsGoogle Apps Scriptsgoogle sheets
Nibesh Khadkakcl.hashnode.dev·Apr 25, 2023How to see how many words you have on google docs with Google Apps Script?Are you tired of manually counting the number of words in your Google Docs while working on your blog or article? Well, fret not, as I have got you covered with a simple yet effective solution. In this tutorial series on Apps Script, I will walk you ...Discuss·173 readsGoogle Apps Scriptsgoogle apps script
Nibesh Khadkakcl.hashnode.dev·Apr 24, 2023How to Insert Multiple Rows in Google Sheets with Apps Script?Hello and welcome to our blog series on automating Google Sheets with Apps Script. In this tutorial, we will guide you on how to insert multiple rows in Google Sheets using a simple script. We'll explore how to use UiApp to create a custom user inter...Discuss·1.4K readsGoogle Apps Scriptsgoogle sheets
