Create Google Sheets Dropdowns with Google Apps Script https://youtu.be/rQXPl-hZxzQ?si=OjT1xeNld2R6jxSW via @YouTube @workspacedevs #GoogleSheets #GoogleAppsScript

For this #HATurday toots #VAM and the #MetMuseum HAT collections are arrayed. Indexes are 'chosen' with JS Math Random and Round. A small bot-script does the rest
#GoogleAppsScript

Those of you who followed my bot @UPressSalesBot on the other platform may be interested to know it's now up and running here on Mastodon, tooting out discounts from university presses.

I'm using a new infrastructure which is social-media-platform agnostic (subscribe to all the mailing lists, parse out sentences with a discount code, toot [or whatever], repeat). I'll post my code shortly.

I also discovered two new tools:

1) Gmail (and other providers) support plus addressing in emails. This means if your email is first.last@gmail.com then first.last+whatever@gmail.com will also go to your inbox.

2) Google Apps Script among other things lets you run javascript code on your inbox, so you can do proper parsing with regular expressions and all sorts of other automation
https://www.google.com/script/start/

#bot #discount #PhDChat #GoogleAppsScript #UniversityPress

Heb een scriptje geschreven dat populariteit van arresten van het EU HvJ over Vo 2016/679 in kaart brengt. Hoe vaker door het EU HvJ naar een arrest wordt verwezen hoe populairder dat arrest. De grote winnaar is 62019CJ0439 (54 verwijzingen; https://eur-lex.europa.eu/legal-content/EN/TXT/?uri=CELEX:62019CJ0439). Als het scriptje spoort tenminst ;-).

#ecj #gdpr #googleappsscript

【Qiitaアナリティクス】"自分の記事がどれだけ見てもらえているか" を見える化するスプレッドシートを作りました 🚀
https://qiita.com/Ryo-Nakano/items/0d794018eb22f3c88fba?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items
#qiita #JavaScript #GoogleAppsScript #spreadsheet #データ分析 #個人開発

Is it possible to scrape dynamic webpages with #GoogleAppsScript?
#dtv #scraping

Can anyone recommend a good #RubyLang #SDK for working with #GoogleAppsScript? I'd prefer to avoid working directly in #JavaScript, but transpilers like #CoffeeScript and others have their own problems.

😂 Het is me gelukt om met Google Apps Script te tooten.
Mijn dag is weer helemaal goed.
Nu een 'echte' bot maken van werkgerelateerde rss-feeds.
#googleappsscript #bot

Auto-Add Date and Time to an Adjacent Cell Upon Edit in Google Sheets with Apps Script. This a long-awaited update to a 5-year-old tutorial.

#GoogleSheets #GoogleAppsScript @workspacedevs

https://youtu.be/GrRmapAPdg4

List all files and folders in a folders directory tree in Google Drive: Apps Script. @WorkspaceDevs #GoogleAppsScript #GoogleDriveAPI #AppsScript #GoogleDrive

yagisanatode.com/list-all-files-and-folders-in-a-folders-directory-tree-in-google-drive-apps-script/

いつも飲み過ぎちゃうから、もっと注意してくれるようにしたお話。
https://qiita.com/pilot_fish/items/65d57a7e5227785cd4c7?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items
#GoogleAppsScript #LineNotify

Referenced link: https://hackernoon.com/removing-duplicates-in-google-sheets-a-guide-for-non-coders
Discuss on https://discu.eu/q/https://hackernoon.com/removing-duplicates-in-google-sheets-a-guide-for-non-coders

Originally posted by HackerNoon | Learn Any Technology / @hackernoon: http://nitter.platypush.tech/hackernoon/status/1636052149661581332#m

Highlight and Remove duplicate rows in your google spreadsheet with this script for free. Works with any type and length of sheets. - by @KhadkaNibesh https://hackernoon.com/removing-duplicates-in-google-sheets-a-guide-for-non-coders #googleappsscript #googlesheets

#blog: It is possible to develop #GoogleAppsScript projects locally, on your machine, in #Typescript, and sync them with Drive. Excited? Don't be. I am still not sure it's a good idea. Anyhow, here's a starter project using Python's #Copier

https://gotofritz.net/blog/clasp-template-for-local-google-apps-script-projects-using-copier/

#GoogleAppsScript って #wasm 使えるのか。
WASI on GAS 作ろうぜ！

Referenced link: https://hackernoon.com/how-to-find-and-delete-duplicate-files-in-google-drive
Discuss on https://discu.eu/q/https://hackernoon.com/how-to-find-and-delete-duplicate-files-in-google-drive

Originally posted by HackerNoon | Learn Any Technology / @hackernoon: http://nitter.platypush.tech/hackernoon/status/1627629146695139328#m

This blog is meant for both coders and non-coders, so, please do humor the over-explanation. - by @KhadkaNibesh https://hackernoon.com/how-to-find-and-delete-duplicate-files-in-google-drive #googleappsscript #googledrive

Find and hide Rows by Grouping Ranges in Google Sheets with Apps Script - A faster approach.
Got a large Google Sheets dataset that you want to hide rows by cell value on? #GoogleAppsScript #GoogleSheets #SpreadsheetAutomation @WorkspaceDevs
https://youtu.be/WTImNqHkl1k

#GoogleAppsScript を .ts で書いて clasp push するとトランスパイルされて clasp pull で .js しか持って来られないので、.ts で書く場合は別途 git とか使ってソース管理した方が良さそう。個人だとあまり気にならないかもだが。

「 clasp 使えば .ts も自動でトランスパイルされるよ！」って言うから試しに ES6 private field 定義したら無茶苦茶頑張っててワロタ。#GoogleAppsScript くん ES6 に対応しなさいよ。

Google 先生、はやくなおして。#GoogleAppsScript

ScriptApp.getService().getUrl() doesn't work for versioned deployments
https://issuetracker.google.com/issues/170799249?pli=1

Google くん #GoogleAppsScript のことあんまり好きじゃなさそう。切り捨てられないか心配。