#GoogleAppsScript

@yagisanatode.bsky.social

3 weeks ago

Something Weird is Going on with Google Drive API Files.get() YouTube video by Yagisanatode -Scott-

Something Weird is Going on with Google Drive API Files.get()
Give this a try before Google 'Fixes' it!🪳

@workspacedevs #GoogleAppsScript #DriveAPI
youtu.be/P_FUp42wts8

0 0 0 0

Charifkub

@charifkub.bsky.social

1 month ago

Google Apps Script คืออะไร เปลี่ยนไฟล์งานธรรมดาให้กลายเป็นซอฟต์แวร์อัจฉริยะ

อ่านต่อ : www.blockdit.com/posts/696b34...

#Charifkub #Google #GoogleAppsScript #JavaScript #Automation #Study #Knowledge #Feed

2 1 0 0

Yagisanatode

@yagisanatode.bsky.social

4 months ago

Darcula Syntax Highlighting for Black Apps Script Chrome Extension - Yagisanatode This year, I became a huge fan of the Chrome Extension Black Apps Script from the team at SW Root. Not only does it allow us to have dark mode syntax highlighting for our Google Apps Script code in th...

Darcula Syntax Highlighting for Black Apps Script Chrome Extension
yagisanatode.com/darcula-synt...
#googleAppsScript

2 0 0 0

Yagisanatode

@yagisanatode.bsky.social

5 months ago

Manage Your TV Shows in Google Sheets - Prepare the Search Shows Modal YouTube video by Yagisanatode -Scott-

Part 4 of Build your own TV show tracker in Google Sheets using the TMDB API is out!📺
Here, we set up our UI modal to search for our shows in our Shows Google Sheet. Oooh pretty!
youtu.be/uccL5NHdEDQ @workspacedevs #GoogleAppsScript #GoogleWorkspace #GoogleSheets #TMDB

0 0 0 0

Yagisanatode

@yagisanatode.bsky.social

5 months ago

Manage Your TV Shows in Google Sheets Creating the Sheets Interface YouTube video by Yagisanatode -Scott-

Part 3 of Build your own TV show tracker in Google Sheets using the TMDB API is out!📺
Time to set up our Shows and Complete Google Sheets and connect our code to the Google Sheets display
youtu.be/npW9qRpuSSQ @workspacedevs #GoogleAppsScript #GoogleWorkspace #GoogleSheets

1 0 0 0

Tiller

@tiller.com

5 months ago

Google Sheets does NOT have a built in way to duplicate rows and columns....

So I made you one.

See how: youtu.be/vMQYskPDA6k

#GoogleSheets #Spreadsheets #SpreadsheetTips #GoogleAppsScript #AppsScript

0 0 0 0

Yagisanatode

@yagisanatode.bsky.social

7 months ago

Multiple Google Sheets Async Requests in Google Apps Script - Yagisanatode Learn how to asynchronously get and update multiple Google Sheets in Google Apps Script and Google Sheets API.

Adventures Getting and Updating multiple Google Sheets asynchronously in Google Apps Script yagisanatode.com/multiple-goo... #GoogleAppsScript #GoogleSheets @WorkspaceDevs

0 0 0 0

Yagisanatode

@yagisanatode.bsky.social

8 months ago

Find and Inspect Apps Script-generated HTML in Chrome Dev Tools - Yagisanatode Learn how to find and inspect Google Apps Script-generated HTML in Chrome Developer Tools

New Tutorial! Find and Inspect Google Apps Script-generated HTML in Chrome Dev Tools wp.me/p9ksIb-7pf #GoogleAppsScript #GoogleWorkspace @WorkspaceDev

0 0 0 0

zaki

@jp-z.jp

9 months ago

claspでGASのソースをGit管理 #GoogleAppsScript - Qiita はじめに GASからREST APIを使ってwebサービスを便利に操作するGoogleスプレッドシートを営業職メンバへ展開(これとかこれの別バージョン)したのはいいけど、機能追加したりする際に「運用中のスクリプトへの機能追加」が手作業だと自爆するほど難しい(というかバージ...

