Arham Abroarhamabro.hashnode.dev·Oct 17, 2024How to Link Google Sheets with Discord Webhooks Using Apps ScriptDiscord Webhooks gives you the ability to post messages to a specific channel automatically. The main thing is that you don’t need a bot login to use Webhook—just a URL. As for the Google Apps Script, it is a powerful tool that you can use to automat...Discussgoogle apps script
GreenFluxblog.greenflux.us·Oct 5, 2024Building A Data-Driven Organizational Chart In Apps ScriptOrganizational charts help visualize the reporting structure of a company in a tree-like graph. They are usually created with a design tool, and lots of manual data entry. Then, every time an employee changes, the graphic has to be updated again manu...GreenFlux and 1 other are discussing this2 people are discussing thisDiscuss·189 readsgoogle-sheetsgoogle sheets
GreenFluxblog.greenflux.us·Sep 6, 2024Talk To Your SpreadSheet: Apps Script + Cohere AIAI can be a huge productivity boost, but it can also become a new bottleneck if it doesn't have existing access to your data. Bouncing back and forth between tabs and pasting sheets data into ChatGPT might solve one problem, but it creates another. I...Discuss·1 like·162 readsllm
GreenFluxblog.greenflux.us·Sep 3, 2024FeaturedBuilding an Interactive XY Image Plot with Google Apps Script and Leaflet.jsGoogle Maps has a ton of features for plotting points on a map, but what if you want to plot points on an image? These XY Image Plot maps are commonly used for floor maps, job site inspections, and even games. In this guide, I'll show you how to crea...Discuss·22 likes·379 readsgoogle-sheetsgoogle apps script
GreenFluxblog.greenflux.us·Aug 27, 2024Generating Heatmaps in Google Sheets using Apps Script and EChartsHeatmaps are a great way to visualize aggregate data so you can easily see trends and spikes in the data. They can summarize data across a range of time, display traffic and weather patterns, or any other series of data comparing two axis. One popula...Discuss·66 readsecharts
GreenFluxblog.greenflux.us·Aug 25, 2024Creating a Google Sheets Sidebar with MermaidJS ChartsGoogle Sheets has a ton of different chart types built-in, but there are a few types missing like Class, Sequence and Sankey diagrams, to name a few. When it comes to these types of charts, you usually have to export your sheets data to another tool,...Discuss·213 readsMermaidJS
nConnectaskai.nc.co.th·Jul 19, 2024Claude 3.5 Create CRUD WebAPP (Code)Make CRUD WebAPP On Google Appscript and Get Database from Google Sheets แจก Codeและ Prompt ภาษาไทย สามารถทำ APP แบบ CRUD (Create , Read , Update , Delete) ใช้ฐานข้อมูลของ Google Sheets ด้วย Claude ใช้คำสั่งบน Claude "ให้สร้าง HTML แบบ CRUD โดย ให้เ...Discuss·221 readsClaude AIcode
Eric Festablog.efcomputing.solutions·Jun 16, 2024Introducing Formstar: Simple, Serverless Form ProcessingIn the past, when I needed to host "static" sites - those that do not rely on server-side functionality like login sessions but instead rely fully on visitors' browsers (client-side) for rendering and interactivity - I looked to traditional web hosti...Discussforms
Eamonn CottrellforfreeCodeCampfreecodecamp.org·May 16, 2024How to Create a Pop-up Image in Your SpreadsheetIn this article, I'll show you two ways to create a lightbox effect in a spreadsheet. The first will trigger the image to be displayed in a large area in the sheet. The second will be an actual HTML popup on top of the sheet. If you want to follow al...Discussgoogle apps script
LebCitlebcit.hashnode.dev·May 3, 2024Creating Conditional Selections in Google Forms using Apps ScriptIntro I mentioned in the previous post that I was working on a project that made me develop Google's Query Language Wrapper.At the project's end, its owners asked if it was possible to use a Google Form, from where the users will submit their data in...Discussgoogle apps script