apps-script-samples
berglas
Our great sponsors
apps-script-samples | berglas | |
---|---|---|
37 | 37 | |
4,339 | 1,224 | |
1.8% | 0.2% | |
5.6 | 6.9 | |
5 days ago | 21 days ago | |
JavaScript | Go | |
Apache License 2.0 | Apache License 2.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
apps-script-samples
-
Open source at Fastly is getting opener
One of the things that stifles openness is noise. Sifting through our public repos, some are very obviously redundant and just distracting. So we started by archiving a whole bunch of them - over half, in fact. We wrote some Google Apps Script in a spreadsheet to import and analyze the state of all our public repos:
- Google Apps Script: Automate and Extend Google Workspace with Simple Code
-
Ask HN: Should I move away from JavaScript based skillset because of saturation?
I am not a JS developer, but in some tech areas there are niches with relatively fewer developers competing for the same position.
I don't know if this is actually a niche, but since I don't see it mentioned frequently on HN, perhaps you could have a look at Google Apps Script [0], which is basically JS for automating and extending Google Docs (Docs, Sheets, Forms, Slides), and integrating them into GCP. Tons of companies have whole departments living inside Google Docs, so I imagine they would pay for software making their lives easier. I would but I currently don't have the budget for it, so I am writing short scripts myself. Curiously, Bard and ChatGPT produce really bad Apps Scripts code, which would be to your advantage.
When I occasionally hire people, I do look at their repos to see how good they are in a specific language. Specifically, how easy to follow and idiomatic their code is, what the quality of their comments and documentation is, are there any tests, even if very rudimentary. I particularly enjoy original projects like home automation, custom keyboard firmware, an alternative Netflix UI, a ggplot extension, a basic Python wrapper for some overly-complicated API vs. your typical to-do app or yet another analysis of the Bike Sharing dataset. I don't expect all people to have public repos or FLOSS contributions because not everyone has the time for that. However, if you wanted to demonstrate skills in a technology you haven't used professionally, I think it is a good idea.
0. https://developers.google.com/apps-script
-
Apps Script function frequency and quotas
I have a function in Apps Script that returns the Document Position, and I currently have it set to be called every second. However, I'm concerned about potential limitations or quotas that I might reach by making such frequent function calls. I got the idea from their own samples.
-
How can I use app scripts on google sites?
Here is the documentation link to help you: https://developers.google.com/apps-script/
- Script to send 3rd party recruiter emails in Gmail directly to SPAM with a GFY canned response
-
How to Connect Your Google Sheet to ChatGPT
Before we get started with ChatGPT, you'll need to set up Google Apps Script. If you're not already familiar with Google Apps Script, you can get started with the documentation here.
-
Google Calendar add-on: Emotify Events
Since a few years I had a Google Apps Script that prefixed some events in my calendar with an emoji. This helps me spot certain events or categories of events. This blogpost explains very well why I like to add emoji's to my calendar events.
-
Ask HN: What does everyone like for all-purpose business process platforms?
From my current employer I discovered that you can get surprisingly high mileage with spreadsheets and a little bit of scripting.
My employer uses Google Sheets with app scripts [1].
It automatically reads emails, updates a bunch of spreadsheets, makes other API calls, creates entire report documents etc.
The initial setup might take a while though.
[1] https://developers.google.com/apps-script
-
Coding Class for Pre-teen?
I have completed https://grasshopper.app entirely with no prior knowledge of coding. It is very hands on easy to follow. There is more doing coding than reading and each question has a walkthrough available. It is by Google and directs you too Google's own coding platform when you finish. It covers the basics of coding, automation, HTML/CSS/JavaScript and Google's AppScript that work with apps like Google Drive and Sheets. Each course has a PDF certificate of completion. (Last I checked the app was bricked and suggested using the webpage until they figured out the bug with the new operating system.)
berglas
-
How to deploy a Django app to Google Cloud Run using Terraform
Secret Manager: secure storage for sensitive data e.g passwords.
- How do you handle sensitive variables with a service-worker?
-
Increasing Your Cloud Function Development Velocity Using Dynamically Loading Python Classes
Google Secret Manager
-
Getting started using Google APIs: API Keys (Part 2)
API keys are easy to "leak" or compromise, so best to not only use the restrictions presented to you when you create them but physically protect them as well. Don't code them in plain-text, don't check them into GitHub, etc. Store them in a secure database or use a service like GCP Secret Manager.
-
Need some advice on API key storage
I've been looking at Google Secret Manager which sounds promising but I've not been able to find any examples or tutorials that help with the actual practical details of best practice or getting this working. I'm currently reading about Cloud Functions which also sound promising but again, I'm just going deeper and deeper into GCP without feeling like I'm gaining any useful insights.
-
Secure GitHub Actions by pull_request_target
In this post, I described how to build secure GitHub Actions workflows by pull_request_target event instead of pull_request event. Using pull_request_target, you can prevent malicious codes from being executed in CI. And by managing secrets in secrets management services such as AWS Secrets Manager and Google Secret Manager and access them via OIDC, you can restrict the access to secrets securely. To migrate pull_request to pull_request_target, several modifications are needed. And pull_request_target has a drawback that it's difficult to test changes of workflows, so it's good to introduce pull_request_target to repositories that require strong permissions in CI. For example, a Terraform Monorepo tends to require strong permissions for CI, so it's good to introduce pull_request_target to it.
-
Need Help with Deploying Directus on Google Cloud Platform (GCP)
If you want to make these secrets more secure and get versioning and access logs for them, you may want to switch to Secret Manager later on. They can still be exposed as environment variables to your code. It's a little more setup work, so start with the simple approach at the top.
-
Has anyone been able to implement the OpenAI API with a Firebase Function (which is needed for the env variable API Key)?
https://cloud.google.com/secret-manager https://aws.amazon.com/secrets-manager/
- Securely storing Social Security Numbers with Firebase?
- Dónde van las credenciales cuando voy a subir un código a la nube para correr 24/7?
What are some alternatives?
nocodb - 🔥 🔥 🔥 Open Source Airtable Alternative
kubernetes-external-secrets - Integrate external secret management systems with Kubernetes
ODrive - Google Drive GUI for Windows / Mac / Linux
helm-charts
examples - Example actors, capability providers, and other demonstrations
kube-secrets-init - Kubernetes mutating webhook for `secrets-init` injection
jsPDF - Client-side JavaScript PDF generation for everyone.
gitleaks - Protect and discover secrets using Gitleaks 🔑
wear-os-samples - Multiple samples showing best practices in app and watch face development on Wear OS.
cocert - Split and distribute your private keys securely amongst untrusted network
google-apps-script - A collection of Google Apps Script that I've worked on over time.
rclone - "rsync for cloud storage" - Google Drive, S3, Dropbox, Backblaze B2, One Drive, Swift, Hubic, Wasabi, Google Cloud Storage, Azure Blob, Azure Files, Yandex Files