GASのコード改造に着手したけど、claspとか使ってGit管理するようにしとけばよかった(遅

claspでGASのソースをGit管理 #GoogleAppsScript - Qiita
https://qiita.com/zaki-lknr/items/b4954c222c1c1db92caf

0 0 0 0

Libby Heeren

@libbyheeren.bsky.social

9 months ago

Yesterday, I wrote a #googleAppsScript and asked #Claude to look at it, tell me what it did, and if it would work as expected. It told me that it would not work for SEVERAL reasons 🙅🏻‍♂️ I had a hunch it was wrong. I went ahead and tested it, and it worked great. None of the problems were real 😂 #databs

23 1 1 0

The Daily Tech Feed

@thedailytechfeed.com

9 months ago

Cybercriminals are exploiting Google Apps Script to host sophisticated phishing campaigns, leveraging trusted platforms to bypass security measures. Stay vigilant! #CyberSecurity #Phishing #GoogleAppsScript Link: thedailytechfeed.com/cybercrimina...

0 0 0 0

The New Oil

@thenewoil.org

9 months ago

Threat actors abuse Google Apps Script in evasive phishing attacks Threat actors are abusing the trusted Google platform 'Google Apps Script' to host phishing pages, making them appear legitimate and eliminating the risk of them getting flagged by security tools.

Threat actors abuse #GoogleAppsScript in evasive #phishing attacks

www.bleepingcomputer.com/news/security/threat-act...

#Google #cybersecurity #cybercrime

0 0 0 0

piggo

@pigondrugs.bsky.social

9 months ago

Google Apps Script Phishing

~Cofense~
Attackers leverage Google Apps Script to host phishing pages, abusing trust for credential theft.
-
IOCs: solinec. com, 167. 250. 5. 66
-
#GoogleAppsScript #Phishing #ThreatIntel

0 0 0 0

@inmobi-info.bsky.social

9 months ago

【LINE bot】記事にいいねをもらったら LINE に通知してささやかな喜びをつぶれるほど抱きしめる 🍒 #GoogleAppsScript はじめに（いいねをくれた）君を忘れない一生懸命書いた記事にいいねがもらえると嬉しいですよね ☺️しかし、Qiita を見にこないと、いいねがもらえたことに気づけません。それでは寂しいので LINE に通知します 🔔 「Web プッシュ通知なら受け取れるよ」何か声が聞こえますが、無視します。作りたいから作るんです。きっと想像した以上に騒がしい未来が僕を待ってる使った技術 Google Apps Script（以下 GAS）コンピューティング、定期実行トリガー Google Sheets データベースの代わり Qiita API v2 記事一覧&いいね一覧を取得 LINE Messaging API LINE にメッセージ送信、Webhook 成果物 1 日 2 回、新着いいねがないかチェックして、あったら LINE に通知する bot です 🤖QiitaLikeNotifier と LineUserIdLogger の 2 つのアプリケーションからなります。 QiitaLikeNotifier メインロジックです。構成図スクリプト const QIITA_TOKEN = PropertiesService.getScriptProperties().getProperty("QIITA_TOKEN"); const QIITA_ARTICLES_SPREADSHEET_ID = PropertiesService.getScriptProperties().getProperty( "QIITA_ARTICLES_SPREADSHEET_ID" ); const LINE_CHANNEL_ACCESS_TOKEN = PropertiesService.getScriptProperties().getProperty( "LINE_CHANNEL_ACCESS_TOKEN" ); const LINE_USER_ID_SPREADSHEET_ID = PropertiesService.getScriptProperties().getProperty( "LINE_USER_ID_SPREADSHEET_ID" ); /** * Qiitaから記事一覧を取得する * @param {number} page 取得ページ番号 * @param {number} perPage 1ページあたりの取得件数 * @return {{ 'id': string, 'title': string, 'url': string, 'likes_count': number }[]} 記事一覧 */ function getArticlesFromQiita(page, perPage) { // const response = UrlFetchApp.fetch( ` { method: "get", headers: { Authorization: `Bearer ${QIITA_TOKEN}`, }, } ); const body = JSON.parse(response.getContentText()); const articles = body.map((item) => ({ id: item["id"], title: item["title"], url: item["url"], likes_count: item["likes_count"], })); return articles; } /** * 記事IDから記事情報へのマッピングを取得する * @param {{ 'id': string, 'title': string, 'url': string, 'likes_count': number }[]} 記事一覧 * @return {{ : { 'title': string, 'url': string, 'likes_count': number }[] }} 記事IDから記事情報へのマッピング */ function getArticleId2Article(articles) { const articleId2Article = {}; articles.forEach((article) => { const id = article["id"]; articleId2Article = { title: article["title"], url: article["url"], likes_count: article["likes_count"], }; }); return articleId2Article; } /** * スプレッドシートからデータを取得する * @param {Sheet} sheet スプレッドシート * @return {{ headers: string[], rows: (string | number)[][] }} */ function getDataFromSpreadsheet(sheet) { const startRow = 1; const startColumn = 1; const numRows = sheet.getLastRow(); const numColumns = sheet.getLastColumn(); // // const data = sheet .getRange(startRow, startColumn, numRows, numColumns) .getValues(); const headers = data[0]; const rows = data.length > 1 ?

【LINE bot】記事にいいねをもらったら LINE に通知してささやかな喜びをつぶれるほど抱きしめる 🍒 #GoogleAppsScript

はじめに（いいねをくれた）君を忘れない一生懸命書いた記事にいいねがもらえると嬉しいですよね ☺️しかし、Qiita を見にこないと、いいねがもらえたことに気づけません。それでは寂しいので LINE に通知します 🔔 「Web プッシュ通知なら受け取れるよ」何か声が聞こえますが、無視します。作りたいから作るんです。きっと想像した以上に騒がしい未来が僕を待ってる使った技術 Google Apps Script（以下 GAS）…

0 0 0 0

Yagisanatode

@yagisanatode.bsky.social

10 months ago

Add Custom Queryable Properties to Any File in Google Drive with Apps Script - Yagisanatode Learn how to add, update and search or query for custom Google Drive properties in file metadata in with Google Apps Script

Add Custom Queryable Properties to Any File in Google Drive with Apps Script
yagisanatode.com/add-custom-q... @GoogleWorkspaceDevs #GoogleDrive #GoogleAppsScript #GoogleWorkspace

2 0 1 0

Kaz Nishimura

@kazssym.bsky.social

11 months ago

doPost がエラーの場合だけ結果を返せば回避可能 #GoogleAppsScript

0 0 1 0

Terry

@strictlywebdev.bsky.social

11 months ago

Add Form Data to Google Sheet with Next.js & Google Apps Script: Demo & Project Setup YouTube video by Strictly Web Dev

🚀 Just posted a new video tutorial on adding form data to a Google Spreadsheet with Next.js Sever Actions and Google Apps Script 📝⚡

📺 Watch here:
youtu.be/OYVDT9cyjJU
...
#NextJS #GoogleAppsScript #GoogleSheets #WebDevelopment #JavaScript #ReactJS #FullStackDev #CodingTutorial #LearnToCode

3 0 0 0

Forem

@forem.com.web.brid.gy

11 months ago

Published an OSS Repository That Continuously Stores GitHub Repository Metrics Using GAS Hey Devs! Previously, I explored how we can monitor OSS activity metrics based on GitHub repository data. ## Consideration of OSS Activity Metrics Based on GitHub Repository Data Takashi Masuda for ROUTE06, Inc. ・ Dec 16 '24 #ospo #opensource #github #marketing Building on that, I implemented a Google Apps Script (GAS) that continuously stores traffic data from GitHub repositories. ## Continuously Storing Traffic Data of Multiple GitHub Repositories Using GAS Takashi Masuda for ROUTE06, Inc. ・ Dec 23 '24 #github #googlesheets #googleappsscript This time, while adding GAS functions to store other metrics, I have published the repository as OSS. I’d like to take this opportunity to introduce it once again. * Published Repository * Stored Metrics * 1. Stargazers * Objectives * Issues * Solution * 2. Traffic views * Objectives * Issues * Solution * 3. Traffic clones * Objectives * Issues * Solution * 4. Top referral sources * Objectives * Issues * Solution * Conclusion ## Published Repository The published repository is available here. ## route06inc / ospo-google-apps-script ### OSPO Google Apps Script by ROUTE06, Inc. The initial setup is summarized in the README. I will focus mainly on why I decided to store these metrics. ## Stored Metrics ### 1. Stargazers #### Objectives * To understand the daily increase in stars. * To correlate the days with star increases with possible reasons or initiatives. #### Issues * On GitHub’s web UI, only the total number of stars and the accounts that starred are visible. * Example: https://github.com/giselles-ai/giselle/stargazers * With Star History, the counts for nearby days are rounded off, and it does not allow for note-taking. * Example: https://www.star-history.com/#giselles-ai/giselle&Date #### Solution I implemented the function updateSheetWithStargazers to record who starred on which day. The graph was created as shown below. The key is to enable “Aggregate” on the X-axis. Except for the colored cells, you can freely add notes. ### 2. Traffic views #### Objectives * To permanently store the numerical data from the `Visitors` graph in the repository’s `Insights > Traffic` section. * `https://github.com/[ORG]/[REPO]/graphs/traffic` #### Issues * The graph does not display data older than two weeks. * The GitHub REST API Get traffic views has the same limitation. #### Solution I implemented the function updateSheetWithLatestTrafficViews that uses this API to store the daily Views and Unique visitors in a spreadsheet. ### 3. Traffic clones #### Objectives * To permanently store the numerical data from the `Git clones` graph in the repository’s `Insights > Traffic` section. * `https://github.com/[ORG]/[REPO]/graphs/traffic` #### Issues * The graph does not display data older than two weeks. * The GitHub REST API Get traffic clones has the same limitation. #### Solution I implemented the function updateSheetWithLatestTrafficClones that uses this API to store the daily Clones and Unique cloners in a spreadsheet. ### 4. Top referral sources #### Objectives * To permanently store the numerical data from the `Referring sites` graph in the repository’s `Insights > Traffic` section. * `https://github.com/[ORG]/[REPO]/graphs/traffic` #### Issues * The graph does not display data older than two weeks. * The GitHub REST API Get top referral sources has the same limitation. * Each value is the total for the past 14 days, which is not very user-friendly. #### Solution I implemented the function updateSheetWithLatestTrafficReferrers using this API to store the daily Referring sites in a spreadsheet. To create a stacked graph, I made a pivot table of Views and Unique visitors on a separate sheet, along with their respective graphs. While the issue of each value being a total for the past 14 days remains unsolved, it seems possible to separate them using spreadsheet functions. ## Conclusion I have published the OSS repository https://github.com/route06inc/ospo-google-apps-script that continuously stores GitHub repository metrics using GAS. This tool is already in daily use on the repositories of Giselle and Liam, and the data is being effectively utilized. * https://github.com/giselles-ai/giselle * https://github.com/liam-hq/liam

0 0 0 0

Tadashi Shigeoka

@codenote.net

11 months ago

GitHub リポジトリのメトリクスを GAS で継続的に蓄積する OSS リポジトリを公開した - ROUTE06 Tech Blog こんにちは。ソフトウェアエンジニアの id:masutaka26 です。以前、OSS 活動の指標（メトリクス）を GitHub のリポジトリデータから考察しました。 tech.route06.co.jp それを踏まえて、GitHub リポジトリのトラフィックデータを継続的に蓄積する Google Apps Script (GAS) を実装しました。 tech.route06.co.jp 今回は他...

GitHubリポジトリのメトリクスをGASで自動蓄積＆可視化するOSSを公開しました🚀
stargazers, views, clones, referral sourcesなどの日々の変化や施策の効果を可視化して、OSS活動の改善に役立てます！

tech.route06.co.jp/entry/2025/0...

#OSS #GitHub #GoogleAppsScript

2 0 0 0

Stéphane Giron

@sgiron.bsky.social

1 year ago

Mistral OCR and Gemini 2.0 Flash: Best Buddies for Document Processing Powered by Apps Script Mistral OCR and Gemini 2.0 Flash for document processing.

Make @MistralAI new OCR model work with Gemini 2.0 Flash for document processing

medium.com/@stephane...

#GoogleGemini #MistralAI #GoogleAppsScript

0 0 0 0

Yagisanatode

@yagisanatode.bsky.social

1 year ago

Google Apps Script Rhino Runtime is deprecated - What's next? YouTube video by Yagisanatode -Scott-

Google Apps Script Rhino Runtime is deprecated - What's next?
youtu.be/yP0bqoKQ3X4 @workspaceDevs #GoogleAppsScript

1 0 0 0

Tom Hinkle

@tomhinkle.net

1 year ago

As a subscriber, I'm able to create Custom GPTs which can hit APIs, so I built a Google Apps Script to serve up an API to ChatGPT that would let me track nutrition over time.

Took some time to write up my recent project to turn GPT into the world's easiest-to-use nutrition tracker. Since custom GPTs can hit any API, new chat capabilities just means building APIs. Anyone else doing this? www.tomhinkle.net/proj/nutriti... #chatgpt #googleappsscript #nutrition #fitness

0 0 0 0

Yagisanatode

@yagisanatode.bsky.social

1 year ago

A First Look at Granular OAuth permissions in Google Apps Script YouTube video by Yagisanatode -Scott-

A First Look at Granular OAuth permissions in Google Apps Script.
Google Developer Experts @GoogleWorkspaceDevs #GoogleAppsScript youtu.be/N6tQumJbk08

1 1 0 0

Yagisanatode

@yagisanatode.bsky.social

1 year ago

Reconsider Smart Chips when Scripting in Google Sheets YouTube video by Yagisanatode -Scott-

Reconsider Smart Chips when using Apps Script in Google Sheets. @GoogleWorspaceDev Google Developer Experts #GoogleAppsScript #GoogleSheets #GoogleWorkspace youtu.be/YQ5SFNXeULE

2 0 0 0

Yagisanatode

@yagisanatode.bsky.social

1 year ago

New Google Chat Quick Commands an alternative to Slash Commands YouTube video by Yagisanatode -Scott-

New Google Chat Quick Commands an alternative to Slash Commands. I give them a spin in Google Apps Script @WorkspaceDevs #GoogleAppsScript #GoogleChat Google Developer Experts

youtu.be/AvAYawLx5SU

0 0 0 0

サードニュース@相互フォロー100%

@new3rd.bsky.social

1 year ago

無料で学べる生成AI活用講座を2月20日に開催！ 株式会社SAMURAIが、初心者向けに無料の生成AIを活用したプログラミング講座を開催。楽器於ますので、業務改善にぜひ活用してください。

無料で学べる生成AI活用講座を2月20日に開催！ #東京都 #港区 #生成AI #プログラミング #GoogleAppsScript

株式会社SAMURAIが、初心者向けに無料の生成AIを活用したプログラミング講座を開催。楽器於ますので、業務改善にぜひ活用してください。

0 0 0 0

Stéphane Giron

@sgiron.bsky.social

1 year ago

Similar Image Generation with Imagen3

How to create your own image using a template tailored to your needs.
Avoid headache to find the best prompt, just give a model and the variation your need to get the result.

medium.com/@stephane...

#VertexAISprint #GoogleAppsScript

1 0 0 0

Todd Harper

@toddvharper.com

1 year ago

Back in our Zapier Python step, we create an Asana project, with a template selected based on the specific service booked and add a link to the Google Drive project folder we just created.

#zapier #asana #googledrive #googleappsscript

1 0 0 0

Earth to Bob

@tobob.earth

1 year ago

I always have these random reasons when I want to shuffle a range of cells in a google sheet.

Finally got around to making a little app script to do this.

Here's the code, it's pretty easy to add to a sheet: github.com/robbobfrh84/...

#GoogleAppsScript #GoogleSheets #indiedev #Coding #TechTips

10 1 0 0

Posts tagged #GoogleAppsScript