Sam Borgessamborges.hashnode.dev·Feb 7, 2024Integrate UiPath and Google Apps Scripts using Orchestrator APITL;DR This article walks you through integrating UiPath with Google Workspace products to automate workflows by connecting to the UiPath Orchestrator API using Google Apps Script. Learn how to create queue items, read from queues, and start jobs. Ess...Discussautomation
Tom McCanntommccann.hashnode.dev·Jan 7, 2024Including the Bootstrap CSS Framework in a Google AppBeing a CSS newbie, I regard Bootstrap as my 'training wheels'. I'm not confident enough with CSS to create clean-looking designs so I welcome help from wherever I can get it. I like the simplicity of Bootstrap. In a previous post I demonstrated how ...Discussgoogle apps script
Tom McCanntommccann.hashnode.dev·Jan 7, 2024Embedding a Svelte app in the Sheets sidebarThe Google Sheets add-on requires a menu and various controls in the sidebar. I originally intended to hand-craft the HTML and CSS, but that would be very fiddly. Is it even possible to integrate a Svelte-developed app into the Google Apps sidebar? Y...Discussbuildinpublic
Tom McCanntommccann.hashnode.dev·Jan 3, 2024Choosing the project and the right toolsRather than choosing a boring brochure-ware website as my first project, I've decided to do something more ambitious. I will build an add-on to Google Sheets that allows users to import data from various relational databases. As you can see from the ...Discussgoogle apps script
PRATYAY MUSTAFIpratyaywrites.hashnode.dev·Dec 28, 2023Build a Basic Web Form with Google Sheets: A Step-by-Step GuideIntroduction :- Now you can use Google Sheets as a basic database to make your project work and prototype your project using google's inbuilt free api `Apps Script`. Google's spreadsheet can store text, number etc. and you can receive data in json fo...Discuss·57 readsGoogle
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·95 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...Discuss·42 readsgoogle 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·122 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·675 readsGoogle Apps Scriptsgoogle apps script