KazooTTTkazoottt.hashnode.dev·Dec 15, 2024使用google sheet + api定时获取油管播放量起因是想要记录一下 milklove 的二搭剧 Whale Store xoxo 在油管上的预告片的播放量的 คุณวาฬร้านชำ (Whale Store xoxo) | GMMTV 2025 - YouTube 于是先搜了一下有没有可以直接使用的开源项目或者接口，然后在 批量统计YouTube视频播放量方法 - 杨哥的出海营销笔记 这篇文章中了解到了可以使用 google sheet 的 apps 脚本 直接获取油管的播放量。 不过这篇文章中的脚本更多的获取当前的播放量，而不是定时获取，...milklove
Shikhar Shuklashikhar99.hashnode.dev·Dec 9, 2024Automate Gmail Attachments to Google Drive Using JavaScript in Apps ScriptManaging email attachments manually is tedious, but with Google Apps Script, you can automate the process in just a few lines of JavaScript. In this article, I’ll walk you through how to create a script that saves attachments from specific Gmail send...JavaScript
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...google 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...238 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...1 like·169 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...22 likes·443 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...79 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,...252 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 โดย ให้เ...222 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...forms
